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);
}
