public bool CustomerSignUp(CUSTOMER_PROFILE CustomerProfile) { bool customerAdded = false; SqlConnection con = new SqlConnection(ConnectionString); string command = "CUSTOMER_PROFILE_CustomerSignUp"; SqlCommand cmd = new SqlCommand(command, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Cust_ID", SqlDbType.UniqueIdentifier).Value = CustomerProfile.CUST_ID; cmd.Parameters.Add("@FirstName", SqlDbType.NChar).Value = CustomerProfile.FIRST_NAME; cmd.Parameters.Add("@LastName", SqlDbType.NChar).Value = CustomerProfile.LAST_NAME; cmd.Parameters.Add("@Address", SqlDbType.NChar).Value = CustomerProfile.ADDRESS; cmd.Parameters.Add("@Email", SqlDbType.NChar).Value = CustomerProfile.EMAIL; cmd.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = CustomerProfile.PHONE_NO; cmd.Parameters.Add("@Gender", SqlDbType.NChar).Value = CustomerProfile.GENDER; cmd.Parameters.Add("@PassWord", SqlDbType.NVarChar).Value = CustomerProfile.PASSWORD; try { con.Open(); cmd.ExecuteNonQuery(); customerAdded = true; } catch (Exception ex) { throw; } con.Close(); return(customerAdded); }
public bool CustomerUpdate(CUSTOMER_PROFILE updateCustomer) { bool customerUpdated = false; SqlConnection con = new SqlConnection(ConnectionString); string command = "[dbo].[CUSTOMER_PROFILE_Edit]"; SqlCommand cmd = new SqlCommand(command, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@CustID", SqlDbType.UniqueIdentifier).Value = updateCustomer.CUST_ID; cmd.Parameters.Add("@FirstName", SqlDbType.NChar).Value = updateCustomer.FIRST_NAME; cmd.Parameters.Add("@LastName", SqlDbType.NChar).Value = updateCustomer.LAST_NAME; cmd.Parameters.Add("@Gender", SqlDbType.NChar).Value = updateCustomer.GENDER; cmd.Parameters.Add("@Address", SqlDbType.NChar).Value = updateCustomer.ADDRESS; cmd.Parameters.Add("@Email", SqlDbType.NChar).Value = updateCustomer.EMAIL; cmd.Parameters.Add("@PhNO", SqlDbType.NVarChar).Value = updateCustomer.PHONE_NO; cmd.Parameters.Add("@PassWord", SqlDbType.NVarChar).Value = updateCustomer.PASSWORD; try { con.Open(); cmd.ExecuteNonQuery(); customerUpdated = true; } catch { customerUpdated = false; throw; } return(customerUpdated); }
public CUSTOMER_PROFILE CustomerDetails(Guid CustID) { SqlConnection con = new SqlConnection(ConnectionString); string command = "[dbo].[CUSTOMER_PROFILE_Details]"; SqlCommand cmd = new SqlCommand(command, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@CustID", SqlDbType.UniqueIdentifier).Value = CustID; SqlDataReader reader; CUSTOMER_PROFILE custprofile = new CUSTOMER_PROFILE();; try { con.Open(); reader = cmd.ExecuteReader(); if (reader.Read()) { custprofile.CUST_ID = new Guid(reader["CUST_ID"].ToString()); custprofile.FIRST_NAME = reader["FIRST_NAME"].ToString(); custprofile.LAST_NAME = reader["LAST_NAME"].ToString(); custprofile.GENDER = reader["GENDER"].ToString(); custprofile.EMAIL = reader["EMAIL"].ToString(); custprofile.ADDRESS = reader["ADDRESS"].ToString(); custprofile.PHONE_NO = reader["PHONE_NO"].ToString(); custprofile.PASSWORD = reader["PASSWORD"].ToString(); } } catch (Exception ex) { throw ex; } return(custprofile); }
public ActionResult customerLogin(string returnUrl) { CUSTOMER_PROFILE profileForLogin = new CUSTOMER_PROFILE(); profileForLogin.extraLogin.ReturnUrl = returnUrl; if (SessionHandler.CurrentUser != null) { return(RedirectToAction("Index", "Home")); } return(View(profileForLogin)); }
public ActionResult Edit(CUSTOMER_PROFILE customerEdit) { if (customerEdit.customerUpdate()) { ViewBag.Message = "Your information updated successfully !!"; } else { ViewBag.Message = "Error occured while updateing the you information." + "\n[Customer_SignUpController.Edit {POST} ]"; } return(View(customerEdit)); }
public ActionResult customerLogin(CUSTOMER_PROFILE profile) { if (profile.CustomerLogin() != null) { if (profile.extraLogin.ReturnUrl == null) { return(RedirectToAction("Index", "Home")); } else { return(Redirect(profile.extraLogin.ReturnUrl)); } } return(View()); }
public CUSTOMER_PROFILE CustomerLogin(string email, string password) { SqlConnection con = new SqlConnection(ConnectionString); string command = "[dbo].[CUSTOMER_PROFILE_LogIn]"; SqlCommand cmd = new SqlCommand(command, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Email", SqlDbType.NChar).Value = email; cmd.Parameters.Add("@PassWord", SqlDbType.NVarChar).Value = password; SqlDataReader reader; CUSTOMER_PROFILE CustomerInfo = null; try { CustomerInfo = new CUSTOMER_PROFILE(); con.Open(); reader = cmd.ExecuteReader(); if (reader.Read()) { CustomerInfo.CUST_ID = new Guid(reader["CUST_ID"].ToString()); CustomerInfo.FIRST_NAME = reader["FIRST_NAME"].ToString(); CustomerInfo.LAST_NAME = reader["LAST_NAME"].ToString(); CustomerInfo.GENDER = reader["GENDER"].ToString(); CustomerInfo.ADDRESS = reader["ADDRESS"].ToString(); CustomerInfo.PHONE_NO = reader["PHONE_NO"].ToString(); CustomerInfo.EMAIL = reader["EMAIL"].ToString(); CustomerInfo.STATUS = reader["STATUS"].ToString(); } } catch { CustomerInfo = null; throw; } return(CustomerInfo); }
public ActionResult CustomerSignUp(CUSTOMER_PROFILE CustomerProfile) { if (CustomerProfile.PASSWORD.Equals(CustomerProfile.CONFIRMPASSWORD)) { if (CustomerProfile.CustomerSignUp()) { //direct login FormsAuthentication.SetAuthCookie(CustomerProfile.EMAIL, CustomerProfile.extraLogin.RememberMe); return(RedirectToAction("Index", "Home")); } else { } } else { ViewBag.Message = "Passwords do not match !!"; } return(View()); }
public ActionResult Edit(Guid custID) { CUSTOMER_PROFILE customerEdit = new CUSTOMER_PROFILE(); return(View(customerEdit.CustomerDetails(custID))); }
// // GET: /Customer_SignUp/ public ActionResult CustomerSignUp() { CUSTOMER_PROFILE SignUp = new CUSTOMER_PROFILE(); return(View(SignUp)); }