private void SetInitRow()
{
DataTable dt = new DataTable();
DataRow dr = null;
//dt.Columns.Add(new DataColumn("ITEMCODE", typeof(string)));
dt.Columns.Add(new DataColumn("ITEMNAME", typeof(string)));
dt.Columns.Add(new DataColumn("ITEM TYPE", typeof(string)));
dt.Columns.Add(new DataColumn("UNITS", typeof(string)));
dt.Columns.Add(new DataColumn("QTY", typeof(string)));
dt.Columns.Add(new DataColumn("SALERATE", typeof(string)));
dt.Columns.Add(new DataColumn("SALERETURN", typeof(string)));
dt.Columns.Add(new DataColumn("RECOVERY", typeof(string)));
dt.Columns.Add(new DataColumn("OUTSTANDING", typeof(string)));
dt.Columns.Add(new DataColumn("AMOUNT", typeof(string)));
dt.Columns.Add(new DataColumn("REMARKS", typeof(string)));
dt.Columns.Add(new DataColumn("ddsr", typeof(string)));
dr = dt.NewRow();
//dr["ITEMCODE"] = string.Empty;
dr["ITEMNAME"] = string.Empty;
dr["ITEM TYPE"] = string.Empty;
dr["UNITS"] = string.Empty;
dr["QTY"] = "0.00";
dr["SALERATE"] = "0.00";
dr["SALERETURN"] = "0.00";
dr["RECOVERY"] = "0.00";
dr["OUTSTANDING"] = "0.00";
dr["AMOUNT"] = "0.00";
dr["REMARKS"] = string.Empty;
dr["ddsr"] = "0.00";
dt.Rows.Add(dr);
//Store the DataTable in ViewState
ViewState["dt_adItm"] = dt;
GVPro1.DataSource = dt;
GVPro1.DataBind();
int rowIndex1 = 0;
LinkButton linkbtndel = (LinkButton)GVPro1.Rows[rowIndex1].Cells[0].FindControl("linkbtndel");
linkbtndel.Visible = false;
}
protected void GVPro1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
if (ViewState["dt_adItm"] != null)
{
DataTable dt = (DataTable)ViewState["dt_adItm"];
DataRow drCurrentRow = null;
int rowIndex = Convert.ToInt32(e.RowIndex);
if (dt.Rows.Count > 1)
{
dt.Rows.Remove(dt.Rows[rowIndex]);
drCurrentRow = dt.NewRow();
ViewState["dt_adItm"] = dt;
GVPro1.DataSource = dt;
GVPro1.DataBind();
SetPreRow();
//ptnSno();
}
}
}
protected void GVDSR_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
GridViewRow row;
//string PURID = GVDSR.DataKeys[row.RowIndex].Values[0].ToString();
if (e.CommandName == "Select")
{
row = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
string MDSRID = Server.HtmlDecode(GVDSR.Rows[row.RowIndex].Cells[0].Text.ToString());
string cmdtxt = "select tbl_Mdsr.CustomerID, CustomerName, replace(convert(NVARCHAR, dsrdat, 101), ' ', '/') as [dsrdat],tbl_Mdsr.dsrid from tbl_Mdsr inner join tbl_ddsr on " +
" tbl_Mdsr.dsrid = tbl_ddsr.dsrid inner join Customers_ on tbl_Mdsr.CustomerID = Customers_.CustomerID inner join Products on tbl_ddsr.ProductID = Products.ProductID " +
" where tbl_Mdsr.CompanyId = '" + Session["CompanyID"] + "' and tbl_Mdsr.BranchId= '" + Session["BranchID"] + "' and tbl_Mdsr.dsrid =" + MDSRID + "";
//string cmdtxt = " select a.mPurID, b.dPurId, b.mPurId, a.ven_id, a.VndrAdd, a.VndrCntct,a.PurNo, a.mPurDate, a.CreatedBy, a.CreatedAt, a.cnic, a.ntnno, a.tobePrntd,b.Dpurid, b.ProNam, b.ProDes, b.Qty, b.Total, b.subtotl, b.unit, b.cost, b.protyp,b.grossttal from MPurchase a inner join DPurchase b on a.mPurID = b.mPurID where a.MPurID =" + MPurID + "";
SqlCommand cmdSlct = new SqlCommand(cmdtxt, con);
SqlDataAdapter adp = new SqlDataAdapter(cmdSlct);
DataTable dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count > 0)
{
HFdsrID.Value = dt.Rows[0]["dsrid"].ToString();
TBdsrdat.Text = dt.Rows[0]["dsrdat"].ToString();
DDL_Cust.SelectedValue = dt.Rows[0]["CustomerID"].ToString();
string cmdDettxt = " select ddsr,'' as [ITEM TYPE],tbl_Ddsr.ProductID as [ITEMNAME],ProductName,untid as [UNITS],tbl_Ddsr.dsrid,Qty,Amt as [AMOUNT], salrat as [SALERATE],salrturn as [SALERETURN],recvry as [RECOVERY],outstan as [OUTSTANDING],ttlamt, '' as [AMOUNT],dsrrmk as[REMARKS] from tbl_Ddsr " +
" inner join tbl_Mdsr on tbl_Ddsr.dsrid = tbl_Mdsr.dsrid inner join Products on tbl_Ddsr.ProductID = Products.ProductID" +
" where tbl_Mdsr.CompanyId = '" + Session["CompanyID"] + "' and tbl_Mdsr.BranchId='" + Session["BranchID"] + "' and tbl_Ddsr.dsrid = " + MDSRID + "";
DataTable dt_Det = new DataTable();
dt_Det = DataAccess.DBConnection.GetDataTable(cmdDettxt);
if (dt_Det.Rows.Count > 0)
{
GVPro1.DataSource = dt_Det;
GVPro1.DataBind();
ViewState["dt_adItm"] = dt_Det;
for (int j = 0; j < dt_Det.Rows.Count; j++)
{
for (int i = 0; i < GVPro1.Rows.Count; i++)
{
Label lbl_pro = (Label)GVPro1.Rows[i].FindControl("lblPurItm");
DropDownList DDL_Itm = (DropDownList)GVPro1.Rows[i].FindControl("DDL_Itm");
Label lbl_unt = (Label)GVPro1.Rows[i].FindControl("lbl_unt");
DropDownList DDL_Unt = (DropDownList)GVPro1.Rows[i].FindControl("DDL_Unt");
Label HFDSR = (Label)GVPro1.Rows[i].FindControl("HFDSR");
Label lbl_Flag = (Label)GVPro1.Rows[i].FindControl("lbl_Flag");
TextBox TextBox1 = (TextBox)GVPro1.Rows[i].FindControl("TextBox1");
//lbl_pro.Text = dt_Det.Rows[j]["ITEMNAME"].ToString();
DDL_Itm.SelectedValue = lbl_pro.Text.Trim();
//lbl_unt.Text = dt_Det.Rows[j]["UNITS"].ToString();
DDL_Unt.SelectedValue = lbl_unt.Text.Trim();
TextBox1.Text = DDL_Itm.SelectedItem.Text; //dt_Det.Rows[j]["ProductName"].ToString();
//HiddenField HFDSR = (HiddenField)GVPro1.Rows[i].FindControl("HFDSR");
//HFDSR.Text = dt_Det.Rows[j]["ddsr"].ToString();
tbtotal.Text = dt_Det.Rows[j]["ttlamt"].ToString();
lbl_Flag.Text = "1";
btnUpd.Enabled = true;
}
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "isActive", "Alert();", true);
lblalert.Text = "No Record Found!!";
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "isActive", "Alert();", true);
lblalert.Text = ex.Message;
}
}
private void AddNewRow()
{
int rowIndex = 0;
if (ViewState["dt_adItm"] != null)
{
DataTable dt = (DataTable)ViewState["dt_adItm"];
DataRow drRow = null;
if (dt.Rows.Count > 0)
{
for (int i = 1; i <= dt.Rows.Count; i++)
{
//extract the Controls values
DropDownList DDL_Itm = (DropDownList)GVPro1.Rows[rowIndex].Cells[0].FindControl("DDL_Itm");
TextBox TextBox1 = (TextBox)GVPro1.Rows[rowIndex].Cells[0].FindControl("TextBox1");
DropDownList DDL_Itmtyp = (DropDownList)GVPro1.Rows[rowIndex].Cells[1].FindControl("DDL_Itmtyp");
DropDownList DDL_Unt = (DropDownList)GVPro1.Rows[rowIndex].Cells[2].FindControl("DDL_Unt");
TextBox TBQty = (TextBox)GVPro1.Rows[rowIndex].Cells[3].FindControl("TBQty");
TextBox TBSalRat = (TextBox)GVPro1.Rows[rowIndex].Cells[4].FindControl("TBSalRat");
TextBox TBSalRtrn = (TextBox)GVPro1.Rows[rowIndex].Cells[5].FindControl("TBSalRtrn");
TextBox TBRecy = (TextBox)GVPro1.Rows[rowIndex].Cells[6].FindControl("TBRecy");
TextBox lblOutstan = (TextBox)GVPro1.Rows[rowIndex].Cells[7].FindControl("lblOutstan");
TextBox TBAmt = (TextBox)GVPro1.Rows[rowIndex].Cells[8].FindControl("TBAmt");
TextBox TBRmk = (TextBox)GVPro1.Rows[rowIndex].Cells[9].FindControl("TBRmk");
//TextBox lblttl = (TextBox)GVPro1.Rows[rowIndex].Cells[8].FindControl("lblttl");
Label dsrid = (Label)GVPro1.FooterRow.Cells[10].FindControl("HFDSR");
LinkButton linkbtndel = (LinkButton)GVPro1.Rows[rowIndex].Cells[0].FindControl("linkbtndel");
linkbtndel.Visible = true;
drRow = dt.NewRow();
//dt.Rows[i - 1]["ITEMCODE"] = DDL_Unt.Text;
dt.Rows[i - 1]["ITEMNAME"] = DDL_Itm.SelectedValue;
TextBox1.Text = DDL_Itm.SelectedItem.Text;
dt.Rows[i - 1]["ITEM TYPE"] = DDL_Itmtyp.Text;
dt.Rows[i - 1]["UNITS"] = DDL_Unt.SelectedValue;
dt.Rows[i - 1]["QTY"] = TBQty.Text;
dt.Rows[i - 1]["SALERATE"] = TBSalRat.Text;
dt.Rows[i - 1]["SALERETURN"] = TBSalRtrn.Text;
dt.Rows[i - 1]["RECOVERY"] = TBRecy.Text;
dt.Rows[i - 1]["OUTSTANDING"] = lblOutstan.Text;
dt.Rows[i - 1]["AMOUNT"] = TBAmt.Text;
dt.Rows[i - 1]["REMARKS"] = TBRmk.Text;
//dt.Rows[i - 1]["ddsr"] = dsrid.Text;
rowIndex++;
//DDL_Unt.Focus();
}
dt.Rows.Add(drRow);
ViewState["dt_adItm"] = dt;
GVPro1.DataSource = dt;
GVPro1.DataBind();
}
}
else
{
Response.Write("ViewState is null");
}
//Set Previous Data on Postbacks
SetPreRow();
}
