protected void Btndelete_Click(object sender, EventArgs e) { if (con.State == ConnectionState.Closed) { con.Open(); } int count = 0; string ZoneCode = ddlzonename.SelectedValue; foreach (GridViewRow row in GridView1.Rows) { CheckBox chk = null; chk = (CheckBox)row.FindControl("chkDelete"); if (chk.Checked == true) { //string godown = chk.Text.Trim().ToString(); string mmzonecode = row.Cells[1].Text; string mzone = row.Cells[2].Text; string tenderrate = row.Cells[3].Text; string mfinancialyear = row.Cells[4].Text; string delLogqry = "Insert into tblZoneMasterNew_Log select * from tblZoneMasterNew where ZoneCode='" + mmzonecode + "'and Tender_Rate='" + tenderrate + "'"; SqlCommand delcmd = new SqlCommand(delLogqry, con); int log = delcmd.ExecuteNonQuery(); string query = "delete from tblZoneMasterNew where ZoneCode='" + mmzonecode + "'and Tender_Rate='" + tenderrate + "'"; SqlCommand cmd = new SqlCommand(query, con); int req = cmd.ExecuteNonQuery(); count = count + 1; } fillgirdforTenderRate(); if (count == 0) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please click on check box before delete'); </script> "); } else { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Deleted Sucessfully'); </script> "); } } if (con.State == ConnectionState.Open) { con.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["issue_id"] != null) { version = Session["hindi"].ToString(); distid = Session["dist_id"].ToString(); issueid = Session["issue_id"].ToString(); ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); txtcapacty.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtcapacty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtcapacty.Attributes.Add("onchange", "return chksqltxt(this)"); txtgname.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtgname.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtgname.Attributes.Add("onchange", "return chksqltxt(this)"); txtcapacty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtgname.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(txtcapacty.Text); ctrllist.Add(txtgname.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } if (Page.IsPostBack == false) { Fillgrid(); if (version == "H") { lblGodownNo.Text = Resources.LocalizedText.lblGodownNo; lblMaxCap.Text = Resources.LocalizedText.lblMaxCap; lblGodownMaster.Text = Resources.LocalizedText.lblGodownMaster; btnaddnew.Text = Resources.LocalizedText.btnaddnew; btnclose.Text = Resources.LocalizedText.btnclose; btnsubmit.Text = Resources.LocalizedText.btnsubmit; btnupdate.Text = Resources.LocalizedText.btnupdate; } } } else { Response.Redirect("~/MainLogin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["dist_id"] != null) { distid = Session["dist_id"].ToString(); //txtrackno.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); //txtrackno.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); //txtrackno.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); //txtrackno.Attributes.Add("onchange", "return chksqltxt(this)"); DaintyDate3.Attributes.Add("onkeypress", "return CheckCalDate(this)"); DaintyDate3.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); DaintyDate3.Attributes.Add("onchange", "return chksqltxt(this)"); //txtrackno.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); chk = new chksql(); ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); ArrayList ctrllist = new ArrayList(); //ctrllist.Add(txtrackno.Text); ctrllist.Add(DaintyDate3.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } if (!IsPostBack) { DaintyDate3.Text = DateTime.Today.Date.ToString("dd-MM-yyyy"); GetName(); fillgrid(); GetCommodity(); GetDist(); GetRailHead(); getstates(); GetDispatchType(); get_scheme(); //GetRackAllert(); } } else { Response.Redirect("~/MainLogin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["issue_id"] != null) { sid = Session["issue_id"].ToString(); //string dbname = "Warehouse"; ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); //mobj = new MoveChallan(ComObj); //string qry = "SELECT GatePass_idFROM dbo.tbl_Receipt_Details where Depot_Id='"+ sid +"'"; //DataSet ds = mobj.selectAny(qry); // GridView1.DataSource = ds.Tables[0]; // GridView1.DataBind(); DaintyDate1.Attributes.Add("onkeypress", "return CheckCalDate(this)"); DaintyDate1.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); DaintyDate1.Attributes.Add("onchange", "return chksqltxt(this)"); DaintyDate2.Attributes.Add("onkeypress", "return CheckCalDate(this)"); DaintyDate2.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); DaintyDate2.Attributes.Add("onchange", "return chksqltxt(this)"); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(DaintyDate1.Text); ctrllist.Add(DaintyDate2.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } if (!IsPostBack) { //fillgrid(); GetSource(); } } else { Response.Redirect("~/MainLogin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["st_id"] == null) { Response.Redirect("~/MainLogin.aspx"); } } catch (Exception ex) { Response.Write(ex.Message); } distid = Session["st_id"].ToString(); if (Page.IsPostBack == false) { ddd_allot_year.Items.Add((int.Parse(DateTime.Today.Year.ToString()) - 1).ToString()); ddd_allot_year.Items.Add(DateTime.Today.Year.ToString()); ddd_allot_year.Items.Add((int.Parse(DateTime.Today.Year.ToString()) + 1).ToString()); ddd_allot_year.SelectedIndex = 1; //ddl_allot_month.SelectedIndex = DateTime.Today.Month - 1; get_comm(); get_scheme(); getDistrict(); } TextBox1.Attributes.Add("onkeypress", "return CheckIsNumeric(this);"); TextBox1.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); TextBox1.Attributes.Add("onchange", "return chksqltxt(this)"); TextBox1.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(TextBox1.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["st_id"] != null) { stid = Session["st_id"].ToString(); ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); txtplace.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtplace.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtplace.Attributes.Add("onchange", "return chksqltxt(this)"); txtplacename.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtplacename.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtplacename.Attributes.Add("onchange", "return chksqltxt(this)"); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(txtplace.Text); ctrllist.Add(txtplacename.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } if (Page.IsPostBack == false) { // fillgrid(); GetState(); } } else { Response.Redirect("~/MainLogin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["issue_id"] != null) { sid = Session["issue_id"].ToString(); distid = Session["dist_id"].ToString(); version = Session["hindi"].ToString(); ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); txtrecdbaf.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtrecdqty.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtdisbag.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtdisqty.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtrecdbaf.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtrecdbaf.Attributes.Add("onchange", "return chksqltxt(this)"); txtrecdqty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtrecdqty.Attributes.Add("onchange", "return chksqltxt(this)"); txtdisbag.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtdisbag.Attributes.Add("onchange", "return chksqltxt(this)"); txtdisqty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtdisqty.Attributes.Add("onchange", "return chksqltxt(this)"); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(txtrecdbaf.Text); ctrllist.Add(txtrecdqty.Text); ctrllist.Add(txtdisbag.Text); ctrllist.Add(txtdisqty.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } txtrackno.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtchallan.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtrecdbaf.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtrecdqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtdisbag.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtdisqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); DaintyDate3.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtdisbag.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtdisqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtchalldt.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txttruckno.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtmaxcap.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtcurntcap.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtavalcap.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); if (!IsPostBack) { DaintyDate3.Text = DateTime.Today.Date.ToString("dd/MM/yyyy"); GetRailHead(); GetChallan(); GetRack(); GetTransport(); GetGodown(); GetCommodity(); GetScheme(); if (version == "H") { lblCommodity.Text = Resources.LocalizedText.lblCommodity; lblGodownNo.Text = Resources.LocalizedText.lblGodownNo; lblScheme.Text = Resources.LocalizedText.lblScheme; lblGodownNo.Text = Resources.LocalizedText.lblGodownNo; lbltotalReceivedBags.Text = Resources.LocalizedText.lbltotalReceivedBags; lblTotalQuantityReceived.Text = Resources.LocalizedText.lblTotalQuantityReceived; lblMaxCap.Text = Resources.LocalizedText.lblCapacity; lblChallanNumber.Text = Resources.LocalizedText.lblChallanNumber; lblTrans.Text = Resources.LocalizedText.lblTrans; lblTruckNumber.Text = Resources.LocalizedText.lblTruckNumber; lblrailhead.Text = Resources.LocalizedText.lblrailhead; lblchallandate.Text = Resources.LocalizedText.lblchallandate; lblCurStackCap.Text = Resources.LocalizedText.lblCurStackCap; lblAvailable.Text = Resources.LocalizedText.lblAvailable; lblIssuedBags.Text = Resources.LocalizedText.lblIssuedBags; lblDispatchQty.Text = Resources.LocalizedText.lblDispatchQty; btnclose.Text = Resources.LocalizedText.btnclose; btnsubmit.Text = Resources.LocalizedText.btnsubmit; lbldepositstock.Text = Resources.LocalizedText.lbldepositstock; lblrackno1.Text = Resources.LocalizedText.lblrackno1; lblrackno.Text = Resources.LocalizedText.lblrackno; lblChallanNumber1.Text = Resources.LocalizedText.lblChallanNumber1; } } } else { Response.Redirect("~/MainLogin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["st_id"] != null) { stid = Session["st_id"].ToString(); ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); txtrrqty.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtwcount.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtrrqty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtrrqty.Attributes.Add("onchange", "return chksqltxt(this)"); txtwcount.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtwcount.Attributes.Add("onchange", "return chksqltxt(this)"); txtrrno.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtrrno.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtrrno.Attributes.Add("onchange", "return chksqltxt(this)"); txtrrqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtwcount.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtrrno.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(txtrrqty.Text); ctrllist.Add(txtwcount.Text); ctrllist.Add(txtrrno.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } if (!IsPostBack) { GetSourceDist(); //GetRack(); dt.Columns.Add("district_code"); dt.Columns.Add("Rack_No"); dt.Columns.Add("RR_No"); dt.Columns.Add("RR_qty"); dt.Columns.Add("Wagon_Count"); Session["dt"] = dt; } } else { Response.Redirect("~/MainLogin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["dist_id"] != null) { distid = Session["dist_id"].ToString(); //txttorderno.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)"); txtroqty.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this),checksqlkey_gen(event,this)"); txtsendqty.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)"); txtcumlqty.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)"); txtbalqty.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)"); txttorderno.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txttorderno.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txttorderno.Attributes.Add("onchange", "return chksqltxt_psw(this)"); //txtsendqty.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtsendqty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtsendqty.Attributes.Add("onchange", "return chksqltxt_psw(this)"); txttorderno.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtroqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtsendqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtcumlqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtbalqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtcommodity.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtscheme.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtrodate.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtliftqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(txttorderno.Text); ctrllist.Add(txtsendqty.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } ComObj = new Common(ConfigurationSettings.AppSettings["ConnectionString"].ToString()); if (!IsPostBack) { DaintyDate1.Text = DateTime.Today.Date.ToString("dd-MM-yyyy"); //GetTransportAll(); GetTransport(); GetDistance(); //GetRO(); GetName(); GetDist(); GetFCIdist(); dt.Columns.Add("RO_No"); dt.Columns.Add("TO_No"); dt.Columns.Add("Quantity"); dt.Columns.Add("DisName"); dt.Columns.Add("IssueName"); dt.Columns.Add("District"); dt.Columns.Add("IssueCenter"); ddldistrict.SelectedValue = distid; GetDCName(); Session["dt"] = dt; ddd_allot_year.Items.Add((int.Parse(DateTime.Today.Year.ToString()) - 1).ToString()); ddd_allot_year.Items.Add(DateTime.Today.Year.ToString()); ddd_allot_year.SelectedIndex = 1; ddl_allot_month.SelectedIndex = DateTime.Today.Month - 1; GetRO(); } } else { Response.Redirect("~/MainLogin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); if (Session["dist_id"] != null) { distid = Session["dist_id"].ToString(); txtmsprate.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtincidental.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtbonus.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtgunnycap.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtmsprate.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtmsprate.Attributes.Add("onchange", "return chksqltxt(this)"); txtincidental.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtincidental.Attributes.Add("onchange", "return chksqltxt(this)"); txtbonus.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtbonus.Attributes.Add("onchange", "return chksqltxt(this)"); txtgunnycap.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtgunnycap.Attributes.Add("onchange", "return chksqltxt(this)"); effective_from.Attributes.Add("onkeypress", "return CheckCalDate(this)"); effective_from.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); effective_from.Attributes.Add("onchange", "return chksqltxt(this)"); txtmsprate.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtincidental.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtbonus.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtgunnycap.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(txtmsprate.Text); ctrllist.Add(txtincidental.Text); ctrllist.Add(txtbonus.Text); ctrllist.Add(txtgunnycap.Text); ctrllist.Add(effective_from.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } if (!IsPostBack) { effective_from.Text = DateTime.Today.Date.ToString("dd-MM-yyyy"); GetScheme(); GetCommodity(); GetSeason(); GetSource(); GetSchemeFCI(); int myear = int.Parse(DateTime.Now.Year.ToString()); ddlcropyear.Items.Add("Crop Year Not Indicated"); ddlcropyear.Items.Add(DateTime.Now.Year + "-" + (int.Parse(DateTime.Now.Year.ToString()) + 1).ToString()); ddlcropyear.Items.Add(DateTime.Now.Year - 1 + "-" + DateTime.Now.Year); ddlcropyear.Items.Add((int.Parse(DateTime.Now.Year.ToString()) - 2).ToString() + "-" + (int.Parse(DateTime.Now.Year.ToString()) - 1).ToString()); ddlcropyear.Items.Add((int.Parse(DateTime.Now.Year.ToString()) - 3).ToString() + "-" + (int.Parse(DateTime.Now.Year.ToString()) - 2).ToString()); ddlcropyear.Items.Add((int.Parse(DateTime.Now.Year.ToString()) - 4).ToString() + "-" + (int.Parse(DateTime.Now.Year.ToString()) - 3).ToString()); ddlcropyear.Items.Add((int.Parse(DateTime.Now.Year.ToString()) - 5).ToString() + "-" + (int.Parse(DateTime.Now.Year.ToString()) - 4).ToString()); ddlcropyear.Items.Add((int.Parse(DateTime.Now.Year.ToString()) - 6).ToString() + "-" + (int.Parse(DateTime.Now.Year.ToString()) - 5).ToString()); ddlcropyear.Items.Add((int.Parse(DateTime.Now.Year.ToString()) - 7).ToString() + "-" + (int.Parse(DateTime.Now.Year.ToString()) - 6).ToString()); ddlcropyear.Items.Add((int.Parse(DateTime.Now.Year.ToString()) - 8).ToString() + "-" + (int.Parse(DateTime.Now.Year.ToString()) - 7).ToString()); ddlcropyear.Items.Add((int.Parse(DateTime.Now.Year.ToString()) - 9).ToString() + "-" + (int.Parse(DateTime.Now.Year.ToString()) - 8).ToString()); ddlcropyear.Items.Add((int.Parse(DateTime.Now.Year.ToString()) - 10).ToString() + "-" + (int.Parse(DateTime.Now.Year.ToString()) - 9).ToString()); } } else { Response.Redirect("~/MainLogin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["dist_id"] == null) { Response.Redirect("~/Session_Expire_Dist.aspx"); } } catch (Exception ex) { Response.Write(ex.Message); } distid = Session["dist_id"].ToString(); sid = Session["issue_id"].ToString(); if (!IsPostBack) { tx_dd_date.Text = DateTime.Today.Date.Date.ToString("dd/MM/yyyy"); ddd_allot_year.Items.Add((int.Parse(DateTime.Today.Year.ToString()) - 1).ToString()); ddd_allot_year.Items.Add(DateTime.Today.Year.ToString()); ddd_allot_year.Items.Add((int.Parse(DateTime.Today.Year.ToString()) + 1).ToString()); ddd_allot_year.SelectedIndex = 1; GetBank(); Get_LinkCooperative(); get_fps_Cash(); ddl_allot_month.SelectedIndex = DateTime.Today.Month - 1; } tx_dd_date.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); tx_dd_amount.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); // hlinkpdo.Attributes.Add("onclick", "window.open('Print_DoorStep_DO.aspx',null,'left=400, top=100, height=900, width= 700, status=n o, resizable= no, scrollbars= no, toolbar= no,location= no, menubar= no');"); chk = new chksql(); ArrayList ctrllist = new ArrayList(); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["dist_id"] != null) { distid = Session["dist_id"].ToString(); Ro_No = Session["RO_No"].ToString(); challan = Session["Challan"].ToString(); TO_No = Session["TO_No"].ToString(); TransID = Session["Trans"].ToString(); IC_No = Session["TIC"].ToString(); txtqtysend.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtnobags.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtqtysend.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtqtysend.Attributes.Add("onchange", "return chksqltxt(this)"); //txtsendqty.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtnobags.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtnobags.Attributes.Add("onchange", "return chksqltxt(this)"); txtchallan.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtchallan.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtchallan.Attributes.Add("onchange", "return chksqltxt(this)"); txtvehno.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtvehno.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtvehno.Attributes.Add("onchange", "return chksqltxt(this)"); txtmoisture.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtmoisture.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtmoisture.Attributes.Add("onchange", "return chksqltxt(this)"); challandate.Attributes.Add("onkeypress", "return CheckCalDate(this)"); challandate.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); challandate.Attributes.Add("onchange", "return chksqltxt(this)"); //string dbname = "Warehouse"; ComObj = new Common(ConfigurationSettings.AppSettings["ConnectionString"].ToString()); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(txtqtysend.Text); ctrllist.Add(txtnobags.Text); ctrllist.Add(txtchallan.Text); ctrllist.Add(txtvehno.Text); ctrllist.Add(challandate.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } if (Session["dc_id"] != null) { //Session.Abandon(); //Session.RemoveAll(); } if (!IsPostBack) { //GetRO(); Transport(); GetGunny(); GetDist(); GetCategory(); GetData(); GetFCIdist(); } } else { Response.Redirect("~/MainLogin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["dist_id"] == null) { Response.Redirect("~/Session_Expire_Dist.aspx"); } } catch (Exception ex) { Response.Write(ex.Message); } ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); distid = Session["dist_id"].ToString(); version = Session["hindi"].ToString(); //sid = Session["issue_id"].ToString(); save.Enabled = true; chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(tx_do_no.Text); ctrllist.Add(TextBox1.Text); ctrllist.Add(tx_qty.Text); ctrllist.Add(tx_dd_no.Text); ctrllist.Add(tx_dd_amount.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } if (Page.IsPostBack == false) { tx_dd_date.Text = DateTime.Today.Date.ToString("dd-MM-yyyy"); tx_do_validity.Text = DateTime.Today.Date.ToString("dd-MM-yyyy"); tx_do_date.Text = DateTime.Today.Date.ToString("dd-MM-yyyy"); ddd_allot_year.Items.Add((int.Parse(DateTime.Today.Year.ToString()) - 1).ToString()); ddd_allot_year.Items.Add(DateTime.Today.Year.ToString()); ddd_allot_year.Items.Add((int.Parse(DateTime.Today.Year.ToString()) + 1).ToString()); ddd_allot_year.SelectedIndex = 1; get_comm(); get_scheme(); get_bankname(); //GetRO(); ddl_allot_month.SelectedIndex = DateTime.Today.Month - 1; if (version == "H") { lbl_lead.Text = Resources.LocalizedText.lbl_lead; lblallotyear.Text = Resources.LocalizedText.lblallotyear; lblallotmonth.Text = Resources.LocalizedText.lblallotmonth; lblCommodity.Text = Resources.LocalizedText.lblCommodity; lblScheme.Text = Resources.LocalizedText.lblScheme; lblratetype.Text = Resources.LocalizedText.lblratetype; lbltoissue.Text = Resources.LocalizedText.lbltoissue; lbldono.Text = Resources.LocalizedText.lbldono; lbldodate.Text = Resources.LocalizedText.lbldodate; lbldovalidity.Text = Resources.LocalizedText.lbldovalidity; lbl_balqty.Text = Resources.LocalizedText.lbl_balqty; lblQuantity.Text = Resources.LocalizedText.lblQuantity; lblqty.Text = Resources.LocalizedText.lblqty; lblRateQuintal.Text = Resources.LocalizedText.lblRateQuintal; lblPaymentMode.Text = Resources.LocalizedText.lblPaymentMode; lblddchekno.Text = Resources.LocalizedText.lblddchekno; lblddchekdate.Text = Resources.LocalizedText.lblddchekdate; lblBankName.Text = Resources.LocalizedText.lblBankName; lblamount.Text = Resources.LocalizedText.lblamount; lbltotamt.Text = Resources.LocalizedText.lbltotamt; btn_new.Text = Resources.LocalizedText.btn_new; save.Text = Resources.LocalizedText.btnsave; btnClose.Text = Resources.LocalizedText.btnclose; } } //tx_do_no.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); //tx_do_validity.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); //tx_permit_validity.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); tx_qty.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); tx_dd_amount.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); tx_rate_qt.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); tx_dd_amount.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); tx_do_no.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); tx_do_no.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_do_no.Attributes.Add("onchange", "return chksqltxt(this)"); TextBox1.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); TextBox1.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); TextBox1.Attributes.Add("onchange", "return chksqltxt(this)"); tx_qty.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); tx_qty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_qty.Attributes.Add("onchange", "return chksqltxt(this)"); tx_dd_no.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); tx_dd_no.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_dd_no.Attributes.Add("onchange", "return chksqltxt(this)"); tx_dd_amount.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); tx_dd_amount.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_dd_amount.Attributes.Add("onchange", "return chksqltxt(this)"); //hlinkpdo.Attributes.Add("onclick", "window.open('print_DeleveryOrder.aspx',null,'left=300, top=90, height=800, width= 650, status=n o, resizable= no, scrollbars= no, toolbar= no,location= no, menubar= no');"); txtcomdty_bal.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_do_no.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); //tx_do_validity.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_qty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_rate_qt.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_tot_amt.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_dd_no.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_dd_amount.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_do_date.Attributes.Add("onkeypress", "return CheckCalDate(this)"); tx_do_validity.Attributes.Add("onkeypress", "return CheckCalDate(this)"); tx_dd_date.Attributes.Add("onkeypress", "return CheckCalDate(this)"); tx_do_date.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_do_date.Attributes.Add("onchange", "return chksqltxt(this)"); tx_do_validity.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_do_validity.Attributes.Add("onchange", "return chksqltxt(this)"); tx_dd_date.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_dd_date.Attributes.Add("onchange", "return chksqltxt(this)"); }
protected void Page_Load(object sender, EventArgs e) { if (Session["dist_id"] != null) { distid = Session["dist_id"].ToString(); version = Session["hindi"].ToString(); txtroqty.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)"); txtrate.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)"); txtamount.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)"); txtchqamt.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)"); txtrodate.Attributes.Add("onkeypress", "return CheckCalDate(this)"); txtrovalidity.Attributes.Add("onkeypress", "return CheckCalDate(this)"); txtddate.Attributes.Add("onkeypress", "return CheckCalDate(this)"); txtroqty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtroqty.Attributes.Add("onchange", "return chksqltxt(this),calcAmount();"); txtrodate.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtrodate.Attributes.Add("onchange", "return chksqltxt(this)"); txtrovalidity.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtrovalidity.Attributes.Add("onchange", "return chksqltxt(this)"); txtddate.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtddate.Attributes.Add("onchange", "return chksqltxt(this)"); txtrono.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtrono.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtrono.Attributes.Add("onchange", "return chksqltxt(this)"); txtrate.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtrate.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtrate.Attributes.Add("onchange", "return chksqltxt(this)"); txtckeckno.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtckeckno.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtckeckno.Attributes.Add("onchange", "return chksqltxt(this)"); txtchqamt.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtchqamt.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtchqamt.Attributes.Add("onchange", "return chksqltxt(this)"); txtchqamt.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)"); txtremark.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtremark.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtremark.Attributes.Add("onchange", "return chksqltxt(this)"); txtrono.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtroqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtrate.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtamount.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtckeckno.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtchqamt.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtalotqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); //string dbname = "Warehouse"; ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); //if (Session["dc_id"] != null) //{ //} distobj = new DistributionCenters(ComObj); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(txtrono.Text); ctrllist.Add(txtrate.Text); ctrllist.Add(txtckeckno.Text); ctrllist.Add(txtchqamt.Text); ctrllist.Add(txtremark.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } if (!IsPostBack) { txtddate.Text = DateTime.Today.Date.ToString("dd-MM-yyyy"); txtrovalidity.Text = DateTime.Today.Date.ToString("dd-MM-yyyy"); txtrodate.Text = DateTime.Today.Date.ToString("dd-MM-yyyy"); GetDist(); GetCommodity(); GetScheme(); GetName(); GetBank(); ddlallot_year.Items.Add((int.Parse(DateTime.Today.Year.ToString()) - 1).ToString()); ddlallot_year.Items.Add(DateTime.Today.Year.ToString()); ddlallot_year.SelectedIndex = 1; ddlalotmm.SelectedIndex = DateTime.Today.Month - 1; if (version == "H") { lblCommodity.Text = Resources.LocalizedText.lblCommodity; lblScheme.Text = Resources.LocalizedText.lblScheme; lblQuantity.Text = Resources.LocalizedText.lblQuantity; lblReleaseOrder.Text = Resources.LocalizedText.lblDetailsofRO; btnsave.Text = Resources.LocalizedText.btnsave; btnclose.Text = Resources.LocalizedText.btnclose; lblmonth.Text = Resources.LocalizedText.lblmonth; lblyear.Text = Resources.LocalizedText.lblyear; lblRateQuintal.Text = Resources.LocalizedText.lblRateQuintal; lblPaymentMode.Text = Resources.LocalizedText.lblPaymentMode; lblddchekno.Text = Resources.LocalizedText.lblddchekno; lblddchekdate.Text = Resources.LocalizedText.lblddchekdate; lblBankName.Text = Resources.LocalizedText.lblBankName; lblamount.Text = Resources.LocalizedText.lblamount; lblamountdd.Text = Resources.LocalizedText.lblamountdd; lblforDist.Text = Resources.LocalizedText.lblforDist; lblReleaseOrderDate.Text = Resources.LocalizedText.lblReleaseOrderDate; lbldovalidity.Text = Resources.LocalizedText.lbldovalidity; lblRemark.Text = Resources.LocalizedText.lblRemark; lblReleaseOrderDate.Text = Resources.LocalizedText.lblReleaseOrderDate; lblqty.Text = Resources.LocalizedText.lblqty; lbl_balqty.Text = Resources.LocalizedText.lbl_balqty; } } } else { Response.Redirect("~/MainLogin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["st_id"] != null) { txtqty.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)"); txtqty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtqty.Attributes.Add("onchange", "return chksqltxt(this)"); txtorderno.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)"); txtdate.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtdate.Attributes.Add("onchange", "return chksqltxt(this)"); txtqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtrate.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); distobj = new DistributionCenters(ComObj); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(txtqty.Text); ctrllist.Add(txtorderno.Text); ctrllist.Add(txtdate.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } if (!IsPostBack) { GetDCName(); //GetZone(); //GetDist(); Getsupplier(); fillgrid(); } } else { Response.Redirect("~/MainLogin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["issue_id"] != null) { distid = Session["dist_id"].ToString(); issueid = Session["issue_id"].ToString(); version = Session["hindi"].ToString(); ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); txtqty.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtbags.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtqty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtqty.Attributes.Add("onchange", "return chksqltxt(this)"); txtbags.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtbags.Attributes.Add("onchange", "return chksqltxt(this)"); txtqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtspos.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtbags.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(txtqty.Text); ctrllist.Add(txtbags.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } if (!IsPostBack) { ddlopeningmonth.SelectedIndex = DateTime.Today.Month - 1; GetScheme(); GetCommodity(); GetCategory(); //GetDCName(); //GetPosition(); GetSource(); GetGodown(); fillGrid(); if (version == "H") { lblSorcePfArrival.Text = Resources.LocalizedText.lblSorcePfArrival; lblCommodity.Text = Resources.LocalizedText.lblCommodity; lblGodown.Text = Resources.LocalizedText.lblGodown; lblScheme.Text = Resources.LocalizedText.lblScheme; lblQuantity.Text = Resources.LocalizedText.lblQuantity; lblBagNumber.Text = Resources.LocalizedText.lblBagNumber; lblopendate.Text = Resources.LocalizedText.lblopendate; lblKgs.Text = Resources.LocalizedText.lblKgs; lblopendetails.Text = Resources.LocalizedText.lblopendetails; btnsubmit.Text = Resources.LocalizedText.btnsubmit; btnclose.Text = Resources.LocalizedText.btnclose; } } } else { Response.Redirect("~/MainLogin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { try { if (Session["dist_id"] == null) { Response.Redirect("~/Session_Expire_Dist.aspx"); } } catch (Exception ex) { Response.Write(ex.Message); } ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); distid = Session["dist_id"].ToString(); sid = Session["issue_id"].ToString(); save.Enabled = true; if (Page.IsPostBack == false) { Session["issubmited"] = "No"; tx_dd_date.Text = DateTime.Today.Date.ToString("dd/MM/yyyy"); tx_do_date.Text = DateTime.Today.Date.ToString("dd/MM/yyyy"); tx_do_validity.Text = DateTime.Today.Date.ToString("dd/MM/yyyy"); tx_permit_date.Text = DateTime.Today.Date.ToString("dd/MM/yyyy"); tx_dd_date.Text = DateTime.Today.Date.ToString("dd/MM/yyyy"); ddd_allot_year.Items.Add((int.Parse(DateTime.Today.Year.ToString()) - 1).ToString()); ddd_allot_year.Items.Add(DateTime.Today.Year.ToString()); ddd_allot_year.Items.Add((int.Parse(DateTime.Today.Year.ToString()) + 1).ToString()); ddd_allot_year.SelectedIndex = 1; get_comm(); get_lead(); get_scheme(); get_bankname(); ddl_allot_month.SelectedIndex = DateTime.Today.Month - 1; } //tx_do_no.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); //tx_permit_no.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); //tx_do_validity.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); //tx_permit_validity.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); tx_qty.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); tx_dd_amount.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); tx_rate_qt.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this);"); tx_do_date.Attributes.Add("onkeypress", "return CheckCalDate(this)"); tx_do_date.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_do_date.Attributes.Add("onchange", "return chksqltxt(this)"); tx_do_validity.Attributes.Add("onkeypress", "return CheckCalDate(this)"); tx_do_validity.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_do_validity.Attributes.Add("onchange", "return chksqltxt(this)"); tx_dd_date.Attributes.Add("onkeypress", "return CheckCalDate(this)"); tx_dd_date.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_dd_date.Attributes.Add("onchange", "return chksqltxt(this)"); tx_qty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_qty.Attributes.Add("onchange", "return chksqltxt(this)"); tx_dd_amount.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_dd_amount.Attributes.Add("onchange", "return chksqltxt(this)"); tx_rate_qt.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_rate_qt.Attributes.Add("onchange", "return chksqltxt(this)"); tx_permit_no.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); tx_permit_no.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_permit_no.Attributes.Add("onchange", "return chksqltxt(this)"); //tx_do_no.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); //tx_do_no.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); //tx_do_no.Attributes.Add("onchange", "return chksqltxt(this)"); tx_dd_no.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); tx_dd_no.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_dd_no.Attributes.Add("onchange", "return chksqltxt(this)"); tx_dd_amount.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); tx_dd_amount.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tx_dd_amount.Attributes.Add("onchange", "return chksqltxt(this)"); hlinkpdo.Attributes.Add("onclick", "window.open('print_DeleveryOrder.aspx',null,'left=300, top=90, height=800, width= 650, status=n o, resizable= no, scrollbars= no, toolbar= no,location= no, menubar= no');"); tx_permit_no.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); //tx_do_no.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); //tx_do_validity.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_qty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_rate_qt.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_tot_amt.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_allot_qty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_dd_no.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_dd_amount.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_already_iqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_balQty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); tx_bal_ic.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtcomdty_bal.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); lbl_alloc.Visible = false; lbl_issue.Visible = false; lbl_curbal.Visible = false; //lbl_stock.Visible = false; lbl_qtalloc.Visible = false; lbl_qtcur.Visible = false; lbl_qtissue.Visible = false; //lbl_qtstk.Visible = false; tx_allot_qty.Visible = false; tx_already_iqty.Visible = false; //tx_bal_ic.Visible = false; tx_balQty.Visible = false; chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(tx_permit_no.Text); //ctrllist.Add(tx_do_no.Text); ctrllist.Add(tx_do_validity.Text); ctrllist.Add(tx_qty.Text); ctrllist.Add(tx_rate_qt.Text); ctrllist.Add(tx_do_date.Text); ctrllist.Add(tx_dd_date.Text); ctrllist.Add(tx_do_date.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } }
protected void Page_Load(object sender, EventArgs e) { Label3.Text = ""; if (Session["st_id"] != null) { ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); txtsupplier.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtsupplier.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtsupplier.Attributes.Add("onchange", "return chksqltxt(this)"); txttenderrate.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)"); txttenderrate.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txttenderrate.Attributes.Add("onchange", "return chksqltxt(this)"); txtmobileno.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)"); txtmobileno.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtmobileno.Attributes.Add("onchange", "return chksqltxt(this)"); txtaddress.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txtaddress.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtaddress.Attributes.Add("onchange", "return chksqltxt(this)"); txtpincode.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)"); txtpincode.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtpincode.Attributes.Add("onchange", "return chksqltxt(this)"); txttenderrate.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtbruitno.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(txtaddress.Text); ctrllist.Add(txtmobileno.Text); ctrllist.Add(txtsupplier.Text); ctrllist.Add(txttenderrate.Text); ctrllist.Add(txtpincode.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } if (!IsPostBack) { //GetDist(); Getzone(); Getsupplier(); fillgird(); fillgirdforselectedZone(); fillgirdforTenderRate(); GetState(); } } else { Response.Redirect("~/MainLogin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["dist_id"] != null) { sid = Session["dist_id"].ToString(); //string dbname = "Warehouse"; txtqty.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtmobile.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtrate.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtqty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtqty.Attributes.Add("onchange", "return chksqltxt(this)"); txtmobile.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtmobile.Attributes.Add("onchange", "return chksqltxt(this)"); txtrate.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtrate.Attributes.Add("onchange", "return chksqltxt(this)"); txttname.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txttname.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txttname.Attributes.Add("onchange", "return chksqltxt(this)"); txttadd.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)"); txttadd.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txttadd.Attributes.Add("onchange", "return chksqltxt(this)"); DaintyDate1.Attributes.Add("onkeypress", "return CheckCalDate(this)"); DaintyDate1.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); DaintyDate1.Attributes.Add("onchange", "return chksqltxt(this)"); txtmobile.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtrate.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); distobj = new DistributionCenters(ComObj); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(txtqty.Text); ctrllist.Add(txtmobile.Text); ctrllist.Add(txtrate.Text); ctrllist.Add(txttname.Text); ctrllist.Add(txttadd.Text); ctrllist.Add(DaintyDate1.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } if (Page.IsPostBack == false) { Fillgrid(); GetTransportType(); GetDistance(); get_block(); lbl_block.Visible = false; ddlBlock.Visible = false; } } else { Response.Redirect("~/MainLogin.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["dist_id"] != null) { distid = Session["dist_id"].ToString(); txtdisbags.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtdisqty.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtrecdqty.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtrackqty.Attributes.Add("onkeypress", "return CheckIsNumeric(this)"); txtdisbags.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtdisbags.Attributes.Add("onchange", "return chksqltxt(this)"); txtdisqty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtdisqty.Attributes.Add("onchange", "return chksqltxt(this)"); txtrecdqty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtrecdqty.Attributes.Add("onchange", "return chksqltxt(this)"); txtrackqty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtrackqty.Attributes.Add("onchange", "return chksqltxt(this)"); txtrackno.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txtrackno.Attributes.Add("onchange", "return chksqltxt(this)"); tctchallanno.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); tctchallanno.Attributes.Add("onchange", "return chksqltxt(this)"); txttruckno.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); txttruckno.Attributes.Add("onchange", "return chksqltxt(this)"); DaintyDate2.Attributes.Add("onkeypress", "return CheckCalDate(this)"); DaintyDate2.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); DaintyDate2.Attributes.Add("onchange", "return chksqltxt(this)"); DaintyDate1.Attributes.Add("onkeypress", "return CheckCalDate(this)"); DaintyDate1.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); DaintyDate1.Attributes.Add("onchange", "return chksqltxt(this)"); DaintyDate3.Attributes.Add("onkeypress", "return CheckCalDate(this)"); DaintyDate3.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);"); DaintyDate3.Attributes.Add("onchange", "return chksqltxt(this)"); txtrecdqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtdisbags.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtdisqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txttruckno.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); txtrackqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString(); chk = new chksql(); ArrayList ctrllist = new ArrayList(); ctrllist.Add(txtrecdqty.Text); ctrllist.Add(txtdisbags.Text); ctrllist.Add(txtdisqty.Text); ctrllist.Add(txttruckno.Text); ctrllist.Add(txtrackqty.Text); ctrllist.Add(txtrackno.Text); ctrllist.Add(tctchallanno.Text); ctrllist.Add(txttruckno.Text); ctrllist.Add(DaintyDate1.Text); ctrllist.Add(DaintyDate2.Text); ctrllist.Add(DaintyDate3.Text); if (chk == null) { } else { bool chkstr = chk.chksql_server(ctrllist); if (chkstr == true) { Page.Server.Transfer(HttpContext.Current.Request.Path); } } ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString()); if (!IsPostBack) { txtrackddate.Text = DateTime.Today.Date.ToString("dd-MM-yyyy"); DaintyDate2.Text = DateTime.Today.Date.ToString("dd-MM-yyyy"); DaintyDate3.Text = DateTime.Today.Date.ToString("dd-MM-yyyy"); GetDist(); GetTransport(); ddlrecddistrict.SelectedValue = distid; GetDCName(); GetRecddist(); GetDestRH(); GetDestDist(); dt.Columns.Add("district_code"); dt.Columns.Add("Rack_No"); dt.Columns.Add("IC_ID"); dt.Columns.Add("IC_Name"); dt.Columns.Add("Challan_No"); dt.Columns.Add("Challan_date"); dt.Columns.Add("Transporter_ID"); dt.Columns.Add("Transporter_Name"); dt.Columns.Add("Truck_No"); dt.Columns.Add("Disp_Bags"); dt.Columns.Add("Disp_Qty"); Session["dt"] = dt; GetChallan(); } } else { Response.Redirect("~/MainLogin.aspx"); } }