protected void GV_POS_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; GV_POS.DataSource = dt; GV_POS.DataBind(); SetPreRowitm(); float GTotal = 0; for (int j = 0; j < GV_POS.Rows.Count; j++) { Label lblttl = (Label)GV_POS.Rows[j].FindControl("lblttl"); GTotal += Convert.ToSingle(lblttl.Text); } TBTtl.Text = GTotal.ToString(); ptnSno(); } } }
private void SetInitRowPuritm() { DataTable dt = new DataTable(); DataRow dr = null; dt.Columns.Add(new DataColumn("Items", typeof(string))); dt.Columns.Add(new DataColumn("Itempric", typeof(string))); dt.Columns.Add(new DataColumn("QTY", typeof(string))); dt.Columns.Add(new DataColumn("Itemcat", typeof(string))); dt.Columns.Add(new DataColumn("TTL", typeof(string))); dt.Columns.Add(new DataColumn("Dposid", typeof(string))); dt.Columns.Add(new DataColumn("ProductID", typeof(string))); dt.Columns.Add(new DataColumn("ProductTypeID", typeof(string))); dr = dt.NewRow(); dr["Items"] = string.Empty; dr["Itempric"] = "0.00"; dr["QTY"] = "0.00"; dr["Itemcat"] = string.Empty; dr["TTL"] = "0.00"; dr["Dposid"] = string.Empty; dr["ProductID"] = string.Empty; dr["ProductTypeID"] = string.Empty; dt.Rows.Add(dr); //Store the DataTable in ViewState ViewState["dt_adItm"] = dt; GV_POS.DataSource = dt; GV_POS.DataBind(); }
protected void TBPos_TextChanged(object sender, EventArgs e) { try { string query = " select tbl_MPos.Mposid,tbl_DPos.ProductID,ProductName as [Items],grntttl,tbl_MPos.CustomerName, " + " Cost as [Itempric],tbl_DPos.ProQty as [Qty],tbl_MPos.BillNO,custtyp, " + " Products.ProductTypeID,ProductTypeName as [Itemcat],tbl_DPos.Ttl as [TTL],Dposid " + " from tbl_MPos inner join tbl_DPos on tbl_MPos.Mposid = tbl_DPos.Mposid " + //" inner join Customers_ on tbl_MPos.CustomerName= Customers_.CustomerName " + " inner join Products on tbl_DPos.ProductID = Products.ProductID " + " inner join tbl_producttype on Products.ProductTypeID = tbl_producttype.ProductTypeID " + " where tbl_MPos.BillNO = '" + TBPos.Text.Trim() + "'"; SqlCommand cmd = new SqlCommand(query, con); DataTable dt_ = new DataTable(); SqlDataAdapter adp = new SqlDataAdapter(cmd); adp.Fill(dt_); if (dt_.Rows.Count > 0) { ddl_custtyp.SelectedValue = dt_.Rows[0]["custtyp"].ToString(); TBCust.Text = dt_.Rows[0]["CustomerName"].ToString(); lblbilno.Text = dt_.Rows[0]["BillNO"].ToString(); TBTtl.Text = dt_.Rows[0]["grntttl"].ToString(); POSID.Value = dt_.Rows[0]["Mposid"].ToString(); GV_POS.DataSource = dt_; GV_POS.DataBind(); ViewState["dt_adItm"] = dt_; } else { ddl_custtyp.SelectedValue = "0"; TBCust.Text = ""; lblbilno.Text = ""; DataTable d = new DataTable(); GV_POS.DataSource = d; GV_POS.DataBind(); } }catch (Exception ex) { throw ex; } }
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 TextBox values TextBox TBItms = (TextBox)GV_POS.Rows[rowIndex].Cells[0].FindControl("TBItms"); Label lblItmpris = (Label)GV_POS.Rows[rowIndex].Cells[1].FindControl("lblItmpris"); TextBox TBItmQty = (TextBox)GV_POS.Rows[rowIndex].Cells[2].FindControl("TBItmQty"); Label lblcat = (Label)GV_POS.Rows[rowIndex].Cells[3].FindControl("lblcat"); Label lblttl = (Label)GV_POS.Rows[rowIndex].Cells[4].FindControl("lblttl"); HiddenField HFDSal = (HiddenField)GV_POS.Rows[rowIndex].Cells[5].FindControl("HFDSal"); HiddenField HFPROID = (HiddenField)GV_POS.Rows[rowIndex].Cells[0].FindControl("PROID"); HiddenField HFPROCATID = (HiddenField)GV_POS.Rows[rowIndex].Cells[3].FindControl("PROCATID"); drRow = dt.NewRow(); dt.Rows[i - 1]["Items"] = TBItms.Text; dt.Rows[i - 1]["Itempric"] = lblItmpris.Text; dt.Rows[i - 1]["QTY"] = TBItmQty.Text; dt.Rows[i - 1]["Itemcat"] = lblcat.Text; dt.Rows[i - 1]["TTL"] = lblttl.Text; dt.Rows[i - 1]["Dposid"] = HFDSal.Value; dt.Rows[i - 1]["ProductID"] = HFPROID.Value; dt.Rows[i - 1]["ProductTypeID"] = HFPROCATID.Value; rowIndex++; float GTotal = 0, CRAmt = 0, DBAmt = 0; for (int j = 0; j < GV_POS.Rows.Count; j++) { Label total = (Label)GV_POS.Rows[j].FindControl("lblttl"); //TextBox CRAmtttl = (TextBox)GV_POS.Rows[j].FindControl("Tbcramt"); //TextBox DBAmtttl = (TextBox)GV_POS.Rows[j].FindControl("Tbdbamt"); GTotal += Convert.ToSingle(total.Text); /*if (CRAmtttl.Text != "0.00" || DBAmtttl.Text != "0.00") * { * CRAmt += Convert.ToSingle(CRAmtttl.Text); * DBAmt += Convert.ToSingle(DBAmtttl.Text); * }*/ TBTtl.Text = GTotal.ToString(); } //TBGrssTotal.Text = GTotal.ToString(); //TBTtl.Text = GTotal.ToString(); //if (DDL_Paytyp.SelectedValue == "2") //{ // TB_ChqAmt.Text = TBTtl.Text; // TB_ChqAmt.Enabled = false; //} //else //{ // TB_CshAmt.Text = TBTtl.Text; // TB_CshAmt.Enabled = false; //} //TBCRAmtttl.Text = CRAmt.ToString(); //Customersttl.Text = DBAmt.ToString(); //ddlPurItm.Focus(); } dt.Rows.Add(drRow); ViewState["dt_adItm"] = dt; GV_POS.DataSource = dt; GV_POS.DataBind(); } } else { Response.Write("ViewState is null"); } //Set Previous Data on Postbacks SetPreRowitm(); }
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 TextBox value TextBox TBItms = (TextBox)GV_POS.Rows[rowIndex].Cells[0].FindControl("TBItms"); HiddenField HFPROID = (HiddenField)GV_POS.Rows[rowIndex].Cells[0].FindControl("PROID"); Label PROTYPID = (Label)GV_POS.Rows[rowIndex].Cells[1].FindControl("PROTYPID"); DropDownList DDL_PROTYPID = (DropDownList)GV_POS.Rows[rowIndex].Cells[1].FindControl("DDL_PROTYPID"); TextBox tbfitpric = (TextBox)GV_POS.Rows[rowIndex].Cells[2].FindControl("tbfitpric"); TextBox tbItmpris = (TextBox)GV_POS.Rows[rowIndex].Cells[3].FindControl("tbItmpris"); TextBox tbsalpris = (TextBox)GV_POS.Rows[rowIndex].Cells[4].FindControl("tbsalpris"); TextBox TBItmQty = (TextBox)GV_POS.Rows[rowIndex].Cells[5].FindControl("TBItmQty"); Label lblttl = (Label)GV_POS.Rows[rowIndex].Cells[6].FindControl("lblttl"); HiddenField HFDSal = (HiddenField)GV_POS.Rows[rowIndex].Cells[7].FindControl("HFDSal"); drRow = dt.NewRow(); dt.Rows[i - 1]["Items"] = TBItms.Text; dt.Rows[i - 1]["ProductID"] = HFPROID.Value; dt.Rows[i - 1]["PROTYPID"] = DDL_PROTYPID.SelectedValue; dt.Rows[i - 1]["fitpric"] = tbfitpric.Text; dt.Rows[i - 1]["Itempric"] = tbItmpris.Text; dt.Rows[i - 1]["salpric"] = tbsalpris.Text; dt.Rows[i - 1]["QTY"] = TBItmQty.Text; dt.Rows[i - 1]["TTL"] = lblttl.Text; dt.Rows[i - 1]["Dposid"] = HFDSal.Value; rowIndex++; float GTotal = 0, CRAmt = 0, DBAmt = 0; for (int j = 0; j < GV_POS.Rows.Count; j++) { Label total = (Label)GV_POS.Rows[j].FindControl("lblttl"); GTotal += Convert.ToSingle(total.Text); TBTtl.Text = GTotal.ToString(); } } dt.Rows.Add(drRow); ViewState["dt_adItm"] = dt; GV_POS.DataSource = dt; GV_POS.DataBind(); } } else { Response.Write("ViewState is null"); } //Set Previous Data on Postbacks SetPreRowitm(); }