Asp.Net Form Design:
Asp.Net Form Design Code
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ModifyCustomerDetails.aspx.cs" Inherits="MyProject.ModifyCustomerDetails" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Button ID="btnsave" runat="server" Enabled="False" style="z-index: 1; left: 733px; top: 202px; position: absolute; height: 29px; width: 55px;" Text="Save" OnClick="btnsave_Click" />
<asp:Label ID="Label1" runat="server" style="z-index: 1; left: 65px; top: 111px; position: absolute" Text="Date Of Birth*"></asp:Label>
<asp:Label ID="Label2" runat="server" style="z-index: 1; left: 107px; top: 80px; position: absolute" Text="Gender*"></asp:Label>
<asp:RadioButton ID="rother" runat="server" style="z-index: 1; left: 304px; top: 78px; position: absolute" Text="Other" GroupName="gender" />
<asp:RadioButton ID="rfemale" runat="server" style="z-index: 1; left: 222px; top: 79px; position: absolute" Text="Female" GroupName="gender" />
<asp:RadioButton ID="rmale" runat="server" style="z-index: 1; left: 157px; top: 77px; position: absolute" Text="Male" GroupName="gender" />
<asp:Label ID="Label4" runat="server" style="z-index: 1; left: 122px; top: 194px; position: absolute" Text="City*"></asp:Label>
<asp:Label ID="Label7" runat="server" style="z-index: 1; left: 93px; top: 274px; position: absolute" Text="Zip code*"></asp:Label>
<asp:Label ID="Label8" runat="server" style="z-index: 1; left: 110px; top: 300px; position: absolute" Text="Phone"></asp:Label>
<asp:Label ID="Label11" runat="server" style="z-index: 1; left: 89px; top: 407px; position: absolute" Text="Education"></asp:Label>
<asp:Label ID="Label12" runat="server" style="z-index: 1; left: 51px; top: 380px; position: absolute" Text="Education Type*"></asp:Label>
<asp:Label ID="Label13" runat="server" style="z-index: 1; left: 77px; top: 327px; position: absolute" Text="Mobile No*"></asp:Label>
<asp:Label ID="Label14" runat="server" style="z-index: 1; left: 108px; top: 354px; position: absolute" Text="EMail*"></asp:Label>
<asp:Label ID="Label9" runat="server" style="z-index: 1; left: 121px; top: 249px; position: absolute; bottom: 257px" Text="Stat*"></asp:Label>
<asp:Label ID="Label10" runat="server" style="z-index: 1; left: 113px; top: 221px; position: absolute" Text="Street*"></asp:Label>
<asp:Label ID="Label5" runat="server" style="z-index: 1; left: 93px; top: 140px; position: absolute" Text="Address*"></asp:Label>
<asp:Label ID="Label6" runat="server" style="z-index: 1; left: 86px; top: 51px; position: absolute" Text="Full Name*"></asp:Label>
<asp:TextBox ID="txtstat" runat="server" style="z-index: 1; left: 158px; top: 247px; position: absolute"></asp:TextBox>
<asp:TextBox ID="txtcity" runat="server" style="z-index: 1; left: 158px; top: 194px; position: absolute"></asp:TextBox>
<asp:TextBox ID="txtphone" runat="server" style="z-index: 1; left: 158px; top: 301px; position: absolute"></asp:TextBox>
<asp:TextBox ID="txtremarks" runat="server" style="z-index: 1; left: 505px; top: 75px; position: absolute; height: 81px; width: 260px" TextMode="MultiLine"></asp:TextBox>
<asp:TextBox ID="txtcustid" runat="server" style="z-index: 1; left: 160px; top: 21px; position: absolute; width: 71px;"></asp:TextBox>
<asp:Button ID="btnfind" runat="server" OnClick="btnfind_Click" style="z-index: 1; left: 253px; top: 18px; position: absolute" Text="Find" />
<asp:TextBox ID="txtemail" runat="server" style="z-index: 1; left: 158px; top: 354px; position: absolute"></asp:TextBox>
<asp:TextBox ID="txtuniversityname" runat="server" style="z-index: 1; left: 158px; top: 463px; position: absolute"></asp:TextBox>
<asp:TextBox ID="txtinterest" runat="server" style="z-index: 1; left: 505px; top: 49px; position: absolute; width: 365px"></asp:TextBox>
<asp:TextBox ID="txtuniversitycountry" runat="server" style="z-index: 1; left: 158px; top: 493px; position: absolute"></asp:TextBox>
<asp:Label ID="Label15" runat="server" style="z-index: 1; left: 37px; top: 493px; position: absolute" Text="University Country"></asp:Label>
<asp:Label ID="Label16" runat="server" style="z-index: 1; left: 52px; top: 462px; position: absolute" Text="University Name"></asp:Label>
<asp:Label ID="Label17" runat="server" style="z-index: 1; left: 105px; top: 435px; position: absolute; right: 862px" Text="Stream"></asp:Label>
<asp:TextBox ID="txtmobile" runat="server" style="z-index: 1; left: 158px; top: 326px; position: absolute"></asp:TextBox>
<asp:TextBox ID="txteducation" runat="server" style="z-index: 1; left: 157px; top: 407px; position: absolute"></asp:TextBox>
<asp:TextBox ID="txtfullname" runat="server" style="z-index: 1; left: 160px; top: 50px; position: absolute; width: 240px"></asp:TextBox>
<asp:TextBox ID="txtzipcode" runat="server" style="z-index: 1; left: 158px; top: 273px; position: absolute"></asp:TextBox>
<asp:TextBox ID="txtaddress" runat="server" style="z-index: 1; left: 159px; top: 137px; position: absolute"></asp:TextBox>
<asp:TextBox ID="txtstreet" runat="server" style="z-index: 1; left: 158px; top: 221px; position: absolute"></asp:TextBox>
<asp:TextBox ID="txtdbo" runat="server" style="z-index: 1; left: 158px; top: 107px; position: absolute"></asp:TextBox>
<asp:TextBox ID="txtcountry" runat="server" style="z-index: 1; left: 159px; top: 166px; position: absolute"></asp:TextBox>
<asp:DropDownList ID="ddledutype" runat="server" style="z-index: 1; left: 158px; top: 380px; position: absolute; bottom: 123px;" OnSelectedIndexChanged="ddledutype_SelectedIndexChanged">
<asp:ListItem>Academy</asp:ListItem>
<asp:ListItem>Non Academy</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="ddlstream" runat="server" style="z-index: 1; left: 158px; top: 435px; position: absolute" OnSelectedIndexChanged="ddlstream_SelectedIndexChanged">
<asp:ListItem></asp:ListItem>
<asp:ListItem>Science</asp:ListItem>
<asp:ListItem>Engineering</asp:ListItem>
<asp:ListItem>Education</asp:ListItem>
<asp:ListItem>Humanities</asp:ListItem>
<asp:ListItem>Education</asp:ListItem>
</asp:DropDownList>
<asp:Label ID="Label18" runat="server" style="z-index: 1; left: 445px; top: 48px; position: absolute" Text="Interest*"></asp:Label>
<asp:Label ID="Label19" runat="server" style="z-index: 1; left: 438px; top: 76px; position: absolute" Text="Remarks*"></asp:Label>
<asp:Button ID="btncancle" runat="server" style="z-index: 1; left: 810px; top: 203px; position: absolute" Text="Cancle" />
<asp:Label ID="lblerror" runat="server" style="z-index: 1; left: 306px; top: 22px; position: absolute"></asp:Label>
<asp:Label ID="Label20" runat="server" style="z-index: 1; left: 79px; top: 23px; position: absolute" Text="CustomerId"></asp:Label>
</div>
<p>
</p>
</form>
</body>
</html>
Asp.net ModifyCustomerDetails.aspx.cs Code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
namespace MyProject
{
public partial class ModifyCustomerDetails : System.Web.UI.Page
{
SqlConnection con;
public void DBConnection()
{
con = new SqlConnection("Server=Kool-PC;Database=CenterDB;user=sa;password=a;trusted_connection=yes");
}
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnfind_Click(object sender, EventArgs e)
{
if(txtcustid.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter customer id.')</script>");
txtcustid.Focus();
}
else
{
getCustomerId();
}
}
private void getCustomerId()
{
DBConnection();
con.Open();
// try
//{
SqlCommand cmd;
cmd = new SqlCommand("Select * From CustomerDetails Where CustomerId='"+txtcustid.Text.Trim()+"'", con);
SqlDataReader dr = cmd.ExecuteReader();
if(dr.HasRows)
{
dr.Read();
txtfullname.Text = dr["CustomerName"].ToString();
if(dr["Gender"].ToString()=="Male")
{
rmale.Checked = true;
rfemale.Checked = false;
rother.Checked = false;
}
else if(dr["Gender"].ToString()=="Female")
{
rmale.Checked = false;
rfemale.Checked = true;
rother.Checked = false;
}
else if (dr["Gender"].ToString() == "Other")
{
rmale.Checked = false;
rfemale.Checked = false;
rother.Checked = true;
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Undefined gender.')</script>");
return;
}
txtdbo.Text = dr["DateOfBirth"].ToString();
txtaddress.Text = dr["Address"].ToString();
txtcountry.Text = dr["Country"].ToString();
txtcity.Text = dr["City"].ToString();
txtstreet.Text = dr["Street"].ToString();
txtstat.Text = dr["Stat"].ToString();
txtzipcode.Text = dr["ZipCode"].ToString();
txtphone.Text = dr["Phone"].ToString();
txtmobile.Text = dr["Mobile"].ToString();
txtemail.Text = dr["Email"].ToString();
ddledutype.Text = dr["EducationType"].ToString();
txteducation.Text = dr["Education"].ToString();
ddlstream.Text = dr["Stream"].ToString();
txtuniversityname.Text = dr["UniversityName"].ToString();
txtuniversitycountry.Text = dr["UniversityCountry"].ToString();
txtinterest.Text = dr["Interest"].ToString();
txtremarks.Text = dr["Remarks"].ToString();
btnsave.Enabled = true;
}
else
{
btnsave.Enabled = false;
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Id does not exist')</script>");
txtcustid.Focus();
}
//}
//catch(Exception ex)
// {
//lblerror.Text = ex.Message;
//}
}
protected void btncancle_Click(object sender, EventArgs e)
{
txtfullname.Text = "";
rmale.Checked = false;
rfemale.Checked = false;
rother.Checked = false;
txtdbo.Text = "";
txtaddress.Text = "";
txtcountry.Text = "";
txtcity.Text = "";
txtstreet.Text = "";
txtstat.Text = "";
txtzipcode.Text = "";
txtphone.Text = "";
txtmobile.Text = "";
txtemail.Text = "";
txteducation.Text = "";
txtuniversityname.Text = "";
txtuniversitycountry.Text = "";
txtinterest.Text = "";
txtremarks.Text = "";
}
protected void btnsave_Click(object sender, EventArgs e)
{
if (txtfullname.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter Full Name.')</script>");
txtfullname.Focus();
}
else if ((rmale.Checked = false) && (rfemale.Checked = false) && (rother.Checked = false))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Select Gender.')</script>");
}
else if (txtdbo.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter Date Of Birth.')</script>");
txtdbo.Focus();
}
else if (txtaddress.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter Address.')</script>");
txtaddress.Focus();
}
else if (txtcountry.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter Country Name.')</script>");
txtcountry.Focus();
}
else if (txtcity.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter City.')</script>");
txtcity.Focus();
}
else if (txtstreet.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter Street.')</script>");
txtstreet.Focus();
}
else if (txtstat.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter Stat.')</script>");
txtstat.Focus();
}
else if (txtzipcode.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter ZipCode.')</script>");
txtzipcode.Focus();
}
else if (txtmobile.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter mobile no.')</script>");
txtmobile.Focus();
}
else if (txtemail.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter Email Address.')</script>");
txtemail.Focus();
}
else if (txtinterest.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter Interest.')</script>");
txtinterest.Focus();
}
else if ((txtremarks.Text.Trim().Equals("")) || (txtremarks.Text.Trim().Length <= 10))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter Remarks.')</script>");
txtremarks.Focus();
}
else if (ddledutype.SelectedIndex == 0)
{
if (txteducation.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter Education.')</script>");
txteducation.Focus();
}
else if (ddlstream.SelectedIndex == -1)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Select Stream.')</script>");
ddlstream.Focus();
}
else if (txtuniversityname.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter University Name.')</script>");
txtuniversityname.Focus();
}
else if (txtuniversitycountry.Text.Trim().Equals(""))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Enter University Country Name.')</script>");
txtuniversitycountry.Focus();
}
else
{
updateRecord();
}
}
else
{
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Calling to insert.')</script>");
updateRecord();
}
}
protected void updateRecord()
{
try
{
DBConnection();
con.Open();
SqlCommand cmd;
cmd = new SqlCommand("Update CustomerDetails SET CustomerName=@fullname,Gender=@gender,DateOfBirth=@dob,Address=@address,Country=@country,City=@city,Street=@street,Stat=@stat,ZipCode=@zipcode,Phone=@phone,Mobile=@mobile,Email=@email,EducationType=@ddlacademytype,Education=@education,Stream=@ddlstream,UniversityName=@universityname,UniversityCountry=@universitycountry,Interest=@interest,Remarks=@remarks Where CustomerId=@CustomerId", con);
cmd.Parameters.Add("@CustomerId", SqlDbType.Int).Value = txtcustid.Text.Trim();
cmd.Parameters.Add("@fullname", SqlDbType.VarChar, 50).Value = txtfullname.Text.Trim();
if((rfemale.Checked==false)&&(rother.Checked==false)&&(rmale.Checked==true))
{
cmd.Parameters.Add("@gender", SqlDbType.VarChar, 10).Value = rmale.Text.Trim();
lblerror.Text = rmale.Text;
}
else if ((rmale.Checked == false) && (rfemale.Checked == true) && (rother.Checked == false))
{
cmd.Parameters.Add("@gender", SqlDbType.VarChar, 10).Value = rfemale.Text.Trim();
lblerror.Text = rfemale.Text;
}
else if ((rmale.Checked == false) && (rfemale.Checked == false) && (rother.Checked == true))
{
cmd.Parameters.Add("@gender", SqlDbType.VarChar, 10).Value = rother.Text.Trim();
lblerror.Text = rother.Text;
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Unspecified Gender.')</script>");
return;
}
cmd.Parameters.Add("@dob", SqlDbType.Date).Value = txtdbo.Text.Trim();
cmd.Parameters.Add("@address", SqlDbType.VarChar, 100).Value = txtaddress.Text.Trim();
cmd.Parameters.Add("@country", SqlDbType.VarChar, 50).Value = txtcountry.Text.Trim();
cmd.Parameters.Add("@city", SqlDbType.VarChar, 50).Value = txtcity.Text.Trim();
cmd.Parameters.Add("@street", SqlDbType.VarChar, 50).Value = txtstreet.Text.Trim();
cmd.Parameters.Add("@stat", SqlDbType.VarChar, 50).Value = txtstat.Text.Trim();
cmd.Parameters.Add("@zipcode", SqlDbType.VarChar, 50).Value = txtzipcode.Text.Trim();
cmd.Parameters.Add("@phone", SqlDbType.VarChar, 50).Value = txtphone.Text.Trim();
cmd.Parameters.Add("@mobile", SqlDbType.VarChar, 50).Value = txtmobile.Text.Trim();
cmd.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = txtemail.Text.Trim();
if (ddledutype.SelectedIndex == 0)
{
cmd.Parameters.Add("@ddlacademytype", SqlDbType.VarChar, 50).Value = ddledutype.Text.Trim();
cmd.Parameters.Add("@education", SqlDbType.VarChar, 50).Value = txteducation.Text.Trim();
cmd.Parameters.Add("@ddlstream", SqlDbType.VarChar, 50).Value = ddlstream.Text.Trim();
cmd.Parameters.Add("@universityname", SqlDbType.VarChar, 50).Value = txtuniversityname.Text.Trim();
cmd.Parameters.Add("@universitycountry", SqlDbType.VarChar, 50).Value = txtuniversitycountry.Text.Trim();
}
else if (ddledutype.SelectedIndex == 1)
{
cmd.Parameters.Add("@ddlacademytype", SqlDbType.VarChar, 50).Value = ddledutype.Text.Trim();
cmd.Parameters.Add("@education", SqlDbType.VarChar, 50).Value = DBNull.Value;
cmd.Parameters.Add("@ddlstream", SqlDbType.VarChar, 50).Value = DBNull.Value;
cmd.Parameters.Add("@universityname", SqlDbType.VarChar, 50).Value = DBNull.Value;
cmd.Parameters.Add("@universitycountry", SqlDbType.VarChar, 50).Value = DBNull.Value;
}
else
{
}
cmd.Parameters.Add("@interest", SqlDbType.VarChar, 100).Value = txtinterest.Text.Trim();
cmd.Parameters.Add("@remarks", SqlDbType.VarChar, 200).Value = txtremarks.Text.Trim();
int count = 0;
if ((count = cmd.ExecuteNonQuery()) == 1)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('Successfuly modified.')</script>");
}
}
catch (Exception ex)
{
txtfullname.Text = ex.Message;
Page.ClientScript.RegisterStartupScript(Page.GetType(), "Message Box", "<script language = 'javascript'>alert('" + ex.Message + "')</script>");
}
}
protected void ddlstream_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void ddledutype_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddledutype.SelectedIndex == 1)
{
txteducation.Enabled = false;
ddlstream.Enabled = false;
txtuniversityname.Enabled = false;
txtuniversitycountry.Enabled = false;
}
else
{
txteducation.Enabled = true;
ddlstream.Enabled = true;
txtuniversityname.Enabled = true;
txtuniversitycountry.Enabled = true;
}
}
}
}
No comments:
Post a Comment