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