create-setup-project

http://www.aspdotnet-suresh.com/2012/04/visual-studio-create-setup-project-to.html

<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/Main.master" CodeFile="AdmissionRegister.aspx.cs" Inherits="AdmissionRegister" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<asp:Content ID="header" runat="server" ContentPlaceHolderID="head">
    <script type="text/javascript">
        function validate() {
            var Complete = document.getElementById('ContentPlaceHolder1_cbox_CompleteRegister');
            if (Complete.checked) {

            }
            else {
                if (document.getElementById("ContentPlaceHolder1_txt_FromDate").value == "" || document.getElementById("ContentPlaceHolder1_txt_ToDate").value == "") {
                    alert("Please select the Date Range");
                    return false;
                }
                else {
                    var fromDate = document.getElementById("ContentPlaceHolder1_txt_FromDate").value;
                    var ToDate = document.getElementById("ContentPlaceHolder1_txt_ToDate").value;
                    var dt1 = parseInt(fromDate.substring(0, 2), 10);

                    var mon1 = parseInt(fromDate.substring(3, 5), 10);

                    var yr1 = parseInt(fromDate.substring(6, 10), 10);

                    var dt2 = parseInt(ToDate.substring(0, 2), 10);

                    var mon2 = parseInt(ToDate.substring(3, 5), 10);

                    var yr2 = parseInt(ToDate.substring(6, 10), 10);

                    mon1 = mon1 - 1;

                    mon2 = mon2 - 1;

                    var date1 = new Date(yr1, mon1, dt1);

                    var date2 = new Date(yr2, mon2, dt2);

                    if (date2 >= date1) {

                        return true;
                    }

                    else {
                        alert("From Date Cannot be greater than To Date")
                        return false;
                    }
                }

            }

            var Franchise = document.getElementById('ContentPlaceHolder1_cbox_Franchisewise');
            if (Franchise.checked) {
                if (document.getElementById('<%=ddl_Franchaise.ClientID%>').selectedIndex == 0) {
                    alert("Please select Franchise Name");
                    return false;
                }
            }

            var Session = document.getElementById('ContentPlaceHolder1_cbox_session');
            if (Session.checked) {
                if (document.getElementById('<%=ddl_Session.ClientID%>').selectedIndex == 0) {
                    alert("Please select the Session");
                    return false;
                }
            }

        }
    </script>  
 <style type="text/css">
.modalBackground
{

    background-color : #696969;
    filter: alpha(opacity=40);
    opacity: 0.7;
    z-index:-1;
}
.ModalWindow
{
  border: solid1px#c0c0c0;
  padding: 100px10px10px10px;
  position:fixed;

}
 </style>

</asp:Content>
<asp:Content ID="Content1" runat="server" ContentPlaceHolderID="ContentPlaceHolder1">


<table width="100%" style="border:1px solid gray">

<tr valign="top" >
<td width="100%">
<table width="100%">

<tr valign="top">
<td  class="Details" width="100%" colspan="2">
<asp:Label ID="lblhead" runat="server"
   style="font-family:Verdana;font-size:13px;color:Red" Text="Admission Register Report">
   </asp:Label>
</td>
</tr>
<tr style="height:10px">
<td colspan="2" width="100%">
 <telerik:RadDatePicker ID="datefrom2" runat="server" Width="100px" ClientIDMode="AutoID">
      <DateInput ID="ADMNDATE2" DateFormat="dd/MM/yyyy" DisplayDateFormat="dd/MM/yyyy" runat="server" OnTextChanged="txt_filterByDate_TextChanged" AutoPostBack="true"></DateInput>
    </telerik:RadDatePicker>
</td>
</tr>

<tr>
<td width="40%" style="padding-left:100px">
<asp:CheckBox ID="cbox_CompleteRegister" runat="server"
        Text="Complete Register Display" CssClass="Details"
        oncheckedchanged="cbox_CompleteRegister_CheckedChanged" AutoPostBack="true"  />
</td>
<td width="60%" style="padding-left:10px" id="td_Date" runat="server" >
<div style="position:relative">
<span class="Details"> From Date</span>
<asp:TextBox ID="txt_FromDate" runat="server" CssClass="DetailsContent"
         Height="16px"></asp:TextBox>
 <cc1:CalendarExtender ID="Calendar1" runat="server" TargetControlID="txt_FromDate" Format="dd/MM/yyyy"></cc1:CalendarExtender>
 &nbsp;

