Professor6T9 Web SheLL

Windows NT WEB-23 10.0 build 17763 (Windows Server 2016) i586
Microsoft-IIS/10.0
103.118.16.173

File Name : PickReqPrint.aspx

<%@ page language="C#" autoeventwireup="true" inherits="PickReqPrint, App_Web_vopkbwcm" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Configuration" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Santron Pickup Request</title>

table.gridtable td {
	border-width: 1px;
	padding: 5px;
	border-style: solid;
	border-color: #666666;
	background-color: #ffffff;
	vertical-align: top;
	text-align: justify;
}

.title3 { font-weight: bold; }
.smalltext { font-size: 8px; }
.smalltext1 { font-size: 7px; }
.leftalign { text-align:left;}

.reqno {
	border: 1px solid #6297BC;
    padding: 5px;
}

</style>

</head>

<table style="width:320px; margin-left:auto; margin-right:auto;" class="PrintButton">
  <tr>
    <td style="padding:5px; vertical-align:middle; white-space:nowrap;">Request No:</td>
    <td style="padding:5px; vertical-align:middle;"><asp:TextBox ID="txtReqNo" runat="server" CssClass="reqno" AutoPostBack="True"></asp:TextBox></td>
    <td style="padding:5px;"><asp:Button ID="btnFetch" runat="server" Text="Ok" CssClass="reqno"/></td>
  </tr>
</table>

<%
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constring"].ConnectionString);
    string ReqNo = "";

