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