<span class="Details"> To Date</span>
<asp:TextBox ID="txt_ToDate" runat="server" CssClass="DetailsContent"
         Height="16px"></asp:TextBox>&nbsp;
         <cc1:CalendarExtender ID="CalendarExtender1" runat="server" Enabled="true" TargetControlID="txt_ToDate" Format="dd/MM/yyyy"></cc1:CalendarExtender>
</div>
</td>
</tr>




<tr style="height:10px">
<td colspan="2">
</td>
</tr>

<tr style="height:10px">
<td width="40%" style="padding-left:100px">
<asp:CheckBox ID="cbox_Deactive" runat="server" CssClass="DetailsContent" Text="Include De-Active Also" />
</td>
<td width="60%">
</td>
</tr>
<tr style="height:10px">
<td colspan="2">
</td>
</tr>
<tr style="height:10px">
<td width="40%" style="padding-left:100px">
<asp:CheckBox ID="cbox_Franchisewise" runat="server" CssClass="DetailsContent"
        Text="Franchise Wise" oncheckedchanged="cbox_Franchisewise_CheckedChanged" AutoPostBack="true"  />
</td>
<td width="60%">
<div id="div_FranchiseWise" runat="server" style="width:100%;" visible="false">
<asp:TextBox ID="txt_Franchaise" runat="server" CssClass="DetailsContent"
         Height="16px" ontextchanged="txt_Franchaise_TextChanged" AutoPostBack="true" ></asp:TextBox>&nbsp;
<asp:DropDownList ID="ddl_Franchaise" runat="server" Width="180px" Height="23px"
        CssClass="DetailsContent" AutoPostBack="true"
        onselectedindexchanged="ddl_Franchaise_SelectedIndexChanged"></asp:DropDownList>
</div>
</td>
</tr>
<tr style="height:10px">
<td colspan="2">
</td>
</tr>
<tr style="height:10px">
<td width="40%" style="padding-left:100px">
<asp:CheckBox ID="cbox_session" runat="server" CssClass="DetailsContent"
        Text="Session Wise" oncheckedchanged="cbox_session_CheckedChanged" AutoPostBack="true" />
</td>
<td width="60%">
<div id="div_Session" runat="server" style="width:100%" visible="false">
<asp:DropDownList ID="ddl_Session" runat="server" CssClass="DetailsContent" Width="180px" Height="23px"></asp:DropDownList>
</div>
</td>
</tr>
<tr style="height:10px">
<td colspan="2" width="100%"></td>
</tr>
<tr>
<td width="40%"></td>
<td width="60%">
<asp:Button ID="btn_display" runat="server" Text="Display" Height="25px"
        Width="70px" onclick="btn_display_Click"  OnClientClick="return validate();"/>&nbsp;
<asp:Button ID="btn_Cancel" runat="server" Text="Cancel" Height="25px" Width="70px"
        onclick="btn_Cancel_Click" />&nbsp;
<asp:Button ID="btn_Report" runat="server" Text="Report" Height="25px" Width="70px" onclick="btn_Report_Click"
        OnClientClick="return validate();"/>

</td>
</tr>
<tr style="height:10px">
<td colspan="2" width="100%">
</td>
</tr>
<tr style="height:10px">
<td colspan="2" width="100%" align="right">
<asp:Label ID="lbl_NoOfRecord" runat="server" CssClass="Details" style="color:Red"></asp:Label>
</td>
</tr>
<tr>
<td colspan="2" align="center" width="100%">
<div id="div_grid" runat="server" style="width:900px;overflow:auto;border:1px solid gray" >

