public ICollection <Package> PackagesInCenter(int centerID)
{
// Reload the distribution center in case the supplied center is not associated with the current context
var center = DistributionCenters.Find(centerID);
var packages = from e in center.Packages
select e;
return(packages.ToList());
}
protected void Page_Load(object sender, EventArgs e)
{
ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString());
distobj = new DistributionCenters(ComObj);
if (!IsPostBack)
{
//fillgrid();
GetDist();
}
}
void GetDepot()
{
distobj = new DistributionCenters(ComObj);
string ord = "Districtid='23" + distid + "' order by DepotName";
DataSet ds = distobj.select(ord);
ddlissue.DataSource = ds.Tables[0];
ddlissue.DataTextField = "DepotName";
ddlissue.DataValueField = "DepotId";
ddlissue.DataBind();
ddlissue.Items.Insert(0, "--Select--");
}
//void GetDepot()
//{
// distobj = new DistributionCenters(ComObj);
// string ord = "Districtid='23" + distid + "' order by DepotName";
// DataSet ds = distobj.select(ord);
// ddlgodown.DataSource = ds.Tables[0];
// ddlgodown.DataTextField = "DepotName";
// ddlgodown.DataValueField = "DepotId";
// ddlgodown.DataBind();
// ddlgodown.Items.Insert(0, "--Select--");
//}
void GetAllDepot()
{
distobj = new DistributionCenters(ComObj);
string ordall = "Select DepotName,DepotId from dbo.tbl_MetaData_DEPOT Order by DepotName";
DataSet ds = distobj.selectAny(ordall);
ddlissuecenter.DataSource = ds.Tables[0];
ddlissuecenter.DataTextField = "DepotName";
ddlissuecenter.DataValueField = "DepotId";
ddlissuecenter.DataBind();
ddlissuecenter.Items.Insert(0, "--Select--");
}
void GetDCNameAll()
{
distobj = new DistributionCenters(ComObj);
string ord = "Select DepotName,DepotID from dbo.tbl_MetaData_DEPOT order by DepotName";
DataSet ds = distobj.selectAny(ord);
ddlissue.DataSource = ds.Tables[0];
ddlissue.DataTextField = "DepotName";
ddlissue.DataValueField = "DepotID";
ddlissue.DataBind();
ddlissue.Items.Insert(0, "--Select--");
// ddDistId.Items.Insert(0, "--चुनिये--");
}
protected void Page_Load(object sender, EventArgs e)
{
ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString());
distobj = new DistributionCenters(ComObj);
if (!IsPostBack)
{
GetCommodity();
bn_del.Visible = false;
GetDist();
}
}
void GetDCName()
{
//ddlissue.Items.Clear();
distobj = new DistributionCenters(ComObj);
string ord = "Select * from tbl_MetaData_Depot order by DepotName";
DataSet ds = distobj.selectAny(ord);
ddlissueCenter.DataSource = ds.Tables[0];
ddlissueCenter.DataTextField = "DepotName";
ddlissueCenter.DataValueField = "DepotID";
ddlissueCenter.DataBind();
// ddDistId.Items.Insert(0, "--चुनिये--");
}
void GetDCName()
{
distobj = new DistributionCenters(ComObj);
string ord = "Districtid='23" + ddldistrict.SelectedValue.ToString() + "' order by DepotName";
DataSet ds = distobj.select(ord);
ddlissue.DataSource = ds.Tables[0];
ddlissue.DataTextField = "DepotName";
ddlissue.DataValueField = "DepotID";
ddlissue.DataBind();
ddlissue.Items.Insert(0, "--Select--");
// ddDistId.Items.Insert(0, "--चुनिये--");
}
void GetPCName()
{
string distcode = ddldistrict.SelectedValue;
distobj = new DistributionCenters(ComObj);
string ord = "DistrictId='23" + ddldistrict.SelectedValue.ToString() + "' order by PcId";
DataSet ds = distobj.selectPC(ord);
ddlprocname.DataSource = ds.Tables[0];
ddlprocname.DataTextField = "PurchaseCenterName";
ddlprocname.DataValueField = "PcId";
ddlprocname.DataBind();
ddlprocname.Items.Insert(0, "--Select--");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["issue_id"] != null)
{
sid = Session["issue_id"].ToString();
did = Session["dist_id"].ToString();
txtqty.Attributes.Add("onkeypress", "return CheckIsNumeric(this)");
txtnobags.Attributes.Add("onkeypress", "return CheckIsNumeric(this)");
txtwcmno.Attributes.Add("onkeypress", "return CheckIsNumeric(this)");
txtmoisture.Attributes.Add("onkeypress", "return CheckIsNumeric(this)");
txtmoisture.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
txtchallan.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
txtqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
txtnobags.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
txtwcmno.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
btnadd.Attributes.Add("onclick", "window.open('GunnyBagsDetails.aspx',null,'left=300, top=10, height=400, width=580, status=n o, resizable= no, scrollbars= no, toolbar= no,location= no, menubar= no');");
ComObjWlC = new Common(ConfigurationManager.AppSettings["ConnectionWlc"].ToString());
ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString());
distobj = new DistributionCenters(ComObj);
if (!IsPostBack)
{
Transport();
GetScheme();
GetGunny();
GetCommodity();
GetCategory();
GetDist();
GetDCName();
GetRecdCategory();
GetSource();
//GetFCIdist();
GetDepositorType();
GetVehicleType();
}
}
else
{
Response.Redirect("~/MainLogin.aspx");
}
}
public void GetDCName()
{
try
{
distobj = new DistributionCenters(ComObj);
string ord = "Districtid='23" + ddldistrict.SelectedValue.ToString() + "' order by DepotName";
DataSet ds = distobj.select(ord);
ddlissuecenter.DataSource = ds.Tables[0];
ddlissuecenter.DataTextField = "DepotName";
ddlissuecenter.DataValueField = "DepotId";
ddlissuecenter.DataBind();
ddlissuecenter.Items.Insert(0, "--Select--");
}
catch (Exception)
{
}
}
void GetDCNameAll()
{
ddlissuename.Items.Clear();
distobj = new DistributionCenters(ComObj);
string getg = "Select * from tbl_MetaData_DEPOT order by DepotName";
//string ord = "Districtid='23" + ddldestdistrict.SelectedValue + "' order by DepotName";
DataSet ds = distobj.selectAny(getg);
ddlissuename.DataSource = ds.Tables[0];
ddlissuename.DataTextField = "DepotName";
ddlissuename.DataValueField = "DepotId";
ddlissuename.DataBind();
ddlissuename.Items.Insert(0, "--Select--");
// ddDistId.Items.Insert(0, "--चुनिये--");
}
void GetIssCName()
{
ddl_IC.Items.Clear();
distobj = new DistributionCenters(ComObj);
string ord = "Districtid='23" + ddl_dist.SelectedValue.ToString() + "' order by DepotName";
DataSet ds = distobj.select(ord);
if (ds == null)
{
}
else
{
ddl_IC.DataSource = ds.Tables[0];
ddl_IC.DataTextField = "DepotName";
ddl_IC.DataValueField = "DepotId";
ddl_IC.DataBind();
ddl_IC.Items.Insert(0, "--Select--");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["issue_id"] != null)
{
sid = Session["issue_id"].ToString();
did = Session["dist_id"].ToString();
ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString());
distobj = new DistributionCenters(ComObj);
if (!IsPostBack)
{
fillgrid();
GetSource();
}
}
else
{
Response.Redirect("~/MainLogin.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["dist_id"] != null)
{
distid = Session["dist_id"].ToString();
version = Session["hindi"].ToString();
txtroqty.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)");
txtrate.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)");
txtamount.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)");
txtchqamt.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)");
txtrodate.Attributes.Add("onkeypress", "return CheckCalDate(this)");
txtrovalidity.Attributes.Add("onkeypress", "return CheckCalDate(this)");
txtddate.Attributes.Add("onkeypress", "return CheckCalDate(this)");
txtroqty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txtroqty.Attributes.Add("onchange", "return chksqltxt(this),calcAmount();");
txtrodate.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txtrodate.Attributes.Add("onchange", "return chksqltxt(this)");
txtrovalidity.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txtrovalidity.Attributes.Add("onchange", "return chksqltxt(this)");
txtddate.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txtddate.Attributes.Add("onchange", "return chksqltxt(this)");
txtrono.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)");
txtrono.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txtrono.Attributes.Add("onchange", "return chksqltxt(this)");
txtrate.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)");
txtrate.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txtrate.Attributes.Add("onchange", "return chksqltxt(this)");
txtckeckno.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)");
txtckeckno.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txtckeckno.Attributes.Add("onchange", "return chksqltxt(this)");
txtchqamt.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)");
txtchqamt.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txtchqamt.Attributes.Add("onchange", "return chksqltxt(this)");
txtchqamt.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)");
txtremark.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)");
txtremark.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txtremark.Attributes.Add("onchange", "return chksqltxt(this)");
txtrono.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
txtroqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
txtrate.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
txtamount.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
txtckeckno.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
txtchqamt.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
txtalotqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
//string dbname = "Warehouse";
ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString());
//if (Session["dc_id"] != null)
//{
//}
distobj = new DistributionCenters(ComObj);
chk = new chksql();
ArrayList ctrllist = new ArrayList();
ctrllist.Add(txtrono.Text);
ctrllist.Add(txtrate.Text);
ctrllist.Add(txtckeckno.Text);
ctrllist.Add(txtchqamt.Text);
ctrllist.Add(txtremark.Text);
if (chk == null)
{
}
else
{
bool chkstr = chk.chksql_server(ctrllist);
if (chkstr == true)
{
Page.Server.Transfer(HttpContext.Current.Request.Path);
}
}
if (!IsPostBack)
{
txtddate.Text = DateTime.Today.Date.ToString("dd-MM-yyyy");
txtrovalidity.Text = DateTime.Today.Date.ToString("dd-MM-yyyy");
txtrodate.Text = DateTime.Today.Date.ToString("dd-MM-yyyy");
GetDist();
GetCommodity();
GetScheme();
GetName();
GetBank();
ddlallot_year.Items.Add((int.Parse(DateTime.Today.Year.ToString()) - 1).ToString());
ddlallot_year.Items.Add(DateTime.Today.Year.ToString());
ddlallot_year.SelectedIndex = 1;
ddlalotmm.SelectedIndex = DateTime.Today.Month - 1;
if (version == "H")
{
lblCommodity.Text = Resources.LocalizedText.lblCommodity;
lblScheme.Text = Resources.LocalizedText.lblScheme;
lblQuantity.Text = Resources.LocalizedText.lblQuantity;
lblReleaseOrder.Text = Resources.LocalizedText.lblDetailsofRO;
btnsave.Text = Resources.LocalizedText.btnsave;
btnclose.Text = Resources.LocalizedText.btnclose;
lblmonth.Text = Resources.LocalizedText.lblmonth;
lblyear.Text = Resources.LocalizedText.lblyear;
lblRateQuintal.Text = Resources.LocalizedText.lblRateQuintal;
lblPaymentMode.Text = Resources.LocalizedText.lblPaymentMode;
lblddchekno.Text = Resources.LocalizedText.lblddchekno;
lblddchekdate.Text = Resources.LocalizedText.lblddchekdate;
lblBankName.Text = Resources.LocalizedText.lblBankName;
lblamount.Text = Resources.LocalizedText.lblamount;
lblamountdd.Text = Resources.LocalizedText.lblamountdd;
lblforDist.Text = Resources.LocalizedText.lblforDist;
lblReleaseOrderDate.Text = Resources.LocalizedText.lblReleaseOrderDate;
lbldovalidity.Text = Resources.LocalizedText.lbldovalidity;
lblRemark.Text = Resources.LocalizedText.lblRemark;
lblReleaseOrderDate.Text = Resources.LocalizedText.lblReleaseOrderDate;
lblqty.Text = Resources.LocalizedText.lblqty;
lbl_balqty.Text = Resources.LocalizedText.lbl_balqty;
}
}
}
else
{
Response.Redirect("~/MainLogin.aspx");
}
}
public DistributionCenter GetDistributionCenter(int centerID)
{
var center = DistributionCenters.SingleOrDefault(DistributionCenter => DistributionCenter.DistributionCenterID == centerID);
return(center);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["st_id"] != null)
{
txtqty.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)");
txtqty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txtqty.Attributes.Add("onchange", "return chksqltxt(this)");
txtorderno.Attributes.Add("onkeypress", "return CheckIsNumeric(event,this)");
txtdate.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txtdate.Attributes.Add("onchange", "return chksqltxt(this)");
txtqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
txtrate.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString());
distobj = new DistributionCenters(ComObj);
chk = new chksql();
ArrayList ctrllist = new ArrayList();
ctrllist.Add(txtqty.Text);
ctrllist.Add(txtorderno.Text);
ctrllist.Add(txtdate.Text);
if (chk == null)
{
}
else
{
bool chkstr = chk.chksql_server(ctrllist);
if (chkstr == true)
{
Page.Server.Transfer(HttpContext.Current.Request.Path);
}
}
if (!IsPostBack)
{
GetDCName();
//GetZone();
//GetDist();
Getsupplier();
fillgrid();
}
}
else
{
Response.Redirect("~/MainLogin.aspx");
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
if (CheckNull(txtbalqty.Text) == 0)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('You have insufficient balance to transfer......'); </script> ");
}
else
{
if (ddlissue.SelectedValue == ddlissued.SelectedValue && ddlscheme.SelectedValue == ddlschemetrs.SelectedValue && ddlsarrival.SelectedValue == ddlarrivalsource.SelectedValue)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Source and Destination Information Should not be same......'); </script> ");
}
else
{
string mstate = "23";
string mcomid = ddlcomdty.SelectedValue;
string mscheme = ddlscheme.SelectedValue;
string mdscheme = ddlschemetrs.SelectedValue;
string msdist = ddldistrict.SelectedValue;
string msissue = ddlissue.SelectedValue;
string mddist = ddldistrictd.SelectedValue;
string mdissue = ddlissued.SelectedValue;
string issueid = ddlissue.SelectedValue;
string fromsrs = ddlsarrival.SelectedValue;
string tosrs = ddlarrivalsource.SelectedValue;
int mbagst = CheckNullInt(txtbags.Text);
string mgdn = ddlgodown.SelectedValue;
string ddate = "";
string udate = "";
int openqty = 0;
int openbag = 0;
int mmonth = int.Parse(DateTime.Today.Month.ToString());
int myear = int.Parse(DateTime.Today.Year.ToString());
float qty = CheckNull(txtqty.Text);
string ip = Request.ServerVariables["REMOTE_ADDR"].ToString();
string stdate = getDate_MDY(tx_stdate.Text);
string cdate = DateTime.Today.Date.ToString();
DateTime std = DateTime.Parse(getDate_MDY(tx_stdate.Text));
string opid = Session["OperatorId"].ToString();
string stm = std.Month.ToString();
string sty = std.Year.ToString();
if (ddlcomdty.SelectedItem.Text == "--Select--" || ddlscheme.SelectedItem.Text == "--Select--" || ddlschemetrs.SelectedItem.Text == "--Select--" || ddlarrivalsource.SelectedItem.Text == "--Select--" || ddlsarrival.SelectedItem.Text == "--Select--")
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Please Select Commodity/Scheme/Source of Arrival......'); </script> ");
}
else
{
string qrey = "insert into dbo.State_Scheme_Transfer(State_Id,District_Id,Depotid,Commodity_Id,S_Scheme_Id,D_District,D_Depot,D_Scheme_Id,Quantity,Month,Year,CreatedDate,UpdatedDate,DeletedDate,IP_Address,Bags,From_Source,To_Source,Godown,ST_Date,OperatorID) values('" + mstate + "','" + distid + "','" + sid + "','" + mcomid + "','" + mscheme + "','" + mddist + "','" + sid + "','" + mdscheme + "'," + qty + "," + stm + "," + sty + ",getdate(),'" + udate + "','" + ddate + "','" + ip + "'," + mbagst + ",'" + fromsrs + "','" + tosrs + "','" + mgdn + "','" + stdate + "','" + opid + "')";
cmd.CommandText = qrey;
cmd.Connection = con;
con.Open();
//SqlTransaction trns;
//trns = con.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted);
//cmd.Transaction = trns;
try
{
if (qty == 0)
{
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Quantity Should not be 0 ......'); </script> ");
}
else
{
//if (ddlscheme.SelectedValue == ddlschemetrs.SelectedValue)
//{
// Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Source and Destination Scheme Should not be Same ......'); </script> ");
//}
//else
//{
cmd.ExecuteNonQuery();
con.Close();
string qrystock = "select Sum(Quantity) as Qty from dbo.State_Scheme_Transfer where Commodity_Id='" + mcomid + "'and S_Scheme_Id='" + mscheme + "' and District_Id='" + distid + "'and Depotid='" + issueid + "' and Month=" + stm + "and Year=" + sty;
mobj = new MoveChallan(ComObj);
DataSet dspro = mobj.selectAny(qrystock);
if (dspro.Tables[0].Rows.Count == 0)
{
}
else
{
DataRow drop = dspro.Tables[0].Rows[0];
float mrothersch = CheckNull(drop["Qty"].ToString());
string qryinsopen = "select * from dbo.tbl_Stock_Registor where Commodity_Id ='" + mcomid + "' and Scheme_Id='" + mscheme + "' and DistrictId ='" + distid + "'and DepotID='" + sid + "'and Month=" + stm + "and Year=" + sty;
mobj = new MoveChallan(ComObj);
DataSet dsopen = mobj.selectAny(qryinsopen);
if (dsopen.Tables[0].Rows.Count == 0)
{
string chkopenss = "Select Round(convert(decimal(18,5),Sum(Current_Balance)),5) as Current_Balance from dbo.issue_opening_balance where District_Id='" + distid + "'and Depotid='" + sid + "'and Commodity_Id='" + mcomid + "'and Scheme_Id ='" + mscheme + "'";
mobj = new MoveChallan(ComObj);
DataSet dsqry = mobj.selectAny(chkopenss);
if (dsqry == null)
{
}
else
{
DataRow drss = dsqry.Tables[0].Rows[0];
decimal sropen = CheckNullDec(drss["Current_Balance"].ToString());
string qryinsr = "insert into dbo.tbl_Stock_Registor(DistrictId,DepotID,Commodity_ID,Scheme_ID,Opening_Balance,Recieved_Procure,Recieved_Otherg,Recieved_FCI,Received_OtherSch,Recieved_Other_Src,Received_RailHead,Received_CMR,Received_Levy,Sale_Do,Sale_otherg,Transfer_OtherSch,Month,Year,Remarks) Values('" + distid + "','" + sid + "','" + mcomid + "','" + mscheme + "'," + sropen + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + CheckNull(txtqty.Text) + "," + stm + "," + sty + ",'')";
cmd.CommandText = qryinsr;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
else
{
string qryinsU = "update dbo.tbl_Stock_Registor set Transfer_OtherSch=" + mrothersch + " where Commodity_Id ='" + mcomid + "'and Scheme_Id ='" + mscheme + "' and DistrictId='" + distid + "'and DepotID='" + issueid + "'and Month=" + stm + "and Year=" + sty;
cmd.CommandText = qryinsU;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
string qrystockd = "select Sum(Quantity) as Qty from dbo.State_Scheme_Transfer where Commodity_Id='" + mcomid + "'and D_Scheme_Id='" + mdscheme + "' and District_Id='" + distid + "'and Depotid='" + issueid + "' and Month=" + stm + "and Year=" + sty;
mobj = new MoveChallan(ComObj);
DataSet dsprod = mobj.selectAny(qrystockd);
if (dspro.Tables[0].Rows.Count == 0)
{
}
else
{
DataRow dropd = dspro.Tables[0].Rows[0];
float mrotherschd = CheckNull(drop["Qty"].ToString());
string qryinsopendes = "select * from dbo.tbl_Stock_Registor where Commodity_Id ='" + mcomid + "'and Scheme_ID='" + mdscheme + "' and DistrictId ='" + distid + "'and DepotID='" + sid + "'and Month=" + stm + "and Year=" + sty;
mobj = new MoveChallan(ComObj);
DataSet dsopends = mobj.selectAny(qryinsopendes);
if (dsopends.Tables[0].Rows.Count == 0)
{
string chkopenss = "Select Round(convert(decimal(18,5),Sum(Current_Balance)),5) as Current_Balance from dbo.issue_opening_balance where District_Id='" + distid + "'and Depotid='" + sid + "'and Commodity_Id='" + mcomid + "'and Scheme_Id ='" + mdscheme + "'";
mobj = new MoveChallan(ComObj);
DataSet dsqry = mobj.selectAny(chkopenss);
if (dsqry == null)
{
}
else
{
DataRow drss = dsqry.Tables[0].Rows[0];
decimal sropen = CheckNullDec(drss["Current_Balance"].ToString());
string qryinsr = "insert into dbo.tbl_Stock_Registor(DistrictId,DepotID,Commodity_ID,Scheme_ID,Opening_Balance,Recieved_Procure,Recieved_Otherg,Recieved_FCI,Received_OtherSch,Recieved_Other_Src,Received_RailHead,Received_CMR,Received_Levy,Sale_Do,Sale_otherg,Transfer_OtherSch,Month,Year,Remarks) Values('" + distid + "','" + sid + "','" + mcomid + "','" + mdscheme + "'," + sropen + "," + 0 + "," + 0 + "," + 0 + "," + CheckNull(txtqty.Text) + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + stm + "," + sty + ",'')";
cmd.CommandText = qryinsr;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
else
{
string qryinsUd = "update dbo.tbl_Stock_Registor set Received_OtherSch=" + mrothersch + " where Commodity_Id ='" + mcomid + "' and Scheme_Id='" + mdscheme + "'and DistrictId='" + distid + "'and DepotID='" + issueid + "'and Month=" + stm + "and Year=" + sty;
cmd.CommandText = qryinsUd;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
float tqty = CheckNull(txtqty.Text);
int mtbags = CheckNullInt(txtbags.Text);
string msource = ddlsarrival.SelectedValue;
string mgodown = ddlgodown.SelectedValue;
string uqry = "Update dbo.issue_opening_balance set Current_Balance=Round(convert(decimal(18,5),Current_Balance),5)-" + tqty + ",Current_Bags=Current_Bags-" + mtbags + " where District_Id='" + distid + "'and Depotid='" + sid + "'and Commodity_Id='" + mcomid + "'and Scheme_Id='" + mscheme + "' and Source ='" + msource + "' and Godown='" + mgodown + "'";
cmd.CommandText = uqry;
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
string mmsource = ddlarrivalsource.SelectedValue;
string chkopenbal = "Select * from dbo.issue_opening_balance where District_Id='" + distid + "'and Depotid='" + sid + "'and Commodity_Id='" + ddlcommodityd.SelectedValue.ToString() + "'and Scheme_Id='" + mdscheme + "' and Godown='" + mgodown + "' and Source='" + mmsource + "'";
distobj = new DistributionCenters(ComObj);
DataSet dsbal = distobj.selectAny(chkopenbal);
if (dsbal == null)
{
}
else
{
if (dsbal.Tables[0].Rows.Count == 0)
{
string qreyins = "insert into dbo.issue_opening_balance(State_Id,District_Id,Depotid,Commodity_Id,Scheme_Id,Category_Id,Godown,Crop_year,Bags,Quantity,Source,Current_Balance,Current_Bags,Month,Year,IP_Address,Stock_Date,CreatedDate,UpdatedDate,DeletedDate) values('" + mstate + "','" + distid + "','" + sid + "','" + ddlcommodityd.SelectedValue.ToString() + "','" + mdscheme + "','','" + mgodown + "',''," + openbag + "," + openqty + ",'" + mmsource + "'," + tqty + "," + mtbags + "," + mmonth + "," + myear + ",'" + ip + "',getdate(),getdate(),'" + udate + "','" + ddate + "'" + ")";
cmd.CommandText = qreyins;
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
else
{
float tqtyd = CheckNull(txtqty.Text);
int tbags = CheckNullInt(txtbags.Text);
string uqryd = "Update dbo.issue_opening_balance set Current_Balance=Round(convert(decimal(18,5),Current_Balance),5)+" + tqtyd + ",Current_Bags=Current_Bags+" + tbags + " where District_Id='" + distid + "'and Depotid='" + sid + "'and Commodity_Id='" + ddlcommodityd.SelectedValue.ToString() + "'and Scheme_Id='" + mdscheme + "' and Godown='" + mgodown + "' and Source='" + mmsource + "'";
cmd.CommandText = uqryd;
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
Page.RegisterClientScriptBlock("mymsg2", "<script language=javascript> alert('Data Transfer Successfully ......'); </script> ");
txtbalqty.ReadOnly = false;
//txtbalqty.Text = uqty.ToString();
//txtbalqtyd.ReadOnly = false;
//txtbalqtyd.Text = uqtyd.ToString();
btnsubmit.Enabled = false;
}
//trns.Commit();
}
catch (Exception ex)
{
//trns.Rollback();
Label1.Visible = true;
Label1.Text = ex.Message;
}
finally
{
con.Close();
ComObj.CloseConnection();
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["dist_id"] != null)
{
sid = Session["dist_id"].ToString();
//string dbname = "Warehouse";
txtqty.Attributes.Add("onkeypress", "return CheckIsNumeric(this)");
txtmobile.Attributes.Add("onkeypress", "return CheckIsNumeric(this)");
txtrate.Attributes.Add("onkeypress", "return CheckIsNumeric(this)");
txtqty.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txtqty.Attributes.Add("onchange", "return chksqltxt(this)");
txtmobile.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txtmobile.Attributes.Add("onchange", "return chksqltxt(this)");
txtrate.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txtrate.Attributes.Add("onchange", "return chksqltxt(this)");
txttname.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)");
txttname.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txttname.Attributes.Add("onchange", "return chksqltxt(this)");
txttadd.Attributes.Add("onkeypress", "return checksqlkey_gen(event,this)");
txttadd.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
txttadd.Attributes.Add("onchange", "return chksqltxt(this)");
DaintyDate1.Attributes.Add("onkeypress", "return CheckCalDate(this)");
DaintyDate1.Attributes.Add("onkeydown", "return checksqlkey_special(event,this);");
DaintyDate1.Attributes.Add("onchange", "return chksqltxt(this)");
txtmobile.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
txtqty.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
txtrate.Style["TEXT-ALIGN"] = TextAlign.Right.ToString();
ComObj = new Common(ConfigurationManager.AppSettings["ConnectionString"].ToString());
distobj = new DistributionCenters(ComObj);
chk = new chksql();
ArrayList ctrllist = new ArrayList();
ctrllist.Add(txtqty.Text);
ctrllist.Add(txtmobile.Text);
ctrllist.Add(txtrate.Text);
ctrllist.Add(txttname.Text);
ctrllist.Add(txttadd.Text);
ctrllist.Add(DaintyDate1.Text);
if (chk == null)
{
}
else
{
bool chkstr = chk.chksql_server(ctrllist);
if (chkstr == true)
{
Page.Server.Transfer(HttpContext.Current.Request.Path);
}
}
if (Page.IsPostBack == false)
{
Fillgrid();
GetTransportType();
GetDistance();
get_block();
lbl_block.Visible = false;
ddlBlock.Visible = false;
}
}
else
{
Response.Redirect("~/MainLogin.aspx");
}
}
void UpdateBalance()
{
string comdtyid = lblcomdty.Text;
string schemeid = lblsch.Text;
string source = "07";
string gdwn = ddlgodown.SelectedValue;
string mstate = "23";
int openbag = 0;
int openqty = 0;
int recdbags = CheckNullInt(txtrecdbaf.Text);
float recdqty = CheckNull(txtrecdqty.Text);
string ip = Request.ServerVariables["REMOTE_ADDR"].ToString();
int month = int.Parse(DateTime.Today.Month.ToString());
int year = int.Parse(DateTime.Today.Year.ToString());
string udate = "";
string ddate = "";
string qrystock = "select Sum(Recd_Qty) as Qty from dbo.RR_receipt_Depot where Commodity='" + comdtyid + "'and Scheme ='" + schemeid + "' and district_code='" + distid + "'and DepotID='" + sid + "' and Month=" + month + "and Year=" + year;
mobj = new MoveChallan(ComObj);
DataSet dspro = mobj.selectAny(qrystock);
if (dspro.Tables[0].Rows.Count == 0)
{
}
else
{
DataRow drop = dspro.Tables[0].Rows[0];
float mrod = CheckNull(drop["Qty"].ToString());
string qryinsopen = "select * from dbo.tbl_Stock_Registor where Commodity_Id ='" + comdtyid + "' and Scheme_ID='" + schemeid + "' and DistrictId ='" + distid + "'and DepotID='" + sid + "'and Month=" + month + "and Year=" + year;
mobj = new MoveChallan(ComObj);
DataSet dsopen = mobj.selectAny(qryinsopen);
if (dsopen.Tables[0].Rows.Count == 0)
{
string chkopenss = "Select Round(convert(decimal,Sum(Current_Balance)),5) as Current_Balance from dbo.issue_opening_balance where District_Id='" + distid + "'and Depotid='" + sid + "'and Commodity_Id='" + comdtyid + "'and Scheme_Id ='" + schemeid + "'";
mobj = new MoveChallan(ComObj);
DataSet dsqry = mobj.selectAny(chkopenss);
if (dsqry == null)
{
}
else
{
DataRow drss = dsqry.Tables[0].Rows[0];
float sropen = CheckNull(drss["Current_Balance"].ToString());
string qryinsr = "insert into dbo.tbl_Stock_Registor(DistrictId,DepotID,Commodity_ID,Scheme_ID,Opening_Balance,Recieved_Procure,Recieved_Otherg,Recieved_FCI,Received_OtherSch,Recieved_Other_Src,Received_RailHead,Received_CMR,Received_Levy,Sale_Do,Sale_otherg,Transfer_OtherSch,Month,Year,Remarks) Values('" + distid + "','" + sid + "','" + comdtyid + "','" + schemeid + "'," + sropen + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + CheckNull(txtrecdqty.Text) + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + month + "," + year + ",'')";
cmd.CommandText = qryinsr;
cmd.ExecuteNonQuery();
con.Close();
}
}
else
{
string qryinsU = "update dbo.tbl_Stock_Registor set Received_RailHead=" + mrod + " where Commodity_Id ='" + comdtyid + "' and Scheme_ID='" + schemeid + "'and DistrictId='" + distid + "'and DepotID='" + sid + "'and Month=" + month + "and Year=" + year;
cmd.CommandText = qryinsU;
cmd.ExecuteNonQuery();
con.Close();
}
}
string chkopenbal = "Select * from dbo.issue_opening_balance where District_Id='" + distid + "'and Depotid='" + sid + "'and Commodity_Id='" + comdtyid + "'and Scheme_Id='" + schemeid + "' and Godown='" + gdwn + "' and Source='" + source + "'";
//mobj = new MoveChallan(ComObj);
distobj = new DistributionCenters(ComObj);
DataSet dsbal = distobj.selectAny(chkopenbal);
if (dsbal == null)
{
}
else
{
if (dsbal.Tables[0].Rows.Count == 0)
{
string pdate = getDate_MDY("01/04/2011");
string qreyins = "insert into dbo.issue_opening_balance(State_Id,District_Id,Depotid,Commodity_Id,Scheme_Id,Category_Id,Godown,Crop_year,Bags,Quantity,Source,Current_Balance,Current_Bags,Month,Year,IP_Address,Stock_Date,CreatedDate,UpdatedDate,DeletedDate) values('" + mstate + "','" + distid + "','" + sid + "','" + comdtyid + "','" + schemeid + "','','" + gdwn + "',''," + openbag + "," + openqty + ",'" + source + "'," + recdqty + "," + recdbags + "," + month + "," + year + ",'" + ip + "','" + pdate + "',getdate(),'" + udate + "','" + ddate + "'" + ")";
cmd.CommandText = qreyins;
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
string qreygdnU = "update dbo.Current_Godown_Position set Current_Capacity=Current_Capacity-" + recdqty + ",Current_Bags=Current_Bags+" + recdbags + ",Current_Balance=Current_Balance+" + recdqty + " where District_Id='" + distid + "' and Depotid='" + sid + "' and Godown='" + gdwn + "'";
cmd.CommandText = qreygdnU;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
else
{
string mugdn = ddlgodown.SelectedValue;
string query = "Update dbo.issue_opening_balance set Current_Balance=Round(convert(decimal,Current_Balance),5)+" + recdqty + ",Current_Bags=Current_Bags+" + recdbags + " where District_Id='" + distid + "'and Depotid='" + sid + "'and Commodity_Id='" + comdtyid + "'and Scheme_Id='" + schemeid + "'and Source='" + source + "' and Godown='" + gdwn + "'";
cmd.CommandText = query;
cmd.Connection = con;
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
string qreygdnU = "update dbo.Current_Godown_Position set Current_Capacity=Current_Capacity-" + recdqty + ",Current_Bags=Current_Bags+" + recdbags + ",Current_Balance=Current_Balance+" + recdqty + " where District_Id='" + distid + "' and Depotid='" + sid + "' and Godown='" + gdwn + "'";
cmd.CommandText = qreygdnU;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
Label1.Text = ex.Message;
}
finally
{
con.Close();
}
}
}
}