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>"); } }