<telerik:RadGrid ID="grd_AdmnReg" runat="server" AutoGenerateColumns="False"
     AllowPaging="True" Width="350%" AllowSorting="True"      
        AllowFilteringByColumn="True" GridLines="None"      
        onitemdatabound="grd_AdmnReg_ItemDataBound"
        onpageindexchanged="grd_AdmnReg_PageIndexChanged"
        onpagesizechanged="grd_AdmnReg_PageSizeChanged"
        onsortcommand="grd_AdmnReg_SortCommand">
    <ClientSettings AllowColumnsReorder="true" ReorderColumnsOnClient="true"></ClientSettings>
    <MasterTableView AllowNaturalSort="false">  
    <Columns>
    <telerik:GridTemplateColumn HeaderText="SNo." SortExpression="SNo">  
    <ItemTemplate>
    <asp:Label ID="lbl_sno" runat="server" Text='<%#Eval("SNo") %>'></asp:Label>
    </ItemTemplate>
    <FilterTemplate>
    <asp:TextBox ID="SNo" runat="server" onkeypress="return isNumber(event)" Width="30px" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged" AutoPostBack="true"></asp:TextBox>
    <asp:ImageButton ID="imgbtn_Sno" runat="server" ImageUrl="~/images/View.jpg"/>
    </FilterTemplate>      
    </telerik:GridTemplateColumn>

    <telerik:GridBoundColumn DataField="ADMNNO" UniqueName="ADMNNO" HeaderText="ADMNNO" FilterDelay="1000"
    AutoPostBackOnFilter="true" SortExpression="ADMNNO" HeaderStyle-Width="3%">
    <FilterTemplate>
    <asp:TextBox ID="ADMNNO" runat="server" AutoPostBack="true"
    onkeypress="return isNumber(event)" Width="60px" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>
    <asp:ImageButton ID="imgbtn_ADMNNO" runat="server" ImageUrl="~/images/View.jpg"/>
    </FilterTemplate>
    </telerik:GridBoundColumn>

    <telerik:GridBoundColumn DataField="ADMNDATE" UniqueName="ADMNDATE" HeaderText="Admn Date"
       SortExpression="ADMNDATESort">
    <FilterTemplate>  
     <telerik:RadDatePicker ID="datefrom" runat="server" Width="100px" ClientIDMode="AutoID">
      <DateInput ID="ADMNDATE" DateFormat="dd/MM/yyyy" DisplayDateFormat="dd/MM/yyyy" runat="server" OnTextChanged="txt_filterByDate_TextChanged" AutoPostBack="true"></DateInput>
    </telerik:RadDatePicker>
 
    </FilterTemplate>
    </telerik:GridBoundColumn>

    <telerik:GridBoundColumn DataField="STDFIRSTNAME" UniqueName="STDFIRSTNAME" HeaderText="Student Name"
    FilterDelay="1000" AutoPostBackOnFilter="true" SortExpression="STDFIRSTNAME">
    <FilterTemplate>
    <asp:TextBox ID="STDFIRSTNAME" runat="server" AutoPostBack="true" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>  
    </FilterTemplate>
    </telerik:GridBoundColumn>

    <telerik:GridBoundColumn DataField="DOB" UniqueName="DOB" HeaderText="DOB" FilterDelay="1000"
    AutoPostBackOnFilter="true" SortExpression="DOBSort">
    <FilterTemplate>
     <telerik:RadDatePicker ID="DOB" runat="server" Width="100px">
      <DateInput ID="dateFromDOB" DateFormat="dd/MM/yyyy" DisplayDateFormat="dd/MM/yyyy" runat="server"></DateInput>
    </telerik:RadDatePicker>
    </FilterTemplate>
    </telerik:GridBoundColumn>

    <telerik:GridBoundColumn DataField="F_MOBILE" UniqueName="F_MOBILE" HeaderText="Mobile"
       SortExpression="F_MOBILE">
        <FilterTemplate>
    <asp:TextBox ID="F_MOBILE" runat="server" AutoPostBack="true" Width="90px" onkeypress="return isNumber(event)" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>  
    </FilterTemplate>
    </telerik:GridBoundColumn>

    <telerik:GridBoundColumn DataField="F_NAME" UniqueName="F_NAME" HeaderText="F_NAME"
    FilterDelay="1000" AutoPostBackOnFilter="true" SortExpression="F_NAME">
    <FilterTemplate>
    <asp:TextBox ID="F_NAME" runat="server" AutoPostBack="true" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>  
    </FilterTemplate>
    </telerik:GridBoundColumn>

    <telerik:GridTemplateColumn HeaderText="Present Class" SortExpression="PRESENT_CLASS">  
    <ItemTemplate>
    <asp:Label ID="lbl_PRESENT_CLASS" runat="server" Text='<%#Eval("PRESENT_CLASS")%>'></asp:Label>
    </ItemTemplate>
    <FilterTemplate>
    <asp:TextBox ID="PRESENT_CLASS" runat="server" AutoPostBack="true" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>  
    </FilterTemplate>      
    </telerik:GridTemplateColumn>

    <telerik:GridBoundColumn DataField="PRESENT_SEC" UniqueName="PRESENT_SEC" HeaderText="Present Section" FilterDelay="1000"
    AutoPostBackOnFilter="true" SortExpression="PRESENT_SEC">
    <FilterTemplate>
    <asp:TextBox ID="PRESENT_SEC" runat="server" AutoPostBack="true" Width="90px" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>
    </FilterTemplate>
    </telerik:GridBoundColumn>

    <telerik:GridBoundColumn DataField="TRANSPORTUSER" UniqueName="TRANSPORTUSER" HeaderText="TransportUser"
       SortExpression="TRANSPORTUSER">
        <FilterTemplate>
    <asp:TextBox ID="TRANSPORTUSER" runat="server" AutoPostBack="true" Width="80px" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>
    </FilterTemplate>      
    </telerik:GridBoundColumn>

    <telerik:GridBoundColumn DataField="ROUTENO" UniqueName="ROUTENO" HeaderText="RouteNo"
    FilterDelay="1000" AutoPostBackOnFilter="true" SortExpression="ROUTENO">
     <FilterTemplate>
    <asp:TextBox ID="ROUTENO" runat="server" AutoPostBack="true" Width="80px" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>
    </FilterTemplate>    
    </telerik:GridBoundColumn>

    <telerik:GridTemplateColumn HeaderText="ADDRESS">  
    <ItemTemplate>
    <asp:Label ID="lbl_ADDRESS" runat="server" Text='<%#Eval("ADDRESS")%>'></asp:Label>
    </ItemTemplate>  
     <FilterTemplate>
    <asp:TextBox ID="ADDRESS" runat="server" AutoPostBack="true" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>
    </FilterTemplate>    
    </telerik:GridTemplateColumn>

    <telerik:GridBoundColumn DataField="F_OCCUPATION" UniqueName="F_OCCUPATION" HeaderText="Occupation" FilterDelay="1000"
    AutoPostBackOnFilter="true" SortExpression="F_OCCUPATION">
    <FilterTemplate>
    <asp:TextBox ID="F_OCCUPATION" runat="server" AutoPostBack="true" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>  
   
    </FilterTemplate>
    </telerik:GridBoundColumn>

    <telerik:GridBoundColumn DataField="CATEGORY" UniqueName="CATEGORY" HeaderText="Category"
       SortExpression="CATEGORY">
       <FilterTemplate>
    <asp:TextBox ID="CATEGORY" runat="server" AutoPostBack="true" Width="80px" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>  
   
    </FilterTemplate>  
    </telerik:GridBoundColumn>

    <telerik:GridBoundColumn DataField="M_NAME" UniqueName="M_NAME" HeaderText="Mother Name"
    FilterDelay="1000" AutoPostBackOnFilter="true" SortExpression="M_NAME">
    <FilterTemplate>
    <asp:TextBox ID="M_NAME" runat="server" AutoPostBack="true" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>  
    </FilterTemplate>
    </telerik:GridBoundColumn>

   
    <telerik:GridBoundColumn DataField="ACTIVE" UniqueName="ACTIVE" HeaderText="Active"
       SortExpression="ACTIVE">
      <FilterTemplate>
    <asp:TextBox ID="ACTIVE" runat="server" AutoPostBack="true" Width="40px" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>  
    </FilterTemplate>  
    </telerik:GridBoundColumn>

    <telerik:GridBoundColumn DataField="FranchiseCode" UniqueName="FranchiseCode" HeaderText="Franchise Code"
    FilterDelay="1000" AutoPostBackOnFilter="true" SortExpression="FranchiseCode">  
    <FilterTemplate>
    <asp:TextBox ID="FranchiseCode" runat="server" AutoPostBack="true" Width="50px" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>
    </FilterTemplate>    
    </telerik:GridBoundColumn>

    <telerik:GridTemplateColumn HeaderText="Student Code">  
    <ItemTemplate>
    <asp:Label ID="lbl_StudentCode" runat="server" Text='<%#Eval("StudentRegNo")%>'></asp:Label>
    </ItemTemplate>  
     <FilterTemplate>
    <asp:TextBox ID="StudentRegNo" runat="server" AutoPostBack="true" Width="70px" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>
    </FilterTemplate>    
    </telerik:GridTemplateColumn>

    <telerik:GridBoundColumn DataField="RandomPassword" UniqueName="RandomPassword" HeaderText="Password"
    FilterDelay="1000" AutoPostBackOnFilter="true" SortExpression="RandomPassword">
    <FilterTemplate>
    <asp:TextBox ID="RandomPassword" runat="server" AutoPostBack="true" Width="70px" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>
   
    </FilterTemplate>
    </telerik:GridBoundColumn>

    <telerik:GridBoundColumn DataField="F_EMAIL" UniqueName="F_EMAIL" HeaderText="F_EMAIL"
       SortExpression="F_EMAIL">
        <FilterTemplate>
    <asp:TextBox ID="F_EMAIL" runat="server" AutoPostBack="true" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>  
    </FilterTemplate>  
    </telerik:GridBoundColumn>

    <telerik:GridBoundColumn DataField="FormNumber" UniqueName="FormNumber" HeaderText="Form Number"
    FilterDelay="1000" AutoPostBackOnFilter="true" SortExpression="FormNumber">
    <FilterTemplate>
    <asp:TextBox ID="FormNumber" runat="server" AutoPostBack="true" Width="70px" onkeypress="return isNumber(event)" ontextchanged="txt_filter_TextChanged" onkeyup="txt_filter_TextChanged"></asp:TextBox>  
    </FilterTemplate>
    </telerik:GridBoundColumn>

    </Columns>
    </MasterTableView>
    </telerik:RadGrid>

 </div>
