public void Delete(Item item)
{
EfDbSet.Remove(item);
}
public void Delete(Employee employee)
{
EfDbSet.Remove(employee);
}
public async Task Insert(Item item)
{
await EfDbSet.AddAsync(item);
}
public async Task Insert(Order order)
{
await EfDbSet.AddAsync(order);
}
public override IQueryable <Show> GetAllAsync()
{
return(EfDbSet
.Include(x => x.Sessions)
.AsNoTracking());
}
public void Delete(SalesOrderItem salesOrderItem)
{
EfDbSet.Remove(salesOrderItem);
}
public override IQueryable <OrderDetail> GetAll()
{
return(EfDbSet.Include(r => r.Product));
}
public async Task Insert(Revenue revenue)
{
await EfDbSet.AddAsync(revenue);
}
public void Delete(Revenue revenue)
{
EfDbSet.Remove(revenue);
}
public void Delete(Customer customer)
{
EfDbSet.Remove(customer);
}
public override IQueryable <Revenue> GetAll()
{
return(EfDbSet.Include(s => s.SalesOrder).Include(c => c.SalesOrder.Customer));
}
public async Task Insert(Customer customer)
{
await EfDbSet.AddAsync(customer);
}
public void Delete(SalesOrder salesOrder)
{
EfDbSet.Remove(salesOrder);
}
public async Task Insert(SalesOrder salesOrder)
{
await EfDbSet.AddAsync(salesOrder);
}
public override IQueryable <SalesOrderItem> GetAll()
{
return(EfDbSet.Include(i => i.Item).Include(s => s.SalesOrder).Include(c => c.SalesOrder.Customer));
}
public override IDataQueryable <Order> GetAll()
{
IDataQueryable <Order> order = new DataQueryable <Order>(EfDbSet.Include("Customer").OrderByDescending(o => o.OrderDate));
return(order);
}
public async Task Insert(SalesOrderItem salesOrderItem)
{
await EfDbSet.AddAsync(salesOrderItem);
}
public override IQueryable <Order> GetAll()
{
return(EfDbSet.Include("Customer"));
}
public IQueryable <Order> GetForClient(string companyName)
{
return(EfDbSet.Where(o => o.Customer.CompanyName == companyName));
}
public override IOrderedQueryable <Order> GetAll()
{
return(EfDbSet.Include("Customer").OrderByDescending(o => o.OrderDate));
}
public override IQueryable <Order> GetAll()
{
return(EfDbSet.Include("Customer").Include("Employee").Include("Shipper"));
}
public async Task Insert(Employee employee)
{
await EfDbSet.AddAsync(employee);
}
public void Delete(Order order)
{
EfDbSet.Remove(order);
}
public override Task <Show> GetById(object id)
{
return(EfDbSet
.Include(x => x.Sessions)
.FirstOrDefaultAsync(x => x.Id == (int)id));
}