public List <Category> GetByName(string name) { using (BCafeContext bCafeEntities = new BCafeContext()) { return(bCafeEntities.Categories.Where(c => c.Name.Contains(name)).ToList()); } }
public Desk GetDesk(string deskName) { using (BCafeContext entities = new BCafeContext()) { return(entities.Desks.FirstOrDefault(d => d.DeskName == deskName)); } }
public Staff GetStaff(string userName) { using (BCafeContext bCafeEntities = new BCafeContext()) { return(bCafeEntities.Staffs.FirstOrDefault(s => s.UserName == userName)); } }
public Staff GetStaff(int id) { using (BCafeContext bCafeEntities = new BCafeContext()) { return(bCafeEntities.Staffs.FirstOrDefault(s => s.Id == id)); } }
public bool AddControl(string userName, string identityNo, string mail) { using (BCafeContext bCafeEntities = new BCafeContext()) { return(bCafeEntities.Staffs.Any(p => p.IdentityNumber == identityNo || p.UserName == userName || p.Mail == mail)); } }
public Product getOrderPrice(int id) { using (BCafeContext bCafeEntities = new BCafeContext()) { return(bCafeEntities.Products.SingleOrDefault(p => p.Id == id)); } }
public List <Product> SearchByName(string key) { using (BCafeContext bCafeEntities = new BCafeContext()) { return(bCafeEntities.Products.Where(p => p.Name.Contains(key)).ToList()); } }
public bool CheckPassword(string userName, string identityNumber) { using (BCafeContext bCafeEntities = new BCafeContext()) { return(bCafeEntities.Staffs.Any(s => s.UserName == userName && s.IdentityNumber == identityNumber)); } }
public int DeskCount() { using (BCafeContext entities = new BCafeContext()) { return(entities.Desks.Count()); } }
public bool Control(string userName, string password) { using (BCafeContext bCafeEntities = new BCafeContext()) { return(bCafeEntities.Staffs.Any(s => s.UserName == userName && s.Password == password)); } }
public List <Staff> SearchStaff(string key) { using (BCafeContext bCafeEntities = new BCafeContext()) { return(bCafeEntities.Staffs.Where(s => s.FirstName.Contains(key)).ToList()); } }
public bool OrderControl(int deskId) { using (BCafeContext bCafeEntities = new BCafeContext()) { var orders = bCafeEntities.Orders.Any(o => o.DeskId == deskId); return(orders); } }
public Product GetById(int productId) { using (BCafeContext bCafeEntities = new BCafeContext()) { var result = bCafeEntities.Products.FirstOrDefault(p => p.Id == productId); return(result); } }
public Order GetById(int orderId) { using (BCafeContext bCafeEntities = new BCafeContext()) { var order = bCafeEntities.Orders.SingleOrDefault(o => o.Id == orderId); return(order); } }
public decimal SumofOrders(int deskId) { using (BCafeContext bCafeEntities = new BCafeContext()) { var desks = bCafeEntities.Desks; var orders = bCafeEntities.Orders; var result = (from o in orders where o.DeskId == deskId select o.OrderPrice).Sum(); return(result); } }
public void Delete(int deskId) { using (BCafeContext bCafeEntities = new BCafeContext()) { var orders = bCafeEntities.Orders; var orderList = (from o in orders where o.DeskId == deskId select o.Id).ToList(); for (int i = 0; i < orderList.Count(); i++) { var result = bCafeEntities.Entry(new Order { Id = orderList[i] }); result.State = EntityState.Deleted; } bCafeEntities.SaveChanges(); } }
public List <OrderDto> ShowOrders(string deskName) { using (BCafeContext bCafeEntities = new BCafeContext()) { var desks = bCafeEntities.Desks; var products = bCafeEntities.Products; var orders = bCafeEntities.Orders; var result = from p in products join o in orders on p.Id equals o.ProductId join d in desks on o.DeskId equals d.Id select new OrderDto { DeskName = d.DeskName, Id = o.Id, OrderPrice = o.OrderPrice, ProductName = p.Name }; return(result.Where(r => r.DeskName.Contains(deskName)).ToList()); } }
public decimal DailySell(string date) { using (BCafeContext bCafeEntities = new BCafeContext()) { var receipts = bCafeEntities.Receipts; var result1 = (from r in receipts where r.Date == date select r.Id).Count(); if (result1 == 0) { return(0); } else { var result = (from r in receipts where r.Date == date select r.Amount).Sum(); return(result); } } }
public List <ProductDto> ShowProducts() { using (BCafeContext bCafeEntities = new BCafeContext()) { var categories = bCafeEntities.Categories; var products = bCafeEntities.Products; var result = from p in products join c in categories on p.CategoryId equals c.Id select new ProductDto { CategoryName = c.Name, Name = p.Name, UnitPrice = p.UnitPrice, UnitsInStock = p.UnitsInStock, Id = p.Id }; return(result.ToList()); } }