</td>
</tr>

<tr>
<td colspan="2" align="center">
<asp:Label ID="lbl_noRecord" runat="server" Text="Sorry,No Reocrd Found" CssClass="Details" style="color:Red"></asp:Label>
</td>
</tr>
<tr>
<td colspan="2">
 <cc1:ModalPopupExtender ID="ModalPopupExtender1" runat="server"
    BackgroundCssClass="ModalBackground" CancelControlID="btnCancel" TargetControlID="btn_Report" PopupControlID="panOpen"
    PopupDragHandleControlID="panOpen" Drag="false"> </cc1:ModalPopupExtender>
<asp:Panel ID="panOpen" runat="server" Height="550px" Width="970px" CssClass="ModalWindow" style="margin-top:-10px;">
<table width="100%" style="height:100%;border:#000 2px solid;background-color:Gray" cellpadding="0" cellspacing="0">
<tr>
<td align="right" style="background-image: url(images/tableheading2Modified.gif); height: 30px" >
<table width="100%">
<tr>
<td width="80%">
<asp:Label ID="lbl_PopUPHeader" runat="server" CssClass="Details" style="color:White"></asp:Label>
</td>
<td width="20%" align="right">
<asp:Image ID="btnCancel" runat="server" ImageUrl="~/images/minus.png" />
</td>
</tr>
</table>

