protected void GetRate() { DObj = new Districts(ComObj); //string getcat = "select Block_cat from pds.block_master where District_code ='" + distid + "' and block_code='" + ddl_block.SelectedValue +"'"; //DataSet dscat = DObj.selectAny(getcat); //if (dscat.Tables[0].Rows.Count == 0) //{ //} //else //{ // DataRow drcat = dscat.Tables[0].Rows[0]; // cat = drcat["Block_cat"].ToString(); //} if (ddl_rate_type.SelectedItem.Value == "U") { string qry = "Select Uraban_rate from dbo.SCSC_IssueRate where Scheme_ID='" + ddl_scheme.SelectedValue + "'and Commodity_ID='" + ddl_commodity.SelectedValue + "'and District_code='" + distid + "'"; DObj = new Districts(ComObj); DataSet ds = DObj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Rate is not available for selected commodity....'); </script> "); tx_rate_qt.ReadOnly = false; tx_rate_qt.Focus(); tx_rate_qt.BackColor = System.Drawing.Color.White; } else { DataRow dr = ds.Tables[0].Rows[0]; tx_rate_qt.Text = dr["Uraban_rate"].ToString(); tx_rate_qt.ReadOnly = true; } } else { string qry = "Select Rural_rate from dbo.SCSC_IssueRate where Scheme_ID='" + ddl_scheme.SelectedValue + "'and Commodity_ID='" + ddl_commodity.SelectedValue + "'"; DObj = new Districts(ComObj); DataSet ds = DObj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Rate is not available for selected commodity....'); </script> "); tx_rate_qt.ReadOnly = false; tx_rate_qt.Focus(); tx_rate_qt.BackColor = System.Drawing.Color.White; } else { DataRow dr = ds.Tables[0].Rows[0]; tx_rate_qt.Text = dr["Rural_rate"].ToString(); tx_rate_qt.ReadOnly = true; } } }
protected void GetRate() { //string todates = DateTime.Today.ToShortDateString(); string todaydate = DateTime.Today.ToString("MM/dd/yyyy"); DObj = new Districts(ComObj); if (ddl_commodity.SelectedItem.Text == "Select" || ddl_scheme.SelectedItem.Text == "Select") { Page.RegisterClientScriptBlock("asdsad", "<script language=javascript > alert('Please select Commodity/Scheme...');</script>"); } else if (ddl_rate_type.SelectedItem.Value == "U") { string qry = "Select Uraban_rate from dbo.SCSC_IssueRate where Scheme_ID='" + ddl_scheme.SelectedValue + "'and Commodity_ID='" + ddl_commodity.SelectedValue + "' and District_code='" + distid + "' and Effective_From<='" + todaydate + "' order by Effective_From desc"; DObj = new Districts(ComObj); DataSet ds = DObj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { // Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Rate is not available for selected commodity....'); </script> "); tx_rate_qt.ReadOnly = false; tx_rate_qt.Focus(); tx_rate_qt.BackColor = System.Drawing.Color.White; tx_rate_qt.Text = "0"; } else { DataRow dr = ds.Tables[0].Rows[0]; tx_rate_qt.Text = dr["Uraban_rate"].ToString(); tx_rate_qt.ReadOnly = true; } } else { string qry = "Select Rural_rate from dbo.SCSC_IssueRate where Scheme_ID='" + ddl_scheme.SelectedValue + "'and Commodity_ID='" + ddl_commodity.SelectedValue + "' and District_code='" + distid + "' and Effective_From<='" + todaydate + "' order by Effective_From desc"; DObj = new Districts(ComObj); DataSet ds = DObj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { //Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Rate is not available for selected commodity....'); </script> "); tx_rate_qt.ReadOnly = false; tx_rate_qt.Focus(); tx_rate_qt.BackColor = System.Drawing.Color.White; tx_rate_qt.Text = "0"; } else { DataRow dr = ds.Tables[0].Rows[0]; tx_rate_qt.Text = dr["Rural_rate"].ToString(); tx_rate_qt.ReadOnly = true; } } }
protected void btnsubmit_Click(object sender, EventArgs e) { string qryc = "SELECT * FROM tbl_MetaData_Purchase_Center where DistrictId='" + ddldistoff.SelectedValue.ToString() + "' and PurchaseCenterName='" + txtCentreName.Text + "'"; DObj = new Districts(ComObj); DataSet ds = DObj.selectAny(qryc); if (ds == null) { } else { if (ds.Tables[0].Rows.Count == 0) { string qry = "INSERT INTO tbl_MetaData_Purchase_Center(PcId,PCCode,CommodityId,DistrictId,RegionId,StateId,CropYearId,MarketingSeason,PurchaseCenterName,DateOfIssue,Address,Phone,PC_CategoryID,PCType,CreatedBy,CreatedDate,UpdatedBy,UpdatedDate,DeletedBy ,DeletedDate,NodalOff,Block,Remark,Status,Master_PCID)VALUES('" + txtpcid.Text + "','','" + ddlcomdty.SelectedValue.ToString() + "','23" + ddldistoff.SelectedValue + "','2300','23','" + ddlseason.SelectedValue.ToString() + "','" + ddlcropyear.SelectedItem.Text.ToString() + "','" + txtCentreName.Text + "','','" + txtAddress.Text + "','" + txtPhone.Text + "','1','','',getdate(),'','','','','" + txtNodalOff.Text + "','" + txtBlock.Text + "','" + txtRemarks.Text + "','4','" + txtpcid.Text + "')"; cmd.Connection = con; cmd.CommandText = qry; try { con.Open(); cmd.ExecuteNonQuery(); con.Close(); //cmd.Connection = con1; //cmd.CommandText = qry; //con1.Open(); //cmd.ExecuteNonQuery(); //con1.Close(); Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Data Inserted Successfully.....'); </script> "); btnsubmit.Enabled = false; } catch (Exception ex) { Label1.Visible = true; Label1.Text = ex.Message; } finally { con.Close(); } } else { Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Purchase Centre Already Exist.....'); </script> "); } } }
void GetBalanceQty() { string commid = lblcmdty.Text; string schemeid = lblsch.Text; int month = int.Parse(ddlalotmm.SelectedValue); int year = int.Parse(ddlallot_year.SelectedValue); string qryGB = "Select Sum(RO_qty) as RO_qty from dbo.RO_of_FCI where Scheme='" + schemeid + "'and Commodity='" + commid + "' and Distt_Id='" + distid + "' and Allot_month=" + month + "and Allot_year=" + year; DObj = new Districts(ComObj); DataSet dsGB = DObj.selectAny(qryGB); if (dsGB == null) { } else { if (dsGB.Tables[0].Rows.Count == 0) { float mbqty = CheckNull(txtalotqty.Text) - CheckNull(txtroqty.Text); txtbalance.Text = "0"; txtbalance.ReadOnly = true; //txtbalance.BackColor = System.Drawing.Color.Wheat; } else { DataRow drGB = dsGB.Tables[0].Rows[0]; string mbalance = System.Math.Round(CheckNull(drGB["RO_qty"].ToString()), 5).ToString(); if (mbalance == "0") { txtbalance.Text = txtalotqty.Text; } else { float mrobal = CheckNull(drGB["RO_qty"].ToString()); float mroalot = CheckNull(txtalotqty.Text); float macbal = mroalot - mrobal; //txtbalance.Text = System.Math.Round(CheckNull(drGB["RO_qty"].ToString()), 5).ToString(); txtbalance.Text = macbal.ToString(); txtbalance.ReadOnly = true; // txtbalance.BackColor = System.Drawing.Color.Wheat; } } } }
private void GetDistrict() { Dobj = new Districts(ComObj); string qrySelect = "SELECT * FROM DistrictMaster order by DistrictName"; DataSet ds = Dobj.selectAny(qrySelect); if (ds == null) { } else { //for first District DropdownList ddl_District.DataSource = ds.Tables[0]; ddl_District.DataValueField = "DistrictCode"; ddl_District.DataTextField = "DistrictName"; ddl_District.DataBind(); ddl_District.Items.Insert(0, "All"); //for sencond District DropdownList ddl_District_Fetch.DataSource = ds.Tables[0]; ddl_District_Fetch.DataValueField = "DistrictCode"; ddl_District_Fetch.DataTextField = "DistrictName"; ddl_District_Fetch.DataBind(); ddl_District_Fetch.Items.Insert(0, "--Select--"); //for sencond District DropdownList ddl_District_Selected.DataSource = ds.Tables[0]; ddl_District_Selected.DataValueField = "DistrictCode"; ddl_District_Selected.DataTextField = "DistrictName"; ddl_District_Selected.DataBind(); ddl_District_Selected.Items.Insert(0, "--Select--"); //for fourth District DropdownList ddl_AddNewDistrict.DataSource = ds.Tables[0]; ddl_AddNewDistrict.DataValueField = "DistrictCode"; ddl_AddNewDistrict.DataTextField = "DistrictName"; ddl_AddNewDistrict.DataBind(); ddl_AddNewDistrict.Items.Insert(0, "--Select--"); } }
protected void ddldistoff_SelectedIndexChanged(object sender, EventArgs e) { string qry = "SELECT Max(PcId) as PcId FROM tbl_MetaData_Purchase_Center"; DObj = new Districts(ComObj); DataSet ds = DObj.selectAny(qry); if (ds == null) { } else { DataRow dr = ds.Tables[0].Rows[0]; txtpcid.Text = dr["PcId"].ToString(); Int64 pcid = Int64.Parse(dr["PcId"].ToString()); pcid = pcid + 1; txtpcid.Text = pcid.ToString(); } }
private void getDistrcts() { Dobj = new Districts(ComObj); string qrySelect = "SELECT * FROM DistrictMaster order by DistrictName"; DataSet ds = Dobj.selectAny(qrySelect); if (ds == null) { } else { DDL_Dist.DataSource = ds.Tables[0]; DDL_Dist.DataValueField = "DistrictCode"; DDL_Dist.DataTextField = "DistrictName"; DDL_Dist.DataBind(); DDL_Dist.Items.Insert(0, "--Select--"); } }
void GetRate() { string qry = "Select Rate from dbo.SCSC_MSP_rate where Commodity_ID='" + ddlcomdty.SelectedValue + "'and Purchase_From='03'and District_code='" + rodist + "'"; DObj = new Districts(ComObj); DataSet ds = DObj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('There is no Rate available for selected commodity....'); </script> "); txtroqty.ReadOnly = false; } else { DataRow dr = ds.Tables[0].Rows[0]; txtrate.Text = CheckNull(dr["Rate"].ToString()).ToString(); txtrate.ReadOnly = true; // txtrate.BackColor = System.Drawing.Color.Wheat; } }
void GetRate() { string mcomdty = ddlcomdty.SelectedValue; string mscheme = ddlscheme.SelectedValue; string todaydate = DateTime.Today.ToString("MM/dd/yyyy"); string qry = "Select Rate from dbo.SCSC_MSP_rate where Commodity_ID='" + mcomdty + "'and Purchase_From='03' and Scheme_ID='" + mscheme + "' and District_code='" + ddldistrict.SelectedValue + "' and Effective_From<='" + todaydate + "' order by Effective_From desc"; DObj = new Districts(ComObj); DataSet ds = DObj.selectAny(qry); if (ds == null) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('There is no Rate available for selected commodity....'); </script> "); txtroqty.ReadOnly = false; txtrate.Text = "0"; ddlscheme.SelectedIndex = 0; ddlcomdty.SelectedIndex = 0; txtrate.Focus(); } else { if (ds.Tables[0].Rows.Count == 0) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('There is no Rate available for selected commodity....'); </script> "); txtroqty.ReadOnly = false; txtrate.Text = "0"; txtrate.Focus(); } else { DataRow dr = ds.Tables[0].Rows[0]; txtrate.Text = CheckNull(dr["Rate"].ToString()).ToString(); txtrate.ReadOnly = true; // txtrate.BackColor = System.Drawing.Color.Wheat; txtroqty.Focus(); } } }
protected void GetRate() { string qry = "Select Rate from dbo.SCSC_MSP_rate where Scheme_ID='" + ddl_scheme.SelectedValue + "'and Commodity_ID='" + ddl_commodity.SelectedValue + "'"; DObj = new Districts(ComObj); DataSet ds = DObj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('There is no Rate available for selected commodity....'); </script> "); tx_rate_qt.ReadOnly = false; tx_rate_qt.Focus(); } else { DataRow dr = ds.Tables[0].Rows[0]; tx_rate_qt.Text = dr["Rate"].ToString(); tx_rate_qt.ReadOnly = true; tx_rate_qt.BackColor = System.Drawing.Color.Wheat; tx_rate_qt.Focus(); } }
protected void ddl_scheme_SelectedIndexChanged(object sender, EventArgs e) { //if (ddl_scheme.SelectedItem.Text == "Select" || ddl_commodity.SelectedItem.Text == "Select" ) //{ // Page.RegisterClientScriptBlock("asdsad", "<script language=javascript > alert('Please select Commodity/Scheme...');</script>"); //} //else //{ // tx_do_no.Focus(); // GetRate(); // get_ComdtyBal(); //} string sctype = ddl_scheme.SelectedItem.Text; int malot = int.Parse(ddl_allot_month.SelectedValue.ToString()); int malotyear = int.Parse(ddd_allot_year.SelectedValue.ToString()); string commodty = ddl_commodity.SelectedValue; string mscheme = ddl_scheme.SelectedValue; if (sctype == "APL" || sctype == "BPL" || sctype == "AAY") { txtcomdty_bal.Text = ""; if (ddl_scheme.SelectedItem.Text == "Non Scheme" || ddl_scheme.SelectedItem.Text == "--Select--" || ddl_commodity.SelectedItem.Text == "--Select--") { Page.RegisterClientScriptBlock("asdsad", "<script language=javascript > alert('Please select Commodity/Scheme...');</script>"); } else { string comm = ddl_commodity.SelectedItem.Text; string scheme = ddl_scheme.SelectedItem.Text; int amonth = int.Parse(ddl_allot_month.SelectedItem.Value); int ayear = int.Parse(ddd_allot_year.SelectedItem.Value); string commodity = ""; if (scheme.ToLower() == "apl") { if (comm.ToLower().Contains("wheat")) { commodity = "wheat_apl_alloc"; } if (comm.ToLower().Contains("rice")) { commodity = "rice_apl_alloc"; } if (comm.ToLower().Contains("sugar")) { commodity = "sugar_alloc"; } } if (scheme.ToLower() == "bpl") { if (comm.ToLower().Contains("wheat")) { commodity = "wheat_bpl_alloc"; } if (comm.ToLower().Contains("rice")) { commodity = "rice_bpl_alloc"; } if (comm.ToLower().Contains("sugar")) { commodity = "sugar_alloc"; } } if (scheme.ToLower() == "aay") { if (comm.ToLower().Contains("wheat")) { commodity = "wheat_aay_alloc"; } if (comm.ToLower().Contains("rice")) { commodity = "rice_aay_alloc"; } if (comm.ToLower().Contains("sugar")) { commodity = "sugar_alloc"; } } if (commodity != "") { cmd.CommandText = "select " + commodity + " from pds.state_alloc where district_code='" + distid + "' and month='" + malot + "' and Year='" + malotyear + "'"; cmd.Connection = con_opdms; con_opdms.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { if (dr[commodity].ToString() == "") { txtcomdty_bal.Text = "0"; } else { txtcomdty_bal.Text = System.Math.Round(decimal.Parse(dr[commodity].ToString()), 2).ToString(); } } dr.Close(); con_opdms.Close(); } if (txtcomdty_bal.Text == "") { txtcomdty_bal.Text = "0"; Page.RegisterClientScriptBlock("asdsad", "<script language=javascript > alert('There is no Allotment for Selected Commodity...');</script>"); } GetRate(); GetRoBalance(); GetBalanceQty(); } txtcomdty_bal.ReadOnly = true; txtcomdty_bal.BackColor = System.Drawing.Color.Wheat; } else { DObj = new Districts(ComObj); string malloc = "select alloc_qty from dbo.dist_mpscsc_alloc where district_code='" + distid + "' and alloc_month=" + malot + " and alloc_year=" + malotyear + " and commodity_id='" + commodty + "' and scheme_id='" + mscheme + "'"; DataSet dsGB = DObj.selectAny(malloc); if (dsGB == null) { } else { if (dsGB.Tables[0].Rows.Count == 0) { Page.RegisterClientScriptBlock("asdsad", "<script language=javascript > alert('There is no Allotment for Selected Commodity...');</script>"); decimal mbqty = CheckNull(txtcomdty_bal.Text) - CheckNull(tx_qty.Text); txtbalqty.Text = mbqty.ToString(); txtcomdty_bal.Text = "0"; txtbalqty.ReadOnly = true; txtbalqty.BackColor = System.Drawing.Color.Wheat; txtcomdty_bal.ReadOnly = true; txtcomdty_bal.BackColor = System.Drawing.Color.Wheat; } else { DataRow drGB = dsGB.Tables[0].Rows[0]; txtcomdty_bal.Text = System.Math.Round(CheckNull(drGB["alloc_qty"].ToString()), 5).ToString(); txtcomdty_bal.ReadOnly = true; txtcomdty_bal.BackColor = System.Drawing.Color.Wheat; } } GetBalanceQty(); GetRate(); } }
void GetRoBalance() { string comodity = ""; if (ddl_commodity.SelectedItem.Text.ToLower().Contains("wheat")) { comodity = "wheat"; } if (ddl_commodity.SelectedItem.Text.ToLower().Contains("rice")) { comodity = "rice"; } if (ddl_commodity.SelectedItem.Text.ToLower().Contains("sugar")) { comodity = "sugar"; } string comdty = ""; string qrycom = "Select Commodity_ID from dbo.tbl_MetaData_STORAGE_COMMODITY where lower(Commodity_Name) like'%" + comodity + "%'"; cmd.CommandText = qrycom; cmd.Connection = con; con.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { comdty = comdty + dr["Commodity_ID"].ToString(); comdty = comdty + ","; } con.Close(); dr.Close(); int ind; ind = comdty.LastIndexOf(","); comdty = comdty.Remove(ind, 1); string commid = ddl_commodity.SelectedValue;; string schemeid = ddl_scheme.SelectedValue; int month = int.Parse(ddl_allot_month.SelectedValue); int year = int.Parse(ddd_allot_year.SelectedValue); string qryGB = "Select Round(convert(decimal,Sum(RO_qty)),5) as RO_qty from dbo.RO_of_FCI group by Distt_Id,Commodity,Allot_month,Allot_year,scheme having (Commodity in(" + comdty + ")) and (Distt_Id='" + distid + "') and (Allot_month=" + month + ")and (Allot_year=" + year + ") and (Scheme='" + schemeid + "')"; DObj = new Districts(ComObj); DataSet dsGB = DObj.selectAny(qryGB); if (dsGB == null) { } else { if (dsGB.Tables[0].Rows.Count == 0) { decimal mbqty = CheckNull(txtcomdty_bal.Text); txtrobalqty.Text = "0"; txtrobalqty.ReadOnly = true; txtrobalqty.BackColor = System.Drawing.Color.Wheat; } else { DataRow drGB = dsGB.Tables[0].Rows[0]; decimal mrobal = CheckNull(drGB["RO_qty"].ToString()); txtrobalqty.Text = mrobal.ToString(); } } }
void GetBalanceQty() { string comodity = ""; if (ddl_commodity.SelectedItem.Text.ToLower().Contains("wheat")) { comodity = "wheat"; } if (ddl_commodity.SelectedItem.Text.ToLower().Contains("rice")) { comodity = "rice"; } if (ddl_commodity.SelectedItem.Text.ToLower().Contains("sugar")) { comodity = "sugar"; } string comdty = ""; string qrycom = "Select Commodity_ID from dbo.tbl_MetaData_STORAGE_COMMODITY where lower(Commodity_Name) like'%" + comodity + "%'"; cmd.CommandText = qrycom; cmd.Connection = con; con.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { comdty = comdty + dr["Commodity_ID"].ToString(); comdty = comdty + ","; } con.Close(); dr.Close(); int ind; ind = comdty.LastIndexOf(","); comdty = comdty.Remove(ind, 1); string commid = ddl_commodity.SelectedValue;; string schemeid = ddl_scheme.SelectedValue; int month = int.Parse(ddl_allot_month.SelectedValue); int year = int.Parse(ddd_allot_year.SelectedValue); string qryGB = "Select Round(convert(decimal,Sum(quantity)),5) as RO_qty from dbo.delivery_order_mpscsc group by district_code,commodity_id,allotment_month,allotment_year,scheme_id,issue_type having (commodity_id in(" + comdty + ")) and (district_code='" + distid + "') and (allotment_month=" + month + ")and (allotment_year=" + year + ") and (scheme_id='" + schemeid + "') and (issue_type='FCI')"; DObj = new Districts(ComObj); DataSet dsGB = DObj.selectAny(qryGB); if (dsGB == null) { } else { if (dsGB.Tables[0].Rows.Count == 0) { decimal mbqty = CheckNull(txtcomdty_bal.Text); decimal mdoqty = CheckNull(txtrobalqty.Text); txtbalqty.Text = (mbqty - mdoqty).ToString(); txtbalqty.ReadOnly = true; txtbalqty.BackColor = System.Drawing.Color.Wheat; } else { DataRow drGB = dsGB.Tables[0].Rows[0]; string mbalance = System.Math.Round(CheckNull(drGB["RO_qty"].ToString()), 5).ToString(); if (mbalance == "0") { txtbalqty.Text = txtcomdty_bal.Text; } else { decimal mrobal = CheckNull(drGB["RO_qty"].ToString()); decimal mroalot = CheckNull(txtcomdty_bal.Text); decimal mdoqty = CheckNull(txtrobalqty.Text); decimal macbal = mroalot - mrobal - mdoqty; //txtbalqty.Text = System.Math.Round(CheckNull(drGB["RO_qty"].ToString()), 5).ToString(); txtbalqty.Text = macbal.ToString(); txtbalqty.ReadOnly = true; txtbalqty.BackColor = System.Drawing.Color.Wheat; } } } }
protected void btnsave_Click(object sender, EventArgs e) { if (txtchqamt.Text == "" || txtckeckno.Text == "") { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Enter Payment Details....'); </script> "); } else { string mronoc = txtrono.Text; mobj2 = new MoveChallan(ComObj); string qryrochk = "select * from dbo.RO_of_FCI where Distt_Id='" + distid + "'and RO_No='" + mronoc + "'"; DataSet dsrochk = mobj2.selectAny(qryrochk); if (dsrochk.Tables[0].Rows.Count == 0) { //DataRow drro = dsro.Tables[0].Rows[0]; if (ddlcomdty.SelectedItem.Text == "--Select--" || ddlscheme.SelectedItem.Text == "--Select--") { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Select The Commodity /Scheme/BankName....'); </script> "); } else { DateTime fdate = new DateTime(); DateTime tdate = new DateTime(); string fromdate = getDate_MDY(txtrodate.Text); string todate = getDate_MDY(txtrovalidity.Text); fdate = Convert.ToDateTime(fromdate); tdate = Convert.ToDateTime(todate); string validity = get_days(fdate, tdate); if (int.Parse(validity) > 25) { Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Validity Should not be more than 25 days'); </script> "); } else { if (Page.IsValid) { decimal mroqty = CheckNull(txtroqty.Text); if (mroqty == 0) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Enter Quantity....'); </script> "); txtroqty.Focus(); } else { string mdistid = distid; string mrono = txtrono.Text; string mrodate = getDate_MDY(txtrodate.Text); string mvdate = getDate_MDY(txtrovalidity.Text); string mrodist = ddldistrict.SelectedValue; string mcomdty = ddlcomdty.SelectedValue; string mscheme = ddlscheme.SelectedValue; decimal mrate = CheckNull(txtrate.Text); decimal mamt = CheckNull(txtamount.Text); string mallotm = ddlalotmm.SelectedValue; string myear = DateTime.Today.Year.ToString(); string mddno = txtckeckno.Text; string mdddate = getDate_MDY(txtddate.Text); decimal mddamt = CheckNull(txtchqamt.Text); string mremark = txtremark.Text; string mislift = "N"; //string mcrdate = DateTime.Today.Date.ToString(); //string mcrtdate = getDate_MDY(mcrdate); string mudate = ""; string mddate = ""; decimal mbqty = decimal.Parse(txtroqty.Text); decimal mallotqty = CheckNull(txtalotqty.Text); decimal mbalqty = CheckNull(txtbalance.Text); decimal mrobalance = mbalqty - CheckNull(txtroqty.Text); int maltmonth = int.Parse(ddlalotmm.SelectedValue); int maltyear = int.Parse(ddlallot_year.SelectedValue); string mbank = ddlbankname.SelectedValue; string iex = "N"; string pmode = ddlpaymenttype.SelectedValue; string ip = Request.ServerVariables["REMOTE_ADDR"].ToString(); string opid = Session["OperatorIDDM"].ToString(); string state = Session["State_Id"].ToString(); string notrans = "N"; string qryInsert = "insert into dbo.RO_of_FCI(State_Id,Distt_Id,RO_No,RO_date,RO_qty,RO_Validity,RO_district,Commodity,Scheme,Rate,Amount,Allot_month,Allot_year,DD_chk_no,DD_chk_date,DD_chk_Amount,Bank_ID,Remarks,IsLifted,Created_date,updated_date,deleted_date,Balance_Qty,IsExpire,IP_Address,Payment_Mode,OperatorID,NoTransaction)values('" + state + "','" + mdistid + "','" + mrono + "','" + mrodate + "'," + mroqty + ",'" + mvdate + "','" + mrodist + "','" + mcomdty + "','" + mscheme + "'," + mrate + "," + mamt + ",'" + mallotm + "','" + myear + "','" + mddno + "','" + mdddate + "'," + mddamt + ",'" + mbank + "','" + mremark + "','" + mislift + "',getdate(),'" + mudate + "','" + mddate + "'," + mbqty + ",'" + iex + "','" + ip + "','" + pmode + "','" + opid + "','" + notrans + "')"; cmd.CommandText = qryInsert; cmd.Connection = con; con.Open(); SqlTransaction trns; trns = con.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted); cmd.Transaction = trns; try { if (mbqty > mbalqty) { Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('RO Quantity Should not be greater than Balance Qty....'); </script> "); txtroqty.Focus(); } else { int count = cmd.ExecuteNonQuery(); if (count == 1) { string trans = "Insert"; DateTime date = DateTime.Now; string qryTrans = "insert into dbo.tbl_ROFCI_Transuction(State_Id,Distt_Id,RO_No,RO_date,RO_qty,RO_Validity,RO_district,Commodity,Scheme,Rate,Amount,Allot_month,Allot_year,DD_chk_no,DD_chk_date,DD_chk_Amount,Bank_ID,Remarks,Operation,Trans_Date,IP_Address,User_ID,OperatorID)values('" + state + "','" + mdistid + "','" + mrono + "','" + mrodate + "'," + mroqty + ",'" + mvdate + "','" + mrodist + "','" + mcomdty + "','" + mscheme + "'," + mrate + "," + mamt + ",'" + mallotm + "','" + myear + "','" + mddno + "','" + mdddate + "'," + mddamt + ",'" + mbank + "','" + mremark + "','" + trans + "',getdate(),'" + ip + "','" + distid + "','" + opid + "')"; cmd.CommandText = qryTrans; cmd.Transaction = trns; cmd.ExecuteNonQuery(); int month = int.Parse(ddlalotmm.SelectedValue); int year = int.Parse(ddlallot_year.SelectedValue); decimal mlift = 0; string qryGD = "Select Balance_Qty,Allotment_Qty from dbo.District_Alloc where Scheme_ID='" + mscheme + "'and Commodity_ID='" + mcomdty + "' and district_code='" + distid + "' and Month=" + month + "and Year=" + year; DObj = new Districts(ComObj); DataSet dsGD = DObj.selectAny(qryGD); if (dsGD.Tables[0].Rows.Count == 0) { string qrydalloc = "insert into dbo.District_Alloc(State_Id,district_code,Month,Year,Commodity_ID,Scheme_ID,Allotment_Qty,Balance_Qty,Lifted_Qty,OperatorID)values('" + state + "','" + distid + "'," + mallotm + "," + maltyear + ",'" + mcomdty + "','" + mscheme + "'," + mallotqty + "," + mrobalance + "," + mlift + ",'" + opid + "')"; cmd.CommandText = qrydalloc; cmd.Transaction = trns; cmd.ExecuteNonQuery(); } else { string qrydallocU = "Update dbo.District_Alloc set Balance_Qty =" + mrobalance + " where Scheme_ID='" + mscheme + "'and Commodity_ID='" + mcomdty + "' and district_code='" + distid + "'and Month=" + month + "and Year=" + year; cmd.Connection = con; cmd.CommandText = qrydallocU; cmd.Transaction = trns; cmd.ExecuteNonQuery(); } } Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Data Saved Successfully...'); </script> "); btnsave.Enabled = false; } trns.Commit(); } catch (Exception ex) { trns.Rollback(); Label1.Visible = true; Label1.Text = ex.Message; } finally { con.Close(); ComObj.CloseConnection(); } } } } } } else { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Release Order Number Already Exist....'); </script> "); } } }
void GetAllotment() { string sctype = lblsch.Text; int malot = int.Parse(ddlalotmm.SelectedValue.ToString()); int malotyear = int.Parse(ddlallot_year.SelectedValue.ToString()); string commodty = ddlcomdty.SelectedValue; string mscheme = ddlscheme.SelectedValue; if (sctype == "1" || sctype == "2" || sctype == "3") { txtalotqty.Text = ""; if (ddlscheme.SelectedItem.Text == "Non Scheme" || ddlscheme.SelectedItem.Text == "--Select--" || ddlcomdty.SelectedItem.Text == "--Select--") { Page.RegisterClientScriptBlock("asdsad", "<script language=javascript > alert('Please select Commodity/Scheme...');</script>"); } else { //GetRate(); string comm = ddlcomdty.SelectedItem.Text; string scheme = ddlscheme.SelectedItem.Text; int amonth = int.Parse(ddlalotmm.SelectedItem.Value); int ayear = int.Parse(DateTime.Today.Year.ToString()); string commodity = ""; if (scheme.ToLower() == "apl") { if (comm.ToLower().Contains("wheat")) { commodity = "wheat_apl_alloc"; } if (comm.ToLower().Contains("rice")) { commodity = "rice_apl_alloc"; } if (comm.ToLower().Contains("sugar")) { commodity = "sugar_alloc"; } } if (scheme.ToLower() == "bpl") { if (comm.ToLower().Contains("wheat")) { commodity = "wheat_bpl_alloc"; } if (comm.ToLower().Contains("rice")) { commodity = "rice_bpl_alloc"; } if (comm.ToLower().Contains("sugar")) { commodity = "sugar_alloc"; } } if (scheme.ToLower() == "aay") { if (comm.ToLower().Contains("wheat")) { commodity = "wheat_aay_alloc"; } if (comm.ToLower().Contains("rice")) { commodity = "rice_aay_alloc"; } if (comm.ToLower().Contains("sugar")) { commodity = "sugar_alloc"; } } if (commodity != "") { cmd.CommandText = "select " + commodity + " from pds.state_alloc where district_code='" + rodist + "' and month='" + amonth + "' and Year='" + ayear + "'"; cmd.Connection = con_opdms; con_opdms.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { if (dr[commodity].ToString() == "") { txtalotqty.Text = "0"; } else { txtalotqty.Text = System.Math.Round(float.Parse(dr[commodity].ToString()), 2).ToString(); } } dr.Close(); con_opdms.Close(); } if (txtalotqty.Text == "") { txtalotqty.Text = "0"; Page.RegisterClientScriptBlock("asdsad", "<script language=javascript > alert('There is no Allotment for Selected Commodity...');</script>"); } GetBalanceQty(); } txtalotqty.ReadOnly = true; // txtalotqty.BackColor = System.Drawing.Color.Wheat; } else { DObj = new Districts(ComObj); string malloc = "select alloc_qty from dbo.dist_mpscsc_alloc where district_code='" + rodist + "' and alloc_month=" + malot + " and alloc_year=" + malotyear + " and commodity_id='" + commodty + "' and scheme_id='" + mscheme + "'"; DataSet dsGB = DObj.selectAny(malloc); if (dsGB == null) { } else { if (dsGB.Tables[0].Rows.Count == 0) { Page.RegisterClientScriptBlock("asdsad", "<script language=javascript > alert('There is no Allotment for Selected Commodity...');</script>"); float mbqty = CheckNull(txtalotqty.Text) - CheckNull(txtroqty.Text); txtbalance.Text = mbqty.ToString(); txtalotqty.Text = "0"; txtbalance.ReadOnly = true; // txtbalance.BackColor = System.Drawing.Color.Wheat; txtalotqty.ReadOnly = true; // txtalotqty.BackColor = System.Drawing.Color.Wheat; } else { DataRow drGB = dsGB.Tables[0].Rows[0]; txtalotqty.Text = System.Math.Round(CheckNull(drGB["alloc_qty"].ToString()), 5).ToString(); txtalotqty.ReadOnly = true; // txtalotqty.BackColor = System.Drawing.Color.Wheat; } } GetBalanceQty(); } }