//Members
//Interface
protected void Page_Load(object sender, EventArgs e)
{
//Event handler for form load event
if (!Page.IsPostBack)
{
//Prepopulate from carton detail
string cartonNumber = Request.QueryString["ID"] == null ? "" : Request.QueryString["ID"].ToString();
if (cartonNumber.Length > 0)
{
TrackingDS summary = (TrackingDS)Session["TrackingSummary"];
if (summary != null && summary.CartonSummaryTable.Rows.Count > 0)
{
//Find the summary info for cartonNumber
TrackingDS.CartonSummaryTableRow summaryRow = summary.CartonSummaryTable.FindByID(cartonNumber);
if (summaryRow != null)
{
//Get all detail rows for this carton
string filter = "[LBL]=" + summaryRow.LBLNumber;
TrackingDS cartons = (TrackingDS)Session["TrackingDetail"];
DataRow[] detailRows = cartons.CartonDetailTable.Select(filter);
if (detailRows != null && detailRows.Length > 0)
{
//Show tracking detail for the carton
TrackingDS.CartonDetailTableRow carton = (TrackingDS.CartonDetailTableRow)detailRows[0];
this.lblName.Text = "ATTN: Claims Department";
this.lblCarrier.Text = "Argix Direct, Inc.";
this.lblDate.Text = DateTime.Today.ToShortDateString();
this.lblAddress.Text = "100 Middlesex Center Blvd, Jamesburg, NJ 08831";
this.lblClaimant.Text = carton.CLNM.Trim(); //Client name
if (carton.CTN.Trim().Length > 0)
{
this.lblDescription.Text = "Carton# " + carton.CTN.Trim(); //Carton#
}
else
{
this.lblDescription.Text = "Label# " + carton.LBL.ToString().Trim(); //LabelSeq#
}
this.lblConsignor.Text = carton.CLNM.Trim(); //Client name, city, state
this.lblShipFrom.Text = carton.VNM.Trim() + " " + carton.VCT.Trim() + ", " + carton.VST.Trim(); //Vendor name, city, state
this.lblFinalDest.Text = carton.SNM.Trim() + " " + carton.SCT.Trim() + ", " + carton.SST.Trim(); //Store name, city, state
this.lblRoutedVia.Text = "Argix Direct, Inc.";
this.lblBOLBy.Text = carton.VNM.Trim(); //Vendor name
this.lblBOLDate.Text = carton.PUD.Trim(); //Pickup date
this.lblPRONum.Text = carton.VK.Trim(); //PRO#
this.lblTrailerNum.Text = ""; //Vendor trailer#
this.lblConsignee.Text = carton.SNM.Trim() + " " + carton.SCT.Trim() + ", " + carton.SST.Trim(); //Store name, city, state
}
}
}
}
}
}
private void displayTrackingDetail(string cartonNumber)
{
//Display tracking info for the specified carton
TrackingDS summary = (TrackingDS)Session["TrackingSummary"];
if (summary != null)
{
//Find the summary info for cartonNumber
TrackingDS.CartonSummaryTableRow summaryRow = summary.CartonSummaryTable.FindByID(cartonNumber);
if (summaryRow != null)
{
//Get all detail rows for this carton
string filter = "[LBL]=" + summaryRow.LBLNumber;
TrackingDS cartons = (TrackingDS)Session["TrackingDetail"];
DataRow[] detailRows = cartons.CartonDetailTable.Select(filter);
if (detailRows != null && detailRows.Length > 0)
{
//Show tracking detail for the carton
showCarton((TrackingDS.CartonDetailTableRow)detailRows[0]);
//Update navigation
this.cboCartons.Visible = this.CartonLabel.Visible = false;
this.btnNavFirst.Visible = this.btnNavPrev.Visible = this.btnNavNext.Visible = this.btnNavLast.Visible = false;
if (summary.CartonSummaryTable.Rows.Count > 1)
{
this.cboCartons.DataSource = summary;
this.cboCartons.DataMember = "CartonSummaryTable";
this.cboCartons.DataTextField = "DisplayNumber";
this.cboCartons.DataValueField = "ID";
this.cboCartons.DataBind();
this.cboCartons.SelectedValue = cartonNumber;
this.cboCartons.Visible = this.CartonLabel.Visible = summary.CartonSummaryTable.Rows.Count > 1;
this.btnNavFirst.Visible = this.btnNavPrev.Visible = this.btnNavNext.Visible = this.btnNavLast.Visible = summary.CartonSummaryTable.Rows.Count > 1;
}
}
}
}
}
private void addSummaryRow(string id, string displayNumber, TrackingDS.CartonDetailTableRow carton, TrackingDS summary)
{
//Create a summary row for the specified carton
TrackingDS.CartonSummaryTableRow record = summary.CartonSummaryTable.NewCartonSummaryTableRow();
record.ID = id;
record.DisplayNumber = displayNumber;
record.CTNNumber = carton.CTN.Trim();
record.LBLNumber = carton.LBL.ToString().Trim();
record.CBOL = carton.IsCBOLNull() ? "" : carton.CBOL.Trim();
if (carton.SCNTP == 3 && !carton.IsSCDNull() && carton.SCD.Trim().Length > 0)
{
record.DateTime = carton.SCD.Trim() + " " + carton.SCTM.Trim();
if (carton.T.Trim().Length == 18 && carton.T.Trim().Substring(0, 2).ToLower() == "1z")
{
record.Status = "Rerouted: Tracking # " + carton.T.Trim();
}
else
{
switch (carton.OM)
{
case "M": record.Status = carton.ISMN == 1 ? "Delivered (Scan N/A - Manual Entry)" : "Delivered"; break;
case "S": record.Status = "Short At Delivery"; break;
case "O": record.Status = "Over At Delivery"; break;
case "A": record.Status = "MisRoute At Delivery"; break;
}
}
record.Location = carton.SCT.Trim() + "/" + carton.SST.Trim();
}
else
{
if (carton.SCNTP == 3 && !carton.IsACTSDDNull() && carton.ACTSDD.Trim().Length > 0)
{
record.DateTime = carton.ACTSDD.Trim();
record.Status = "Out For Delivery";
record.Location = carton.SCT.Trim() + "/" + carton.SST.Trim();
}
else
{
if (!carton.IsAARDNull() && carton.AARD.Trim().Length > 0)
{
record.DateTime = carton.AARD.Trim() + " " + carton.AART.Trim();
if (carton.SCNTP == 1)
{
switch (carton.OM)
{
case "M": record.Status = "Scanned At Delivery Terminal"; break;
case "S": record.Status = "Short At Delivery Terminal"; break;
case "O": record.Status = "Over At Delivery Terminal"; break;
case "A": record.Status = "MisRoute At Delivery Terminal"; break;
}
}
else
{
record.Status = "Arrived At Delivery Terminal";
}
if (!carton.IsSAGCTNull())
{
record.Location = carton.SAGCT.Trim() + "/" + (carton.IsSAGSTNull() ? "" : carton.SAGST.Trim());
}
else
{
record.Location = (carton.IsAGCTNull() ? "" : carton.AGCT.Trim()) + "/" + (carton.IsAGSTNull() ? "" : carton.AGST.Trim());
}
}
else
{
if (!carton.IsADPDNull() && carton.ADPD.Trim().Length > 0)
{
record.DateTime = carton.ADPD.Trim() + " " + carton.ADPT.Trim();
record.Status = "Departed Sort Facility";
record.Location = carton.SRTLOC.Trim();
}
else
{
if (!carton.IsASFDNull() && carton.ASFD.Trim().Length > 0)
{
record.DateTime = carton.ASFD.Trim() + " " + carton.ASFT.Trim();
record.Status = "Arrived At Sort Facility";
record.Location = carton.SRTLOC.Trim();
}
}
}
}
}
summary.CartonSummaryTable.AddCartonSummaryTableRow(record);
}
protected void OnPODRequest(object sender, EventArgs e)
{
//Send request to Customer Service and confirmation to user
TrackingDS.CartonDetailTableRow carton = null;
string cbol = "";
bool imageFound = false;
MembershipServices membership = new MembershipServices();
TrackingDS summary = (TrackingDS)Session["TrackingSummary"];
TrackingDS.CartonSummaryTableRow summaryRow = summary.CartonSummaryTable.FindByID(this.CartonNumberValue.Text);
if (summaryRow == null)
{
summaryRow = summary.CartonSummaryTable.FindByID(this.LabelSeqValue.Text);
}
if (summaryRow != null)
{
//Get all detail rows for this carton
string filter = "[LBL]=" + summaryRow.LBLNumber;
TrackingDS cartons = (TrackingDS)Session["TrackingDetail"];
DataRow[] detailRows = cartons.CartonDetailTable.Select(filter);
if (detailRows != null && detailRows.Length > 0)
{
//Get carton data
carton = (TrackingDS.CartonDetailTableRow)detailRows[0];
if (membership.IsAdmin || membership.IsArgix || membership.IsPODMember)
{
//Check for a POD image for this CBOL
cbol = carton.IsCBOLNull() ? "" : carton.CBOL.Trim();
if (cbol.Length > 0)
{
string cl = carton.CL.Trim().PadLeft(3, '0');
string div = "%";
string st = carton.S.ToString().PadLeft(5, '0');
Imaging.ImageService isvc = new Imaging.ImageService();
isvc.Url = Application["ImageService"].ToString();
isvc.UseDefaultCredentials = true;
DataSet ds = isvc.SearchSharePointImageStore("TBill", "TBBarCode", cbol + cl + div + st + "%");
imageFound = (ds != null && ds.Tables[0].Rows.Count > 0);
}
}
}
}
if (imageFound)
{
//Image available- open image into another browser instance
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("<script language=javascript>");
sb.Append("window.open('PODImage.aspx?doc=TBill&prop=TBBarCode&search=" + cbol + "%', '_blank', 'width=480,height=576,menubar=yes,location=no,toolbar=no,status=yes,resizable=yes');");
sb.Append("</script>");
Page.ClientScript.RegisterStartupScript(typeof(Page), "POD Image", sb.ToString());
}
else
{
//No image; request a POD from Argix
EmailServices svcs = new EmailServices();
MembershipUser user = Membership.GetUser();
string substore = Session["SubStore"] != null ? Session["SubStore"].ToString() : "";
svcs.SendPODRequest(user, carton, substore);
svcs.SendPODRequestConfirm(user, carton, substore);
//Disply confirmation to user
Response.Redirect("PODConfirmation.aspx");
}
}
