//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"); } }