public int CreateOrderDetail(OrderDetail orderDetail) { List <OrderDetail> orderDetails = _context.OrderDetails.ToList(); OrderDetail FindOrderDetail = orderDetails.Find(o => o.OrderId == orderDetail.OrderId && o.ProductId == orderDetail.ProductId); Product product = _context.Products.FirstOrDefault(p => p.Id == orderDetail.ProductId); if (orderDetails.Contains(FindOrderDetail)) { FindOrderDetail.Quantity += orderDetail.Quantity; FindOrderDetail.Total += Bill(product.Price, orderDetail.Quantity, orderDetail.Discount); _context.Update(FindOrderDetail); } else { orderDetail.Total = Bill(product.Price, orderDetail.Quantity, orderDetail.Discount); _context.Add(orderDetail); } return(_context.SaveChanges()); }
public ActionResult AddCart() { List <CartItem> carts = Session["giohang"] as List <CartItem>; if (carts == null) { return(RedirectToAction("GioHangIndex", "Home")); } if (Session["user"] as string == null) { return(RedirectToAction("Login", "Account")); } string i = Session["user"].ToString(); var id = db.Customers.FirstOrDefault(x => x.Usernames == i); List <Cart> l = new List <Cart>(); foreach (var item in carts) { Cart c = new Cart { TotalMoney = item.TotalMoney, Status = false, CustomerID = id.CustomerID, DateCreate = DateTime.Now, ProductID = item.ProductID, Quantity = item.Quantity }; l.Add(c); } db.Carts.AddRange(l); db.SaveChanges(); carts.Clear(); Session["message"] = "Thành công"; return(RedirectToAction("GioHangIndex", "Home")); }
public ActionResult Create(Product product, HttpPostedFileBase img1, HttpPostedFileBase img2, HttpPostedFileBase img3, HttpPostedFileBase img4) { //Thêm hình ảnh vào CSDL if (ModelState.IsValid) { string path1, path2, path3, path4; if (img1 == null) { path1 = null; } else { path1 = Server.MapPath("~/Imgs/" + Path.GetFileName(img1.FileName)); img1.SaveAs(path1); product.Images1 = @"/Imgs/" + img1.FileName; } if (img2 == null) { path2 = null; } else { path2 = Server.MapPath("~/Imgs/" + Path.GetFileName(img2.FileName)); img2.SaveAs(path2); product.Images2 = @"/Imgs/" + img2.FileName; } if (img3 == null) { path3 = null; } else { path3 = Server.MapPath("~/Imgs/" + Path.GetFileName(img3.FileName)); img3.SaveAs(path3); product.Images3 = @"/Imgs/" + img3.FileName; } if (img4 == null) { path4 = null; } else { path4 = Server.MapPath("~/Imgs/" + Path.GetFileName(img4.FileName)); img4.SaveAs(path4); product.Images4 = @"/Imgs/" + img4.FileName; } db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); } //Đưa dữ liệu vào dropdownlist ViewBag.ProductTypeID = new SelectList(db.ProductTypes, "ProductTypeID", "Name", product.ProductTypeID); ViewBag.TradeID = new SelectList(db.Trades, "TradeID", "Name", product.TradeID); return(View(product)); }
public ActionResult Create([Bind(Include = "TradeID,Name")] Trade trade) { if (ModelState.IsValid) { db.Trades.Add(trade); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(trade)); }
public ActionResult Create([Bind(Include = "ProductTypeID,Name")] ProductType productType) { if (ModelState.IsValid) { db.ProductTypes.Add(productType); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(productType)); }
public ActionResult Create([Bind(Include = "CustomerID,Name,Address,PhoneNumbers,Usernames,Password,HashPassword,AccessManagement")] Customer customer) { if (ModelState.IsValid) { customer.HashPassword = CreateMD5(customer.Password); db.Customers.Add(customer); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customer)); }
public ActionResult SignUp(FormCollection f) { string username = f["email"].ToString(); var password = f["password"].ToString(); var us = db.Customers.FirstOrDefault(x => x.Usernames == username); if (us != null) { ViewBag.message = "Tài khoản đã tồn tại !"; return(RedirectToAction("SignUp")); } var pass = CreateMD5(password); Customer c = new Customer { Usernames = f["email"].ToString(), Address = f["address"].ToString(), Password = f["password"].ToString(), Name = f["name"].ToString(), PhoneNumbers = f["phone"].ToString(), HashPassword = pass }; db.Customers.Add(c); var result = db.SaveChanges(); if (result > 0) { return(RedirectToAction("ListProduct", "Home")); } else { ViewBag.message = "Fail"; return(RedirectToAction("SignUp")); } }
private void SeedData(WatchShopDbContext context) { context.AddRange(GetDummyData()); context.SaveChanges(); }
public int Delete(int id) { _context.Remove(GetProduct(id)); return(_context.SaveChanges()); }
public int CreateCategory(Category category) { _context.Add(category); return(_context.SaveChanges()); }
public int CreateOrder(Order order) { _context.Add(order); return(_context.SaveChanges()); }