protected void GVInfo_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
Label2.Visible = false;
LinkButton1.Visible = false;
lblmsg.Visible = false;;
btnapproval.Visible = true;
lblMessage2.Visible = false;
txtbox.Visible = true;
long k;
k = Convert.ToInt32(GVInfo.DataKeys[e.NewSelectedIndex].Value);
i = Convert.ToInt32(GVInfo.DataKeys[e.NewSelectedIndex].Value);
DataSet ds;
string qry = string.Format("SELECT nameofsubdivision,srchallanbookno,srchallanpageno,srchallandate,estimateno,contractorname,nameofestimate,stockitemyype,stockitemcode,stockitemname," +
" goodstype,unit,totalqtyestimate,qtydrawntilldate,qtyindented, recdempname,recdsdoname,lineid,linename,itemtypecode FROM stockissuetable " +
" where itxno={0} ", k);
ds = DBConnection.fillDataSet(qry);
if (ds.Tables[0].Rows.Count != 0)
{
txtsubdivison.Text = ds.Tables[0].Rows[0]["nameofsubdivision"].ToString();
ddestimate.SelectedItem.Text = ds.Tables[0].Rows[0]["nameofestimate"].ToString();
ddline.SelectedItem.Text = ds.Tables[0].Rows[0]["linename"].ToString();
ddgoodstype.SelectedItem.Text = ds.Tables[0].Rows[0]["goodstype"].ToString();
dditemname.Items.Clear();
dditemname.Items.Add(new ListItem(ds.Tables[0].Rows[0]["stockitemname"].ToString(), ds.Tables[0].Rows[0]["stockitemcode"].ToString()));
//dditemname.SelectedValue = ;
//dditemname.SelectedItem.Text = ds.Tables[0].Rows[0]["stockitemname"].ToString();
dditemtype.SelectedItem.Text = ds.Tables[0].Rows[0]["stockitemyype"].ToString();
//dditemtype.SelectedValue = ds.Tables[0].Rows[0]["itemtypecode"].ToString();
txtunit.Text = ds.Tables[0].Rows[0]["unit"].ToString();
txtqty.Text = ds.Tables[0].Rows[0]["totalqtyestimate"].ToString();
txtcontractor.Text = ds.Tables[0].Rows[0]["contractorname"].ToString();
txtje.Text = ds.Tables[0].Rows[0]["recdempname"].ToString();
txtsdo.Text = ds.Tables[0].Rows[0]["recdsdoname"].ToString();
txtqtydrwn.Text = ds.Tables[0].Rows[0]["qtydrawntilldate"].ToString();
txtsrbook.Text = ds.Tables[0].Rows[0]["srchallanbookno"].ToString();
txtsrpage.Text = ds.Tables[0].Rows[0]["srchallanpageno"].ToString();
txtsrdate.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["srchallandate"]).ToString("dd-MM-yyyy");
txtqtyindent.Text = ds.Tables[0].Rows[0]["qtyindented"].ToString();
txtquantitystore();
}
ds.Clear();
ds.Dispose();
// txtquantitystore();
string scmdText = "autovaluenew";
string[][] param = new string[][] { new string[] { "@iitemcode", dditemname.SelectedValue }
, new string[] { "@istorename", Session["StoreName"].ToString() }
, new string[] { "@goodstatus", ddgoodstype.SelectedItem.Text } };
DataTable dt = null;
dt = DBConnection1.executeProcedure(scmdText, param);
string temp = dt.Rows[0][0].ToString();
txtissuedvalue.Text = temp;
}
protected void GVInfo_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
lblmsg.Visible = false;
btndel.Visible = false;
btnapproval.Visible = true;
lblMessage2.Visible = false;
txtbox.Visible = true;
long k;
k = Convert.ToInt32(GVInfo.DataKeys[e.NewSelectedIndex].Value);
i = Convert.ToInt32(GVInfo.DataKeys[e.NewSelectedIndex].Value);
DataSet ds;
string qry = string.Format("SELECT rtxno,smonth,syear,scurdate,storename,grbookno,grpageno,grdate,stockstatus, " +
"lineid,linename,subdivid,subdiv,divid,division,firmid,firmname,pstclstore,goodstype, " +
"stockrecddate,stockinspectdate,storechallanno,srwchallanDate,pono,podate,grpid,grgrphead,subgrpid,grsubgrphead,itemno,itype,itemcode,itemname, " +
"unit,qtyrecd,qtyaccepted,rate,subtotal,edpercentage,cesspercentage,highereducesspercentage,total,cstvatpercentage,freight,insurance,field4,grandtotal, " +
"empcode,empname,desg,stockrole,username,field7,field2,estimateno,estid,grtime FROM stockreceipttable " +
" where rtxno={0} "
, k);
ds = DBConnection.fillDataSet(qry);
if (ds.Tables[0].Rows.Count != 0)
{
txtgrno.Text = ds.Tables[0].Rows[0]["grbookno"].ToString();
txtgrpageno.Text = ds.Tables[0].Rows[0]["grpageno"].ToString();
txtgrdate.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["grdate"]).ToString("dd-MM-yyyy");
Tr20.Visible = true;
Tr21.Visible = true;
Tr22.Visible = true;
ddline.SelectedItem.Text = ds.Tables[0].Rows[0]["linename"].ToString();
ddsubdiv.SelectedItem.Text = ds.Tables[0].Rows[0]["subdiv"].ToString();
dddiv.SelectedItem.Text = ds.Tables[0].Rows[0]["division"].ToString();
ddstatus.SelectedItem.Text = ds.Tables[0].Rows[0]["goodstype"].ToString();
txtreceiptdate.Text = ds.Tables[0].Rows[0]["stockrecddate"].ToString();
txtinspectdate.Text = ds.Tables[0].Rows[0]["stockinspectdate"].ToString();
txtsrwno.Text = ds.Tables[0].Rows[0]["storechallanno"].ToString();
txtsrwdate.Text = ds.Tables[0].Rows[0]["srwchallanDate"].ToString();
txtpono.Text = ds.Tables[0].Rows[0]["pono"].ToString();
txtpodate.Text = ds.Tables[0].Rows[0]["podate"].ToString();
// ddgrouphead.SelectedItem.Text = ds.Tables[0].Rows[0]["grgrphead"].ToString();
// ddsubgrp.SelectedItem.Text = ds.Tables[0].Rows[0]["grsubgrphead"].ToString();
dditemtype.SelectedItem.Text = ds.Tables[0].Rows[0]["itype"].ToString();
//dditemname.SelectedItem.Text = ds.Tables[0].Rows[0]["itemname"].ToString();
dditemname.Items.Clear();
dditemname.Items.Add(new ListItem(ds.Tables[0].Rows[0]["itemname"].ToString(), ds.Tables[0].Rows[0]["itemcode"].ToString()));
txtunit.Text = ds.Tables[0].Rows[0]["unit"].ToString();
txtrquantity.Text = ds.Tables[0].Rows[0]["qtyrecd"].ToString();
txtrvalue.Text = ds.Tables[0].Rows[0]["qtyaccepted"].ToString();
txtrate.Text = ds.Tables[0].Rows[0]["rate"].ToString();
txtsubtotal.Text = ds.Tables[0].Rows[0]["subtotal"].ToString();
txted.Text = ds.Tables[0].Rows[0]["edpercentage"].ToString();
txtcess.Text = ds.Tables[0].Rows[0]["cesspercentage"].ToString();
txtheducess.Text = ds.Tables[0].Rows[0]["highereducesspercentage"].ToString();
txttotal.Text = ds.Tables[0].Rows[0]["total"].ToString();
txtvat.Text = ds.Tables[0].Rows[0]["cstvatpercentage"].ToString();
txtfreight.Text = ds.Tables[0].Rows[0]["freight"].ToString();
txtprcvar.Text = ds.Tables[0].Rows[0]["field4"].ToString();
txtgrandtotal.Text = ds.Tables[0].Rows[0]["grandtotal"].ToString();
txtempcode.Text = ds.Tables[0].Rows[0]["empcode"].ToString();
txtempname.Text = ds.Tables[0].Rows[0]["empname"].ToString();
txtdesg.Text = ds.Tables[0].Rows[0]["desg"].ToString();
ddestimate.SelectedItem.Text = ds.Tables[0].Rows[0]["estimateno"].ToString();
txtgrno.Text = "";
txtgrpageno.Text = "";
txtgrdate.Text = "dd-mm-yyyy";
txtreceiptdate.Text = "dd-mm-yyyy";
txtinspectdate.Text = "dd-mm-yyyy";
}
ds.Clear();
ds.Dispose();
Proceed.Text = "Update";
can.Visible = false;
readonlytext();
grouphead();
subgrouphead();
string scmdText = "autovaluenew";
string[][] param = new string[][] { new string[] { "@iitemcode", dditemname.SelectedValue }
, new string[] { "@istorename", Session["StoreName"].ToString() }
, new string[] { "@goodstatus", ddstatus.SelectedItem.Text } };
DataTable dt = null;
dt = DBConnection1.executeProcedure(scmdText, param);
if (dt.Rows.Count > 0)
{
string temp = dt.Rows[0][0].ToString();
txtrate.Text = temp;
}
else
{
txtrate.Text = "0.000";
}
}