protected void btnSaleReport_Click(object sender, EventArgs e)
{
string fromDate, toDate;
total_sale.Visible = true;
fromDate = datepicker1.Value;
toDate = datepicker2.Value;
DataTable sale = stock.GetSalesReport(fromDate, toDate);
sale_total.Visible = true;
Decimal finalamount = 0;
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();
}