public IEnumerable <Product> TopSeller() { db = new StoreOlineEntities(); var result = db.Products.OrderByDescending(p => p.OrderDets.Sum(o => o.Quantity)); return(result); }
public ActionResult Edit(Product product) { if (ModelState.IsValid) { product.DateEnter = DateTime.Now; using (StoreOlineEntities db = new StoreOlineEntities()) { var temp = db.Products.Where(t => t.ProductID == product.ProductID).SingleOrDefault(); if (temp == null) { db.Products.Add(product); db.SaveChanges(); TempData["message"] = product.ProductName + " has been added"; return(RedirectToAction("Products")); } else { using (StoreOlineEntities db1 = new StoreOlineEntities()) { db1.Entry(product).State = EntityState.Modified; db1.SaveChanges(); TempData["message"] = product.ProductName + " has been saved"; return(RedirectToAction("Products")); } } } } return(View(product)); }
public IEnumerable <MonthReport> GetMonthReport(int year) { db = new StoreOlineEntities(); return(db.Orders.Where(t => t.OrderDate.Year == year).GroupBy(t => t.OrderDate.Month).Select(t => new MonthReport() { Month = t.Key, Total = t.Sum(o => o.Total) })); }
public IEnumerable <Product> GetByCategory(string category) { db = new StoreOlineEntities(); var result = db.Products.Where(p => p.GroupProduct.Category.Aliases.Trim() == category || p.GroupProduct.Aliases.Trim() == category); return(result); }
public Product Delete(Product obj) { db = new StoreOlineEntities(); var tmp = db.Products.SingleOrDefault(t => t.ProductID == obj.ProductID); db.Products.Remove(tmp); db.SaveChanges(); return(tmp); }
public ViewResult Edit(int ProductID, string returnUrl) { using (StoreOlineEntities db2 = new StoreOlineEntities()) { var temp = db2.Products.SingleOrDefault(t => t.ProductID == ProductID); ViewBag.Mode = "Edit"; ViewBag.ReturnUrl = returnUrl; return(View(temp)); } }
public IEnumerable <DayReport> GetDayReport(DateTime start, DateTime end) { db = new StoreOlineEntities(); var res = db.Orders.GroupBy(t => t.OrderDate).Where(t => t.Key >= start && t.Key <= end).Select(t => new DayReport() { date = t.Key, Total = t.Sum(o => o.Total) }); return(res); }
public Order Delete(Order obj) { db = new StoreOlineEntities(); var tmp = db.Orders.SingleOrDefault(o => o.OrderID == obj.OrderID); if (tmp != null) { db.Orders.Remove(obj); } db.SaveChanges(); return(tmp); }
public IEnumerable <GroupProduct> GetListByAliases(string aliases) { db = new StoreOlineEntities(); var category = db.Categories.SingleOrDefault(c => c.Aliases.Trim() == aliases); if (category == null) { var group = db.GroupProducts.SingleOrDefault(g => g.Aliases.Trim() == aliases); return(db.Categories.SingleOrDefault(c => c.CategoryID == group.CategoryID).GroupProducts); } return(category.GroupProducts); }
public void LoadData() { products = new Dictionary <int, int>(); users = new Dictionary <string, int>(); StoreOlineEntities db = new StoreOlineEntities(); var listProduct = db.Products.ToList(); int ii = 0; foreach (var item in listProduct) { products.Add(item.ProductID, ii++); } var temp = db.OrderDets.Select(t => new UserToProduct() { UserID = t.Order.UserID, ProductID = t.ProductID, Quantity = t.Quantity }).ToList(); var buffer = temp.GroupBy(t => t.UserID).ToList(); for (int i = 0; i < buffer.Count; i++) { users.Add(buffer[i].Key, i); } N = users.Count; M = products.Count; data = new int[N, M]; for (int i = 0; i < N; i++) { var item = buffer[i].GroupBy(t => t.ProductID).Select(t => new { ID = t.Key, Total = t.Sum(o => o.Quantity) }).ToList(); int index = 0; int j = 0; foreach (var item1 in products) { if (index >= item.Count) { break; } if (item[index].ID == item1.Value) { if (j >= M) { break; } data[i, j] = item[index].Total; index++; } j++; } } }
public void Update(Order order) { if (users.ContainsKey(order.UserID)) { StoreOlineEntities db = new StoreOlineEntities(); int index = users[order.UserID]; foreach (var item in order.OrderDets) { data[index, products[item.ProductID]] += item.Quantity; } } }
public bool Update(Order obj) { db = new StoreOlineEntities(); if (db.Orders.SingleOrDefault(o => o.OrderID == obj.OrderID) == null) { return(false); } db.Orders.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(true); }
public bool Add(Order obj) { db = new StoreOlineEntities(); var tmp = db.Orders.SingleOrDefault(o => o.OrderID == obj.OrderID); if (tmp != null) { return(false); } db.Orders.Add(obj); db.SaveChanges(); return(true); }
public ActionResult Contact(MailBox mail) { if (ModelState.IsValid) { using (StoreOlineEntities db = new StoreOlineEntities()) { mail.DateEnter = DateTime.Now; db.MailBoxes.Add(mail); db.SaveChanges(); } } return(RedirectToAction("Contact")); }
public bool Add(Product obj) { db = new StoreOlineEntities(); var tmp = db.Products.SingleOrDefault(t => t.ProductID == obj.ProductID); if (tmp != null) { return(false); } db.Products.Add(obj); db.SaveChanges(); return(true); }
public bool Update(Product obj) { db = new StoreOlineEntities(); var tmp = db.Products.SingleOrDefault(t => t.ProductID == obj.ProductID); if (tmp == null) { return(false); } db.Products.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(true); }
public ActionResult Delete(int OrderID, string state) { using (StoreOlineEntities db = new StoreOlineEntities()) { var tmp = db.Orders.SingleOrDefault(t => t.OrderID == OrderID); if (tmp != null) { db.OrderDets.RemoveRange(tmp.OrderDets); db.Orders.Remove(tmp); db.SaveChanges(); TempData["message"] = tmp.OrderID + " at " + tmp.OrderDate.ToString("dd/MM/yyyy") + " was deleted"; } } return(RedirectToAction("Index", new { state = state })); }
public ActionResult Edit(int OrderID, string state) { using (StoreOlineEntities db = new StoreOlineEntities()) { var tmp = db.Orders.SingleOrDefault(t => t.OrderID == OrderID); if (tmp != null) { tmp.IsShipping = true; tmp.ShippingDate = DateTime.Now; db.SaveChanges(); TempData["message"] = tmp.OrderID + " at " + tmp.OrderDate.ToString("dd/MM/yyyy") + " was accepted"; } } return(RedirectToAction("Index", new { state = state })); }
public Product FindByAliases(string aliases) { db = new StoreOlineEntities(); return(db.Products.SingleOrDefault(p => p.Aliases.Trim() == aliases)); }
public Product FindByID(object ID) { db = new StoreOlineEntities(); return(db.Products.SingleOrDefault(p => p.ProductID == (int)ID)); }
public IEnumerable <GroupProduct> GetAll() { db = new StoreOlineEntities(); return(db.GroupProducts); }
public AspNetUser FindByName(string name) { db = new StoreOlineEntities(); return(db.AspNetUsers.SingleOrDefault(u => u.UserName.Trim() == name)); }
public IEnumerable <Category> GetAll() { db = new StoreOlineEntities(); return(db.Categories); }
public Order FindByID(object ID) { db = new StoreOlineEntities(); return(db.Orders.SingleOrDefault(o => o.OrderID == (int)ID)); }
public IEnumerable <Order> GetAll() { db = new StoreOlineEntities(); return(db.Orders); }