Thursday, 27 March 2014

public string Gtrk_UserInformation(BGTrack UserInfo) { string referenceNumber = ""; Ocon = Oconnect.GetConnection(); SqlCommand Ocmd = new SqlCommand("GTRK_CREATETRANSACTIONINFO", Ocon); Ocmd.CommandType = CommandType.StoredProcedure; try { if (Ocmd.Connection.State == ConnectionState.Closed) { Ocmd.Connection.Open(); } Ocmd.Parameters.Clear(); Ocmd.Parameters.AddWithValue("@GTRK_TRUCK_NO", UserInfo.TruckNo); Ocmd.Parameters.AddWithValue("@GTRK_PLANT_CODE", UserInfo.Plantcode); Ocmd.Parameters.AddWithValue("@GTRK_TRUCK_TYPE_CODE", UserInfo.TruckType); Ocmd.Parameters.AddWithValue("@GTRK_TRANSPORTER_CODE", UserInfo.TransType); Ocmd.Parameters.AddWithValue("@GRRK_REMARKS", UserInfo.Remarks); Ocmd.Parameters.AddWithValue("@GTRK_DRIVER_NAME", UserInfo.DriverName); Ocmd.Parameters.AddWithValue("@GTRK_LICENCE_NO", UserInfo.DrivLinceno); Ocmd.Parameters.AddWithValue("@GTRK_MOBILE_NO", UserInfo.DriveMobileno); Ocmd.Parameters.AddWithValue("@GTRK_CREATE_BY", UserInfo.Createby); Ocmd.Parameters.AddWithValue("@FLAG", UserInfo.Flag); Ocmd.Parameters.Add("@referenceNumber", SqlDbType.VarChar, 20).Value = "00000000"; Ocmd.Parameters["@referenceNumber"].Direction = ParameterDirection.Output; Ocmd.CommandTimeout = 0; Ocmd.ExecuteNonQuery(); referenceNumber = Ocmd.Parameters["@referenceNumber"].Value.ToString(); } catch (Exception ex) { referenceNumber = "00000000"; throw ex; } finally { if (Ocmd.Connection.State == ConnectionState.Open) { Ocmd.Connection.Close(); } } return referenceNumber; } using System; using System.Collections; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.Services; using System.Text; using BussineLayer; public partial class frm_Gtrk_Glass_Loading : System.Web.UI.Page { BussineLayer.BGTrack ObBLL = new BussineLayer.BGTrack(); string strApp = string.Empty; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { txttruckType.Attributes.Add("ReadOnly", "ReadOnly"); txtTrnsName.Attributes.Add("ReadOnly", "ReadOnly"); txtTruckno.Attributes.Add("autocomplete", "off"); txtTrnsName.Attributes.Add("autocomplete", "off"); txtDrivername.Attributes.Add("autocomplete", "off"); txtLicence.Attributes.Add("autocomplete", "off"); txtmobile.Attributes.Add("autocomplete", "off"); txtRemarks.Attributes.Add("autocomplete", "off"); } } public string GenerateReqNumber() { try { string GenReqNo; Int64 NextNum; DataTable DtGeneReqNo = new DataTable(); DtGeneReqNo = ObBLL.Get_Gtrk_Generatereqno(); if (DtGeneReqNo.Rows.Count > 0 && DtGeneReqNo.Rows[0]["DOC_NO"].ToString() != "") { GenReqNo = DtGeneReqNo.Rows[0]["DOC_NO"].ToString(); NextNum = Convert.ToInt64(GenReqNo); NextNum = NextNum + 1; GenReqNo = Convert.ToString(NextNum); GenReqNo = GenReqNo.PadLeft(10, '0'); return GenReqNo; } else { GenReqNo = "0000000001"; return GenReqNo; } } catch (Exception ex) { return "Error in Generation Request Numbers"; } } [WebMethod] public static string TrlNo(string TruckNo) { string result = ""; BussineLayer.BGTrack ObBLL = new BussineLayer.BGTrack(); DataTable DtTruck = new DataTable(); ObBLL.TruckType = TruckNo.ToString().Trim(); DtTruck = ObBLL.Get_Gtrk_truck_Type(ObBLL); if (DtTruck.Rows.Count > 0) { for (int i = 1; i <= DtTruck.Rows.Count; i++) { result = result + " "; } } else { result = result + " "; } result = result + "
" + DtTruck.Rows[i - 1]["TRUCKTYPE"].ToString() + "
No Records Found...
"; return result; } [WebMethod] public static string TransName(string Transportname) { string result = ""; BussineLayer.BGTrack ObBLL = new BussineLayer.BGTrack(); DataTable DtTrans = new DataTable(); ObBLL.TransName = Transportname.ToString().Trim(); DtTrans = ObBLL.Get_Transport_Name(ObBLL); if (DtTrans.Rows.Count > 0) { for (int i = 1; i <= DtTrans.Rows.Count; i++) { result = result + " "; } } else { result = result + " "; } result = result + "
" + DtTrans.Rows[i - 1]["TRANSNAME"].ToString() + "
No Records Found...
"; return result; } [WebMethod] public static string TrackNumber(string TrackNo) { string result = ""; BussineLayer.BGTrack objBLL = new BussineLayer.BGTrack(); DataTable DtTruck = new DataTable(); objBLL.TruckNo = TrackNo.ToString().Trim(); DtTruck = objBLL.Get_Gtrack_tracknumber(objBLL); if (DtTruck.Rows.Count > 0) { for (int i = 1; i <= DtTruck.Rows.Count; i++) { result = result + " "; } } else { result = result + " "; } result = result + "
" + DtTruck.Rows[i - 1]["GTRK_TRUCK_NO"].ToString() + " " + DtTruck.Rows[i - 1]["TRACKNO"].ToString() + "
No Records Found...
"; return result; } public void btnSave_Click(object sender, EventArgs e) { string[] Transnames = new string[100]; string[] TrackTypes = new string[100]; TrackTypes = txttruckType.Text.Split('-'); Transnames = txtTrnsName.Text.Split('-'); string DocNo = ""; string TruckTime = DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss"); DataTable DtInsInfor = new DataTable(); ObBLL.TruckNo = txtTruckno.Text.ToString().Trim(); ObBLL.Plantcode = Session["Client"].ToString(); ObBLL.TruckType = TrackTypes[0].ToString().Trim(); ObBLL.TransType = Transnames[0].ToString().Trim(); ObBLL.Remarks = txtRemarks.Text.ToString().Trim(); ObBLL.DriverName = txtDrivername.Text.ToString().Trim(); ObBLL.DrivLinceno = txtLicence.Text.ToString().Trim(); ObBLL.DriveMobileno = txtmobile.Text.ToString().Trim(); ObBLL.Createby = Session["UserName"].ToString(); if (Transnames[0].Length==10 && TrackTypes[0].Length==3) { ObBLL.Flag = "IN"; DocNo = ObBLL.Gtrk_UserInformation(ObBLL); } else { ObBLL.Flag = "OUT"; DocNo = ObBLL.Gtrk_UserInformation(ObBLL); } Resetvalue(); if (DocNo != "0000000000" && DocNo.Length != 0) { hdnDocNo.Value = DocNo; hdnDate.Value = TruckTime; ScriptManager.RegisterStartupScript(UPDGlass, this.GetType(), "Click", "SuccessMessage();", true); } else { ScriptManager.RegisterStartupScript(btnSave, btnSave.GetType(), "Failer", "javascript:alert('Wrong user information');", true); } } private void Resetvalue() { txtTruckno.Text = ""; txttruckType.Text = ""; txtTrnsName.Text = ""; txtDrivername.Text = ""; txtLicence.Text = ""; txtmobile.Text = ""; txtRemarks.Text = ""; } } function SuccessMessage(){ if (!alert("Document Successfully Saved.(Document No:" + $(".hdnDocNo").val() +")\n\n"+ "Truck in Entry-Date & Time :" + $(".hdnDate").val() +"")){ var url="PrintDocumentNo.aspx?&DocNo=" + $(".hdnDocNo").val() + ""; window.open(url,'_blank','height=850,width=670,status=yes,toolbar=no,menubar=no,location=no,scrollbars=no,resizable=no,titlebar=no' ); } }

No comments:

Post a Comment