public IList <IDataService> GetOpertionalOverviewData2(IDataReader reader) { IList <IDataService> lst = new List <IDataService>(); List <OperationalOverview> items = new List <OperationalOverview>(); while (reader.Read()) { OperationalOverview obj = new OperationalOverview(); obj.StatusCode = reader["STATUS_CODE"].ToString() ?? string.Empty; obj.StatusDescription = reader["STATUSDESC"].ToString() ?? string.Empty; obj.LoadNumber = reader["PICKLOADCOUNT"].ToString() ?? string.Empty; obj.MultiOrders = reader["MULTIORDERS"].ToString() ?? string.Empty; obj.MultiOrderItems = reader["MULTITEMS"].ToString() ?? string.Empty; obj.SingleOrders = reader["SINGLEORDERS"].ToString() ?? string.Empty; obj.TotalOrders = reader["TOTALORDERS"].ToString() ?? string.Empty; obj.EarliestOrderDateTime = Convert.ToDateTime(reader["MINORDERDATE"].ToString() ?? DateTime.MinValue.ToString()); items.Add(obj); } this.OverviewInfo = items; lst.Add(this); reader.Close(); return(lst); }
public IList <IDataService> GetOpertionalCancellations(IDataReader reader) { IList <IDataService> lst = new List <IDataService>(); List <OperationalOverview> items = new List <OperationalOverview>(); while (reader.Read()) { OperationalOverview obj = new OperationalOverview(); //obj.StatusCode = reader["STATUS_CODE"].ToString() ?? string.Empty; //obj.StatusDescription = reader["STATUS"].ToString() ?? string.Empty; //obj.LoadNumber = reader["LOAD"].ToString() ?? string.Empty; obj.MultiOrders = reader["TOTMULTIS"].ToString() ?? string.Empty; obj.MultiOrderItems = reader["TOTMULTIITEMS"].ToString() ?? string.Empty; obj.SingleOrders = reader["TOTSINGLES"].ToString() ?? string.Empty; obj.TotalOrders = reader["TOTCANCELLATIONS"].ToString() ?? string.Empty; //obj.EarliestOrderDateTime = Convert.ToDateTime(reader["EARLIESTDATE"].ToString() ?? DateTime.MinValue.ToString()); items.Add(obj); } this.OverviewInfo = items; lst.Add(this); reader.Close(); return(lst); }