</td>
</tr>
<tr>
<td align="right"   >
<iframe id="iframe_Popup" runat="server" scrolling="auto" height="550px" width="970px"></iframe>
</td>
</tr>
</table>
</asp:Panel>
</td>
</tr>
</table>
</td>
</tr>

</table>

</asp:Content>




using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using DataAccessLayer;
using Telerik.Web.UI;

public partial class AdmissionRegister : System.Web.UI.Page
{
    clsDALCommon objCommon = new clsDALCommon();
    DAL_AdmissionRegister objAdmission = new DAL_AdmissionRegister();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            div_grid.Visible = false;
            lbl_noRecord.Visible = false;
            lbl_NoOfRecord.Visible = false;
            bindFranchaise();
            bindSession();
         


            iframe_Popup.Visible = false;
            panOpen.Visible = false;
            ModalPopupExtender1.Hide();
        }
    }

    public void bindFranchaise()
    {
        DataTable dtFranchaise = objCommon.GetFranchise("");
        if (dtFranchaise.Rows.Count > 0)
        {
            ddl_Franchaise.DataTextField = "Location";
            ddl_Franchaise.DataValueField = "Code";
            ddl_Franchaise.DataSource = dtFranchaise;
            ddl_Franchaise.DataBind();
            ddl_Franchaise.Items.Insert(0, new ListItem("---Please Select Franchaise---", "0"));

        }
    }
    public void bindSession()
    {
        string Query = "SELECT * FROM SessionMaster order by SessionID";
        DataTable dtFranchaise = objCommon.ExecuteQuery(Query);
        if (dtFranchaise.Rows.Count > 0)
        {
            ddl_Session.DataTextField = "SessionName";
            ddl_Session.DataValueField = "SessionID";
            ddl_Session.DataSource = dtFranchaise;
            ddl_Session.DataBind();
            ddl_Session.Items.Insert(0, new ListItem("---Please Select Session---", "0"));

        }
    }
    protected void txt_Franchaise_TextChanged(object sender, EventArgs e)
    {
        DataTable dt = new DataTable();
        dt = objCommon.GetFranchise(txt_Franchaise.Text);
        if (dt.Rows.Count > 0)
        {
            string Franchise_name = dt.Rows[0]["Location"].ToString();
            ddl_Franchaise.ClearSelection();
            foreach (ListItem item in ddl_Franchaise.Items)
            {
                if (item.Text == Franchise_name)
                {
                    item.Selected = true;

                }
            }

        }
        else
        {
            ddl_Franchaise.ClearSelection();
            foreach (ListItem item in ddl_Franchaise.Items)
            {
                if (item.Text == "---Please Select Franchaise---")
                {
                    item.Selected = true;

                }
            }

        }
    }
    protected void ddl_Franchaise_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (ddl_Franchaise.SelectedValue != "0")
        {
            txt_Franchaise.Text = ddl_Franchaise.SelectedValue;
        }
        else
        {
            txt_Franchaise.Text = "";
        }
    }
    protected void btn_display_Click(object sender, EventArgs e)
    {
        BindGridview();
    }
    protected void btn_Cancel_Click(object sender, EventArgs e)
    {
        Clear();
    }
    public void Clear()
    {
        cbox_Deactive.Checked = false;
        cbox_Franchisewise.Checked = false;
        cbox_CompleteRegister.Checked = false;
        cbox_session.Checked = false;
        ddl_Franchaise.ClearSelection();
        ddl_Session.ClearSelection();
        txt_Franchaise.Text = "";
        div_FranchiseWise.Visible = false;
        div_Session.Visible = false;
        div_grid.Visible = false;
    }
    protected void btn_Report_Click(object sender, EventArgs e)
    {
        string Active = "Y";
        string Code = "";
        int session = 0;
        if (cbox_Deactive.Checked)
        {
            Active = "";
        }
        if (cbox_Franchisewise.Checked)
        {
            Code = txt_Franchaise.Text;
        }
        if (cbox_session.Checked)
        {
            session = Convert.ToInt32(ddl_Session.SelectedItem.ToString());
        }
        string FromDate = "";
        string ToDate = "";
        if (txt_FromDate.Text != "" && txt_ToDate.Text != "")
        {
            FromDate = objCommon.ChangeDateFormat(txt_FromDate.Text);
            ToDate = objCommon.ChangeDateFormat(txt_ToDate.Text);
        }
        Session["AdmissionFCode"] = txt_Franchaise.Text;
        Session["AdmissionActive"] = Active;
        Session["AdmissionSession"] = session;
        Session["AdmissionFranchise"] = ddl_Franchaise.SelectedItem.Text;
        Session["AdmissionFromDate"] = FromDate;
        Session["AdmissionToDate"] = ToDate;
       
        iframe_Popup.Visible = true;
        iframe_Popup.Attributes["src"] = "PrintReportPages/AdmissionRegisterReport.aspx";
        panOpen.Visible = true;
        ModalPopupExtender1.CancelControlID = "btnCancel";
        ModalPopupExtender1.Show();
        //Response.Redirect("PrintReportPages/AdmissionRegisterReport.aspx");
    }
    protected void cbox_Franchisewise_CheckedChanged(object sender, EventArgs e)
    {
        if (cbox_Franchisewise.Checked)
        {
            div_FranchiseWise.Visible = true;
        }
        else
        {
            div_FranchiseWise.Visible = false;

        }
    }
    protected void cbox_session_CheckedChanged(object sender, EventArgs e)
    {
        if (cbox_session.Checked)
        {
            div_Session.Visible = true;
        }
        else
        {
            div_Session.Visible = false;

        }

    }
 

    public void BindGridview()
    {
        DataTable dtRecords = new DataTable();
        string Active = "Y";
        string Code = "";
        int session = 0;
        if (cbox_Deactive.Checked)
        {
            Active = "";
        }
        if (cbox_Franchisewise.Checked)
        {
            Code = txt_Franchaise.Text;
        }
        if (cbox_session.Checked)
        {
            session = Convert.ToInt32(ddl_Session.SelectedItem.ToString());
        }
        string FromDate = "";
        string ToDate = "";
        if (txt_FromDate.Text != "" && txt_ToDate.Text != "")
        {
            FromDate = objCommon.ChangeDateFormat(txt_FromDate.Text);
            ToDate = objCommon.ChangeDateFormat(txt_ToDate.Text);
        }
        dtRecords = objAdmission.GetAdmissionRegister(Active, Code, session, FromDate, ToDate);
        Session["dtAdmission"] = dtRecords;
        if (dtRecords.Rows.Count > 0)
        {
            grd_AdmnReg.DataSource = dtRecords;
            grd_AdmnReg.DataBind();
            div_grid.Visible = true;
            lbl_noRecord.Visible = false;
            lbl_NoOfRecord.Visible = true;
            lbl_NoOfRecord.Text = "Total Reocrds : " + dtRecords.Rows.Count;
        }
        else
        {
            div_grid.Visible = false;
            lbl_noRecord.Visible = true;
            lbl_NoOfRecord.Visible = false;
        }

    }
    protected void cbox_CompleteRegister_CheckedChanged(object sender, EventArgs e)
    {
        if (cbox_CompleteRegister.Checked)
        {
            td_Date.Visible = false;
        }
        else
        {
            td_Date.Visible = true;

        }
    }
    protected void grd_AdmnReg_PageIndexChanged(object source, Telerik.Web.UI.GridPageChangedEventArgs e)
    {
        BindGridview();
    }
    protected void grd_AdmnReg_PageSizeChanged(object source, Telerik.Web.UI.GridPageSizeChangedEventArgs e)
    {
        BindGridview();
    }
    protected void grd_AdmnReg_SortCommand(object source, Telerik.Web.UI.GridSortCommandEventArgs e)
    {
        BindGridview();
    }
    protected void grd_AdmnReg_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
    {
        if (e.Item is GridDataItem)
        {
            e.Item.Attributes.Add("onmouseover", "this.originalstyle=this.style.backgroundColor;this.style.backgroundColor='silver'");
            e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor=this.originalstyle");
            e.Item.Attributes.Add("style", "cursor:pointer;");

        }    
    }
    public void BindGridViewAfterFilter(string FilterQuery)
    {
        DataTable dt = (DataTable)Session["dtAdmission"];
        if (dt.Rows.Count > 0)
        {
            DataRow[] dr = dt.Select(FilterQuery);
            if (dr.Length > 0)
            {
                DataTable dtNew = dr.CopyToDataTable();
                if (dtNew.Rows.Count > 0)
                {
                    grd_AdmnReg.DataSource = dtNew;
                    grd_AdmnReg.DataBind();
                    lbl_NoOfRecord.Text = "Total Reocrds : " + dtNew.Rows.Count;
                }
            }
        }

    }

    protected void txt_filter_TextChanged(object sender, EventArgs e)
    {
        TextBox txt = (TextBox)sender;      
        if (txt.Text != "")
        {
            string Id = txt.ID;
            string text = txt.Text;
            if (Id == "SNo" || Id == "ADMNNO")
            {
                BindGridViewAfterFilter(Id + " = "+ Convert.ToInt32(txt.Text));
            }
            else
            {
                BindGridViewAfterFilter(Id + " like '%" +txt.Text+"%'");

            }
        }
        else
        {

        }
       
    }

    protected void txt_filterByDate_TextChanged(object sender, EventArgs e)
    {
     
       

    }
 
}