Manoj Kumar Thakur: June 2011

Save and update Multiple records

StringBuilder builder = new StringBuilder();
            builder.Append("<Root>");

            for (int i = 0; i < grdPermission.Rows.Count; i++)
            {
                string ActivityName = string.Empty;
                string ActivityID = string.Empty;
                string view = string.Empty;
                string edit = string.Empty;
                string delete = string.Empty;

                ActivityID = ((Label)grdPermission.Rows[i].Cells[1].FindControl("lblActivityID")).Text.Trim();
                ActivityName = ((Label)grdPermission.Rows[i].Cells[1].FindControl("lblActivityName")).Text.Trim();
                string rdBtnListAction = ((RadioButtonList)grdPermission.Rows[i].Cells[2].FindControl("rdBtnListAction")).SelectedValue.ToString();

                builder.Append("<Activities ActivityID='" + ActivityID + "' RoleID = '" + ddl_AllRoles.SelectedValue.ToString() + "' Permission ='" + rdBtnListAction + "'></Activities>");

            }
            builder.Append("</Root>");
            builder.ToString();
            objAdminSecurityBL = new AdminSecurityBL();
            objAdminSecurityBL.PermissiontoActivities( builder.ToString());
            objAdminSecurityBL = null;




Alter Procedure [sp_insertUsersExcel]
(
@XmlString xml = null


)
AS

Begin


declare @VerseSize nvarchar(100)
declare @CompanyCardID nvarchar(100)
declare @PTextSize nvarchar(100)
DECLARE @idoc int
Declare @abcdas int=0
         declare @abc varchar(max) =''
         declare @abc1 varchar(max) =''


   exec sp_xml_preparedocument @idoc output, @xmlString

   DECLARE pCursor CURSOR FOR
   select xCompanyCardID,xVerseSize,xPTextSize from openxml(@idoc,'/root/XML_FIRM',1)
   with(xCompanyCardID nvarchar(100),xVerseSize nvarchar(100),xPTextSize nvarchar(100))

   OPEN pCursor

   FETCH NEXT FROM pCursor into @CompanyCardID,@VerseSize,@PTextSize
    WHILE @@FETCH_STATUS = 0

    BEGIN


   if exists(select * from tbl_Cards where CompanyCardID=@CompanyCardID)
   begin
      update tbl_Cards set VerseSize=@VerseSize,PTextSize=@PTextSize where CompanyCardID=@CompanyCardID
      --update tbl_Cards set VerseSize='',PTextSize='' where CompanyCardID=@CompanyCardID
   end
   else
       begin
       if(LEN(@abc) < 7980)
       begin
    set @abcdas=@abcdas+1

        set @abc= @abc + @CompanyCardID +'<br/>'
        end

        else
        begin
        set @abcdas=@abcdas+1
        set @abc1= @abc1 + @CompanyCardID + '<br/>'
        end

       end

      FETCH NEXT FROM pCursor into @CompanyCardID,@VerseSize,@PTextSize
    End
     CLOSE pCursor
     DEALLOCATE pCursor

EXEC sp_xml_removedocument @iDoc

     print @abc
      print @abc1



End

Autocomplete using jquery ashx extension file

$("#ContentPlaceHolder2_txtLeftInsuranceName").autocomplete('../AutoComplete/AutoCompInsuranceName.ashx', { matchContains: false, minChars: 1, autoFill: false, mustMatch: true, width: 300, cacheLength: 10, max: 10 }).bind("click");

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Configuration;
using System.Text;
using PatientEstimator.BusinessLogic;
using PatientEstimator.Common;

namespace PatientEstimator.Web.AutoComplete
{
    /// <summary>
    /// Summary description for AutoCompInsuranceName
    /// </summary>
    public class AutoCompInsuranceName : IHttpHandler
    {

        public void ProcessRequest(HttpContext context)
        {
            PatientSearchBO objPatientSearchBO = new PatientSearchBO();
            PatientSearchBL objPatientSearchBL = new PatientSearchBL();

            string prefixText = context.Request.QueryString["q"];
            objPatientSearchBO.insname = prefixText;

            List<PatientSearchBO> ProviderCodeList = objPatientSearchBL.GETInsurance(objPatientSearchBO);
            StringBuilder sbProviderCodeList = new StringBuilder();

            for (int i = 0; i < ProviderCodeList.Count; i++)
            {

                sbProviderCodeList.Append(ProviderCodeList[i].insname)
                               .Append(Environment.NewLine);
            }

            context.Response.Write(sbProviderCodeList.ToString());

        }

        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }
}

only take two digits after decimal

Pop up at center of the screen

Hide/show table row on ckeck/unhcheck the checkboxes

$('#btnFilterApply').click(function () {

                    $("#filterDivInner input[type=checkbox]").each(function() {

                       if ($(this).is(':checked'))
                       {

                        var crow = $(this).attr("name");
                        $('#tableresult tr:contains("'+ crow +'")').show();

                       }
                       else
                       {
                         var urow = $(this).attr("name");

                         if(urow == '' || urow == ' ')
                         {

                         $('#tableresult tr:contains("'+ urow +'")').hide();
                          //$('#tableresult tr:contains('+ urow +')').style.display='none';


                         }
                         else
                         {
                          $('#tableresult tr:contains("'+ urow +'")').hide();
                         }

                         $('#tableresult tr:first').show();
                       }

                    }); // end $("#filterDivInner input[type=checkbox]").each(function()


         $('#filterDivOuter').hide();

   }); // btn close Apply function

Filter the table using pop up div

click outside the Pop Div then Pop Div close

Using Jquery CheckAll and UncheckAll

    // check and uncheck all checkboxes

    $('#chkall').click(function () {
        $("#filterDivInner :checkbox").attr('checked', $(this).attr('checked'));
    });

How to split a string

string abc = "D1.23:ManojThakur";

sring xyz = abc.Split('.')[0] //D1

string z= abc.split(':')[1] // 23:ManojThakur

Thursday, 23 June 2011