public bool AddCustomer(Customer cust)
{
bool status = false;
string conStr = ConfigurationManager.ConnectionStrings["FashionableMeDB"].ConnectionString;
SqlConnection conn = new SqlConnection(conStr);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into Customer values (@userid,@email,@pass,@name,@address,@city,@state,@pin,@mobile,@dob,@gender)",conn);
cmd.Parameters.AddWithValue("userid",cust.UserID);
cmd.Parameters.AddWithValue("email", cust.Email);
cmd.Parameters.AddWithValue("pass",cust.Password );
cmd.Parameters.AddWithValue("name",cust.Name );
cmd.Parameters.AddWithValue("address", cust.Address);
cmd.Parameters.AddWithValue("city", cust.City);
cmd.Parameters.AddWithValue("state", cust.State);
cmd.Parameters.AddWithValue("pin", cust.Pincode);
cmd.Parameters.AddWithValue("mobile", cust.MobileNumber);
cmd.Parameters.AddWithValue("dob", cust.DateOfBirth.ToString());
cmd.Parameters.AddWithValue("gender", cust.IsMale?"M":"F");
int res = cmd.ExecuteNonQuery();
status = true;
}
catch (Exception exc)
{
HttpContext.Current.Session["ErrorMessage"] = exc.Message;
status = false;
}
conn.Close();
return status;
}
public bool sendRegisterDetails(Customer cust)
{
CustomerDal dalobj = new CustomerDal();
// step 1, calculate MD5 hash from input
cust.Password = hashPassword(cust.Password);
if(dalobj.AddCustomer(cust))
return true;
return false;
}
