Procedure With Joining with Multiple Tables

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

Alter procedure sp_FranchisewiseCollection_Report
(
@FromDate varchar(4000),
@ToDate varchar(4000)
)
as
begin
declare @sqlStr varchar(4000)
set @sqlStr=''

set @sqlstr='select FR.FranchiseCode,
FM.FranchiseName,
(select SUM(CurrentPaid) from FeeReceipt where PaymentMode=''Cash''
and ReceiptDate between CONVERT(VARCHAR(15),'''+@FromDate+''',103) AND CONVERT(VARCHAR(15),'''+@ToDate+''',103) and FranchiseCode=FR.FranchiseCode) Cash_Collection ,

(select SUM(CurrentPaid) from FeeReceipt where PaymentMode IN (''Cheque'',''CREDIT CARD'')
and ReceiptDate between CONVERT(VARCHAR(15),'''+@FromDate+''',103) AND CONVERT(VARCHAR(15),'''+@ToDate+''',103) and FranchiseCode=FR.FranchiseCode) Bank_Collection ,

(select SUM(CurrentPaid) from FeeReceipt where PaymentMode IN (''Cheque'',''CREDIT CARD'',''Cash'')
and ReceiptDate between CONVERT(VARCHAR(15),'''+@FromDate+''',103) AND CONVERT(VARCHAR(15),'''+@ToDate+''',103) and FranchiseCode=FR.FranchiseCode) Total_Collection ,

(select SUM(Fine) from FeeReceipt where
 ReceiptDate between CONVERT(VARCHAR(15),'''+@FromDate+''',103) AND CONVERT(VARCHAR(15),'''+@ToDate+''',103) and FranchiseCode=FR.FranchiseCode) Fine_Collected ,

 CR.Amount as Chq_Return

from FeeReceipt FR
left join

(select FranchiseCode,ISNULL(SUM(AMOUNT),0) as "Amount" FROM CHEQUERETURN WHERE vDATE between
 CONVERT(VARCHAR(15),'''+@FromDate+''',103) AND CONVERT(VARCHAR(15),'''+@ToDate+''',103)
group by FranchiseCode ) CR
on FR.FranchiseCode=CR.FranchiseCode

left join

(select Code,FranchiseName from FranchiseMaster) FM

on FR.FranchiseCode=FM.Code
group by FR.FranchiseCode,CR.Amount,FM.FranchiseName
order by FR.FranchiseCode'

exec(@sqlstr)
 
end

Textbox like HtmlEditor using RadControl

http://demos.telerik.com/aspnet-ajax/editor/examples/editorastextbox/defaultcs.aspx
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
 <link href="Telerik.css" rel="stylesheet" type="text/css" />   
 <telerik:RadEditor  Height="100px" Width="350px" ToolsWidth="350px" EditModes="Design"
     ID="RadEditor1" runat="server" ToolbarMode="ShowOnFocus" ToolsFile="~/Jupcss/Telerik.xml">
     </telerik:RadEditor>



/* The following CSS needs to be copied to the page to produce textbox-like RadEditor */

Telerik.css

.reLeftVerticalSide, .reRightVerticalSide, .reToolZone, .reToolCell {
     background: white !important;
}

.reToolCell {
     display: none\9 !important; /* for all versions of IE in order to prevent border bottom disappearing */
}

.reContentCell {
     border-width: 0 !important;
}

.formInput {
     border: solid 1px black;
}

.RadEditor {
     filter: chroma(color=c2dcf0);
}

.reWrapper_corner, .reWrapper_center {
     display: none !important; /* for FF */
}

td.reWrapper_corner, td.reWrapper_center {
     display: block\9 !important; /* for all versions of IE */
}

.reContentCell
{
   height: 100px !important; /* this height should be qual to reWrapper element inline height, which in that case is 150px */
}
        
 .reContentCell iframe
 {
   border-bottom: 1px solid #828282;
 }

Telerik.xml

<?xml version="1.0" encoding="utf-8" ?>
<root>
  <tools name="Formatting" enabled="true" dockable="true">
    <tool name="Bold" />
    <tool name="Italic" />   
    <tool name="Underline" />
    <tool separator="true"/>
    <tool name="ForeColor" />
    <tool name="BackColor"/>
    <tool separator="true"/>
    <tool name="FontName"/>
    <tool name="RealFontSize"/>   
  </tools>
</root>
 

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)
    {
     
       

    }
 
}

Suppress Crystal Report Footer On last Page

 Supress Line in Last Page

Right Click on Report--->Report-->Section Expert---->Page Footer-->Suppress (No Drill Down)

Click on Formula Image and Write the following formula

if(pagenumber=TotalPageCount) then
 true
else
false;

 Change Orientation in Crystal Report

