Tuesday, 17 September 2013

Sorting Of The Gridview column without using Datasource

 protected void GVinsurance_onSorting(object sender, GridViewSortEventArgs e)
        {

            DataTable dt1 = (DataTable)ViewState["DT"];//GVProvider.DataSource as DataTable;
            if (dt1 != null)
            {

                if (dt1 != null)
                {
                    DataView dvSortedView = new DataView(dt1);

                    dvSortedView.Sort = e.SortExpression + " " + getSortDirectionString(e.SortDirection);

                    GVInsurance.DataSource = dvSortedView;
                    GVInsurance.DataBind();
                }

            }
        }

----------------------------------------



 private string getSortDirectionString(SortDirection sortDirection)
        {
            string newSortDirection = String.Empty;

            if (Convert.ToString(ViewState["newSortDirection"]) == "DESC")
            {
                ViewState["newSortDirection"] = "ASC";
            }
            else
                ViewState["newSortDirection"] = "DESC";

            return newSortDirection = Convert.ToString(ViewState["newSortDirection"]);
        }


Wednesday, 17 July 2013

Validating number of characters before and after decimal point using javascript

  function validatemaxAmt(sender, evt)
{
              var splitValue = sender.value.split(".", 2);

        
                  if(splitValue[0] != null)
                 {
                    if(splitValue[0].length < 7)
                    {
                       // alert("Correct format.");
                        return true; // allow postback (if applicable)
                    }
                    else
                    {
                        alert("Incorrect number of decimal digits.");
                        sender.value="0";
                        sender.focus();
                        return false; // disallow postback (if applicable)
              
                    }
                }
}

Wednesday, 26 June 2013

Handling the radio button list with yes or no confirmation message in C#


rdbbilltype.Attributes.Add("onclick", "if(!confirm('Are you sure to change the bill type? ')) return false;");



Looks simple but it will allow only when the OK button is clicked, Or else it wont change the selection.

Awesome...!!!

Monday, 17 June 2013

Javascript validation for special characters in ASP.NET/ C#

function validatespecailchars()
{

     var txtbox = document.getElementById('<%=txtsearch.ClientID %>').value;
   
      var str="<";
        var str1=">";
        var str2="--";
        var str3=";";
        var str4="'";

    if((txtbox.indexOf(str)>=0)||(txtbox.indexOf(str1)>=0)||(txtbox.indexOf(str2)>=0)||      (txtbox.indexOf(str3)>=0)||(txtbox.indexOf(str4)>=0))
    {
         alert('Special Characters are not Allowed.');
        // you can focus here that particular control
     }
}

Wednesday, 17 April 2013

Generating the Graphs in Asp.net

In desing page

// put one literal 

<asp:Literal ID="TATLiteral1" runat="server"></asp:Literal>


In Code Behind


        string sql = "", sql1 = "", sql2 = "", sql3="";
        string condition = "";
        string strXML, strCategories1 ;
        DataTable fdt = null;
        DataTable fdt1 = null;
        DataTable fdt3 = null;
        OracleCommand cmd = null;
        OracleDataAdapter da = null;


       /// genarate the data for your graph

            sql = " Your Query to get data";
            fdt1 = new DataTable();
            cmd = new OracleCommand(sql, conn);
            da = new OracleDataAdapter(cmd);
            da.Fill(fdt1);


     // after getting data put it in the XML format as below

  //  header tag for graph
   
         strXML1 = "<graph  rotateNames='0' animation='1'  numdivlines='4'  baseFont='Arial' baseFontSize='10' baseFontColor='000000' useRoundEdges='1' showLegend='0' bgColor='ffffff' borderColor='ffffff' showYAxisValues='0'>";


   // categories

  strCategories1 = "<categories> <category name='0-2 Hrs' /> <category name='>2 Hrs' /></categories>";

                strXML1 += strCategories1;
// dataset you are providing

                strXML1 += " <dataset seriesName='"+fdt3.Rows[0]["HOSPNAME"]+"' color='8B0000'   showValues='1'>";
                strXML1 += "<set   value='" + fdt1.Rows[0]["Total"].ToString() + "' />";
                strXML1 += "<set   value='" + fdt1.Rows[1]["Total"].ToString() + "' />";
                strXML1 += " </dataset>";

                strXML1 += " <dataset seriesName='"+fdt3.Rows[1]["HOSPNAME"]+"' color='2F4F4F' showValues='1'>";
                strXML1 += "<set   value='" + fdt1.Rows[2]["Total"].ToString() + "' />";
                strXML1 += "<set   value='" + fdt1.Rows[3]["Total"].ToString() + "' />";
                strXML1 += " </dataset>";


                strXML1 += " <dataset seriesName='" + fdt3.Rows[2]["HOSPNAME"] + "' color='20B2AA' showValues='1'>";
                strXML1 += "<set  value='" + fdt1.Rows[4]["Total"].ToString() + "' />";
                strXML1 += "<set  value='" + fdt1.Rows[5]["Total"].ToString() + "' />";
                strXML1 += " </dataset>";
               

                strXML1 += "</graph>";

// binding to literal 

                TATLiteral1.Text = FusionCharts.RenderChartHTML("../ChartsLicense/MSColumn2D.swf", "", strXML1, "Preauthinfo", "350", "170", false);




NOTE : Graph is also depends on the swf files which we provide  like BAR, COLUMN , LINE , STACKED (here m using Multi series column graph)  So download all the swf files from  fusioncharts.com ( refer it for more info for graphs)



Calling the loading images using javascript (processing image)


In head  

//Use this javascript

  <script type="text/javascript">

  function hideLoading()
        {
              document.getElementById('divLoading').style.display = "none";
              document.getElementById('divFrameHolder').style.display = "block";
              document.getElementById('div4').style.display = "none";
              document.getElementById('div2').style.display = "block";
              document.getElementById('div5').style.display = "none";
              document.getElementById('div3').style.display = "block";
        }
     </script>


In form

// call javascript function in iframe tag


 <table style="width:830px;height:480px;font-family:Arial;" bgcolor="white" align="center">
                <tr style="height:8px">
                <td align="center" style="font-weight:bold;font-size:12px;">
                <asp:Label ID="chart4" runat="server" ></asp:Label>
                </td>
                <td align="center" style="font-weight:bold;font-size:12px;">
                <asp:Label ID="chart5" runat="server" ></asp:Label>
                </td>
                </tr>
                <tr style="height:200px">
                <td colspan="2" valign="top" align="center">
                  <div id="divLoading" style="align:center;">
                    <img src="../images/loading45.gif" alt="" width="150px" height="150px" />
                  </div> 
                  <div id="divFrameHolder" style="display:none">  
                <iframe src="smartmisframeaging.aspx" onload="hideLoading()" frameborder="0" scrolling="no" width="100%" height="230"></iframe>
                 </div> 
                </td>
                </tr>
                <tr style="height: 8px">
                <td align="center" style="font-weight:bold;font-size:12px;">
                 <asp:Label ID="chrt1" runat="server"></asp:Label>
                </td>
                <td align="left" style="font-weight:bold;font-size:12px;padding-left:40px;">
                  <asp:Label ID="chrt2" runat="server"></asp:Label>
                  <asp:Label ID="chrt3" runat="server"></asp:Label>
                </td>

                </tr>
                <tr align="left">
                <td  style="width:215px;padding-left:0px;" valign="top" align="center">
                 <div id="div4" style="align:center;">
                    <img src="../images/loading45.gif" alt="" width="150px" height="150px" />
                 </div> 
                <div id="div2" style="display:none">  
                 <iframe id="preauth" src="smartmisframepreauth.aspx"  onload="hideLoading()"      frameborder="0" scrolling="no" width="100%" height="300px"></iframe>
                </div>
                </td>
                <td valign="top" align="center">
                 <div id="div5" style="align:center;">
                    <img src="../images/loading45.gif" alt="" width="150px" height="150px" />
                  </div> 
                 <div id="div3" style="display:none">  
                  <iframe src="smartMISframehrs.aspx"  onload="hideLoading()" frameborder="0" scrolling="no" width="100%" height="300px" marginwidth="0"></iframe>
                 </div> 
                </td>
                </tr>
                </table>






Friday, 8 February 2013

Getting the nested gridview values when it is inside the content placeholder in javascript


function  Rdbtn(index)
{
   var gridView1 = document.getElementById('ctl00_ContentPlaceHolder1_GVBenefit');
 
   var billamt=0;
   var billamt_tot=0; 
   var input4 =  gridView1.rows[index - 1].getElementsByTagName('input')[6]; 
   var idExt=index;  
    for (var i = 1; i < gridView1.rows.length; i++)
    {
          if(parseInt(idExt,10) <= 9)
          {
           idExt = "0" + idExt;                     
          }  

            var VExtGrid = "ctl00_ContentPlaceHolder1_GVBenefit_ctl"+idExt;              
            var gridView = document.getElementById(VExtGrid+"_GvSubBenfits");       
             for (var j = 1; j < gridView.rows.length; j++)
             {  
                   var inputs1 = gridView.rows[j].getElementsByTagName('input')[0];
                   var inputs2 = gridView.rows[j].getElementsByTagName('input')[1];
                   var txtAdm = gridView.rows[j].getElementsByTagName('input')[2];

                   if( inputs1.checked==true )
                   {
                    txtAdm.setAttribute("disabled", false);       
                   }
                    if( inputs2.checked==true )
                   {
                    txtAdm.setAttribute("disabled", true);       
                   }
                 
                   if (txtAdm.value.length<1)
                   {
                     billamt=0;
                   }
                   else
                   {
                     billamt =parseFloat(txtAdm.value);
                   }
             
                billamt_tot = billamt_tot + billamt;
              
                input4.value = billamt_tot;
             }
             GetAppAmt();
      }   
  
}