public ActionResult Products(int ProductID) { MVCTestEntities _entity = new MVCTestEntities(); List <Product> hh = _entity.Products.Where(x => x.CategoryID == ProductID).ToList(); return(View(hh)); }
public ActionResult ProductDetails(int ProductID) { MVCTestEntities _entity = new MVCTestEntities(); Product hh = _entity.Products.Where(x => x.ProductID == ProductID).First(); return(View(hh)); }
public ActionResult EditCart(int id) { MVCTestEntities _entity = new MVCTestEntities(); var lst1 = (from mc in _entity.Carts join pr in _entity.Products on mc.ProductID equals pr.ProductID join ur in _entity.Users on mc.UserID equals ur.UserID where mc.CartID == id select new { ProductName = pr.Name, ProductImage = pr.ImagePath, ProductQnt = mc.ProductQnt, TotalPrice = mc.TotalPrice, CartID = mc.CartID }).ToList(); List <MyCart> mcrt = new List <MyCart>(); for (int j = 0; j < lst1.Count; j++) { MyCart mct = new MyCart(); mct.ProductName = lst1[j].ProductName; mct.ProductQnt = lst1[j].ProductQnt; mct.TotalPrice = lst1[j].TotalPrice; mct.CartID = lst1[j].CartID; mct.ProductImage = lst1[j].ProductImage; mcrt.Add(mct); } return(View(mcrt[0])); }
public ActionResult Index(User user) { MVCTestEntities _entity = new MVCTestEntities(); var _result = _entity.Users.Where(x => x.Email == user.Email && x.Pws == user.Pws).ToList(); if (_result.Count > 0) { Session["UserID"] = _result[0].UserID; if (user.Email == "*****@*****.**") { return(RedirectToAction("Index", "Admin")); } else { return(RedirectToAction("Index", "Shopping")); } } else { Session["UserID"] = null; return(View()); } }
public ActionResult AddProduct(Product product, HttpPostedFileBase file) { MVCTestEntities _entity = new MVCTestEntities(); if (ModelState.IsValid) { if (file != null) { var fileName = Path.GetFileName(file.FileName); file.SaveAs(Path.Combine(Server.MapPath("~/Assets/Images/"), fileName)); product.ImagePath = fileName; } _entity.Products.Add(product); _entity.SaveChanges(); return(RedirectToAction("Index")); } else { product.CategoryList = new SelectList(_entity.Categories.AsEnumerable(), "CategoryID", "Name"); return(View(product)); } }
public ActionResult AddtoCart(FormCollection collection) { if (Session["UserID"] != null) // check user is loged in { if (Convert.ToString(collection["Quantity"]) != "") { int qnt = Convert.ToInt32(collection["Quantity"]); int price = Convert.ToInt32(collection["Price"]); int productid = Convert.ToInt32(collection["ProductID"]); MVCTestEntities _entity = new MVCTestEntities(); Cart crt = new Cart(); crt.ProductID = productid; crt.UserID = Convert.ToInt32(Session["UserID"]); crt.ProductQnt = qnt; crt.TotalPrice = qnt * price; _entity.Carts.Add(crt); _entity.SaveChanges(); Cart ct = new Cart(); List <Cart> lst = _entity.Carts.Where(x => x.UserID == crt.UserID).ToList(); var lst1 = (from mc in _entity.Carts join pr in _entity.Products on mc.ProductID equals pr.ProductID join ur in _entity.Users on mc.UserID equals ur.UserID where mc.UserID == crt.UserID select new { ProductName = pr.Name, ProductImage = pr.ImagePath, ProductQnt = mc.ProductQnt, TotalPrice = mc.TotalPrice, CartID = mc.CartID }).ToList(); List <MyCart> mcrt = new List <MyCart>(); for (int j = 0; j < lst1.Count; j++) { MyCart mct = new MyCart(); mct.ProductName = lst1[j].ProductName; mct.ProductQnt = lst1[j].ProductQnt; mct.ProductImage = lst1[j].ProductImage; mct.TotalPrice = lst1[j].TotalPrice; mct.CartID = lst1[j].CartID; mcrt.Add(mct); } return(View("MyCart", mcrt)); } else { return(View()); } } else { return(RedirectToAction("Index", "Account")); // redirect when user is not login } }
public ActionResult AddProduct() { MVCTestEntities _entity = new MVCTestEntities(); Product product = new Product(); product.CategoryList = new SelectList(_entity.Categories.AsEnumerable(), "CategoryID", "Name"); return(View(product)); }
public ActionResult GetEmployees() { //using (EmployeeDataEntities dc = new EmployeeDataEntities()) using (MVCTestEntities dc = new MVCTestEntities()) { //var employees = dc.Employees.OrderBy(a => a.FirstName).ToList(); var employees = dc.EmployeeDatas.OrderBy(a => a.FirstName).ToList(); return(Json(new { data = employees }, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddCategory(Category category) { MVCTestEntities _entity = new MVCTestEntities(); _entity.Categories.Add(category); _entity.SaveChanges(); // return View(); return(RedirectToAction("Index")); }
public ActionResult Save(int id) { //using (EmployeeDataEntities dc = new EmployeeDataEntities()) using (MVCTestEntities dc = new MVCTestEntities()) { //var employees = dc.Employees.Where(a => a.EmployeeID == id).FirstOrDefault(); var employees = dc.EmployeeDatas.Where(a => a.EmployeeID == id).FirstOrDefault(); return(Json(new { data = employees }, JsonRequestBehavior.AllowGet)); } }
public static DbContext GetCurrentContext() { //一次请求公用一个实例,上下文也可可以随便切换 // return new MVCTestEntities(); if (!(CallContext.GetData("DbContext") is DbContext db)) { db = new MVCTestEntities(); CallContext.SetData("DbContext", db); } return(db); }
public ActionResult EditCart(FormCollection collection) { MVCTestEntities _entity = new MVCTestEntities(); Cart ct = new Cart(); ct.CartID = Convert.ToInt32(collection["CartID"]); ct.ProductQnt = Convert.ToInt32(collection["ProductQnt"]); ct.TotalPrice = Convert.ToInt32(collection["ProductQnt"]) * Convert.ToInt32(collection["UnitPrice"]); // update cart _entity.Carts.Attach(ct); var et = _entity.Entry(ct); et.Property(e => e.ProductQnt).IsModified = true; et.Property(e => e.TotalPrice).IsModified = true; _entity.SaveChanges(); var lst1 = (from mc in _entity.Carts join pr in _entity.Products on mc.ProductID equals pr.ProductID join ur in _entity.Users on mc.UserID equals ur.UserID where mc.CartID == ct.CartID select new { ProductName = pr.Name, ProductImage = pr.ImagePath, ProductQnt = mc.ProductQnt, TotalPrice = mc.TotalPrice, CartID = mc.CartID }).ToList(); List <MyCart> mcrt = new List <MyCart>(); for (int j = 0; j < lst1.Count; j++) { MyCart mct = new MyCart(); mct.ProductName = lst1[j].ProductName; mct.ProductQnt = lst1[j].ProductQnt; mct.TotalPrice = lst1[j].TotalPrice; mct.CartID = lst1[j].CartID; mct.ProductImage = lst1[j].ProductImage; mcrt.Add(mct); } Session["Result"] = mcrt; ViewBag.Myorder = mcrt; return(View("MyCart", mcrt)); }
public ActionResult RegisterUser(User user) { if (ModelState.IsValid) { MVCTestEntities _entity = new MVCTestEntities(); _entity.Users.Add(user); _entity.SaveChanges(); return(View("Index")); } else { return(View()); } }
public ActionResult Delete(int id) { //using (EmployeeDataEntities dc = new EmployeeDataEntities()) using (MVCTestEntities dc = new MVCTestEntities()) { //var v = dc.Employees.Where(a => a.EmployeeID == id).FirstOrDefault(); var v = dc.EmployeeDatas.Where(a => a.EmployeeID == id).FirstOrDefault(); if (v != null) { return(View(v)); } else { return(HttpNotFound()); } } }
public ActionResult MyCart() { MVCTestEntities _entity = new MVCTestEntities(); if (Session["UserID"] != null) // check user is loged in { int userid = Convert.ToInt32(Session["UserID"]); var lst1 = (from mc in _entity.Carts join pr in _entity.Products on mc.ProductID equals pr.ProductID join ur in _entity.Users on mc.UserID equals ur.UserID where mc.UserID == userid select new { ProductName = pr.Name, ProductImage = pr.ImagePath, ProductQnt = mc.ProductQnt, TotalPrice = mc.TotalPrice, CartID = mc.CartID }).ToList(); List <MyCart> mcrt = new List <MyCart>(); for (int j = 0; j < lst1.Count; j++) { MyCart mct = new MyCart(); mct.ProductName = lst1[j].ProductName; mct.ProductQnt = lst1[j].ProductQnt; mct.TotalPrice = lst1[j].TotalPrice; mct.CartID = lst1[j].CartID; mct.ProductImage = lst1[j].ProductImage; mcrt.Add(mct); } Session["Result"] = mcrt; ViewBag.Myorder = mcrt; return(View(mcrt)); } else { return(RedirectToAction("Index", "Account")); // redirect when user is not login } }
public ActionResult Checkout(FormCollection collection) { ViewBag.AddressA = Convert.ToString(collection["Address"]); List <MyCart> crt = (List <MyCart>)ViewBag.Myorder; MVCTestEntities _entity = new MVCTestEntities(); int userid = Convert.ToInt32(Session["UserID"]); _entity.Carts.Where(x => x.UserID == userid).ToList().ForEach(p => _entity.Carts.Remove(p)); _entity.SaveChanges(); ViewBag.Myorder = null; return(View("Thankyou")); }
//DeleteCart public ActionResult DeleteCart(int id) { MVCTestEntities _entity = new MVCTestEntities(); var crt = _entity.Carts.Where(x => x.CartID == id).First(); _entity.Carts.Remove(crt); _entity.SaveChanges(); int userid = Convert.ToInt32(Session["UserID"]); var lst1 = (from mc in _entity.Carts join pr in _entity.Products on mc.ProductID equals pr.ProductID join ur in _entity.Users on mc.UserID equals ur.UserID where mc.UserID == userid select new { ProductName = pr.Name, ProductImage = pr.ImagePath, ProductQnt = mc.ProductQnt, TotalPrice = mc.TotalPrice, CartID = mc.CartID }).ToList(); List <MyCart> mcrt = new List <MyCart>(); for (int j = 0; j < lst1.Count; j++) { MyCart mct = new MyCart(); mct.ProductName = lst1[j].ProductName; mct.ProductQnt = lst1[j].ProductQnt; mct.TotalPrice = lst1[j].TotalPrice; mct.CartID = lst1[j].CartID; mct.ProductImage = lst1[j].ProductImage; mcrt.Add(mct); } Session["Result"] = mcrt; ViewBag.Myorder = mcrt; return(View("MyCart", mcrt)); }
public ActionResult DeleteEmployee(int id) { bool status = false; //using (EmployeeDataEntities dc = new EmployeeDataEntities()) using (MVCTestEntities dc = new MVCTestEntities()) { //var v = dc.Employees.Where(a => a.EmployeeID == id).FirstOrDefault(); var v = dc.EmployeeDatas.Where(a => a.EmployeeID == id).FirstOrDefault(); if (v != null) { //dc.Employees.Remove(v); dc.EmployeeDatas.Remove(v); dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
// GET: UserRegister //接收form表单返回的数据并存储到数据库中 public ActionResult Index(FormCollection collection) { string str = ""; //if (Request["textname"].Equals(null) || Request["pwname"].Equals(null) || Request["textname"] == "" || Request["pwname"].Equals("")) //{ // str = ""; // } if (Request["textname"] == null) { str = ""; } else { //声明一个上下文 MVCTestEntities mVCTestEntities = new MVCTestEntities(); //创建一个实体 Mytest0329.users firstuser = new users(); //firstuser.username = Request["textname"]; //firstuser.password = Request["pwname"]; firstuser.username = collection["textname"]; firstuser.password = collection["pwname"]; //在上下文中的表的类中添加实体 mVCTestEntities.users.Add(firstuser); //告诉上下文保存更改,即执行SQL语句操作 mVCTestEntities.SaveChanges(); ViewData["status"] = "注册成功"; } return(View()); }
public bool VerifyUser(string userName, string password, ref List <string> roles) { try { using (var dbContext = new MVCTestEntities()) { var user = dbContext.Users.SingleOrDefault(u => u.name.Equals(userName) && u.password.Equals(password)); if (user != null) { foreach (var role in user.UserRoles) { roles.Add(role.Role.name); } return(true); } } return(false); } catch (Exception e) { return(false); } }
//public ActionResult Save(Employee emp) public ActionResult Save(EmployeeData emp) { bool status = false; if (ModelState.IsValid) { //using (EmployeeDataEntities dc = new EmployeeDataEntities()) using (MVCTestEntities dc = new MVCTestEntities()) { if (emp.EmployeeID > 0) { //Edit //var v = dc.Employees.Where(a => a.EmployeeID == emp.EmployeeID).FirstOrDefault(); var v = dc.EmployeeDatas.Where(a => a.EmployeeID == emp.EmployeeID).FirstOrDefault(); if (v != null) { v.FirstName = emp.FirstName; v.LastName = emp.LastName; v.EmailID = emp.EmailID; v.City = emp.City; v.Country = emp.Country; } } else { //Save //dc.Employees.Add(emp); dc.EmployeeDatas.Add(emp); } dc.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }