public ActionResult Create(BusinessLayer.CustomerDetail values) { if (ModelState.IsValid) { // try //{ Check if this new email already exists on DB if (!dbset.ConfirmEmailIsUnique(values.Email.ToString())) { var order = new BusinessLayer.CustomerDetail(); var cartid = sc.GetCartId(this.HttpContext); //Create new member into the database sc.CreateMember(values);//customerDetail //send admin an email to call and confirm new user BusinessLayer.SendEmails sendmail = new SendEmails(); sendmail.NewCustomerEmail(values); //Update tblUserProfile with correct UserName sc.UpdatetblUserProfileWithCurrentUserName(values.Email.Trim(), cartid); return(RedirectToAction("Index", "ShoppingCart")); } else { ViewBag.StateId = new SelectList(dbset.States, "StateId", "StateName"); return(View("NotUniqueEmailIndex")); } } ViewBag.StateId = new SelectList(dbset.States, "StateId", "StateName"); return(View()); }
public void CreateMember(CustomerDetail customer) { using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spAddMemberToCustomerDB", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter paramUsername = new SqlParameter(); paramUsername.ParameterName = "@Username"; paramUsername.Value = customer.Email; cmd.Parameters.Add(paramUsername); SqlParameter parampassword = new SqlParameter(); parampassword.ParameterName = "@password"; parampassword.Value = customer.password; cmd.Parameters.Add(parampassword); SqlParameter paramFirstName = new SqlParameter(); paramFirstName.ParameterName = "@FirstName"; paramFirstName.Value = customer.FirstName; cmd.Parameters.Add(paramFirstName); SqlParameter paramLastName = new SqlParameter(); paramLastName.ParameterName = "@LastName"; paramLastName.Value = customer.LastName; cmd.Parameters.Add(paramLastName); SqlParameter paramAddress = new SqlParameter(); paramAddress.ParameterName = "@Address"; paramAddress.Value = customer.Address; cmd.Parameters.Add(paramAddress); SqlParameter paramStateId = new SqlParameter(); paramStateId.ParameterName = "@StateId"; paramStateId.Value = customer.StateId; cmd.Parameters.Add(paramStateId); SqlParameter paramPhone = new SqlParameter(); paramPhone.ParameterName = "@Phone"; paramPhone.Value = customer.Phone; cmd.Parameters.Add(paramPhone); SqlParameter paramEmail = new SqlParameter(); paramEmail.ParameterName = "@Email"; paramEmail.Value = customer.Email; cmd.Parameters.Add(paramEmail); con.Open(); cmd.ExecuteNonQuery(); } }
public ActionResult Edit(BusinessLayer.CustomerDetail cusdet) { if (ModelState.IsValid) { dbset.SaveChangesCustomerDetailToDB(cusdet); return(RedirectToAction("Index", "Home")); } var cartid = sc.GetCartId(this.HttpContext); string UserName = sc.GetLoginDetail(cartid); BusinessLayer.CustomerDetail fooditem = dbset.CustomerDetails.Single(emp => emp.Email == UserName); ViewBag.StateId = new SelectList(dbset.States.OrderBy(x => x.StateName), "StateId", "StateName", fooditem.StateId); return(View(fooditem)); }
public void SaveChangesCustomerDetailToDB(CustomerDetail employee) { using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spSaveChangesCustomerDetail", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter parampassword = new SqlParameter(); parampassword.ParameterName = "@password"; parampassword.Value = employee.password; cmd.Parameters.Add(parampassword); SqlParameter paramFirstName = new SqlParameter(); paramFirstName.ParameterName = "@FirstName"; paramFirstName.Value = employee.FirstName; cmd.Parameters.Add(paramFirstName); SqlParameter paramLastName = new SqlParameter(); paramLastName.ParameterName = "@LastName"; paramLastName.Value = employee.LastName; cmd.Parameters.Add(paramLastName); SqlParameter paramAddress = new SqlParameter(); paramAddress.ParameterName = "@Address"; paramAddress.Value = employee.Address; cmd.Parameters.Add(paramAddress); SqlParameter paramStateId = new SqlParameter(); paramStateId.ParameterName = "@StateId"; paramStateId.Value = employee.StateId; cmd.Parameters.Add(paramStateId); SqlParameter paramPhone = new SqlParameter(); paramPhone.ParameterName = "@Phone"; paramPhone.Value = employee.Phone; cmd.Parameters.Add(paramPhone); SqlParameter paramEmail = new SqlParameter(); paramEmail.ParameterName = "@Email"; paramEmail.Value = employee.Email; cmd.Parameters.Add(paramEmail); con.Open(); cmd.ExecuteNonQuery(); } }
// // GET: /CheckOut/Edit/5 public ActionResult Edit() { var cartid = sc.GetCartId(this.HttpContext); string UserName = sc.GetLoginDetail(cartid); if (UserName == "Guest") { return(View("Index")); } else { BusinessLayer.CustomerDetail fooditem = dbset.CustomerDetails.Single(emp => emp.Email == UserName); if (fooditem == null) { return(HttpNotFound()); } ViewBag.StateId = new SelectList(dbset.States.OrderBy(x => x.StateName), "StateId", "StateName", fooditem.StateId); return(View(fooditem)); } }