public async Task <IQueryable <SalesOrder> > GetEntitiesByExpression(Expression <Func <SalesOrder, bool> > predicate)
{
IQueryable <SalesOrder> result = _dbContext.Set <SalesOrder>().Where(predicate).AsQueryable <SalesOrder>();
await Task.Yield();
return(result);
}
public IQueryable <AddressBook> GetEntitiesByExpression(Expression <Func <AddressBook, bool> > predicate)
{
//IQueryable<SalesOrder> result = _dbContext.Set<SalesOrder>().Where(predicate).AsQueryable<SalesOrder>();
var result = _dbContext.Set <AddressBook>().Where(predicate);
return(result);
}
public IQueryable <PayRollTransactionsByEmployee> GetEntitiesByExpression(Expression <Func <PayRollTransactionsByEmployee, bool> > predicate)
{
//IQueryable<SalesOrder> result = _dbContext.Set<SalesOrder>().Where(predicate).AsQueryable<SalesOrder>();
var result = _dbContext.Set <PayRollTransactionsByEmployee>().Where(predicate);
return(result);
}
public async Task <IList <PackingSlipDetail> > FindByExpression(Expression <Func <PackingSlipDetail, bool> > predicate)
{
try
{
IQueryable <PackingSlipDetail> query = _dbContext.Set <PackingSlipDetail>().Where(predicate);
IList <PackingSlipDetail> list = new List <PackingSlipDetail>();
foreach (var item in query)
{
list.Add(item);
}
await Task.Yield();
return(list);
}
catch (Exception ex) { throw new Exception(GetMyMethodName(), ex); }
}
public async Task <PurchaseOrderDetail> FindEntityByExpression(Expression <Func <PurchaseOrderDetail, bool> > predicate)
{
IQueryable <PurchaseOrderDetail> result = _dbContext.Set <PurchaseOrderDetail>().Where(predicate);
return(await result.FirstOrDefaultAsync <PurchaseOrderDetail>());
}
public async Task <ServiceInformationInvoice> FindEntityByExpression(Expression <Func <ServiceInformationInvoice, bool> > predicate)
{
IQueryable <ServiceInformationInvoice> result = _dbContext.Set <ServiceInformationInvoice>().Where(predicate);
return(await result.FirstOrDefaultAsync <ServiceInformationInvoice>());
}
public IQueryable <Shipment> GetEntitiesByExpression(Expression <Func <Shipment, bool> > predicate)
{
var result = _dbContext.Set <Shipment>().Where(predicate);
return(result);
}
public async Task <AccountReceivableInterest> FindEntityByExpression(Expression <Func <AccountReceivableInterest, bool> > predicate)
{
IQueryable <AccountReceivableInterest> result = _dbContext.Set <AccountReceivableInterest>().Where(predicate);
return(await result.FirstOrDefaultAsync <AccountReceivableInterest>());
}
public IQueryable <JobCostLedger> GetEntitiesByExpression(Expression <Func <JobCostLedger, bool> > predicate)
{
var result = _dbContext.Set <JobCostLedger>().Where(predicate);
return(result);
}
public async Task <IList <Invoice> > GetEntitiesByExpression(Expression <Func <Invoice, bool> > predicate)
{
return(await(_dbContext.Set <Invoice>().Where(predicate)).ToListAsync <Invoice>());
}
public IQueryable <AccountReceivableDetail> GetEntitiesByExpression(Expression <Func <AccountReceivableDetail, bool> > predicate)
{
var result = _dbContext.Set <AccountReceivableDetail>().Where(predicate);
return(result);
}
public IQueryable <TimeAndAttendanceSetup> GetEntitiesByExpression(Expression <Func <TimeAndAttendanceSetup, bool> > predicate)
{
var result = _dbContext.Set <TimeAndAttendanceSetup>().Where(predicate);
return(result);
}
public async Task <Inventory> FindEntityByExpression(Expression <Func <Inventory, bool> > predicate)
{
IQueryable <Inventory> result = _dbContext.Set <Inventory>().Where(predicate);
return(await result.FirstOrDefaultAsync <Inventory>());
}
public IQueryable <ContractInvoice> GetEntitiesByExpression(Expression <Func <ContractInvoice, bool> > predicate)
{
var result = _dbContext.Set <ContractInvoice>().Where(predicate);
return(result);
}
public async Task <ProjectManagementWorkOrderToEmployee> FindEntityByExpression(Expression <Func <ProjectManagementWorkOrderToEmployee, bool> > predicate)
{
IQueryable <ProjectManagementWorkOrderToEmployee> result = _dbContext.Set <ProjectManagementWorkOrderToEmployee>().Where(predicate);
return(await result.FirstOrDefaultAsync <ProjectManagementWorkOrderToEmployee>());
}
public async Task <Poquote> FindEntityByExpression(Expression <Func <Poquote, bool> > predicate)
{
IQueryable <Poquote> result = _dbContext.Set <Poquote>().Where(predicate);
return(await result.FirstOrDefaultAsync <Poquote>());
}
public async Task <Equipment> FindEntityByExpression(Expression <Func <Equipment, bool> > predicate)
{
IQueryable <Equipment> result = _dbContext.Set <Equipment>().Where(predicate);
return(await result.FirstOrDefaultAsync <Equipment>());
}
