public EntityPolicy GetByOrder(int OrderID)
{
var data = base.DataContext.Policy.Where(p => p.FK_OrderID == OrderID);
if (data.Count() == 1)
{
return(FactoryPolicy.Get(data.Single()));
}
else
{
return(null);
}
}
public EntityPolicy GetPolicyFolio(int OrderID, string Folio)
{
var data = base.DataContext.Policy.Where(p => p.FK_OrderID == OrderID && p.IDPolicy == Folio);
if (data.Count() > 0)
{
return(FactoryPolicy.Get(data.First()));
}
else
{
return(null);
}
}
public EntityPolicy Get(int Id)
{
var data = base.DataContext.Policy.Where(p => p.PK_PolicyID == Id);
if (data.Count() == 1)
{
return(FactoryPolicy.Get(data.Single()));
}
else
{
return(null);
}
}
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()));
}
