public static List <SanPham> getAllProduct() { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); var dataset = db.Products.Where(x => x.isDeleted == "0").ToList(); List <SanPham> result = new List <SanPham>(); for (int i = 0; i < dataset.Count; i++) { SanPham temp = new SanPham(); temp.STT = (i + 1).ToString(); temp.Name = dataset[i].Name; temp.ProductID = dataset[i].ProductID; temp.CategoryID = dataset[i].CategoryID; Category category = db.Categories.Where(x => x.CategoryID == temp.CategoryID).First(); temp.CategoryName = category.Name; temp.Cost = dataset[i].Cost; temp.Quantity = dataset[i].Quantity.ToString(); result.Add(temp); } return(result); } catch (Exception) { List <SanPham> result = new List <SanPham>(); return(result); } }
public static List <SanPham> GetProductsByName(string categoryName) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); var dataset = (from p in db.Products join q in db.Categories on p.CategoryID equals q.CategoryID where q.Name == categoryName && p.isDeleted == "0" select new { p, q.Name } ).ToList(); List <SanPham> result = new List <SanPham>(); for (int i = 0; i < dataset.Count; i++) { SanPham temp = new SanPham(); temp.STT = (i + 1).ToString(); temp.ProductID = dataset[i].p.ProductID; temp.CategoryName = dataset[i].Name; temp.CategoryID = dataset[i].p.CategoryID; temp.Cost = dataset[i].p.Cost; temp.Name = dataset[i].p.Name; temp.Quantity = dataset[i].p.Quantity.ToString(); result.Add(temp); } return(result); } catch (Exception) { return(new List <SanPham>()); } }
public static bool DeleteCategory(string CategoryID) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); var itemToRemove = db.Categories.SingleOrDefault(x => x.CategoryID == CategoryID); //returns a single item. if (itemToRemove != null) { itemToRemove.isDeleted = "1"; int res = db.SaveChanges(); if (res > 0) { return(true); } else { return(false); } } return(true); } catch (Exception e) { return(false); } }
public static List <KeyValuePair <string, int> > GetRevenue(DateTime start, DateTime end) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); var ListDate = db.Bills.Where(m => m.Created_at >= start && m.Created_at <= end).Select(m => m.Created_at).Distinct().ToList(); //Find total Revenue in this date List <int> TotalRevenue = new List <int>(); for (int i = 0; i < ListDate.Count; i++) { DateTime d = DateTime.Parse(ListDate[i].ToString()); var count = db.Bills.Where(x => x.Created_at == d).ToList(); int total = 0; for (int j = 0; j < count.Count; j++) { total += Int32.Parse(count[j].Total); } TotalRevenue.Add(total); } List <KeyValuePair <string, int> > valueList = new List <KeyValuePair <string, int> >(); for (int i = 0; i < ListDate.Count; i++) { DateTime d = DateTime.Parse(ListDate[i].ToString()); valueList.Add(new KeyValuePair <string, int>(d.ToString("dd/MM/yyyy"), TotalRevenue[i])); } return(valueList); } catch (Exception e) { List <KeyValuePair <string, int> > valueList = new List <KeyValuePair <string, int> >(); return(valueList); } }
public static bool AddProduct(string Ten_SP, string ID_SP, string Gia_SP, string Loai_SP, int SoLuong) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); var dataset = db.Categories.FirstOrDefault(x => x.Name == Loai_SP); Product product = new Product(); product.Name = Ten_SP; product.isDeleted = "0"; product.ProductID = ID_SP; product.Cost = Gia_SP; product.Quantity = SoLuong; product.CategoryID = dataset.CategoryID; db.Products.Add(product); int res = db.SaveChanges(); if (res > 0) { return(true); } return(false); } catch (Exception e) { return(false); } }
public static List <BillItem> GetBillItems(DateTime start, DateTime end) { try { List <BillItem> result = new List <BillItem>(); QuanLyBanHangEntities db = new QuanLyBanHangEntities(); var dataset = db.Bills.Where(x => x.Created_at >= start && x.Created_at <= end).ToList(); for (int i = 0; i < dataset.Count; i++) { BillItem temp = new BillItem(); temp.STT = (i + 1).ToString(); temp.CustomerName = dataset[i].CustomerName; temp.BillID = dataset[i].Bill_ID; DateTime date = DateTime.Parse(dataset[i].Created_at.ToString()); temp.Created_at = date.ToString("dd/MM/yyyy"); temp.Status = dataset[i].TrangThai; temp.Total = dataset[i].Total; result.Add(temp); } return(result); } catch { return(new List <BillItem>()); } }
public static int GetCoupon(string Coupon) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); var dataset = db.Coupons.Where(x => x.CouponID == Coupon && x.SoLuong > 0).First(); return(dataset.PhanTram ?? default(int)); } catch { return(0); } }
public static string getCategoryName(string CategoryID) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); var dataset = db.Categories.FirstOrDefault(x => x.CategoryID == CategoryID); return(dataset.Name); } catch { return(""); } }
public static List <SaleProduct> GetHistory(DateTime start, DateTime end) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); var dataset = (from p in db.Bills join q in db.BillInfoes on p.Bill_ID equals q.Bill_ID where p.Created_at >= start && p.Created_at <= end select q ).ToList(); List <SaleProduct> result = new List <SaleProduct>(); List <string> ProductID = new List <string>(); List <string> ProductName = new List <string>(); List <int> Qty = new List <int>(); for (int i = 0; i < dataset.Count; i++) { int index = ProductID.IndexOf(dataset[i].ProductID); int t = Int32.Parse(dataset[i].Qty.ToString()); if (index != -1) { Qty[index] = Qty[index] + t; } else { ProductID.Add(dataset[i].ProductID); Qty.Add(t); } } for (int i = 0; i < ProductID.Count; i++) { string str = ProductID[i].Trim(); Product p = db.Products.First(x => x.ProductID == str); SaleProduct sp = new SaleProduct(); sp.CategoryID = p.CategoryID; sp.Cost = p.Cost; sp.ProductID = p.ProductID; sp.Name = p.Name; sp.Qty = Qty[i].ToString(); sp.Total = (Qty[i] * Int32.Parse(sp.Cost)).ToString(); sp.STT = i + 1; result.Add(sp); } return(result); } catch (Exception e) { List <SaleProduct> result = new List <SaleProduct>(); return(result); } }
public static Product GetInfoProduct(string ProductName) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); Product p = new Product(); p = db.Products.First(x => x.Name == ProductName); return(p); } catch (Exception e) { return(new Product()); } }
public static List <KeyValuePair <string, int> > GetProducts(DateTime start, DateTime end) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); var dataset = (from p in db.Bills join q in db.BillInfoes on p.Bill_ID equals q.Bill_ID where p.Created_at >= start && p.Created_at <= end select q ).ToList(); List <string> ProductID = new List <string>(); List <string> ProductName = new List <string>(); List <int> Qty = new List <int>(); for (int i = 0; i < dataset.Count; i++) { int index = ProductID.IndexOf(dataset[i].ProductID); int t = Int32.Parse(dataset[i].Qty.ToString()); if (index != -1) { Qty[index] = Qty[index] + t; } else { ProductID.Add(dataset[i].ProductID); Qty.Add(t); } } for (int i = 0; i < ProductID.Count; i++) { string str = ProductID[i].Trim(); Product p = db.Products.First(x => x.ProductID == str); ProductName.Add(p.Name); } List <KeyValuePair <string, int> > valueList = new List <KeyValuePair <string, int> >(); for (int i = 0; i < ProductName.Count; i++) { string Name = ProductName[i].Trim(); valueList.Add(new KeyValuePair <string, int>(Name, Qty[i])); } return(valueList); } catch (Exception e) { List <KeyValuePair <string, int> > valueList = new List <KeyValuePair <string, int> >(); return(valueList); } }
public static bool UpdateCategory(string CategoryID, string CategoryName) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); Category p = db.Categories.First(x => x.CategoryID == CategoryID); p.Name = CategoryName; db.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public static bool checkLogin(String username, String password) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); var dataset = db.Users.Where(x => x.Username == username && x.Password == password).ToList(); if (dataset.Count > 0) { return(true); } return(false); } catch (Exception) { return(false); } }
public static bool CreateBill(List <Item> items, string CustomerName, string BillID, string Total, string tt, string CurrentCoupon = "") { try { // Insert into table Bill QuanLyBanHangEntities db = new QuanLyBanHangEntities(); Bill ItemBill = new Bill(); ItemBill.Total = Total; ItemBill.CustomerName = CustomerName; ItemBill.Bill_ID = BillID; ItemBill.TrangThai = tt; if (CurrentCoupon != "") { ItemBill.CouponID = CurrentCoupon; var dataset = db.Coupons.FirstOrDefault(x => x.CouponID == CurrentCoupon); dataset.SoLuong = dataset.SoLuong - 1; } DateTime today = DateTime.Today; ItemBill.Created_at = today; db.Bills.Add(ItemBill); // Insert into table BillInfo for (int i = 0; i < items.Count; i++) { BillInfo billInfo = new BillInfo(); billInfo.Bill_ID = BillID; billInfo.ProductID = items[i].ProductID; billInfo.Qty = Int32.Parse(items[i].Qty); var dataset = db.Products.FirstOrDefault(x => x.ProductID == billInfo.ProductID); dataset.Quantity = dataset.Quantity - billInfo.Qty; db.BillInfoes.Add(billInfo); } int res = db.SaveChanges(); if (res > 0) { return(true); } return(false); } catch (Exception e) { return(false); } }
public static bool DeleteProducts(string ID) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); var itemToRemove = db.Products.SingleOrDefault(x => x.ProductID == ID); //returns a single item. if (itemToRemove != null) { db.Products.Remove(itemToRemove); db.SaveChanges(); } return(true); } catch (Exception e) { return(false); } }
public static bool UpdateProducts(string Ten_SP, string ID_SP, string Gia_SP, string Loai_SP, int So_Luong) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); var dataset = db.Categories.FirstOrDefault(x => x.Name == Loai_SP); Product p = db.Products.First(x => x.ProductID == ID_SP); p.Name = Ten_SP; p.CategoryID = dataset.CategoryID; p.Cost = Gia_SP; p.Quantity = So_Luong; db.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public static List <Category1> getAllCategory() { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); List <Category1> result = new List <Category1>(); var dataset = db.Categories.Where(x => x.isDeleted == "0").ToList(); for (int i = 0; i < dataset.Count; i++) { Category1 temp = new Category1(); temp.STT = i + 1; temp.Name = dataset[i].Name; temp.CategoryID = dataset[i].CategoryID; result.Add(temp); } return(result); } catch (Exception) { return(new List <Category1>()); } }
public static bool CreateCoupon(string ID, int phanTram, int soLuong) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); Coupon coupon = new Coupon(); coupon.CouponID = ID; coupon.SoLuong = soLuong; coupon.PhanTram = phanTram; db.Coupons.Add(coupon); int res = db.SaveChanges(); if (res > 0) { return(true); } return(false); } catch (Exception) { return(false); } }
public static bool AddCategory(string CategoryID, string Name) { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); Category category = new Category(); category.isDeleted = "0"; category.CategoryID = CategoryID; category.Name = Name; db.Categories.Add(category); int res = db.SaveChanges(); if (res > 0) { return(true); } return(false); } catch (Exception e) { return(false); } }
public static List <CouponItem> getAllCoupon() { try { QuanLyBanHangEntities db = new QuanLyBanHangEntities(); var dataset = db.Coupons.Where(x => x.SoLuong > 0).ToList(); List <CouponItem> result = new List <CouponItem>(); for (int i = 0; i < dataset.Count; i++) { CouponItem temp = new CouponItem(); temp.STT = (i + 1).ToString(); temp.CouponID = dataset[i].CouponID; temp.SoLuong = dataset[i].SoLuong.ToString(); temp.PhanTram = dataset[i].PhanTram.ToString(); result.Add(temp); } return(result); } catch { return(new List <CouponItem>()); } }