public int AddCustomer(C_BO C)
{
SqlConnection con = new SqlConnection("server=intvmsql01;user id=PJ09TMS101_1718;password=tcstvm;database=DB09TMS101_1718");
con.Open();
SqlCommand cmd = new SqlCommand("sp_addcustomer03", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@cn", C.C_Name1);
cmd.Parameters.AddWithValue("@g", C.Gender1);
cmd.Parameters.AddWithValue("@dob", C.DOB1);
cmd.Parameters.AddWithValue("@cno", C.C_Number1);
cmd.Parameters.AddWithValue("@city", C.City1);
cmd.Parameters.AddWithValue("@cid", 0);
cmd.Parameters["@cid"].Direction = ParameterDirection.Output;
int rowaffected = cmd.ExecuteNonQuery();
if (rowaffected > 0)
{
int cid = Convert.ToInt32(cmd.Parameters["@cid"].Value);
return(cid);
}
else
{
return(0);
}
}
public List <C_BO> ViewCustomer()
{
SqlConnection con = new SqlConnection("server=intvmsql01;user id=PJ09TMS101_1718;password=tcstvm;database=DB09TMS101_1718");
con.Open();
SqlCommand cmd = new SqlCommand("sp_viewcustomer123", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader();
List <C_BO> lst = new List <C_BO>();
while (reader.Read())
{
C_BO c = new C_BO();
c.C_id1 = Convert.ToInt32(reader["C_id"]);
c.C_Name1 = reader["C_Name"].ToString();
c.Gender1 = reader["Gender"].ToString();
c.DOB1 = Convert.ToDateTime(reader["DOB"]);
c.C_Number1 = Convert.ToInt64(reader["C_Number"]);
c.City1 = reader["City"].ToString();
lst.Add(c);
}
return(lst);
}
protected void Button1_Click(object sender, EventArgs e)
{
string c_name = TextBox1.Text;
string g = DropDownList1.Text;
DateTime dob = DateTime.Parse(TextBox2.Text);
double c_no = Convert.ToInt64(TextBox3.Text);
string city = TextBox4.Text;
C_BO obj = new C_BO(c_name, g, dob, c_no, city);
C_DAL obj1 = new C_DAL();
int cid = obj1.AddCustomer(obj);
if (cid > 0)
{
Response.Write("<script>alert('Your customer id is" + cid + "')</script>");
}
else
{
Response.Write("<script>alert('Error')</script>");
}
}
