protected void btnAdd_Click(object sender, EventArgs e)
{
if (ViewState["SALE_TRANSACTION_TABLE"] == null)
{
ViewState["SALE_TRANSACTION_TABLE"] = getSchema();
ViewState["SALE_TRANSACTION_TABLE"] = getSchemaData();
//GridBinding
SaleStockTrans.DataSource = (DataTable)ViewState["SALE_TRANSACTION_TABLE"];
SaleStockTrans.DataBind();
}
else
{
ViewState["SALE_TRANSACTION_TABLE"] = getSchemaData();
//GridBinding
SaleStockTrans.DataSource = (DataTable)ViewState["SALE_TRANSACTION_TABLE"];
SaleStockTrans.DataBind();
}
stock.UpdateStockQuantity(txtQuantity.Text.Trim().ToString(), ddlStock.SelectedItem.Value.ToString());
txtQuantity.Text = "";
txtAmount.Text = "";
txtDiscount.Text = "";
btnPrint.Visible = true;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
Page.Validate("Save");
if (Page.IsValid)
{
if (ViewState["SALE_TRANSACTION_TABLE"] == null)
{
ViewState["SALE_TRANSACTION_TABLE"] = getSchema();
ViewState["SALE_TRANSACTION_TABLE"] = getSchemaData();
//GridBinding
SaleStockTrans.DataSource = (DataTable)ViewState["SALE_TRANSACTION_TABLE"];
SaleStockTrans.DataBind();
}
else
{
ViewState["SALE_TRANSACTION_TABLE"] = getSchemaData();
//GridBinding
SaleStockTrans.DataSource = (DataTable)ViewState["SALE_TRANSACTION_TABLE"];
SaleStockTrans.DataBind();
}
saveStock.Visible = true;
AMOUNT.Text = "";
txtQuantity.Text = "";
}
}
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
int index = Convert.ToInt32(e.RowIndex);
DataTable dt = ViewState["SALE_TRANSACTION_TABLE"] as DataTable;
dt.Rows[index].Delete();
ViewState["SALE_TRANSACTION_TABLE"] = dt;
SaleStockTrans.DataSource = ViewState["SALE_TRANSACTION_TABLE"] as DataTable;
SaleStockTrans.DataBind();
}
protected void btnPrint_Click(object sender, EventArgs e)
{
SaleStockTrans.PagerSettings.Visible = false;
SaleStockTrans.DataBind();
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
SaleStockTrans.RenderControl(hw);
string gridHTML = sw.ToString().Replace("\"", "'")
.Replace(System.Environment.NewLine, "");
StringBuilder sb = new StringBuilder();
sb.Append("<script type = 'text/javascript'>");
sb.Append("window.onload = new function(){");
sb.Append("var printWin = window.open('', '', 'left=0");
sb.Append(",top=0,width=1000,height=600,status=0');");
sb.Append("printWin.document.write(\"");
sb.Append(gridHTML);
sb.Append("\");");
sb.Append("printWin.document.close();");
sb.Append("printWin.focus();");
sb.Append("printWin.print();");
sb.Append("printWin.close();};");
sb.Append("</script>");
ClientScript.RegisterStartupScript(this.GetType(), "GridPrint", sb.ToString());
SaleStockTrans.PagerSettings.Visible = true;
SaleStockTrans.DataBind();
}
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
int iStock_id, iQunatity;
iStock_id = Convert.ToInt32(e.Values["STOCK_ID"]);
iQunatity = Convert.ToInt32(e.Values["QUANTITY"]);
int index = Convert.ToInt32(e.RowIndex);
DataTable dt = ViewState["SALE_TRANSACTION_TABLE"] as DataTable;
dt.Rows[index].Delete();
ViewState["SALE_TRANSACTION_TABLE"] = dt;
SaleStockTrans.DataSource = ViewState["SALE_TRANSACTION_TABLE"] as DataTable;
SaleStockTrans.DataBind();
stock.UpdateStockQuantityAfterDelete(iQunatity, iStock_id);
}
protected void btnSaleReportDetail_Click(object sender, EventArgs e)
{
string fromDate, toDate;
Decimal finalamount = 0;
total_sale.Visible = true;
fromDate = DateTime.Now.ToString("yyyy-MM-dd");
toDate = DateTime.Now.ToString("yyyy-MM-dd");
DataTable sale = stock.GetSalesReport(fromDate, toDate);
sale_total.Visible = true;
foreach (DataRow dr in sale.Rows)
{
finalamount += Convert.ToDecimal(dr["TOTAL_AMOUNT"].ToString());
}
Label_Total_sale.Text = finalamount.ToString();
SaleStockTrans.DataSource = sale as DataTable;
SaleStockTrans.DataBind();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (ViewState["SALE_TRANSACTION_TABLE"] == null)
{
ViewState["SALE_TRANSACTION_TABLE"] = getSchema();
ViewState["SALE_TRANSACTION_TABLE"] = getSchemaData();
//GridBinding
SaleStockTrans.DataSource = (DataTable)ViewState["SALE_TRANSACTION_TABLE"];
SaleStockTrans.DataBind();
}
else
{
ViewState["SALE_TRANSACTION_TABLE"] = getSchemaData();
//GridBinding
SaleStockTrans.DataSource = (DataTable)ViewState["SALE_TRANSACTION_TABLE"];
SaleStockTrans.DataBind();
}
//mp1.Show();
// DataTable dt = getSchemaData();
}