Right click--->Design--->Page SetUp--->Orientation--->LandScape format



Find a Control (Textbox) in Crystal Report

  public void BindCompDetails(ReportDocument Obj)
        {
            DataTable dtCompany = objCommon.GetCompAddress();
            if (dtCompany.Rows.Count > 0)
            {
                TextObject CompName = ((TextObject)Obj.ReportDefinition.Sections["Section1"].ReportObjects["txtCompName"]);
     
                TextObject ToDate = ((TextObject)Obj.ReportDefinition.Sections["Section2"].ReportObjects["txt_To"]);
                ToDate.Text = Session["BadDebtToDate"].ToString();
            }           

        }

Javascript Function to wait for specific time after user Types

 <script type="text/javascript">
        var typewatch = function () {
            var timer = 0;
            return function (callback, ms) {
                clearTimeout(timer);
                timer = setTimeout(callback, ms);
                if (timer != 0) {
                    callserver();
                }
            }
        } ();
    </script>

 <input type="text" onKeyUp="typewatch(function(){alert('Time elapsed!')}, 2000 );" />

Change the Gridview SortDirection on Header Click

  protected void grd_SearchQueryBuilder_Sorting(object sender, GridViewSortEventArgs e)
    {
        string Direction =GetSortDirection(e.SortExpression);
        string  expre = e.SortExpression;       
        Sortgridview(expre,Direction);

    }


 public string GetSortDirection(string SortExpression)
    {
        if (ViewState[SortExpression] == null)
            ViewState[SortExpression] = "Desc";
        else
            ViewState[SortExpression] = ViewState[SortExpression].ToString() == "Desc" ? "Asc" : "Desc";

        return ViewState[SortExpression].ToString();
    }

Calling Server side Method From Javascript

 <script type="text/javascript">
        function HandleIT() {
            var name = document.getElementById('<%=txtname.ClientID %>').value;
            var address = document.getElementById('<%=txtaddress.ClientID %>').value;
            PageMethods.ProcessIT(name, address, onSucess, onError);
            function onSucess(result)
            {
                alert(result);
            }
            function onError(result)
            {
                alert('Something wrong.');
            }
        }
    </script>

<div>
        <p>Say bye-bey to Postbacks.</p>

        <asp:ScriptManager ID='ScriptManager1' runat='server' EnablePageMethods='true' />
<div>
        <asp:TextBox ID="txtname" runat="server"></asp:TextBox>
        <br />
        <asp:TextBox ID="txtaddress" runat="server"></asp:TextBox>
        <br />
        <asp:Button ID="btnCreateAccount" runat="server" Text="Signup" OnClientClick="HandleIT(); return false;" />
    </div>

[WebMethod]
    public static string ProcessIT(string name, string address)
    {
        string result = "Welcome Mr. " + name + ". Your address is '" + address + "'.";
        return result;
    }

http://codes.codedigest.com/CodeDigest/80-Calling-a-Serverside-Method-from-JavaScript-in-ASP-Net-AJAX---PageMethods.aspx


http://aspdotnetcodebook.blogspot.in/2008/10/calling-page-methods-from-javascript.html

Alternating row style with onmouseover and onmouseout

     <AlternatingRowStyle BackColor="AliceBlue" />

protected void grd_SearchQueryBuilder_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onmouseover", "this.originalstyle=this.style.backgroundColor;this.style.backgroundColor='silver'");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=this.originalstyle");
            e.Row.Attributes.Add("style", "cursor:pointer;");
        }
    }

Settting in web.config for Default page

<system.webServer>
<defaultDocument>
      <files>
        <clear />
        <add value="index.aspx" />
      </files>
    </defaultDocument>
</system.webServer>

Resize an Image in c#

static Stream strm = null;
fileName = FileUpload2.PostedFile.FileName;
strm = FileUpload2.PostedFile.InputStream;
GetHeightWidth_Resize("115","120",fileName);

public void GetHeightWidth_Resize(string Height, string Width, string resizeFileName)
    {
        try
        {
            string filename = resizeFileName;
            string targetPath = Server.MapPath(Request.ApplicationPath) + "\\Worksheet\\" + Convert.ToString(Session["SchoolId"]) + "\\" + filename;
            var targetFile = targetPath;
            ResizeImage(Height, Width, strm, targetFile);           
        }

        catch (Exception ex)
        {
            objException.keepExceptionDetails(PageName, "GetHeightWidth_Resize()", ex.Message);
            Response.Redirect("SisError.aspx");
        }

    }

    private void ResizeImage(string Height, string Width, Stream sourcePath, string targetPath)
    {
        try
        {
            using (var image = System.Drawing.Image.FromStream(sourcePath))
            {
                var newWidth = Convert.ToInt32(Width);
                var newHeight = Convert.ToInt32(Height);
                var thumbnailImg = new Bitmap(newWidth, newHeight);
                var thumbGraph = Graphics.FromImage(thumbnailImg);
                thumbGraph.CompositingQuality = CompositingQuality.HighQuality;
                thumbGraph.SmoothingMode = SmoothingMode.HighQuality;
                thumbGraph.InterpolationMode = InterpolationMode.HighQualityBicubic;
                var imageRectangle = new Rectangle(0, 0, newWidth, newHeight);
                thumbGraph.DrawImage(image, imageRectangle);
                thumbnailImg.Save(targetPath, image.RawFormat);
            }
        }

        catch (Exception ex)
        {
            objException.keepExceptionDetails(PageName, "ResizeImage()", ex.Message);
            Response.Redirect("SisError.aspx");
        }
    }

