public List <OutstandingPOD> GetOutstandingPODForAge(int clientIdentityID, int age) { try { int?_age = null; if (age > 0) { _age = age; } DataAccess.POD DAL = new Orchestrator.DataAccess.POD(); DataSet dsPOD = DAL.GetAgedOutstandingPOD(clientIdentityID, _age); var retVal = (from r in dsPOD.Tables[0].AsEnumerable() select new OutstandingPOD() { OrderID = r.Field <int>("OrderID"), RunID = r.Field <int>("JobID"), DeliveryDateTime = r.Field <DateTime>("DeliveryDateTime"), ArrivalDateTime = r.Field <DateTime>("ArrivalDateTime"), CustomerOrderNumber = r.Field <string>("CustomerOrderNumber") }).ToList(); return(retVal); } catch (Exception ex) { throw ex; } }
public List <PODSummaryRow> GetAgedOutstandingPOD(int clientIdentityID, int age) { try { int?_age = null; if (age > 0) { _age = age; } DataAccess.POD DAL = new Orchestrator.DataAccess.POD(); DataSet dsPOD = DAL.GetAgedOutstandingPOD(clientIdentityID, _age); var retVal = (from r in dsPOD.Tables[0].AsEnumerable() select new PODSummaryRow() { Days4 = r.Field <int>("4Days"), Days7 = r.Field <int>("7Days"), Days15 = r.Field <int>("15Days") }).ToList(); return(retVal); } catch (Exception ex) { throw ex; } }
private void GetDetailData(int identityID, int age) { DataAccess.POD dacPOD = new Orchestrator.DataAccess.POD(); gvDetails.DataSource = dacPOD.GetAgedOutstandingPOD(identityID, age); gvDetails.DataBind(); grdOverview.Visible = false; gvDetails.Visible = true; btnCancel.Visible = true; }
private void GetOverviewData() { DataAccess.POD dacPOD = new Orchestrator.DataAccess.POD(); grdOverview.DataSource = dacPOD.GetAgedOutstandingPOD(null, null); grdOverview.DataBind(); gvDetails.Visible = false; if (grdOverview.Visible == false) { grdOverview.Visible = true; } }