public List <EntityMonitorOrder> GetByUserID(int UserID, DateTime fh)
{
DateTime fhInico = new DateTime(fh.Year, fh.Month, fh.Day, 0, 0, 0);
DateTime fhFin = new DateTime(fh.Year, fh.Month, fh.Day, 23, 59, 59);
return(FactoryMonitorOrder.GetList((from p in base.DataContext.MonitorOrders
where p.Orders.Employee.FK_UserID == UserID &&
p.Orders.OrderExecuteDate >= fhInico &&
p.Orders.OrderExecuteDate <= fhFin
select p).ToList()));
}
public EntityMonitorOrder GetByOrderID(int Id)
{
var data = base.DataContext.MonitorOrders.Where(p => p.FK_OrderID == Id);
if (data.Count() == 1)
{
return(FactoryMonitorOrder.Get(data.Single()));
}
else
{
return(null);
}
}
public EntityMonitorOrder GetByOrder(string OrderID, DateTime fh)
{
var fhInicio = new DateTime(fh.Year, fh.Month, fh.Day, 0, 0, 0);
var fhFin = new DateTime(fh.Year, fh.Month, fh.Day, 23, 59, 59);
var data = base.DataContext.MonitorOrders.Where(p => p.Orders.OrderID == OrderID && p.Orders.OrderExecuteDate >= fhInicio && p.Orders.OrderExecuteDate <= fhFin);
if (data.Count() == 1)
{
return(FactoryMonitorOrder.Get(data.Single()));
}
else
{
return(null);
}
}
public List <EntityMonitorOrder> GeListByOrderAverage(List <int> OrderIDs)
{
return(FactoryMonitorOrder.GetList(base.DataContext.MonitorOrders.Where(p => OrderIDs.Contains(p.FK_OrderID) && p.FK_StatusOrderID == 4).ToList()));
}
public List <EntityMonitorOrder> GetAll()
{
return(FactoryMonitorOrder.GetList(base.DataContext.MonitorOrders.ToList()));
}
public List <EntityMonitorOrder> GetActives()
{
return(FactoryMonitorOrder.GetList(base.DataContext.MonitorOrders.Where(p => p.Status == true).ToList()));
}
