protected void ItemSalesGridView_RowUpdating(object sender, GridViewUpdateEventArgs e) { //Findout the controls inside the gridview TextBox txtQty = (TextBox)ItemSalesGridView.Rows[e.RowIndex].Cells[2].FindControl("txtEQty"); TextBox txtUnit = (TextBox)ItemSalesGridView.Rows[e.RowIndex].Cells[3].FindControl("txtEUnit"); TextBox txtTotal = (TextBox)ItemSalesGridView.Rows[e.RowIndex].Cells[4].FindControl("txtETotal"); //TextBox txtUnit = (TextBox)ItemSalesGridView.Rows[e.RowIndex].Cells[3].FindControl("txtEDOB"); //Assign the ViewState to the datatable DataRow dr = ((DataTable)ViewState["Details"]).Rows[e.RowIndex]; dr.BeginEdit(); dr["Qty"] = txtQty.Text; dr["Perprice"] = txtUnit.Text; dr["Subprice"] = Convert.ToDecimal(dr["Qty"]) * Convert.ToDecimal(dr["Perprice"]); dr.EndEdit(); dr.AcceptChanges(); ItemSalesGridView.EditIndex = -1; //Now bind the datatable to the gridview ItemSalesGridView.DataSource = (DataTable)ViewState["Details"]; ItemSalesGridView.DataBind(); txtSubTotal.Text = total.ToString(); DiscountCalculation(); }
protected void ItemSalesGridView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { ItemSalesGridView.EditIndex = -1; ItemSalesGridView.DataSource = (DataTable)ViewState["Details"]; ItemSalesGridView.DataBind(); }
protected void ItemSalesGridView_RowEditing(object sender, GridViewEditEventArgs e) { //Change the gridview to edit mode ItemSalesGridView.EditIndex = e.NewEditIndex; //Now bind the gridview ItemSalesGridView.DataSource = (DataTable)ViewState["Details"]; ItemSalesGridView.DataBind(); }
protected void ItemSalesGridView_RowDeleting(object sender, GridViewDeleteEventArgs e) { dataTable = (DataTable)ViewState["Details"]; if (dataTable.Rows.Count > 0) { dataTable.Rows[e.RowIndex].Delete(); ViewState["Details"] = dataTable; ItemSalesGridView.DataSource = dataTable; ItemSalesGridView.DataBind(); txtSubTotal.Text = total.ToString(); DiscountCalculation(); } }
protected void ItemSalesGridView_RowDeleting(object sender, GridViewDeleteEventArgs e) { DataTable dataTable = new DataTable(); dataTable = (DataTable)ViewState["Details"]; if (dataTable.Rows.Count > 0) { dataTable.Rows[e.RowIndex].Delete(); ViewState["Details"] = dataTable; ItemSalesGridView.DataSource = dataTable; ItemSalesGridView.DataBind(); txtGrandTotal.Text = total.ToString(); txtPayableAmount.Text = total.ToString(); } }
public void AddSaleItems() { //string serial; //serial = txtSerial.Text; //ItemSalesGridView.DataSource = _ItemSalesRepository.GetAllSaleItems(serial); //ItemSalesGridView.DataBind(); DataTable dataTable = new DataTable(); dataTable.Columns.Add("Name", typeof(string)); dataTable.Columns.Add("Qty", typeof(decimal)); dataTable.Columns.Add("Perprice", typeof(decimal)); dataTable.Columns.Add("Subprice", typeof(decimal)); DataRow dr = null; var data = (DataTable)ViewState["Details"]; if (data != null) { for (int i = 0; i < 1; i++) { dataTable = (DataTable)ViewState["Details"]; if (dataTable.Rows.Count > 0) { dr = dataTable.NewRow(); dr["Name"] = ItemsDropDownList.SelectedItem.ToString(); dr["Qty"] = txtQty.Text; dr["Perprice"] = txtItemPrice.Text; dr["Subprice"] = Convert.ToDecimal(dr["Qty"]) * Convert.ToDecimal(dr["Perprice"]); dataTable.Rows.Add(dr); ItemSalesGridView.DataSource = dataTable; ItemSalesGridView.DataBind(); } else { dr = dataTable.NewRow(); dr["Name"] = ItemsDropDownList.SelectedItem.ToString(); dr["Qty"] = txtQty.Text; dr["Perprice"] = txtItemPrice.Text; dr["Subprice"] = Convert.ToDecimal(dr["Qty"]) * Convert.ToDecimal(dr["Perprice"]); dataTable.Rows.Add(dr); ItemSalesGridView.DataSource = dataTable; ItemSalesGridView.DataBind(); } } } else { dr = dataTable.NewRow(); dr["Name"] = ItemsDropDownList.SelectedItem.ToString(); dr["Qty"] = txtQty.Text; dr["Perprice"] = txtItemPrice.Text; dr["Subprice"] = Convert.ToDecimal(dr["Qty"]) * Convert.ToDecimal(dr["Perprice"]); dataTable.Rows.Add(dr); ItemSalesGridView.DataSource = dataTable; ItemSalesGridView.DataBind(); } ViewState["Details"] = dataTable; txtQty.Text = ""; }
public void SaleOrder() { try { string code = txtItemcode.Text; var getData = _ItemSalesRepository.GetDataByCode(code); if (getData != null) { Item = getData.ItemName.ToString(); Unit = Convert.ToDecimal(getData.Mrp); DataTable dataTable = new DataTable(); dataTable.Columns.Add("Item", typeof(string)); dataTable.Columns.Add("Qty", typeof(decimal)); dataTable.Columns.Add("Unit", typeof(decimal)); dataTable.Columns.Add("Total", typeof(decimal)); DataRow dr = null; var data = (DataTable)ViewState["Details"]; if (data != null) { for (int i = 0; i < 1; i++) { dataTable = (DataTable)ViewState["Details"]; if (dataTable.Rows.Count > 0) { dr = dataTable.NewRow(); dr["Item"] = Item; dr["Qty"] = Qty; dr["Unit"] = Unit; dr["Total"] = Convert.ToDecimal(dr["Qty"]) * Convert.ToDecimal(dr["Unit"]); dataTable.Rows.Add(dr); ItemSalesGridView.DataSource = dataTable; ItemSalesGridView.DataBind(); } else { dr = dataTable.NewRow(); dr["Item"] = Item; dr["Qty"] = Qty; dr["Unit"] = Unit; dr["Total"] = Convert.ToDecimal(dr["Qty"]) * Convert.ToDecimal(dr["Unit"]); dataTable.Rows.Add(dr); ItemSalesGridView.DataSource = dataTable; ItemSalesGridView.DataBind(); } } } else { dr = dataTable.NewRow(); dr["Item"] = Item; dr["Qty"] = Qty; dr["Unit"] = Unit; dr["Total"] = Convert.ToDecimal(dr["Qty"]) * Convert.ToDecimal(dr["Unit"]); dataTable.Rows.Add(dr); ItemSalesGridView.DataSource = dataTable; ItemSalesGridView.DataBind(); } ViewState["Details"] = dataTable; txtItemcode.Text = ""; txtItemcode.Focus(); } else { } } catch { } }