public ActionResult NewCustomer(CustTable cus) { var context = new Mydb(); context.CustTables.Add(cus); context.SaveChanges(); return(RedirectToAction("AllCustomers")); }
public ActionResult AddtoCart(int id) { if (Session["id"] == null) { return(Redirect("~/Customer/Login")); } if (ModelState.IsValid) { Products find = db.products.Find(id); cart c = new cart(); c.pid = find.id; c.cid = (int)Session["id"]; db.cart.Add(c); db.SaveChanges(); return(RedirectToAction("ShowCart")); } return(View()); }
public ActionResult Signup(customer data) { if (ModelState.IsValid) { db.customer.Add(data); db.SaveChanges(); return(Redirect("~/Customer/Login")); } return(View(data)); }
public ActionResult Delete(string id) { int cusId = int.Parse(id); var context = new Mydb(); var model = context.CustTables.FirstOrDefault((e) => e.CustId == cusId); context.CustTables.Remove(model); context.SaveChanges(); return(RedirectToAction("AllCustomers")); }
public ActionResult AddProducts(Products pro) { if (ModelState.IsValid) { db.products.Add(pro); db.SaveChanges(); return(Redirect("~/Admin/index")); } return(View(pro)); }
public ActionResult Find(CustTable cus) { var context = new Mydb(); var model = context.CustTables.FirstOrDefault((e) => e.CustId == cus.CustId); model.CustName = cus.CustName; model.CustAddress = cus.CustAddress; model.CustSalary = cus.CustSalary; context.SaveChanges(); return(RedirectToAction("AllCustomers")); }
public ActionResult placeOrder() { if (Session["id"] == null) { return(Redirect("~/Customer/Login")); } var cart = db.cart.ToArray(); Orders ord = new Orders(); for (int i = 0; i < cart.Length; i++) { ord.uis = (int)Session["id"]; ord.pid = cart[i].pid; ord.status = "Pending"; db.orders.Add(ord); db.SaveChanges(); db.cart.Remove(cart[i]); db.SaveChanges(); } return(Redirect("~/Products/Index")); }
// Post Data In Db public UserDetails saveUser(UserDtl userDtl) { try { string message = null; UserDtl user1 = db.UserDtls.SingleOrDefault(x => x.email == userDtl.email); if (user1 == null) { var pass = EncodePasswordToBase64(userDtl.password); if (userDtl.role == 1) { userDtl.active = true; var user = new UserDtl() { active = true, userName = userDtl.userName.Trim().ToLower(), email = userDtl.email.Trim().ToLower(), firstName = userDtl.firstName.Trim(), lastName = userDtl.lastName.Trim(), role = userDtl.role, password = pass }; db.UserDtls.Add(user); db.SaveChanges(); message = "Registered Successfully"; } else if (userDtl.role == 2) { var user = new UserDtl(); user.active = true; user.role = userDtl.role; user.userName = userDtl.userName.Trim().ToLower(); user.email = userDtl.email.Trim().ToLower(); user.firstName = userDtl.firstName.Trim(); user.lastName = userDtl.lastName.Trim(); user.contactNumber = userDtl.contactNumber; user.yearOfExperience = userDtl.yearOfExperience; user.linkedinUrl = userDtl.linkedinUrl; user.trainerTimings = userDtl.trainerTimings; user.trainerTechnology = userDtl.trainerTechnology; user.password = pass; user.confirmedSignUp = userDtl.confirmedSignUp; db.UserDtls.Add(user); db.SaveChanges(); message = "Registered Successfully"; } else if (userDtl.role == 3) { var user = new UserDtl(); user.active = true; user.role = userDtl.role; user.userName = userDtl.userName.Trim().ToLower(); user.email = userDtl.email.Trim().ToLower(); user.firstName = userDtl.firstName.Trim(); user.lastName = userDtl.lastName.Trim(); user.contactNumber = userDtl.contactNumber; user.password = pass; user.confirmedSignUp = userDtl.confirmedSignUp; db.UserDtls.Add(user); db.SaveChanges(); message = "Registered Successfully"; } } else { message = "Email Already Exists"; } return(new UserDetails() { message = message }); } catch { throw; } }