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(); }