public List <EntityOrder> GetByEmployee(int EmployeeID, DateTime fhExecute)
{
return(FactoryOrder.GetList(base.DataContext.Orders.Where(p => p.FK_EmployeeID == EmployeeID && DbFunctions.TruncateTime(p.OrderExecuteDate) == fhExecute).ToList()));
}
public List <EntityOrder> GetAll(List <int> EmployeeID, DateTime fhExecute, bool PreODS)
{
return(FactoryOrder.GetList(base.DataContext.Orders.Where(p => EmployeeID.Contains(p.FK_EmployeeID.Value) && DbFunctions.TruncateTime(p.OrderExecuteDate) == fhExecute && p.PreOrder == PreODS).ToList()));
}
public List <EntityOrder> GetByRange(DateTime Inicio, DateTime Fin)
{
return(FactoryOrder.GetList(base.DataContext.Orders.Where(p => DbFunctions.TruncateTime(p.OrderExecuteDate) >= Inicio && DbFunctions.TruncateTime(p.OrderExecuteDate) <= Fin).ToList()));
}
public List <EntityOrder> GetAll()
{
return(FactoryOrder.GetList(base.DataContext.Orders.ToList()));
}
public List <EntityOrder> GetAll(string SendCRM, DateTime syncDate)
{
return(FactoryOrder.GetList(base.DataContext.Orders.Where(p => p.SendCRM == SendCRM & p.FK_StatusSchemeID != 44 & p.OrderExecuteDate >= syncDate).ToList()));
}
public List <EntityOrder> GetActives()
{
return(FactoryOrder.GetList(base.DataContext.Orders.Where(p => p.Status == true).ToList()));
}