public List <EntityPolicy> GetAllListODSJourney(List <int> EmployeeID, DateTime MinfhExecute, DateTime MaxfhExecute, bool PreODS) { return(FactoryPolicy.GetList(base.DataContext.Policy.Where(p => EmployeeID.Contains(p.FK_EmployeeID) && DbFunctions.TruncateTime(p.CreateDate) >= MinfhExecute && DbFunctions.TruncateTime(p.CreateDate) <= MaxfhExecute).ToList())); }
//p.FK_EmployeeID.Value public List <EntityPolicy> GetAll(List <int> EmployeeID, DateTime fhExecute) { return(FactoryPolicy.GetList(base.DataContext.Policy.Where(p => EmployeeID.Contains(p.FK_EmployeeID) && DbFunctions.TruncateTime(p.CreateDate) == fhExecute).ToList())); }
// //PolicyCreateDate cuestionar public List <EntityPolicy> GetByRange(DateTime Inicio, DateTime Fin) { return(FactoryPolicy.GetList(base.DataContext.Policy.Where(p => DbFunctions.TruncateTime(p.CreateDate) >= Inicio && DbFunctions.TruncateTime(p.CreateDate) <= Fin).ToList())); }
//public List<EntityPolicy> GetAll(string SendCRM, DateTime syncDate) //{ // return FactoryPolicy.GetList(base.DataContext.PolicyRefMan.Where(p => p.SendCRM == SendCRM & p.FK_StatusSchemeID != 44 & p.OrderExecuteDate >= syncDate).ToList()); //} public List <EntityPolicy> GetAll() { return(FactoryPolicy.GetList(base.DataContext.Policy.ToList())); }
public List <EntityPolicy> GetActives() { return(FactoryPolicy.GetList(base.DataContext.Policy.Where(p => p.Status == true).ToList())); }
// public List <EntityPolicy> GetByEmpoyeeDate(int UserID, DateTime date) { return(FactoryPolicy.GetList(base.DataContext.Policy.Where(p => p.FK_EmployeeID == UserID && DbFunctions.TruncateTime(p.CreateDate) == date).OrderByDescending(o => o.CreateDate).ToList())); }