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;
}
}