Procedure Retruning Value

Alter Procedure sp_DuplicateClientCode
(
@ClientCode nvarchar(max))
as
begin
Declare @Duplicate int
if exists(select * from ItSchool_ClientUserPass_Mst where ClientCode=@ClientCode)
 set @Duplicate=1
 else
 set @Duplicate=0
 return @Duplicate
end


SqlConnection con = new SqlConnection(constr);
        SqlCommand cmdD = new SqlCommand("sp_DuplicateClientCode", con);
        cmdD.CommandType = CommandType.StoredProcedure;
        cmdD.Parameters.Add("@ClientCode", SqlDbType.VarChar).Value = txtccode.Text;
        var returnParameter = cmdD.Parameters.Add("@Duplicate", SqlDbType.Int);
        returnParameter.Direction = ParameterDirection.ReturnValue;
        con.Open();
        cmdD.ExecuteNonQuery();
        var result = returnParameter.Value;      
        con.Close();

Useful Links

http://www.codeproject.com/Articles/25513/Singleton-Design-Pattern-C-implementation (Singleton-Design-Pattern)
http://www.codeproject.com/Articles/28384/Design-pattern-FAQ-Part-3-Design-pattern-training (All Design Patern)

http://www.codeproject.com/Articles/639717/MVC-Interview-Questions-and-Answers-All-about-MVC (MVC)
http://www.codeproject.com/Articles/556995/Model-view-controller-MVC-Interview-questions-and  (MVC)
http://www.codeproject.com/Articles/207797/Learn-MVC-Model-View-Controller-step-by-step-in-7  (MVC)
http://www.c-sharpcorner.com/UploadFile/1492b1/mvc-3-interview-questions-and-answers/          (MVC)

http://www.c-sharpcorner.com/uploadfile/puranindia/net-framework-and-architecture/  (.Net Architecture)

http://abhijitjana.net/2010/03/14/beginner%E2%80%99s-guide-how-iis-process-asp-net-request/ (how iis works)

http://www.codeproject.com/Articles/29008/Asp-Net-Interview-Question-Part-3(Interview quesions)


What do you understand by SQL Injection attack?
Ans:- A SQL injection attack occurs when untrusted input can modify the logic of a SQL query in unexpected ways.

http://www.codeproject.com/Articles/30018/Function-Overloading-in-Web-Services(method Overoading in Webservice)

http://tympanus.net/codrops/2010/06/07/fancy-sliding-form-with-jquery/ (Beautiful Tab)

Hosting the application with Crystal Report in IIS

Hosting the Application in IIS

http://www.codeproject.com/Articles/280137/How-To-Deploy-a-Web-App-in-IIS

If Crystal Report is not Working after hosting the application in IIS

1. You need to use Web Application Project,No Website Project because Web App will combine DLL to project also.
2. Copy C:\inetpub\wwwroot\aspnet_client\system_web\4_0_30319\crystalreportviewers13 (you'll got it when you install -CRforVS_redist_install_32bit_13_0.exe)   To your project such as  (ProjectName/crystalreportviewers13)
3. copy this below to your web.config
3.1
<configSections>
    <sectionGroup name="businessObjects">
      <sectionGroup name="crystalReports">
        <section name="rptBuildProvider" type="CrystalDecisions.Shared.RptBuildProviderHandler, CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, Custom=null" />
           <section name="crystalReportViewer" type="System.Configuration.NameValueSectionHandler" />
      </sectionGroup>
    </sectionGroup>
      </configSections>
3.2
 <businessObjects>
      <crystalReports>
        <rptBuildProvider>
          <add embedRptInResource="true" />
        </rptBuildProvider>
        <crystalReportViewer>
              <add key="ResourceUri" value="/crystalreportviewers13" />
      </crystalReportViewer>
      </crystalReports>
    </businessObjects>
3.4 Publish your web application with FTP Mode to your any folder,and copy this publish to your web server then TEST it!

If any error comes in preview.aspx then Delete all the content from that page