public List <ModelViewODS> GetList(string StatusVisitID, string ModuleID, string PriorityID, string StatusOrderID, string ServiceID, string OrderID, string Employee, string StartDate, string EndDate, entities.Entity.Security.EntityUser User)
{
var predicate = PredicateBuilder.New <MonitorOrders>();
if (StatusVisitID.Trim().Length > 0)
{
List <int> iStatusVisitID = StatusVisitID.Split(',').Select(int.Parse).ToList();
if (iStatusVisitID.Count() > 0)
{
predicate = predicate.And(i => iStatusVisitID.Contains(i.FK_StatusVisitID.Value));
}
}
if (ModuleID.Trim().Length > 0)
{
List <int> iModuleID = ModuleID.Split(',').Select(int.Parse).ToList();
if (iModuleID.Count() > 0)
{
predicate = predicate.And(i => iModuleID.Contains(i.Orders.FK_ModuleID.Value));
}
}
if (PriorityID.Trim().Length > 0)
{
List <int> iPriorityID = PriorityID.Split(',').Select(int.Parse).ToList();
if (iPriorityID.Count() > 0)
{
predicate = predicate.And(i => iPriorityID.Contains(i.SequenceVisit.Value));
}
}
if (StatusOrderID.Trim().Length > 0)
{
List <int> iStatusOrderID = StatusOrderID.Split(',').Select(int.Parse).ToList();
if (iStatusOrderID.Count() > 0)
{
predicate = predicate.And(i => iStatusOrderID.Contains(i.FK_StatusOrderID.Value));
}
}
if (ServiceID.Trim().Length > 0)
{
List <int> iServiceID = ServiceID.Split(',').Select(int.Parse).ToList();
if (iServiceID.Count() > 0)
{
predicate = predicate.And(i => iServiceID.Contains(i.Orders.FK_GuarantyID.Value));
}
}
if (OrderID.Trim().Length > 0)
{
predicate = predicate.And(i => i.Orders.OrderID.Contains(OrderID));
}
if (Employee.Trim().Length > 0)
{
predicate = predicate.And(i => (i.Orders.Employee.FirstName + " " + i.Orders.Employee.LastName).Contains(Employee));
}
DateTime fhIni = DateTime.Today;
if (DateTime.TryParse(StartDate, out fhIni))
{
predicate = predicate.And(i => i.Orders.OrderExecuteDate >= fhIni);
}
DateTime fhFin = DateTime.Today;
if (DateTime.TryParse(EndDate, out fhFin))
{
fhFin = fhFin.AddHours(23).AddMinutes(59).AddSeconds(59);
predicate = predicate.And(i => i.Orders.OrderExecuteDate <= fhFin);
}
if (User.ModuleID.HasValue)
{
predicate = predicate.And(i => i.Orders.FK_ModuleID == User.ModuleID.Value);
}
base.DataContext.Database.CommandTimeout = 1600;
return(base.DataContext.MonitorOrders.Where(predicate).Select(q => new ModelViewODS()
{
MonitorID = q.PK_MonitorOrdersID,
StatusOrderID = q.FK_StatusOrderID.Value,
StatusVisitID = q.FK_StatusVisitID.Value,
ModuleID = q.Orders.FK_ModuleID.Value,
StatusODS = q.CauseOrder.StatusOrder.StatusOrder1,
CauseOrder = q.CauseOrder.CauseOrder1,
Module = q.Orders.Employee.ModuleMabe.ModuleID + " " + q.Orders.Employee.ModuleMabe.Base,
OrderID = q.Orders.OrderID,
EmployeeName = q.Orders.Employee.FirstName + " " + q.Orders.Employee.LastName,
ServiceType = q.Orders.Guaranty.GuarantyID + " " + q.Orders.Guaranty.Guaranty1,
StatusVisit = q.StatusVisit.StatusVisit1,
StartVisitODS = q.StartVisitDate.ToString(),
StartTryODS = q.StartServiceDate.ToString(),
StartRunODS = q.StartOrderDate.ToString(),
EndVisitODS = q.EndVisitDate.ToString(),
EndTryODS = q.EndServiceDate.ToString(),
EndRunODS = q.EndOrderDate.ToString(),
LatitudeStartVisit = q.LatitudeStartVisit.HasValue ? q.LatitudeStartVisit.Value.ToString() : "",
LogitudeStartVisit = q.LogitudeStartVisit.HasValue ? q.LogitudeStartVisit.Value.ToString() : "",
LatitudeEndVisit = q.LatitudeEndVisit.HasValue ? q.LatitudeEndVisit.Value.ToString() : "",
LogitudeEndVisit = q.LogitudeEndVisit.HasValue ? q.LogitudeEndVisit.Value.ToString() : "",
LatitudeStartOrder = q.LatitudeStartOrder.HasValue ? q.LatitudeStartOrder.Value.ToString() : "",
LogitudeStartOrder = q.LogitudeStartOrder.HasValue ? q.LogitudeStartOrder.Value.ToString() : "",
LatitudeEndOrder = q.LatitudeEndOrder.HasValue ? q.LatitudeEndOrder.Value.ToString() : "",
LogitudeEndOrder = q.LogitudeEndOrder.HasValue ? q.LogitudeEndOrder.Value.ToString() : "",
DurationVisit = q.DurationVisit.HasValue ? q.DurationVisit.Value.ToString() : "",
DurationExecute = q.DurationExecute.HasValue ? q.DurationExecute.Value.ToString() : "",
Notes = q.NoteOrder,
URL = q.Orders.URLPreOrder,
SendCRM = q.Orders.SendCRM,
OrderExecuteDate = q.Orders.OrderExecuteDate,
Invoice = q.Orders.Invoice.Count() > 0 ? "Si" : "No",
Evidence = q.Evidence.Where(p => p.TypeEvidence == "StartODS").Select(p => new EvidenceOrder()
{
TypeEvidence = p.TypeEvidence, URLEvidence = GlobalConfiguration.urlRequest + p.URLEvidence.Substring(2)
}).Take(3).ToList(),
DurationOrder = ""
}).ToList());
}
public static List <ModelViewEvidence> GetLisEvidencetAll(string StatusVisitID, string ModuleID, string PriorityID, string StatusOrderID, string ServiceID, string OrderID, string Employee, string StartDate, string EndDate, entities.Entity.Security.EntityUser User)
{
return(new BusinessOrderEvidence().GetList(StatusVisitID, ModuleID, PriorityID, StatusOrderID, ServiceID, OrderID, Employee, StartDate, EndDate, User));
}
public List <ModelViewEvidence> GetList(string StatusVisitID, string ModuleID, string PriorityID, string StatusOrderID, string ServiceID, string OrderID, string Employee, string StartDate, string EndDate, entities.Entity.Security.EntityUser User)
{
var predicate = PredicateBuilder.New <MonitorOrders>();
if (StatusVisitID.Trim().Length > 0)
{
List <int> iStatusVisitID = StatusVisitID.Split(',').Select(int.Parse).ToList();
if (iStatusVisitID.Count() > 0)
{
predicate = predicate.And(i => iStatusVisitID.Contains(i.FK_StatusVisitID.Value));
}
}
if (ModuleID.Trim().Length > 0)
{
List <int> iModuleID = ModuleID.Split(',').Select(int.Parse).ToList();
if (iModuleID.Count() > 0)
{
predicate = predicate.And(i => iModuleID.Contains(i.Orders.FK_ModuleID.Value));
}
}
if (PriorityID.Trim().Length > 0)
{
List <int> iPriorityID = PriorityID.Split(',').Select(int.Parse).ToList();
if (iPriorityID.Count() > 0)
{
predicate = predicate.And(i => iPriorityID.Contains(i.SequenceVisit.Value));
}
}
if (StatusOrderID.Trim().Length > 0)
{
List <int> iStatusOrderID = StatusOrderID.Split(',').Select(int.Parse).ToList();
if (iStatusOrderID.Count() > 0)
{
predicate = predicate.And(i => iStatusOrderID.Contains(i.FK_StatusOrderID.Value));
}
}
if (ServiceID.Trim().Length > 0)
{
List <int> iServiceID = ServiceID.Split(',').Select(int.Parse).ToList();
if (iServiceID.Count() > 0)
{
predicate = predicate.And(i => iServiceID.Contains(i.Orders.FK_GuarantyID.Value));
}
}
if (OrderID.Trim().Length > 0)
{
predicate = predicate.And(i => i.Orders.OrderID.Contains(OrderID));
}
if (Employee.Trim().Length > 0)
{
predicate = predicate.And(i => (i.Orders.Employee.FirstName + " " + i.Orders.Employee.LastName).Contains(Employee));
}
DateTime fhIni = DateTime.Today;
if (DateTime.TryParse(StartDate, out fhIni))
{
predicate = predicate.And(i => i.Orders.OrderExecuteDate >= fhIni);
}
DateTime fhFin = DateTime.Today;
if (DateTime.TryParse(EndDate, out fhFin))
{
fhFin = fhFin.AddHours(23).AddMinutes(59).AddSeconds(59);
predicate = predicate.And(i => i.Orders.OrderExecuteDate <= fhFin);
}
if (User.ModuleID.HasValue)
{
predicate = predicate.And(i => i.Orders.FK_ModuleID == User.ModuleID.Value);
}
return(base.DataContext.MonitorOrders.Where(predicate).Select(q => new ModelViewEvidence()
{
OrderID = q.Orders.OrderID,
EmployeeName = q.Orders.Employee.FirstName + " " + q.Orders.Employee.LastName,
Date = SqlFunctions.DateName("day", q.Orders.OrderExecuteDate) + "/" + SqlFunctions.DateName("month", q.Orders.OrderExecuteDate) + "/" + SqlFunctions.DateName("year", q.Orders.OrderExecuteDate),
EvidenceStartODS = q.Evidence.Where(p => p.TypeEvidence == "StartODS").Select(p => new EvidenceOrder()
{
TypeEvidence = p.TypeEvidence, URLEvidence = GlobalConfiguration.urlRequest + p.URLEvidence.Substring(2)
}).ToList(),
EvidenceBadUse = q.Evidence.Where(p => p.TypeEvidence == "BadUse").Select(p => new EvidenceOrder()
{
TypeEvidence = p.TypeEvidence, URLEvidence = GlobalConfiguration.urlRequest + p.URLEvidence.Substring(2)
}).ToList(),
EvidenceNoSeriesNumber = q.Evidence.Where(p => p.TypeEvidence == "NoSeriesNumber").Select(p => new EvidenceOrder()
{
TypeEvidence = p.TypeEvidence, URLEvidence = GlobalConfiguration.urlRequest + p.URLEvidence.Substring(2)
}).ToList(),
EvidencePurchaseNote = q.Evidence.Where(p => p.TypeEvidence == "PurchaseNote").Select(p => new EvidenceOrder()
{
TypeEvidence = p.TypeEvidence, URLEvidence = GlobalConfiguration.urlRequest + p.URLEvidence.Substring(2)
}).ToList(),
EvidenceSummary = q.Evidence.Where(p => p.TypeEvidence == "Summary").Select(p => new EvidenceOrder()
{
TypeEvidence = p.TypeEvidence, URLEvidence = GlobalConfiguration.urlRequest + p.URLEvidence.Substring(2)
}).ToList(),
EvidenceFinish = q.Evidence.Where(p => p.TypeEvidence == "Finish").Select(p => new EvidenceOrder()
{
TypeEvidence = p.TypeEvidence, URLEvidence = GlobalConfiguration.urlRequest + p.URLEvidence.Substring(2)
}).ToList()
}).ToList());
}
public List <ModelViewODS> GetList(string StatusVisitID, string ModuleID, string PriorityID, string StatusOrderID, string ServiceID, string OrderID, string Employee, string StartDate, string EndDate, entities.Entity.Security.EntityUser User)
{
return(new RepositoryMonitorOrder().GetList(StatusVisitID, ModuleID, PriorityID, StatusOrderID, ServiceID, OrderID, Employee, StartDate, EndDate, User));
}
