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(); }