void GetRecipt() { mobj1 = new MoveChallan(ComObj); string qrey = "select * from dbo.tbl_Receipt_Details where challan_no='" + challan + "'and S_of_arrival='02'"; DataSet ds = mobj1.selectAny(qrey); if (ds.Tables[0].Rows.Count == 0) { Label1.Visible = true; Label1.Text = "Currently no Receipt Details Found"; } else { Label2.Visible = true; Label3.Visible = true; Label4.Visible = true; DataRow dr = ds.Tables[0].Rows[0]; lblrecdate.Visible = true; lblrecdate.Text = getdateM(dr["arrival_date"].ToString()); lblatime.Visible = true; lblatime.Text = dr["Arrival_time"].ToString(); lblweight.Visible = true; lblweight.Text = dr["Recd_Qty"].ToString(); } }
void GetData() { if (ddlrackno.SelectedItem.Text == "--Select--") { txtsrailh.Text = ""; txtdesrailh.Text = ""; ddlrackno.Focus(); } else { string rackno = ddlrackno.SelectedValue; mobj = new MoveChallan(ComObj); string qrey = "select tbl_Rail_Head.RailHead_Name as RailHead_Name from dbo.Rake_Master_Sugar left join dbo.tbl_Rail_Head on Rake_Master_Sugar.RailHead=tbl_Rail_Head.RailHead_Code where Rake_Master_Sugar.district_code='" + ddlsourcedist.SelectedValue + "' and Rake_Master_Sugar.Rack_No='" + rackno + "'"; DataSet ds = mobj.selectAny(qrey); if (ds.Tables[0].Rows.Count == 0) { } else { DataRow drs = ds.Tables[0].Rows[0]; txtsrailh.Text = drs["RailHead_Name"].ToString(); txtsrailh.ReadOnly = true; } } }
void GetData() { mobj = new MoveChallan(ComObj); string qrychallan = "SELECT challan_no,challan_date,Commodity,Recieved_Bags,Recd_Qty,Moisture,WCM_no,Vehile_no,Category,Crop_year FROM dbo.tbl_Receipt_Details where Dist_Id='" + did + "'and Depot_ID='" + sid + "'and IsRecieved='N' and Challan_No='"; DataSet ds = mobj.selectAny(qrychallan); }
void GetGodown() { if (cons.State == ConnectionState.Closed) { cons.Open(); } mobj = new MoveChallan(ComObj); string qry = "SELECT * FROM dbo.tbl_MetaData_GODOWN where DistrictId='" + did + "' and DepotId='" + gid + "' order by Godown_ID"; SqlCommand cmdgod = new SqlCommand(qry, cons); SqlDataAdapter dagdn = new SqlDataAdapter(cmdgod); DataSet ds = new DataSet(); dagdn.Fill(ds); ddlgodown.DataSource = ds.Tables[0]; ddlgodown.DataTextField = "Godown_Name"; ddlgodown.DataValueField = "Godown_ID"; ddlgodown.DataBind(); // ddlgodown.Items.Insert(0, "--Select--"); // 5002141132 if (cons.State == ConnectionState.Open) { cons.Close(); } }
void GetRackAllert() { string qryr = "select Rack_No,districtsmp.district_name,Recd_RailHead,tbl_Rail_Head.RailHead_Name from Rack_Receipt_Bulk left join pds.districtsmp on districtsmp.district_code=Rack_Receipt_Bulk.district_code left join dbo.tbl_Rail_Head on Rack_Receipt_Bulk.Recd_RailHead=tbl_Rail_Head.RailHead_Code where Sending_District='" + distid + "' and Rack_No not in(select Rack_No from tbl_RackMaster where district_code='" + distid + "')"; mobj = new MoveChallan(ComObj); DataSet dsrac = mobj.selectAny(qryr); if (dsrac == null) { } else { if (dsrac.Tables[0].Rows.Count == 0) { lblrack.Visible = false; Label1.Visible = false; Label1.Text = "Currently no record found...."; } else { lblrack.Visible = true; Label1.Visible = false; GridView1.DataSource = dsrac; GridView1.DataBind(); } } }
void fillGrid_iado() { string did = ddl_dist.SelectedValue; string depid = ddl_IC.SelectedValue; string gid = ddlgodown.SelectedValue; string qrychk = "select * from issue_against_do where district_code='" + did + "' and issueCentre_code='" + depid + "' and Godown='" + gid + "' "; mobj = new MoveChallan(ComObj); DataSet dschk = mobj.selectAny(qrychk); if (dschk == null) { } else { if (dschk.Tables[0].Rows.Count > 0) { GridView_Iado.DataSource = dschk.Tables[0]; GridView_Iado.DataBind(); } else { GridView_Iado.DataSource = null; GridView_Iado.DataBind(); } } }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { GridView1.Columns[9].Visible = true; GridView1.Columns[10].Visible = true; GridView1.Columns[11].Visible = true; GridView1.Columns[12].Visible = true; string issuid = ddlissueCenter.SelectedValue; string mmsource = GridView1.SelectedRow.Cells[9].Text; string comdty = GridView1.SelectedRow.Cells[10].Text; string scheme = GridView1.SelectedRow.Cells[11].Text; string godown = GridView1.SelectedRow.Cells[12].Text; string openqty = GridView1.SelectedRow.Cells[5].Text; string currqty = GridView1.SelectedRow.Cells[7].Text; mobj = new MoveChallan(ComObj); string qreyfetch = "Delete from dbo.issue_opening_balance where Depotid='" + issuid + "' and Godown='" + godown + "'and Commodity_ID='" + comdty + "' and Scheme_ID='" + scheme + "' and Source='" + mmsource + "'"; try { cmd.Connection = con; cmd.CommandText = qreyfetch; con.Open(); cmd.ExecuteNonQuery(); } catch (Exception Ex) { } finally { con.Close(); } }
public void GetBalance() { string mcomdtyid = ddlcomdty.SelectedValue; //string mcatid = ddlcategory.SelectedValue; string mscheme = ddlscheme.SelectedValue; string mgdown = ddlgodown.SelectedValue; string msource = ddlsarrival.SelectedValue; mobj1 = new MoveChallan(ComObj); string qry = "Select Round(Current_Balance,5) as Current_Balance from dbo.issue_opening_balance where District_Id='" + distid + "'and Depotid='" + issueid + "'and Commodity_Id='" + mcomdtyid + "'and Scheme_Id='" + mscheme + "' and Godown='" + mgdown + "' and Source='" + msource + "'"; DataSet ds = mobj1.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('There is No opening for selected Comodity/Scheme....'); </script> "); lblbqty.Visible = false; txtbqty.Visible = false; } else { DataRow dr = ds.Tables[0].Rows[0]; txtbqty.Text = dr["Current_Balance"].ToString(); lblbqty.Visible = true; txtbqty.Visible = true; txtbqty.BackColor = System.Drawing.Color.Wheat; txtbqty.ReadOnly = true; } }
void GetTo() { mobj = new MoveChallan(ComObj); string qry = "SELECT TO_Number FROM dbo.Transport_Order where fromDistrict='" + distid + "'and fromIssueCenter='" + issueid + "'and IsLifted='N'"; DataSet ds = mobj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { ddltono.Items.Clear(); ListItem lst = new ListItem(); lst.Text = "Not Indicated"; lst.Value = "0"; ddltono.Items.Insert(0, "--Select--"); ddltono.Items.Insert(1, lst); } else { ddltono.Items.Clear(); ddltono.DataSource = ds.Tables[0]; ddltono.DataTextField = "TO_Number"; ddltono.DataValueField = "TO_Number"; ddltono.DataBind(); ddltono.Items.Insert(0, "--Select--"); ddltono.Items.Insert(1, "Not Indicated"); } }
void GetPosition() { string qrypos = "select Round( Sum(Current_Balance),2) as Current_Balance from dbo.issue_opening_balance where District_Id='" + distid + "'and Depotid='" + issueid + "'"; mobj = new MoveChallan(ComObj); DataSet dspos = mobj.selectAny(qrypos); if (dspos.Tables[0].Rows.Count == 0) { txtspos.Text = "0"; txtspos.ReadOnly = true; txtspos.BackColor = System.Drawing.Color.Wheat; } else { DataRow drpos = dspos.Tables[0].Rows[0]; float pos = CheckNull(drpos["Current_Balance"].ToString()); if (pos == 0) { txtspos.Text = "0"; txtspos.ReadOnly = true; txtspos.BackColor = System.Drawing.Color.Wheat; } else { txtspos.Text = drpos["Current_Balance"].ToString(); txtspos.ReadOnly = true; txtspos.BackColor = System.Drawing.Color.Wheat; } } }
protected void ddlissue_SelectedIndexChanged(object sender, EventArgs e) { string gname = ddlissue.SelectedValue; mobj = new MoveChallan(ComObj); string qrygdn = "SELECT * FROM dbo.tbl_MetaData_GODOWN where DistrictId='" + distid + "' and DepotId='" + issueid + "' and Godown_ID='" + gname + "'"; DataSet ds = mobj.selectAny(qrygdn); if (ds == null) { } else { if (ds.Tables[0].Rows.Count == 0) { lblcap.Visible = false; txtcap.Visible = false; } else { lblcap.Visible = true; txtcap.Visible = true; txtcap.ReadOnly = true; DataRow dr = ds.Tables[0].Rows[0]; txtcap.Text = dr["Godown_Capacity"].ToString(); } } }
void fillGrid() { string mcomid = ddlcomdty.SelectedValue; string mcatid = ddlcategory.SelectedValue; string mscheme = ddlscheme.SelectedValue; int year = int.Parse(DateTime.Today.Date.Year.ToString()); int month = int.Parse(DateTime.Today.Date.Month.ToString()); string qrychk = "select issue_opening_balance.Quality, issue_opening_balance.Godown,convert(nvarchar,issue_opening_balance.Stock_Date,103)Stock_Date,issue_opening_balance.Source,issue_opening_balance.Scheme_Id,issue_opening_balance.Commodity_Id,convert(decimal(18,5),issue_opening_balance.Current_Balance) as Current_Balance ,issue_opening_balance.Current_Bags,convert(decimal(18,5),issue_opening_balance.Quantity) as Quantity, issue_opening_balance.Bags,issue_opening_balance.Crop_year,issue_opening_balance.Month,issue_opening_balance.Bags,tbl_MetaData_GODOWN.Godown_Name,tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name ,tbl_MetaData_SCHEME.Scheme_Name as Scheme_Name,Source_Arrival_Type.Source_Name as Source_Name from dbo.issue_opening_balance left join dbo.tbl_MetaData_STORAGE_COMMODITY on issue_opening_balance.Commodity_Id=tbl_MetaData_STORAGE_COMMODITY .Commodity_Id left join dbo.tbl_MetaData_SCHEME on issue_opening_balance.Scheme_Id =tbl_MetaData_SCHEME.Scheme_Id left join dbo.Source_Arrival_Type on issue_opening_balance.Source=Source_Arrival_Type.Source_ID left join dbo.tbl_MetaData_GODOWN on issue_opening_balance.Godown=tbl_MetaData_GODOWN.Godown_ID where issue_opening_balance.District_Id='" + distid + "'and issue_opening_balance.Depotid='" + issueid + "' and issue_opening_balance.Bags != 0 and issue_opening_balance.Quantity != 0"; mobj = new MoveChallan(ComObj); DataSet dschk = mobj.selectAny(qrychk); if (dschk == null) { } else { GridView1.DataSource = dschk.Tables[0]; GridView1.DataBind(); //GridView1.Columns[9].Visible = false; //GridView1.Columns[10].Visible = false; //GridView1.Columns[11].Visible = false; //GridView1.Columns[12].Visible = false; } }
void GetRect() { if (ddlrackno.SelectedItem.Text == "--Select--") { } else { string rackno = ddlrackno.SelectedValue; mobj12 = new MoveChallan(ComObj); string qreyfetch = "select * from dbo.Rack_Receipt_Bulk where Rack_No=" + rackno; DataSet dsfetch = mobj12.selectAny(qreyfetch); if (dsfetch.Tables[0].Rows.Count == 0) { } else { DataRow drs = dsfetch.Tables[0].Rows[0]; lblrecdqty.Text = drs["Rack_RecdQty"].ToString(); lblrrecddate.Text = drs["Rack_RecdDate"].ToString(); } } }
void GetBags() { if (ddlrackno.SelectedItem.Text == "--Select--") { } else { string rackno = ddlrackno.SelectedValue; mobj = new MoveChallan(ComObj); string qreysd = "select Sum(Received_Bags) as SentBag,Sum(Disp_Qty) as Disp_Qty from dbo.Rack_Dispatch_Details where Rack_Dispatch_Details.district_code='" + distid + "' and Rack_Dispatch_Details.Rack_No=" + rackno; DataSet ds = mobj.selectAny(qreysd); if (ds.Tables[0].Rows.Count == 0) { lblsntbags.Text = ""; lblbags.Text = ""; lblsntqty.Text = ""; } else { DataRow drs = ds.Tables[0].Rows[0]; lblsntbags.Text = drs["SentBag"].ToString(); lblbags.Text = drs["SentBag"].ToString(); lblsntqty.Visible = true; lblsntqty.Text = drs["Disp_Qty"].ToString(); lblrecdqty.Text = ""; lblrrecddate.Text = ""; } } }
private void fillgridOther() { string did = ddl_dist.SelectedValue; string depid = ddl_IC.SelectedValue; string gid = ddlgodown.SelectedValue; mobj = new MoveChallan(ComObj); string qry = "SELECT tbl_Receipt_Details.Godown as Godown, tbl_Receipt_Details.challan_no, tbl_Receipt_Details.challan_date,tbl_Receipt_Details.Vehile_no,tbl_Receipt_Details.Receipt_Id,tbl_Receipt_Details.S_of_arrival,Source_Arrival_Type.Source_Name as Source_Name FROM dbo.tbl_Receipt_Details left join dbo.Source_Arrival_Type on tbl_Receipt_Details.S_of_arrival= Source_Arrival_Type.Source_ID where Dist_Id='" + did + "' and Depot_ID='" + depid + "' and Godown='" + gid + "' order by Order by challan_date desc"; DataSet ds = mobj.selectAny(qry); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { GridView_other.DataSource = ds.Tables[0]; GridView_other.DataBind(); } else { GridView_other.DataSource = null; GridView_other.DataBind(); } } else { GridView_other.DataSource = null; GridView_other.DataBind(); } }
void GetRackQty() { mobj = new MoveChallan(ComObj); string qreyrq = "select Sum(Rack_Qty) as Rack_Qty from dbo.Rack_Dispatch_Bulk where district_code='" + distid + "' and Rack_No='" + rackno + "'"; DataSet ds = mobj.selectAny(qreyrq); if (ds.Tables[0].Rows.Count == 0) { } else { DataRow drs = ds.Tables[0].Rows[0]; string flag = ""; if (flag == drs["Rack_Qty"].ToString()) { txtrackqty.Text = "0"; txtrackqty.ReadOnly = true; } else { txtrackqty.Text = drs["Rack_Qty"].ToString(); txtrackqty.ReadOnly = true; } } }
void fillGrid_opening() { string distid = ddl_dist.SelectedValue; string issueid = ddl_IC.SelectedValue; string gdwnId = ddlgodown.SelectedValue; string qrychk = "select issue_opening_balance.District_Id as DistiD,issue_opening_balance.Depotid as depid,issue_opening_balance.Godown,issue_opening_balance.Source,issue_opening_balance.Scheme_Id,issue_opening_balance.Commodity_Id,convert(decimal(18,5),issue_opening_balance.Current_Balance) as Current_Balance ,issue_opening_balance.Current_Bags,convert(decimal(18,5),issue_opening_balance.Quantity) as Quantity ,issue_opening_balance.Bags,tbl_MetaData_GODOWN.Godown_Name,tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name ,tbl_MetaData_SCHEME.Scheme_Name as Scheme_Name,Source_Arrival_Type.Source_Name as Source_Name ,Current_Godown_Position.Month, Current_Godown_Position.Year from dbo.issue_opening_balance left join dbo.tbl_MetaData_STORAGE_COMMODITY on issue_opening_balance.Commodity_Id=tbl_MetaData_STORAGE_COMMODITY .Commodity_Id left join dbo.tbl_MetaData_SCHEME on issue_opening_balance.Scheme_Id =tbl_MetaData_SCHEME.Scheme_Id left join dbo.Source_Arrival_Type on issue_opening_balance.Source=Source_Arrival_Type.Source_ID left join dbo.tbl_MetaData_GODOWN on issue_opening_balance.Godown=tbl_MetaData_GODOWN.Godown_ID left join Current_Godown_Position on issue_opening_balance.Godown=Current_Godown_Position.Godown where issue_opening_balance.District_Id='" + distid + "'and issue_opening_balance.Depotid='" + issueid + "' and Godown='" + gdwnId + "'"; mobj = new MoveChallan(ComObj); DataSet dschk = mobj.selectAny(qrychk); if (dschk == null) { } else { if (dschk.Tables[0].Rows.Count > 0) { GridView_opn.DataSource = dschk.Tables[0]; GridView_opn.DataBind(); } else { GridView_opn.DataSource = null; GridView_opn.DataBind(); } } }
void GetDistt() { mobj1 = new MoveChallan(ComObj); string qrey = "select DistrictId,DepotName from dbo.tbl_MetaData_DEPOT where DepotID='" + issueid + "'"; DataSet ds = mobj1.selectAny(qrey); DataRow dr = ds.Tables[0].Rows[0]; distid = dr["DistrictId"].ToString(); dname = dr["DepotName"].ToString(); dist = distid.Substring(2, 2); string qrey2 = "select district_name from pds.districtsmp where district_code='" + dist + "'"; DataSet ds2 = mobj1.selectAny(qrey2); DataRow dr2 = ds2.Tables[0].Rows[0]; distname = dr2["district_name"].ToString(); lbldepot.Text = dname; lbldistt.Text = distname; lblgno.Text = sid; string daten = DateTime.Now.ToString(); string gdaten = getdate(daten); lblgdtae.Text = gdaten; # region Wheat if (Session["Commodity_Id"].ToString() == "1")
void fillGrid_tch() { string did = ddl_dist.SelectedValue; string depid = ddl_IC.SelectedValue; string gid = ddlgodown.SelectedValue; string qrychk = "select * from SCSC_Truck_challan where Dist_ID='" + did + "' and Depot_Id='" + depid + "' and Dispatch_Godown='" + gid + "' "; mobj = new MoveChallan(ComObj); DataSet dschk = mobj.selectAny(qrychk); if (dschk == null) { } else { if (dschk.Tables[0].Rows.Count > 0) { GridView_trck_chn.DataSource = dschk.Tables[0]; GridView_trck_chn.DataBind(); } else { GridView_trck_chn.DataSource = null; GridView_trck_chn.DataBind(); } } }
void GetChallan() { mobj = new MoveChallan(ComObj); string qry = "SELECT * FROM dbo.Rack_Receipt_Details where district_code='" + distid + "'and IssueCenter='" + sid + "' and IsReceived='N'"; DataSet ds = mobj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { ddlchallan.Items.Clear(); ListItem lst = new ListItem(); lst.Text = "Not Indicated"; lst.Value = "0"; ddlchallan.Items.Insert(0, "--Select--"); ddlchallan.Items.Insert(1, lst); } else { ddlchallan.Items.Clear(); ddlchallan.DataSource = ds.Tables[0]; ddlchallan.DataTextField = "Challan_No"; ddlchallan.DataValueField = "Challan_No"; ddlchallan.DataBind(); ddlchallan.Items.Insert(0, "--Select--"); ddlchallan.Items.Insert(1, "Not Indicated"); } }
protected void btnadd_Click(object sender, EventArgs e) { string ip = Request.ServerVariables["REMOTE_ADDR"].ToString(); string opid = Session["OperatorIDDM"].ToString(); string state = Session["State_Id"].ToString(); mobj = new MoveChallan(ComObj); string qrey = "select max(Bank_ID) as Bank_ID from dbo.Bank_Master where District_Code='" + distid + "'and issueCenter_code='" + distid + "'"; DataSet ds = mobj.selectAny(qrey); DataRow dr = ds.Tables[0].Rows[0]; bankid = dr["Bank_ID"].ToString(); if (bankid == "") { bankid = distid + "2001"; } else { banknum = Convert.ToInt32(bankid); banknum = banknum + 1; bankid = banknum.ToString(); } string mbname = txtbankname.Text; string mbadd = txtbadds.Text; string remark = ""; string insert = "insert into dbo.Bank_Master(State_Id,District_Code,issueCenter_code,Bank_ID,Bank_Name,Remarks,IP,OperatorID)values('" + state + "','" + distid + "','" + distid + "','" + bankid + "','" + mbname + "','" + remark + "','" + ip + "','" + opid + "')"; cmd.Connection = con; cmd.CommandText = insert; con.Open(); SqlTransaction trns; trns = con.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted); try { cmd.Transaction = trns; cmd.ExecuteNonQuery(); trns.Commit(); Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Data Inserted Successfully.....'); </script> "); btnadd.Enabled = false; } catch (Exception ex) { trns.Rollback(); Label1.Visible = true; Label1.Text = ex.Message; } finally { con.Close(); ComObj.CloseConnection(); } fillgrid(); }
protected void ddlgodown_SelectedIndexChanged(object sender, EventArgs e) { string gname = ddlgodown.SelectedValue; mobj = new MoveChallan(ComObj); string qrygdn = "SELECT * FROM dbo.tbl_MetaData_GODOWN where DistrictId='" + distid + "' and DepotId='" + sid + "' and Godown_ID='" + gname + "'"; DataSet ds = mobj.selectAny(qrygdn); if (ds == null) { } else { if (ds.Tables[0].Rows.Count == 0) { txtmaxcap.Text = ""; } else { DataRow dr = ds.Tables[0].Rows[0]; txtmaxcap.Text = dr["Godown_Capacity"].ToString(); } } GetCapGodown(); }
void GetCapGodown() { string gname = ddlgodown.SelectedValue; mobj = new MoveChallan(ComObj); string qrygdn = "SELECT Round(Sum(convert(decimal(18,5),Current_Balance)),5) as Current_Balance FROM dbo.issue_opening_balance where District_Id='" + did + "' and Depotid='" + gid + "' and Godown='" + gname + "'"; DataSet ds = mobj.selectAny(qrygdn); if (ds == null) { } else { if (ds.Tables[0].Rows.Count == 0) { txtcurntcap.Text = ""; } else { DataRow dr = ds.Tables[0].Rows[0]; txtcurntcap.Text = (CheckNull(dr["Current_Balance"].ToString())).ToString(); txtavalcap.Text = (System.Math.Round(CheckNull(txtmaxcap.Text) - CheckNull(txtcurntcap.Text), 5)).ToString(); } } }
void GetBalRQty() { if (ddlrackno.SelectedItem.Text == "--Select--") { } else { int month = int.Parse(DateTime.Today.Month.ToString()); int year = int.Parse(DateTime.Today.Year.ToString()); string rackno = txtrackno.Text; string ddidt = ddldistrict.SelectedValue; mobj = new MoveChallan(ComObj); string qreyrq = "select Sum(Disp_Qty) as Disp_Qty from dbo.Rack_Receipt_Details where district_code='" + distid + "' and Rack_No='" + rackno + "'"; DataSet ds = mobj.selectAny(qreyrq); if (ds.Tables[0].Rows.Count == 0) { } else { DataRow drs = ds.Tables[0].Rows[0]; string flag = ""; if (flag == drs["Disp_Qty"].ToString()) { txtissqty.Text = "0"; txtissqty.ReadOnly = true; } else { txtissqty.Text = drs["Disp_Qty"].ToString(); txtissqty.ReadOnly = true; } } } }
protected void dgridchallan_SelectedIndexChanged(object sender, EventArgs e) { string dispid = dgridchallan.SelectedRow.Cells[4].Text; Session["Dispatch"] = dispid; string tag = "Y"; mobj = new MoveChallan(ComObj); string qry = "SELECT IsDeposit FROM dbo.SCSC_Truck_challan where Dispatch_id='" + dispid + "'"; DataSet ds = mobj.selectAny(qry); DataRow dr = ds.Tables[0].Rows[0]; string st = dr["IsDeposit"].ToString().Trim(); if (st == tag) { lbldisp.Visible = true; lbldisp.Text = "Sorry You Can't Edit This Truck Challan ,It has been Diposited.."; Page.RegisterClientScriptBlock("mymsg3", "<script language=javascript> alert('Sorry You Can't Edit This RO ,It has been lifted'); </script> "); } else { Response.Redirect("../IssueCenter/TruckChallan_Edit.aspx"); } }
void GetChallan() { string mrack = txtrackno.Text; mobj = new MoveChallan(ComObj); string qry = "SELECT * FROM dbo.RR_receipt_Depot where district_code='" + distid + "'and Rack_No='" + mrack + "' and Challan_st='N'"; DataSet ds = mobj.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { ddlchallan.Items.Clear(); ListItem lst = new ListItem(); lst.Text = "Not Indicated"; lst.Value = "0"; ddlchallan.Items.Insert(0, "--Select--"); ddlchallan.Items.Insert(1, lst); } else { ddlchallan.Items.Clear(); ddlchallan.DataSource = ds.Tables[0]; ddlchallan.DataTextField = "TC_Number"; ddlchallan.DataValueField = "TC_Number"; ddlchallan.DataBind(); ddlchallan.Items.Insert(0, "--Select--"); ddlchallan.Items.Insert(1, "Not Indicated"); } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { mobj = new MoveChallan(ComObj); mobj.Depot_ID = sid; mobj.GatePass_id = gateno; //mobj.delete(); }
void GetData() { if (ddlrackno.SelectedItem.Text == "--Select--") { txtsrailh.Text = ""; txtdesrailh.Text = ""; ddlrackno.Focus(); } else { string rackno = ddlrackno.SelectedValue; mobj = new MoveChallan(ComObj); string qrey = "select tbl_Rail_Head.RailHead_Name ,RailHead_Dest.RailHead_Name as DestRName from dbo.tbl_RackMaster left join dbo.tbl_Rail_Head on tbl_RackMaster.RailHead=tbl_Rail_Head.RailHead_Code left join dbo.tbl_Rail_Head as RailHead_Dest on tbl_RackMaster.Dest_RailHead=RailHead_Dest.RailHead_Code where tbl_RackMaster.district_code='" + distid + "' and tbl_RackMaster.Rack_No=" + rackno; DataSet ds = mobj.selectAny(qrey); if (ds.Tables[0].Rows.Count == 0) { } else { DataRow drs = ds.Tables[0].Rows[0]; txtsrailh.Text = drs["RailHead_Name"].ToString(); txtdesrailh.Text = drs["DestRName"].ToString(); txtsrailh.ReadOnly = true; txtdesrailh.ReadOnly = true; } } }
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e) { string challan = GridView2.SelectedRow.Cells[1].Text; string rono = GridView2.SelectedRow.Cells[3].Text; mobj = new MoveChallan(ComObj); string qrychallan = "SELECT challan_no,challan_date,Commodity,Recieved_Bags,Recd_Qty,Moisture,WCM_no,Vehile_no,Category,Crop_year FROM dbo.tbl_Receipt_Details where Dist_Id='" + did + "'and Depot_ID='" + sid + "'and IsDeposit='N' and Challan_No='" + challan + "' and RO_No='" + rono + "'"; DataSet ds = mobj.selectAny(qrychallan); if (ds == null) { } else { DataRow dr = ds.Tables[0].Rows[0]; txtchallan.Text = dr["challan_no"].ToString(); txtwcm.Text = dr["WCM_no"].ToString(); txtmoisture.Text = dr["Moisture"].ToString(); txtqty.Text = dr["Recd_Qty"].ToString(); txtbags.Text = dr["Recieved_Bags"].ToString(); txttruckno.Text = dr["Vehile_no"].ToString(); } }
protected void ddlscheme_SelectedIndexChanged(object sender, EventArgs e) { string mcomid = ddlcomdty.SelectedValue; string mcatid = ddlcategory.SelectedValue; string mscheme = ddlscheme.SelectedValue; mobj1 = new MoveChallan(ComObj); string qry = "Select Current_Balance from dbo.issue_opening_balance where District_Id='" + did + "'and Depotid='" + sid + "'and Commodity_Id='" + mcomid + "'and Scheme_Id='" + mscheme + "'"; DataSet ds = mobj1.selectAny(qry); if (ds.Tables[0].Rows.Count == 0) { Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('There is No opening for selected Comodity/Scheme....'); </script> "); //lblbalanceqty.Visible = false; //txtbalqty.Visible = false; } else { DataRow dr = ds.Tables[0].Rows[0]; //txtbalqty.Text = dr["Current_Balance"].ToString(); //lblbalanceqty.Visible = true; //txtbalqty.Visible = true; //txtbalqty.BackColor = System.Drawing.Color.Wheat; //txtbalqty.ReadOnly = true; } }