void fillgrid()
{
mobj = new MoveChallan(ComObj);
string qry = "SELECT SCSC_Procurement.*,tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name,Society.Society_Name +','+ SocPlace +',' + Society_Id as PurchaseCenterName FROM dbo.SCSC_Procurement left join dbo.tbl_MetaData_STORAGE_COMMODITY on SCSC_Procurement.Commodity_Id=tbl_MetaData_STORAGE_COMMODITY .Commodity_Id left join dbo.Society on SCSC_Procurement.Purchase_Center= Society.Society_Id where IssueCenter_ID='" + sid + "' order by SCSC_Procurement.Recd_date desc";
DataSet ds = mobj.selectAny(qry);
if (ds.Tables[0].Rows.Count == 0)
{
Label1.Visible = true;
Label1.Text = "Currently no Record is present";
}
else
{
dgridchallan.DataSource = ds.Tables[0];
dgridchallan.DataBind();
}
}
void fillgrid()
{
mobj = new MoveChallan(ComObj);
string qry = "SELECT * FROM dbo.SCSC_Truck_challan where Dist_ID='" + distid + "' and Depot_Id='" + sid + "' and Challan_No not like '%NoChallan%' ";
DataSet ds = mobj.selectAny(qry);
if (ds.Tables[0].Rows.Count == 0)
{
lbldisp.Visible = true;
lbldisp.Text = "No Record Present";
}
else
{
dgridchallan.DataSource = ds.Tables[0];
dgridchallan.DataBind();
}
}
void GetName()
{
mobj = new MoveChallan(ComObj);
string qry1dt = "select district_name from pds.districtsmp where district_code='" + distid + "'";
DataSet ds1dt = mobj.selectAny(qry1dt);
DataRow dr1dt = ds1dt.Tables[0].Rows[0];
Label3.Text = dr1dt["district_name"].ToString();
mobj = new MoveChallan(ComObj);
string qryissue = "select DepotName from dbo.tbl_MetaData_DEPOT where DepotID='" + issueid + "'";
DataSet dsic = mobj.selectAny(qryissue);
DataRow dric = dsic.Tables[0].Rows[0];
Label4.Text = dric["DepotName"].ToString();
}
void GetBank()
{
mobj2 = new MoveChallan(ComObj);
string qrybank = "select Bank_ID,Bank_Name from dbo.Bank_Master where district_code='" + distid + "' and issueCenter_code='" + distid + "'";
DataSet dsb = mobj2.selectAny(qrybank);
ddlbankname.DataSource = dsb.Tables[0];
ddlbankname.DataTextField = "Bank_Name";
ddlbankname.DataValueField = "Bank_ID";
ddlbankname.DataBind();
ListItem lst = new ListItem();
lst.Text = "--Select--";
lst.Value = "NA";
ddlbankname.Items.Insert(0, lst);
}
void fillgrid()
{
mobj = new MoveChallan(ComObj);
string qry = "SELECT * FROM dbo.Lift_A_RO where Dist_Id='" + distid + "' and RO_No not like '%NoRO%'";
DataSet ds = mobj.selectAny(qry);
if (ds.Tables[0].Rows.Count == 0)
{
lbldisp.Visible = true;
lbldisp.Text = "Currently No Record Found";
}
else
{
dgridchallan.DataSource = ds.Tables[0];
dgridchallan.DataBind();
}
}
public void GetGodown()
{
try
{
mobj = new MoveChallan(ComObj);
string qry = "SELECT * FROM dbo.tbl_MetaData_GODOWN where DistrictId='" + distid + "' and DepotId='" + issueid + "' order by Godown_ID";
DataSet ds = mobj.selectAny(qry);
ddlgodown.DataSource = ds.Tables[0];
ddlgodown.DataTextField = "Godown_Name";
ddlgodown.DataValueField = "Godown_ID";
ddlgodown.DataBind();
ddlgodown.Items.Insert(0, "--Select--");
}
catch (Exception)
{
}
}
public void GetSource()
{
try
{
mobj = new MoveChallan(ComObj);
string qry = "SELECT * FROM dbo.Source_Arrival_Type order by Source_ID";
DataSet ds = mobj.selectAny(qry);
ddlsarrival.DataSource = ds.Tables[0];
ddlsarrival.DataTextField = "Source_Name";
ddlsarrival.DataValueField = "Source_ID";
ddlsarrival.DataBind();
ddlsarrival.Items.Insert(0, "--Select--");
}
catch (Exception)
{
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string mbankname = txtbankname.Text;
mobj = new MoveChallan(ComObj);
string qreygodn = "select * from dbo.Bank_Master where District_Code='" + distid + "'and issueCenter_code='" + issueid + "' and Bank_Name='" + mbankname + "'";
DataSet dsgodn = mobj.selectAny(qreygodn);
if (dsgodn == null)
{
}
else
{
if (dsgodn.Tables[0].Rows.Count == 0)
{
string bank_id = GridView1.SelectedRow.Cells[1].Text;
string bname = txtbankname.Text;
string Update = "Update dbo.Bank_Master set Bank_Name='" + bname + "'where District_Code='" + distid + "' and issueCenter_code='" + issueid + "'and Bank_ID='" + bank_id + "'";
cmd.Connection = con;
cmd.CommandText = Update;
try
{
con.Open();
cmd.ExecuteNonQuery();
Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Data Updated Successfully.....'); </script> ");
btnsubmit.Enabled = false;
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
finally
{
con.Close();
ComObj.CloseConnection();
}
}
else
{
Page.RegisterClientScriptBlock("mymsg1", "<script language=javascript> alert('Bank Name Already Exist.....'); </script> ");
btnupdate.Enabled = false;
}
}
}
protected void ddlStates_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlStates.SelectedItem.Text != "Madhya Pradesh")
{
ddldesdistt.DataSource = "";
ddldesdistt.DataBind();
mobj = new MoveChallan(ComObj);
string qrydist = "SELECT district_code,district_name FROM OtherState_DistrictCode where State_Id = '" + ddlStates.SelectedValue + "'";
DataSet dsd = mobj.selectAny(qrydist);
ddldesdistt.DataSource = dsd.Tables[0];
ddldesdistt.DataTextField = "district_name";
ddldesdistt.DataValueField = "district_code";
ddldesdistt.DataBind();
ddldesdistt.Items.Insert(0, "--Select--");
lblrailhead.Visible = true;
txtrailhead.Visible = true;
lblsenddist.Visible = false;
ddldesrailhead.Visible = false;
}
else
{
ddldesdistt.DataSource = "";
ddldesdistt.DataBind();
mobj = new MoveChallan(ComObj);
string qrydist = "select district_name,district_code from pds.districtsmp order by district_name ";
DataSet dsd = mobj.selectAny(qrydist);
ddldesdistt.DataSource = dsd.Tables[0];
ddldesdistt.DataTextField = "district_name";
ddldesdistt.DataValueField = "district_code";
ddldesdistt.DataBind();
ddldesdistt.Items.Insert(0, "--Select--");
lblrailhead.Visible = false;
txtrailhead.Visible = false;
lblsenddist.Visible = true;
ddldesrailhead.Visible = true;
}
}
void GetBalance()
{
string mcomdtyid = ddlcomdty.SelectedValue;
//string mcatid = ddlcategory.SelectedValue;
string mscheme = ddlscheme.SelectedValue;
string godown = ddlgodown.SelectedValue;
string msource = lblsource.Text;
mobj1 = new MoveChallan(ComObj);
string qry = "Select Round(Current_Balance,2) as Current_Balance,Current_Bags from dbo.issue_opening_balance where District_Id='" + distid + "'and Depotid='" + issueid + "'and Commodity_Id='" + mcomdtyid + "'and Scheme_Id='" + mscheme + "' and Godown='" + godown + "'and Source='" + msource + "'";
DataSet ds = mobj1.selectAny(qry);
if (ds == null)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('There is No opening for selected Comodity/Scheme....'); </script> ");
lblbqty.Visible = false;
txtbqty.Visible = false;
}
else
{
if (ds.Tables[0].Rows.Count == 0)
{
txtbqty.Text = "0";
txtcurbags.Text = "0";
lblbqty.Visible = true;
txtbqty.Visible = true;
txtbqty.BackColor = System.Drawing.Color.Wheat;
txtcurbags.Visible = true;
txtcurbags.BackColor = System.Drawing.Color.Wheat;
txtbqty.ReadOnly = true;
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
txtbqty.Text = dr["Current_Balance"].ToString();
txtcurbags.Text = dr["Current_Bags"].ToString();
lblbqty.Visible = true;
txtbqty.Visible = true;
txtbqty.BackColor = System.Drawing.Color.Wheat;
txtcurbags.Visible = true;
txtcurbags.BackColor = System.Drawing.Color.Wheat;
txtbqty.ReadOnly = true;
}
}
}
void GetRackDetails()
{
string qryr = "select Rack_Receipt_Bulk.Rack_No,Rack_Receipt_Bulk.district_code,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='" + txtrackno.Text + "'";
mobj = new MoveChallan(ComObj);
DataSet dsrac = mobj.selectAny(qryr);
if (dsrac == null)
{
}
else
{
if (dsrac.Tables[0].Rows.Count == 0)
{
lbltctrackno.Visible = true;
txtrackno.Visible = true;
ddldesrailhead.Enabled = true;
ddldesdistt.Enabled = true;
GetDist();
GetDestRH();
}
else
{
lbltctrackno.Visible = false;
txtrackno.Visible = false;
DataRow drrack = dsrac.Tables[0].Rows[0];
ddldesdistt.SelectedValue = drrack["district_code"].ToString();
ddldesdistt.Enabled = false;
mobj = new MoveChallan(ComObj);
string qrydrh = "select RailHead_Code,RailHead_Name from dbo.tbl_Rail_Head where district_code='" + drrack["district_code"].ToString() + "'";
DataSet dsdh = mobj.selectAny(qrydrh);
ddldesrailhead.DataSource = dsdh.Tables[0];
ddldesrailhead.DataTextField = "RailHead_Name";
ddldesrailhead.DataValueField = "RailHead_Code";
ddldesrailhead.DataBind();
ddldesrailhead.Items.Insert(0, "--Select--");
ddldesrailhead.SelectedValue = drrack["Recd_RailHead"].ToString();
ddldesrailhead.Enabled = false;
}
}
}
void GetSeason()
{
mobj = new MoveChallan(ComObj);
string qryms = "select * from dbo.Marketing_Season";
DataSet dsms = mobj.selectAny(qryms);
if (dsms == null)
{
}
else
{
ddlmseason.DataSource = dsms.Tables[0];
ddlmseason.DataTextField = "Season_Name";
ddlmseason.DataValueField = "Season_Id";
ddlmseason.DataBind();
ddlmseason.Items.Insert(0, "--Select--");
}
}
void GetSource()
{
mobj = new MoveChallan(ComObj);
string qrygs = "SELECT * FROM dbo.Source_Arrival_Type where Source_Id in (01,03) order by Source_ID";
DataSet ds = mobj.selectAny(qrygs);
if (ds == null)
{
}
else
{
ddlsource.DataSource = ds.Tables[0];
ddlsource.DataTextField = "Source_Name";
ddlsource.DataValueField = "Source_ID";
ddlsource.DataBind();
ddlsource.Items.Insert(0, "--Select--");
}
}
void GetScheme()
{
mobj = new MoveChallan(ComObj);
string qrysch = "SELECT * FROM dbo.Purchase_Pool Order By Scheme_ID";
DataSet ds = mobj.selectAny(qrysch);
if (ds == null)
{
}
else
{
ddlscheme.DataSource = ds.Tables[0];
ddlscheme.DataTextField = "Scheme_Name";
ddlscheme.DataValueField = "Scheme_Id";
ddlscheme.DataBind();
ddlscheme.Items.Insert(0, "--Select--");
}
}
void GetState()
{
mobj = new MoveChallan(ComObj);
string qryms = "select * from dbo.State_Master order by State_Name ";
DataSet dsms = mobj.selectAny(qryms);
if (dsms == null)
{
}
else
{
ddlstate.DataSource = dsms.Tables[0];
ddlstate.DataTextField = "State_Name";
ddlstate.DataValueField = "State_Code";
ddlstate.DataBind();
ddlstate.Items.Insert(0, "--Select--");
}
}
void GetDispatchType()
{
mobj = new MoveChallan(ComObj);
string qryd = "SELECT * FROM DispatchType";
DataSet dsd = mobj.selectAny(qryd);
if (dsd.Tables[0].Rows.Count == 0)
{
}
else
{
ddldispatchtype.DataSource = dsd.Tables[0];
ddldispatchtype.DataTextField = "DispatchName";
ddldispatchtype.DataValueField = "DispatchId";
ddldispatchtype.DataBind();
}
}
void GetRackRecdQty()
{
mobj = new MoveChallan(ComObj);
string qreyrq = "select Rack_RecdQty,Rack_Qty,Rack_RecdDate from dbo.Rack_Receipt_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];
txtrackqty.Text = drs["Rack_Qty"].ToString();
txtrecdqty.Text = drs["Rack_RecdQty"].ToString();
DaintyDate1.Text = getdate(drs["Rack_RecdDate"].ToString());
txtissqty.ReadOnly = true;
}
}
protected void Button6_Click(object sender, EventArgs e)
{
string comdty = ddlcomdty.SelectedValue;
string scheme = ddlscheme.SelectedValue;
string distid = ddldistrict.SelectedValue;
string issueid = ddlissue.SelectedValue;
string source = ddlsarrival.SelectedValue;
int mmonth = int.Parse(ddl_allot_month.SelectedValue);
int myear = int.Parse(ddd_allot_year.SelectedValue);
string qrystock = "select Sum(Quantity) as Qty from dbo.State_Scheme_Transfer where Commodity_Id='" + comdty + "'and S_Scheme_Id='" + scheme + "' and District_Id='" + distid + "'and Depotid='" + issueid + "' and Month=" + mmonth + "and Year=" + myear;
mobj = new MoveChallan(ComObj);
DataSet dspro = mobj.selectAny(qrystock);
if (dspro.Tables[0].Rows.Count == 0)
{
txtgetscheme.Text = "0";
}
else
{
DataRow drop = dspro.Tables[0].Rows[0];
txtgetscheme.Text = CheckNull(drop["Qty"].ToString()).ToString();
}
////
string qrystockdest = "select Sum(Quantity) as Qty from dbo.State_Scheme_Transfer where Commodity_Id='" + comdty + "'and D_Scheme_Id='" + scheme + "' and District_Id='" + distid + "'and Depotid='" + issueid + "' and Month=" + mmonth + "and Year=" + myear;
mobj = new MoveChallan(ComObj);
DataSet dsprod = mobj.selectAny(qrystockdest);
if (dspro.Tables[0].Rows.Count == 0)
{
txtrecdScheme.Text = "0";
}
else
{
DataRow drop = dsprod.Tables[0].Rows[0];
txtrecdScheme.Text = CheckNull(drop["Qty"].ToString()).ToString();
}
}
protected void ddlstate_SelectedIndexChanged(object sender, EventArgs e)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
if (ddlstate.SelectedItem.Text != "Madhya Pradesh")
{
ddldistrict.DataSource = "";
ddldistrict.DataBind();
mobj = new MoveChallan(ComObj);
string qrydist = "SELECT district_code,district_name FROM OtherState_DistrictCode where State_Id = '" + ddlstate.SelectedValue + "'";
DataSet dsd = mobj.selectAny(qrydist);
ddldistrict.DataSource = dsd.Tables[0];
ddldistrict.DataTextField = "district_name";
ddldistrict.DataValueField = "district_code";
ddldistrict.DataBind();
ddldistrict.Items.Insert(0, "--Select--");
}
else
{
ddldistrict.DataSource = "";
ddldistrict.DataBind();
mobj = new MoveChallan(ComObj);
string qrydist = "select district_name,district_code from pds.districtsmp order by district_name ";
DataSet dsd = mobj.selectAny(qrydist);
ddldistrict.DataSource = dsd.Tables[0];
ddldistrict.DataTextField = "district_name";
ddldistrict.DataValueField = "district_code";
ddldistrict.DataBind();
ddldistrict.Items.Insert(0, "--Select--");
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
void fillgrid()
{
mobj = new MoveChallan(ComObj);
string qry = "SELECT RO_of_FCI.*,districtsmp.district_name from dbo.RO_of_FCI left join pds.districtsmp on RO_of_FCI.Distt_Id=districtsmp.district_code where RO_of_FCI.IsExpire='Y' and RO_of_FCI.Distt_Id='" + distid + "' and RO_of_FCI.RO_No='" + rono + "'";
DataSet ds = mobj.selectAny(qry);
if (ds.Tables[0].Rows.Count == 0)
{
lblmsg.Visible = true;
lblmsg.Text = "No Record Present Currently";
}
else
{
lblmsg.Visible = false;
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
GridView1.Columns[0].Visible = false;
}
}
void GetRack()
{
//int month = int.Parse(DateTime.Today.Month.ToString());
//int year = int.Parse(DateTime.Today.Year.ToString());
//ddlrackno.Items.Insert(0, "--Select--");
//string qreyrac = "select Rack_No from dbo.Rake_Master_Sugar where Dest_District='" + distid + "'";
//cmd.Connection = con;
//cmd.CommandText = qreyrac;
//con.Open();
//dr = cmd.ExecuteReader();
//while (dr.Read())
//{
// ddlrackno.Items.Add(dr["Rack_No"].ToString());
//}
//dr.Close();
//con.Close();
mobj = new MoveChallan(ComObj);
string qreyrac = "select Rack_No from dbo.Rake_Master_Sugar where district_code='" + distid + "' and Mode='S'";
DataSet ds = mobj.selectAny(qreyrac);
if (ds.Tables[0].Rows.Count == 0)
{
ddlrackno.Items.Clear();
ListItem lst = new ListItem();
lst.Text = "Not Indicated";
lst.Value = "0";
ddlrackno.Items.Insert(0, "--Select--");
ddlrackno.Items.Insert(1, lst);
}
else
{
ddlrackno.Items.Clear();
ddlrackno.DataSource = ds.Tables[0];
ddlrackno.DataTextField = "Rack_No";
ddlrackno.DataValueField = "Rack_No";
ddlrackno.DataBind();
ddlrackno.Items.Insert(0, "--Select--");
ddlrackno.Items.Insert(1, "Not Indicated");
}
}
void GetFactory()
{
string st = ddlstate.SelectedValue;
mobj = new MoveChallan(ComObj);
string qryms = "select distinct(Factory_Code) as Factory_Code,Factory_Name from dbo.Sugar_Places where State_code=" + st + " and Place_code='" + ddlplace.SelectedValue + "' order by Factory_Name";
DataSet dsms = mobj.selectAny(qryms);
if (dsms == null)
{
}
else
{
ddlfactory.DataSource = dsms.Tables[0];
ddlfactory.DataTextField = "Factory_Name";
ddlfactory.DataValueField = "Factory_Code";
ddlfactory.DataBind();
ddlfactory.Items.Insert(0, "--Select--");
}
}
void fillgrid(string qry)
{
string logtype = ddllogintype.SelectedValue;
mobj = new MoveChallan(ComObj);
//string qry = "SELECT User_LogTime.user_id,User_LogTime.IP_Address,User_LogTime.Login_Date, User_LogTime.Login_Time, User_LogTime.Logout_Time, User_LogTime.offline,tbl_MetaData_DEPOT.DepotName FROM User_LogTime Left JOIN tbl_MetaData_DEPOT ON User_LogTime.user_id = tbl_MetaData_DEPOT.DepotID where Login_Date>='" + fromdae + "'and Login_Date <='" + todate + "'and User_LogTime.Login_Type='" + logtype + "' order by User_LogTime.offline";
DataSet ds = mobj.selectAny(qry);
if (ds.Tables[0].Rows.Count == 0)
{
lblmsg.Visible = true;
lblmsg.Text = "No Record Present Currently";
}
else
{
lblmsg.Visible = false;
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
void fillgridProc()
{
string did = ddl_dist.SelectedValue;
string sid = ddl_IC.SelectedValue;
string gid = ddlgodown.SelectedValue;
mobj = new MoveChallan(ComObj);
string qry = "SELECT SCSC_Procurement.*, tbl_MetaData_GODOWN.Godown_Name as Godown_Name, tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name,tbl_MetaData_Purchase_Center.PurchaseCenterName FROM dbo.SCSC_Procurement left join tbl_MetaData_GODOWN on SCSC_Procurement.Recd_Godown=tbl_MetaData_GODOWN.Godown_ID left join dbo.tbl_MetaData_STORAGE_COMMODITY on SCSC_Procurement.Commodity_Id=tbl_MetaData_STORAGE_COMMODITY .Commodity_Id left join dbo.tbl_MetaData_Purchase_Center on SCSC_Procurement.Purchase_Center=tbl_MetaData_Purchase_Center.PcId where Distt_ID='" + did + "' and IssueCenter_ID='" + sid + "' and Recd_Godown='" + gid + "' order by SCSC_Procurement.Recd_date desc";
DataSet ds = mobj.selectAny(qry);
if (ds.Tables[0].Rows.Count > 0)
{
dgrid_Proc.DataSource = ds.Tables[0];
dgrid_Proc.DataBind();
}
else
{
dgrid_Proc.DataSource = null;
dgrid_Proc.DataBind();
}
}
void fillgrid()
{
con.Open();
mobj = new MoveChallan(ComObj);
string qry = "SELECT SCSC_Procurement.*,tbl_MetaData_GODOWN.Godown_Name,tbl_MetaData_DEPOT.DepotName, tbl_MetaData_STORAGE_COMMODITY .Commodity_Name as Commodity_Name,Society.Society_Name +','+ SocPlace +',' + Society_Id as PurchaseCenterName FROM dbo.SCSC_Procurement left join dbo.tbl_MetaData_STORAGE_COMMODITY on SCSC_Procurement.Commodity_Id=tbl_MetaData_STORAGE_COMMODITY .Commodity_Id left join dbo.Society on SCSC_Procurement.Purchase_Center= Society.Society_Id inner join tbl_MetaData_DEPOT on SCSC_Procurement.IssueCenter_ID=tbl_MetaData_DEPOT.DepotID left join tbl_MetaData_GODOWN on tbl_MetaData_GODOWN.Godown_ID=SCSC_Procurement.Recd_Godown where TC_Number='" + txt_tcno.Text.Trim() + "' and Purchase_Center ='" + ddl_purchasecentre.SelectedValue.ToString() + "' order by SCSC_Procurement.Recd_date desc";
DataSet ds = mobj.selectAny(qry);
if (ds.Tables[0].Rows.Count == 0)
{
Label1.Visible = true;
Label1.Text = "Currently no Record is present";
dgridchallan.DataBind();
}
else
{
Label1.Visible = false;
dgridchallan.DataSource = ds.Tables[0];
dgridchallan.DataBind();
}
con.Close();
}
void getsweepageCategory()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
mobj = new MoveChallan(ComObj);
string qry = "SELECT * FROM dbo.tbl_sweepage_CATEGORY ";
DataSet ds = mobj.selectAny(qry);
ddlcataegory.DataSource = ds.Tables[0];
ddlcataegory.DataTextField = "Category_Name";
ddlcataegory.DataValueField = "Category_Id";
ddlcataegory.DataBind();
ddlcataegory.Items.Insert(0, "--Select--");
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
void GetICenter()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
mobj = new MoveChallan(ComObj);
string qry = "SELECT * FROM dbo.tbl_MetaData_DEPOT where DistrictId = '23" + distid + "' order by DepotID ";
DataSet ds = mobj.selectAny(qry);
ddlissuecenter.DataSource = ds.Tables[0];
ddlissuecenter.DataTextField = "DepotName";
ddlissuecenter.DataValueField = "DepotID";
ddlissuecenter.DataBind();
ddlissuecenter.Items.Insert(0, "--Select--");
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
void fillgrid()
{
string date = DateTime.Today.Date.ToString("MM/dd/yyyy");
mobj = new MoveChallan(ComObj);
string qry = "SELECT RO_of_FCI.*,districtsmp.district_name from dbo.RO_of_FCI left join pds.districtsmp on RO_of_FCI.Distt_Id=districtsmp.district_code where RO_of_FCI.RO_Validity <'" + date + "' and RO_of_FCI.Distt_Id='" + distid + "' and RO_of_FCI.RO_No <> 'NoRO' order by RO_of_FCI.RO_date Desc";
DataSet ds = mobj.selectAny(qry);
if (ds.Tables[0].Rows.Count == 0)
{
lblmsg.Visible = true;
lblmsg.Text = "No Record Present Currently";
}
else
{
lblmsg.Visible = false;
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
//GridView1.Columns[0].Visible = false;
}
}
void GetGodown()
{
mobj = new MoveChallan(ComObj);
string qry = "SELECT * FROM dbo.tbl_MetaData_GODOWN where DistrictId='" + ddl_dist.SelectedValue + "' and DepotId='" + ddl_IC.SelectedValue + "' order by Godown_ID";
DataSet ds = mobj.selectAny(qry);
ddlgodown.DataSource = ds.Tables[0];
if (ds.Tables[0].Rows.Count > 0)
{
ddlgodown.DataTextField = "Godown_Name";
ddlgodown.DataValueField = "Godown_ID";
ddlgodown.DataBind();
ddlgodown.Items.Insert(0, "--Select--");
}
else
{
ddlgodown.Items.Clear();
ddlgodown.DataValueField = null;
ddlgodown.DataBind();
}
}
void fillGrid()
{
string depoid = ddlissueCenter.SelectedValue;
string qrychk = "select issue_opening_balance.* ,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.Depotid='" + depoid + "'";
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;
}
}