public WOData(List<Status> StatusList)
{
using (var db = new mp250dbDB())
{
var objStatusArray = StatusList.ToCommaSeparatedString().Split(',');
WorkOrders = db.WOes
.Where(w => objStatusArray.Contains(w.STATUS + string.Empty))
.ToList();
}
}
public WOData(DateTime dtmStartDate, DateTime dtmEndDate)
{
using (var db = new mp250dbDB())
{
WorkOrders = db.WOes
.Where(w => w.REQUESTDATE >= dtmStartDate || w.COMPLETIONDATE >= dtmStartDate || w.COMPLETIONDATE == null)
.Where(w => w.REQUESTDATE <= dtmEndDate || w.COMPLETIONDATE <= dtmEndDate || w.COMPLETIONDATE == null)
.ToList();
}
}
public WOData(out List<WODurationCategory> DurationCategories, List<Status> StatusList)
{
using (var db = new mp250dbDB())
{
var objStatusArray = StatusList.ToCommaSeparatedString().Split(',');
WorkOrders = db.WOes
.Where(w => objStatusArray.Contains(w.STATUS + string.Empty))
.ToList();
}
DurationCategories = SegmentByWOType();
}
public WOData(out List<WODurationCategory> DurationCategories, DateTime dtmStartDate, DateTime dtmEndDate)
{
using (var db = new mp250dbDB())
{
WorkOrders = db.WOes
.Where(w => w.REQUESTDATE >= dtmStartDate || w.COMPLETIONDATE >= dtmStartDate || w.COMPLETIONDATE == null)
.Where(w => w.REQUESTDATE <= dtmEndDate || w.COMPLETIONDATE <= dtmEndDate || w.COMPLETIONDATE == null)
.ToList();
}
DurationCategories = SegmentByWOType();
}