try
    {
        if (Request.QueryString["id"] != null)
        {
            ReqNo = Request.QueryString["id"].ToString();
        }
        
        if (Request.Form["txtReqNo"] != null)
        {
            ReqNo = Request.Form["txtReqNo"].ToString();
        }

if (ReqNo != "")
        {
            string sqlStr = "Select A.AWBNo, P.*, B.*, C.CurrencyCode From PickupRequests P " + 
                            "Inner Join AirWayBillNoAllotment A On A.Fk_PickupReqID = P.Pk_PickupReqID " + 
                            "Inner Join Location.Branches B On P.Fk_ReqToFacilityID = B.Pk_BranchID " + 
                            "Left Join Location.Currencies C On P.Fk_DeclaredCurrencyID = C.Pk_CurrencyID " +
                            "Where P.RequestNo= @ReqNo ";

txtReqNo.Text = ReqNo;
            DataTable dt = new DataTable();
            SqlCommand cmd = new SqlCommand(sqlStr, con);
            cmd.Parameters.AddWithValue("@ReqNo", ReqNo);
            SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);
            if (dt.Rows.Count > 0)
            {
%>

<table style="width:700px; margin-left:auto; margin-right:auto;page-break-after:always;" >
  <tr>
    <td>
    <table width="100%">
      <tr>
        <td style="width:33%"><img src="images/logo1.png" alt="" /></td>
        <td style="width:34%; text-align: center;font-size:12pt; font-weight:bold;">Shipper Letter of Instruction</td>
        <td style="width:33%; text-align: center; font-weight:bold;">
            <img src="barcode.ashx?code=<% Response.Write(dt.Rows[0]["AWBNo"].ToString()); %>&ShowText=0&Thickness=1&Height=50" 
                 alt="<% Response.Write(dt.Rows[0]["AWBNo"].ToString()); %>" /><br />                                  
                 AWB #: <% Response.Write(dt.Rows[0]["AWBNo"].ToString()); %>
        </td>
      </tr>
    </table>
    <div style="height:5px;"></div>
    <table width="100%" class="gridtable">
      <tr>
        <td><span class="title3">Request No</span></td>
        <td><%=dt.Rows[0]["RequestNo"].ToString()%></td>
        <td><span class="title3">Request Date</span></td>
        <td><% Response.Write(Convert.ToDateTime(dt.Rows[0]["ReqDateTime"].ToString()).ToString("dd-MMM-yyyy HH:mm")); %></td>
        <td><span class="title3">Reference No</span></td>
        <td><%=dt.Rows[0]["PurchaseOrderNo"].ToString()%></td>
      </tr>
      <tr>
        <td><span class="title3">Service Type</span></td>
        <td><%=dt.Rows[0]["ServiceType"].ToString()%></td>
        <td><span class="title3">Shipment Type</span></td>
        <td><%=dt.Rows[0]["ShipmentType"].ToString()%></td>
        <td><span class="title3">Customs Value</span></td>
        <td><%=dt.Rows[0]["CurrencyCode"].ToString()%> <%=dt.Rows[0]["DeclaredValue"].ToString()%></td>
      </tr>
      <tr>
        <td><span class="title3">Bill To</span></td>
        <td><%=dt.Rows[0]["RaiseBillTo"].ToString()%></td>
        <td><span class="title3">Duty Bill To</span></td>
        <td><%=dt.Rows[0]["RaiseDutyBillTo"].ToString()%></td>
        <td><span class="title3">Shipment Terms</span></td>
        <td><%=dt.Rows[0]["ShipmentTerms"].ToString()%></td>
      </tr>
      <tr>
        <td><span class="title3">Total Pcs</span></td>
        <td><%=dt.Rows[0]["TotalPcs"].ToString()%></td>
        <td><span class="title3">Actual Weight</span></td>
        <td><%=dt.Rows[0]["TotalWeight"].ToString()%> Kg.</td>
        <td><span class="title3">Consignee VAT  No</span></td>
        <td><%=dt.Rows[0]["ReceiverVATRefNo"].ToString()%></td>
      </tr>
    </table>
    <div style="height:5px;"></div>
    <table class="gridtable" style="width:100%">
      <tr>
        <td style="width:50%;">
          <span class="title3">Shipper</span><br />
          <div class="leftalign">
            <%
                Response.Write(dt.Rows[0]["ShipperName"].ToString() + "<br />" +
                               dt.Rows[0]["ShipperAddress"].ToString() + "<br />" +
                               dt.Rows[0]["ShipperCity"].ToString() + " " +
                               dt.Rows[0]["ShipperPin"].ToString() + "<br />" +
                               dt.Rows[0]["ShipperState"].ToString() + " " +
                               dt.Rows[0]["ShipperCountry"].ToString() + "<br />Contact: " +
                               dt.Rows[0]["ShipperContact"].ToString() + "<br />Phone: " +
                               dt.Rows[0]["ShipperPhone"].ToString());  
            %>
          </div>
          </td>
        <td style="width:50%;">
          <span class="title3">Consignee</span><br />
          <div class="leftalign">
          <%
                Response.Write(dt.Rows[0]["ConsigneeName"].ToString() + "<br />" +
                                dt.Rows[0]["ConsigneeAddress"].ToString() + "<br />" +
                                dt.Rows[0]["ConsigneeCity"].ToString() + " " +
                                dt.Rows[0]["ConsigneePin"].ToString() + "<br />" +
                                dt.Rows[0]["ConsigneeState"].ToString() + " " +
                                dt.Rows[0]["ConsigneeCountry"].ToString() +  "<br />Contact: " +
                                dt.Rows[0]["ConsigneeContact"].ToString() + "<br />Phone: " +
                                dt.Rows[0]["ConsigneePhone"].ToString()); 
            %>
          </div>
          </td>
      </tr>
    </table>
    <div style="height:5px;"></div>
    <table class="gridtable" style="width:100%">
      <tr>
        <td>
        	<span class="title3">Description of Goods</span><br />
            <%=dt.Rows[0]["DescOfGoods"].ToString().Replace("\r\n","<br />")%>
        </td>
        <td>
        	<span class="title3">Dimensions</span><br />
            <%=dt.Rows[0]["PackageDimensions"].ToString().Replace("\r\n","<br />")%>
        </td>
        <td>
        	<span class="title3">Marks & Nos</span><br />
            <%=dt.Rows[0]["MarksAndNos"].ToString().Replace("\r\n","<br />")%>
        </td>
        <td>
        	<span class="title3">Special Delivery Instructions</span><br />
            <%=dt.Rows[0]["SpecialDeliveryInstructions"].ToString().Replace("\r\n","<br />")%>
        </td>
      </tr>
    </table>    
    <div style="height:5px;"></div>
    <table class="gridtable" style="width:100%">
      <tr>
        <td style="width:50%;">
          <span class="title3">Shipper's Authorisation and Agreement</span><br />
          <span class="smalltext">The Customr declares that all descriptions, values and other particular furnished herein are accurate and complete. The Customer undertakes to indemnify the Agent against all losses, damages, expenses, fines and any other liabiliies whatsoever arising from any inaccuracy or omission, even if such inaxxuracy or omission is not due to any negligence. The Customer declares that pursuant to Condition 15 of the Contract of Condition overleaf it shall be responsible for all charges and expenses relating to the changes and expenses are to be prepaid or collected. The undersigned authorized officer of the Customer hereby declares that he has read the Conditions of Contract overleaf and terms and condition appearing on this pages and that he fully understands them and agress on behalf of the Customer that they should form part of the contract which, upon acceptance to the above instructions by the Agent, will be concluded between the Customer and the Agent. I fully read and unstand this Shipper Letter of Instruction (Booking Form) 2nd page terms and conditions will be apply on this courier parcel and this air freight shipment.</span>
          <br /><br />
          <span class="title3">E-Signature & Stamp of the Shipper or its Agent</span><br /><br />
          <strong><% Response.Write(dt.Rows[0]["ShipperContact"].ToString() ); %></strong><br />           
          Date: <% Response.Write(Convert.ToDateTime(dt.Rows[0]["EntryDateTime"].ToString()).ToString("dd-MMM-yyyy")); %>
        </td>
        <td style="width:50%;">
          <span class="title3">Agent Declaration</span><br />
          <span class="smalltext">The Agent acknowledges receipt or the above instructions from the CustOmer. This acknowledgement does not constitute an acceptance of the instructions by the Agent, Acceptance of the instructions will be made by way of the issue of the Agent's Courier Waybill, House Air Waybill, Air Consignment Note or the Air Carrier's Air Waybill or other such similar documents. Where goods or documents are delivered to and accepted by the Agent before the Agent accepts the Customers instructions, no liability whatsoever for such goods of documents will be accepted by the Agent. If, however, the Agent is held to be liable, all the provisions of limitation of liabilities specified in the Conditions of Contract overleaf will apply. The Customer shall reimburse the Agent with all expenses and costs incurred and will indemnify the Agent For all losses and liabilities howsoever caused.</span>
          <br /><br /><br /><br />
                <% 
                    if (dt.Rows[0]["Country"].ToString() == "Hong Kong")
                    Response.Write(
                           "<strong>" + dt.Rows[0]["InternationalInvoiceTitle"].ToString() + "</strong><br />" + 
                           dt.Rows[0]["Address1"].ToString() + "<br />" + 
                           dt.Rows[0]["Address2"].ToString() + "<br />" + 
                           dt.Rows[0]["City"].ToString() + " Zip: " + 
                           dt.Rows[0]["Pin"].ToString()
                           ); 
                    else
                        Response.Write(
                               "<strong>" + dt.Rows[0]["InternationalInvoiceTitle"].ToString() + "</strong><br />" +
                               dt.Rows[0]["Address1"].ToString() + "<br />" +
                               dt.Rows[0]["Address2"].ToString() + "<br />" +
                               dt.Rows[0]["City"].ToString() + " Zip: " +
                               dt.Rows[0]["Pin"].ToString() + "<br />" +
                               dt.Rows[0]["State"].ToString() + "<br />" +
                               dt.Rows[0]["Country"].ToString()
                               ); 
                  %>
        </td>
      </tr>
    </table>
    <div class="title3" style="text-align:center; font-size:8pt;">Tel: +91.11.45071420 | Track @ https://www.santronexpress.com</div>
    </td>
  </tr>
</table>

<%
            }
        }
    }
    catch (Exception ex)
    {
        Response.Write("Error: " + ex.Message.ToString());
    }
