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
{
}
}
