Center.aspx
<%@ Page Title="" Language="C#" MasterPageFile="~/Content.Master" AutoEventWireup="true"CodeBehind="Center.aspx.cs" Inherits="eSMS.WebFormKidsSchool.Center" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>
<asp:Content ID="Content1" ContentPlaceHolderID="bodyContent" runat="server">
<div style="height: 100%; width: 100%;" align="center">
<ajaxToolkit:ToolkitScriptManager runat="server" ID="ToolkitScriptManager1">
</ajaxToolkit:ToolkitScriptManager>
<asp:UpdatePanel ID="upnl" runat="server" UpdateMode="Conditional" ChildrenAsTriggers="true">
<Triggers>
<asp:AsyncPostBackTrigger ControlID="gvwCenter" EventName="PageIndexChanging" />
<asp:AsyncPostBackTrigger ControlID="gvwCenter" EventName="RowCommand" />
<asp:AsyncPostBackTrigger ControlID="gvwCenter" EventName="RowEditing" />
<asp:AsyncPostBackTrigger ControlID="gvwCenter" EventName="RowDeleting" />
<asp:AsyncPostBackTrigger ControlID="btnCancel" EventName="Click" />
<asp:AsyncPostBackTrigger ControlID="btnSave" EventName="Click" />
</Triggers>
<ContentTemplate>
<asp:Panel ID="Panel1" runat="server" CssClass="pnlBody">
<table width="100%" border="0" align="center">
<tr>
<td align="center">
<asp:Label ID="lblTitle" runat="server" Text="Center" CssClass="title" Font-Bold="True"
Font-Size="Larger"></asp:Label>
</td>
</tr>
<tr>
<td align="center">
<table width="40%" border="0" align="center" cellspacing="12">
<tr>
<td align="center" colspan="3" style="padding-bottom: 5px">
<asp:Label ID="lblMessage" runat="server" Text="" ForeColor="Red" Font-Bold="True"></asp:Label>
</td>
</tr>
<tr align="left">
<td>
<asp:Label ID="lblCenterName" runat="server" CssClass="label" Text="Center Name"></asp:Label><span
style="color: Red">*</span>
</td>
<td>
<asp:TextBox ID="txtCenterName" CssClass="text" runat="server" TabIndex="1"></asp:TextBox>
<asp:RequiredFieldValidator runat="server" ID="reqCenter" ValidationGroup="Search"
ControlToValidate="txtCenterName" Display="None" ErrorMessage="Enter Center Name"
SetFocusOnError="true" />
<ajaxToolkit:ValidatorCalloutExtender runat="Server" ID="ValidatorCalloutExtender3"
TargetControlID="reqCenter" Enabled="true" />
</td>
</tr>
<tr align="left">
<td>
<asp:Label ID="lblCenterAdd1" runat="server" CssClass="label" Text="Center Address 1"></asp:Label><span
style="color: Red">*</span>
</td>
<td>
<asp:TextBox ID="txtCenterAdd1" runat="server" TabIndex="2" CssClass="text"></asp:TextBox>
<asp:RequiredFieldValidator runat="server" ID="reqAdd1" ValidationGroup="Search"
ControlToValidate="txtCenterAdd1" Display="None" ErrorMessage="Enter Center Address 1"
SetFocusOnError="true" />
<ajaxToolkit:ValidatorCalloutExtender runat="Server" ID="ValidatorCalloutExtender1"
TargetControlID="reqAdd1" Enabled="true" />
</td>
</tr>
<tr align="left">
<td>
<asp:Label ID="lblCenterAdd2" runat="server" CssClass="label" Text="Center Address 2"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtCenterAdd2" runat="server" TabIndex="3" CssClass="text"></asp:TextBox>
</td>
</tr>
<tr align="left">
<td>
<asp:Label ID="lblLandline" runat="server" CssClass="label" Text="Landline No"></asp:Label><span
style="color: Red">*</span>
</td>
<td>
<asp:TextBox ID="txtLandlineNo" runat="server" MaxLength="15" TabIndex="4" CssClass="text"></asp:TextBox>
<asp:RequiredFieldValidator runat="server" ID="reqLandlineno" ValidationGroup="Search"
ControlToValidate="txtLandlineNo" Display="None" ErrorMessage="Enter Landline No"
SetFocusOnError="true" />
<ajaxToolkit:ValidatorCalloutExtender runat="Server" ID="PNReqE3" TargetControlID="reqLandlineno"
Enabled="true" />
</td>
</tr>
<tr align="left">
<td>
<asp:Label ID="lblMobileNo" runat="server" CssClass="label" Text="Mobile No"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtMobileNo" runat="server" MaxLength="10" TabIndex="5" CssClass="text"></asp:TextBox>
<ajaxToolkit:ValidatorCalloutExtender runat="Server" ID="ValidatorCalloutExtender4"
TargetControlID="reqLandlineno" Enabled="true" />
</td>
</tr>
<tr>
<td align="center" colspan="2">
<br />
<br />
<asp:Button ID="btnSave" runat="server" Text="Save" ValidationGroup="Search" CssClass="button"
OnClick="btnSave_Click" TabIndex="6" />
<asp:Button ID="btnClear" runat="server" Text="Clear" CssClass="button" OnClick="btnClear_Click"
TabIndex="7" />
<asp:Button ID="btnCancel" runat="server" Text="Cancel" CssClass="button" OnClick="btnCancel_Click"
TabIndex="8" />
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center">
</td>
</tr>
<tr>
<td align="center">
<table width="60%" border="0" align="center">
<tr>
<td>
<div style="overflow: auto; height: 230px; width: 725px">
<asp:GridView ID="gvwCenter" runat="server" AllowPaging="True" AutoGenerateColumns="False"
DataKeyNames="CenterCode" CssClass="gvw" Width="98%" OnRowEditing="gvwCenter_RowEditing"
ShowHeaderWhenEmpty="True" OnPageIndexChanging="gvwCenter_PageIndexChanging"
OnRowDeleting="gvwCenter_RowDeleting" OnRowCommand="gvwCenter_RowCommand">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="lnkEdit" CommandArgument="<%# ((GridViewRow) Container).RowIndex %>"
runat="server" Text="Edit" CommandName="Edit">
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="CenterCode" HeaderText="Center Code" ReadOnly="True" />
<asp:BoundField DataField="CenterName" ItemStyle-HorizontalAlign="Left" HeaderText="Center Name"
ReadOnly="True">
<ItemStyle HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="CenterAddress1" ItemStyle-HorizontalAlign="Left" HeaderText="Center Add1"
ReadOnly="True">
<ItemStyle HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="CenterAddress2" ItemStyle-HorizontalAlign="Left" HeaderText="Center Add2"
ReadOnly="True">
<ItemStyle HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="LandLineNo" HeaderText="Landline No" ReadOnly="True" />
<asp:BoundField DataField="MobileNo" HeaderText="Mobile No" ReadOnly="true" />
<asp:BoundField DataField="CustomerName" HeaderText="Created By" ReadOnly="True" />
<asp:BoundField DataField="CreatedDate" HeaderText="Created Date" ReadOnly="True" />
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="lnkDelete" CommandArgument="<%# ((GridViewRow) Container).RowIndex %>"
runat="server" Text="Delete" CommandName="Delete" OnClientClick="return confirm('Are you sure to Delete this record?');">
</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerStyle BackColor="#A8211D" Height="1em" Font-Size="X-Small" ForeColor="White"
HorizontalAlign="Center" VerticalAlign="Middle" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
</asp:GridView>
</div>
</td>
</tr>
</table>
<asp:HiddenField ID="hdnCenterCode" runat="server" />
</td>
</tr>
</table>
</asp:Panel>
</ContentTemplate>
</asp:UpdatePanel>
</div>
</asp:Content>
Center.aspx.cs
using System;using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Xml.Linq;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
namespace eSMS.App_Code
{
public class KidsLayer
{
SqlConnection strConn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbConn"].ToString());
DataTable objDT = new DataTable("tbl");
public void Conn()
{
SqlConnection strConn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbConn"].ToString());
}
public DataTable Datatable(string SpName, params object[] CommandParameters)
{
strConn.Open();
using (SqlCommand comm = new SqlCommand(SpName, strConn))
{
comm.CommandText = SpName;
comm.CommandType = CommandType.StoredProcedure;
SqlCommandBuilder.DeriveParameters(comm);
comm.Parameters.RemoveAt(0);
for (int i = 0, j = comm.Parameters.Count; i < j; i++)
{
comm.Parameters[i].Value = CommandParameters[i];
}
SqlDataAdapter objDA = new SqlDataAdapter(comm);
objDA.Fill(objDT);
comm.Parameters.Clear();
strConn.Close();
return objDT;
}
}
public int ExecuteNonQuery(string SpName, params object[] CommandParameters)
{
strConn.Open();
using (SqlCommand comm = new SqlCommand(SpName, strConn))
{
comm.CommandText = SpName;
comm.CommandType = CommandType.StoredProcedure;
SqlCommandBuilder.DeriveParameters(comm);
comm.Parameters.RemoveAt(0);
for (int i = 0, j = comm.Parameters.Count; i < j; i++)
{
comm.Parameters[i].Value = CommandParameters[i];
}
int result = comm.ExecuteNonQuery();
comm.Parameters.Clear();
strConn.Close();
return result;
}
}
public DataSet Dataset(string SpName, params object[] CommandParameters)
{
strConn.Open();
using (SqlCommand cmd = new SqlCommand(SpName, strConn))
{
//con.Open();
cmd.CommandText = SpName;
cmd.CommandType = CommandType.StoredProcedure;
SqlCommandBuilder.DeriveParameters(cmd);
cmd.Parameters.RemoveAt(0);
for (int i = 0, j = cmd.Parameters.Count; i < j; i++)
{
cmd.Parameters[i].Value = CommandParameters[i];
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
strConn.Close();
cmd.Parameters.Clear();
return ds;
}
}
}
}
Create proc [dbo].[sp_GetCenterByName]
@CenterCode bigint,
@CenterName varchar(50)
as
select CenterCode,CenterName from Center where CenterCode=@CenterCode and CenterName=@CenterName AND (MFD = 0 OR MFD IS NULL)
Create PROCEDURE [dbo].[sp_SaveCenter]
-- Add the parameters for the stored procedure here
@CenterName nvarchar(50),
@CenterAddress1 nvarchar(MAX),
@CenterAddress2 nvarchar(MAX),
@LandLineNo nvarchar(50),
@MobileNo nvarchar(50),
@CreatedBy int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
INSERT INTO Center
(
CenterName,
CenterAddress1,
CenterAddress2,
LandLineNo,
MobileNo,
CreatedBy,
CreatedDate
)
VALUES
(
@CenterName,
@CenterAddress1,
@CenterAddress2,
@LandLineNo,
@MobileNo,
@CreatedBy,
GETDATE()
)
END
Create PROCEDURE [dbo].[sp_UpdateCenter]
-- Add the parameters for the stored procedure here
@CenterCode bigint,
@CenterName nvarchar(50),
@CenterAddress1 nvarchar(MAX),
@CenterAddress2 nvarchar(MAX),
@LandLineNo nvarchar(50),
@MobileNo nvarchar(50),
@ModifiedBy int,
@MFD bit
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
IF (@MFD = 0)
BEGIN
UPDATE Center
SET
CenterName=@CenterName,
CenterAddress1=@CenterAddress1,
CenterAddress2=@CenterAddress2,
LandLineNo=@LandLineNo,
MobileNo=@MobileNo,
ModifiedBy=@ModifiedBy,
ModifiedDate=GETDATE()
WHERE
CenterCode=@CenterCode
END
ELSE
BEGIN
UPDATE Center
SET MFD = 1
, ModifiedBy = @ModifiedBy
, ModifiedDate = GETDATE()
WHERE
CenterCode=@CenterCode
END
END
No comments:
Post a Comment