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