void LoadData()
{
clsPartTransfer obj = new clsPartTransfer();
if (ddlSite.SelectedValue != "0")
{
obj.Op = 4;
obj.DestinationSite = Convert.ToInt32(ddlSite.SelectedValue);
obj.SourceSite = Convert.ToInt32(ddlSite.SelectedValue);
}
else
{
obj.Op = 3;
}
try { obj.EntryDate1 = Convert.ToDateTime(txtDateFrom.Text).ToShortDateString(); }
catch { }
try { obj.EntryDate2 = Convert.ToDateTime(txtDateTo.Text).ToShortDateString(); }
catch { }
DataTable dt = obj.PartTransfer(obj).Tables[0];
grdData.DataSource = dt;
grdData.DataBind();
foreach (GridViewRow dr in grdData.Rows)
{
LiteralControl lc = new LiteralControl();
lc.Text = "<a href='PTReport.aspx?RefNo=" + grdData.DataKeys[dr.RowIndex].Value + "' target='_blank'>View</a>";
dr.Cells[8].Controls.Add(lc);
}
}
public void PartTrasnferTrack(string RefNo)
{
clsPartTransfer obPT = new clsPartTransfer();
clsPTItems obPTI = new clsPTItems();
obPT.Reference = RefNo;
obPT.Op = 5;
DataTable dtPT = obPT.PartTransfer(obPT).Tables[0];
if (dtPT.Rows.Count > 0)
{
obPTI.PTID = Convert.ToInt32(dtPT.Rows[0]["ID"]);
}
else
{
obPTI.PTID = 0;
}
obPTI.Op = 2;
DataTable dtPTI = obPTI.PTITems(obPTI).Tables[0];
DataTable[] arr = new DataTable[2];
arr[0] = dtPT;
arr[1] = dtPTI;
Context.Response.Write(JsonConvert.SerializeObject(arr));
}
/* Op=1 Insert data
* Op =2 Update status
* Op=3 Get all Data By Date
* Op=4 Get All Data By Site And Date
* Op=5 Get Detail by Reference
* Op=6 get Max ID
*/
public DataSet PartTransfer(clsPartTransfer obj)
{
try
{
connect();
SqlParameter[] param = new SqlParameter[11];
param[0] = new SqlParameter("@ID", obj._ID);
param[1] = new SqlParameter("@Reference", obj._Reference);
param[2] = new SqlParameter("@SourceSite", obj._SourceSite);
param[3] = new SqlParameter("@DestinationSite", obj._DestinationSite);
param[4] = new SqlParameter("@EntryDate1", obj._EntryDate1);
param[5] = new SqlParameter("@EntryDate2", obj._EntryDate2);
param[6] = new SqlParameter("@VehicleNo", obj._VehicleNo);
param[7] = new SqlParameter("@DriverName", obj._DriverName);
param[8] = new SqlParameter("@DriverPh", obj._DriverPh);
param[9] = new SqlParameter("@Status", obj._Status);
param[10] = new SqlParameter("@Op", obj._Op);
DataSet ds = SqlHelper.ExecuteDataset(co, "procPartTransfer", param);
return(ds);
}
catch
{
return(null);
}
finally
{
co.Close();
}
}
protected void grdData_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
clsPartTransfer obj = new clsPartTransfer();
obj.Reference = grdData.DataKeys[e.RowIndex].Value.ToString();
obj.Status = 2;
obj.Op = 2;
obj.PartTransfer(obj);
LoadData();
SendSMS(grdData.DataKeys[e.RowIndex].Value.ToString());
}
public void GetPartTransferByDateAndSite(string EntryDate1, string EntryDate2, int SiteID)
{
clsPartTransfer obj = new clsPartTransfer();
obj.EntryDate1 = EntryDate1;
obj.EntryDate2 = EntryDate2;
obj.SourceSite = SiteID;
obj.DestinationSite = SiteID;
obj.Op = 4;
DataTable dt = obj.PartTransfer(obj).Tables[0];
Context.Response.Write(JsonConvert.SerializeObject(dt));
}
public void SavePartTransfer(string Reference, int SourceSite, int DestinationSite, string EntryDate, string VehicleNo, string DriverName, string DriverPh, int Status)
{
clsPartTransfer obj = new clsPartTransfer();
obj.Reference = Reference;
obj.SourceSite = SourceSite;
obj.DestinationSite = DestinationSite;
obj.EntryDate1 = EntryDate;
obj.VehicleNo = VehicleNo;
obj.DriverName = DriverName;
obj.DriverPh = DriverPh;
obj.Status = Status;
obj.Op = 1;
obj.PartTransfer(obj);
Context.Response.Write(JsonConvert.SerializeObject("Saved"));
}
void SendSMS(string Reference)
{
clsPartTransfer obj = new clsPartTransfer();
obj.Op = 5;
obj.Reference = Reference;
DataTable dt = obj.PartTransfer(obj).Tables[0];
string Mobile = "";
try
{
if (dt.Rows[0]["SSiteInchargePh"].ToString().Trim() != "")
{
Mobile = Mobile + dt.Rows[0]["SSiteInchargePh"].ToString();
}
if (dt.Rows[0]["DSiteInchargePh"].ToString().Trim() != "")
{
if (Mobile != "")
{
Mobile = Mobile + ",";
}
Mobile = Mobile + dt.Rows[0]["DSiteInchargePh"].ToString();
}
clsPTItems obPTI = new clsPTItems();
obPTI.PTID = Convert.ToInt32(dt.Rows[0]["ID"]);
obPTI.Op = 2;
DataTable dtPTI = obPTI.PTITems(obPTI).Tables[0];
int total = 0;
foreach (DataRow dr in dtPTI.Rows)
{
total = total + Convert.ToInt32(dr["Quantity"]);
}
string Message = "Reference No: " + Reference + ", From: " + dt.Rows[0]["SourceSiteName"] + ", To: " + dt.Rows[0]["DestSiteName"] + ", Quantity: " + total.ToString() + ", Vehicle No: " + dt.Rows[0]["VehicleNo"];
Message = Message + ", Driver Name:" + dt.Rows[0]["DriverName"] + ", Driver Phone: " + dt.Rows[0]["DriverPhone"] + ", Status: Delivered";
string URL = "http://sambsms.com/app/smsapi/index.php?key=458AD34748890B&campaign=0&routeid=7&type=text&contacts=" + Mobile + "&senderid=TKECON&msg=" + Message + "";
HttpWebRequest request = WebRequest.Create(URL) as HttpWebRequest;
//optional
HttpWebResponse response = request.GetResponse() as HttpWebResponse;
}
catch
{
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
clsPartTransfer obj = new clsPartTransfer();
try { obj.Reference = Convert.ToDateTime(txtDate.Text).Year.ToString() + Convert.ToDateTime(txtDate.Text).Day.ToString() + Convert.ToDateTime(txtDate.Text).Month.ToString() + ddlSourceSite.SelectedValue + ddlDestSite.SelectedValue; }
catch { obj.Reference = DateTime.Today.Year.ToString() + DateTime.Today.Day.ToString() + DateTime.Today.Month.ToString() + ddlSourceSite.SelectedValue + ddlDestSite.SelectedValue; }
obj.SourceSite = Convert.ToInt32(ddlSourceSite.SelectedValue);
obj.DestinationSite = Convert.ToInt32(ddlDestSite.SelectedValue);
try { obj.EntryDate1 = Convert.ToDateTime(txtDate.Text).ToShortDateString(); }
catch { }
obj.VehicleNo = txtVehicleNo.Text;
obj.DriverName = txtDriverName.Text;
obj.DriverPh = txtDriverPh.Text;
obj.Status = 1;
obj.Op = 1;
obj.PartTransfer(obj);
obj.Op = 6;
DataTable dt = obj.PartTransfer(obj).Tables[0];
int ID = Convert.ToInt32(dt.Rows[0][0]);
SaveItems(ID);
SendSMS(obj.Reference);
}
Panel LoadData()
{
clsPartTransfer obPT = new clsPartTransfer();
clsPTItems obPTI = new clsPTItems();
obPT.Reference = Request.QueryString["RefNo"].ToString();
obPT.Op = 5;
DataTable dtPT = obPT.PartTransfer(obPT).Tables[0];
obPTI.PTID = Convert.ToInt32(dtPT.Rows[0]["ID"]);
obPTI.Op = 2;
DataTable dtPTI = obPTI.PTITems(obPTI).Tables[0];
StringBuilder str = new StringBuilder();
//select a.ID,a.Reference,a.SourceSite,SourceSiteName,SourceSiteAddress,SourceSitePhoneNo,SourceSiteEmail,a.DestinationSite,
//DestSiteName,DestSiteAddress,DestSitePhoneNo,DestSiteEmail,EntryDate,a.VehicleNo,a.DriverName,a.DriverPh,a.Status,CurrStatus
str.Append("<table width='100%' style='font-size:8;'>");
str.Append("<tr><td colspan='8'>");
str.Append("<h4>TK Engineering Consortium Pvt. Limited</h4>");
str.Append("<h5>Date: " + dtPT.Rows[0]["EntryDate"] + "</h5>");
str.Append("</td><td colspan='4'>");
str.Append("<img src='" + MapPath("~/images/logo.jpg") + "' width='150'/>");
str.Append("</tr>");
str.Append("<tr><td colspan='4'>");
str.Append("Source Site:<br><b>" + dtPT.Rows[0]["SourceSiteName"] + "</b><br>");
str.Append("Address: " + dtPT.Rows[0]["SourceSiteAddress"].ToString().Replace("\n", "<br>") + "<br>");
str.Append("Phone No: " + dtPT.Rows[0]["SourceSitePhoneNo"] + "<br>");
str.Append("Email: " + dtPT.Rows[0]["SourceSiteEmail"] + "<br>");
str.Append("Site Incharge: " + dtPT.Rows[0]["SSiteIncharge"] + "<br>Phone No" + dtPT.Rows[0]["SSiteInchargePh"]);
str.Append("</td><td colspan='4'></td><td align='right' colspan='4'><div style='text-align:left;'>");
str.Append("Destination Site:<br><b>" + dtPT.Rows[0]["DestSiteName"] + "</b><br>");
str.Append("Address: " + dtPT.Rows[0]["DestSiteAddress"].ToString().Replace("\n", "<br>") + "<br>");
str.Append("Phone No: " + dtPT.Rows[0]["DestSitePhoneNo"] + "<br>");
str.Append("Email: " + dtPT.Rows[0]["DestSiteEmail"] + "<br>");
str.Append("Site Incharge: " + dtPT.Rows[0]["DSiteIncharge"] + "<br>Phone No" + dtPT.Rows[0]["DSiteInchargePh"]);
str.Append("</div></td></tr>");
str.Append("</table>");
str.Append("<table width='100%' style='font-size:8;' border='1'>");
//PartNo, PartName, MachineName, Quantity, Rate, Total
int i = 0;
str.Append("<tr><td><b>SL</b></td><td colspan='2'><b>Part No</b></td><td colspan='3'><b>Part Name</b></td><td colspan='3'><b>Machine Name</b></td><td><b>Quantity</b></td><td><b>Rate</b></td><td><b>Total</b></td></tr>");
int TQ = 0;
foreach (DataRow dr in dtPTI.Rows)
{
i++;
str.Append("<tr>");
str.Append("<td>" + i + "</td>");
str.Append("<td colspan='2'>" + dr["PartNo"] + "</td>");
str.Append("<td colspan='3'>" + dr["PartName"] + "</td>");
str.Append("<td colspan='3'>" + dr["MachineName"] + "</td>");
str.Append("<td>" + dr["Quantity"] + "</td>");
str.Append("<td>" + dr["Rate"] + "</td>");
str.Append("<td>" + dr["Total"] + "</td>");
str.Append("</tr>");
TQ = TQ + Convert.ToInt32(dr["Quantity"]);
}
str.Append("</table>");
str.Append("<h5>Total Quantity Dispatched: " + TQ.ToString() + "</h5>");
str.Append("<h5>Driver Name: " + dtPT.Rows[0]["DriverName"] + "</h5>");
str.Append("<h5>Driver Phone No: " + dtPT.Rows[0]["DriverPh"] + "</h5>");
str.Append("<h5>Current Status: " + dtPT.Rows[0]["CurrStatus"] + "</h5>");
Label lbl = new Label();
lbl.Text = str.ToString();
Panel pnl = new Panel();
pnl.Controls.Add(lbl);
return(pnl);
}