%>

</form></body>
</html>

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	0777	2025-11-20 09:01:01
..	dir	-	0/0	0777	2024-04-07 09:40:16
bin	dir	-	0/0	0777	2025-11-20 09:07:03
css	dir	-	0/0	0777	2025-11-20 09:01:34
dtp	dir	-	0/0	0777	2025-11-20 09:00:57
images	dir	-	0/0	0777	2025-11-20 09:01:00
js	dir	-	0/0	0777	2025-11-20 09:01:03
webfonts	dir	-	0/0	0777	2025-11-20 09:01:04
About.aspx	text/html	9.17 KB	0/0	0666	2025-11-20 09:07:03
Contact.aspx	text/html	2.68 KB	0/0	0666	2025-11-20 09:07:06
Default.aspx	text/html	4.31 KB	0/0	0666	2025-11-20 09:07:06
Network.aspx	text/html	3.86 KB	0/0	0666	2025-11-20 09:07:03
PickReq.aspx	text/html	34.07 KB	0/0	0666	2025-11-20 09:07:03
PickReqPrint.aspx	text/html	12.62 KB	0/0	0666	2025-11-20 09:07:03
Pickup.aspx	text/html	6.93 KB	0/0	0666	2025-11-20 09:07:03
PrecompiledApp.config	text/plain	49 B	0/0	0666	2025-11-20 09:07:06
Track.aspx	text/html	5.66 KB	0/0	0666	2025-11-20 09:07:06
Web.config	text/xml	1.41 KB	0/0	0666	2025-11-20 09:07:48
awbprint.aspx	text/html	23.65 KB	0/0	0666	2025-11-20 09:07:06
barcode.ashx	text/plain	1.1 KB	0/0	0666	2025-11-20 09:07:03
captcha.aspx	text/html	315 B	0/0	0666	2025-11-20 09:07:03
index.html.org	text/html	541 B	0/0	0666	2025-09-16 08:04:09
main.master	text/html	8.13 KB	0/0	0666	2025-11-20 09:07:03
web.config.org	text/xml	29.27 KB	0/0	0666	2025-09-16 09:39:29

Team Anon Force

https://t.me/Professor6T9x