protected void Button1_Click(object sender, EventArgs e)
{
connection con = new connection();
GridView1.DataSource = con.DisplayData("sp_report_expiry", "", endDate.Text, "");
GridView1.DataBind();
panelVisibility();
}
protected void Button1_Click(object sender, EventArgs e)
{
connection con = new connection();
GridView1.DataSource = con.DisplayData("sp_report_purchaseReturn", startDate.Text, endDate.Text, "");
GridView1.DataBind();
panelVisibility();
//double tot = 0;
//for (int i = 0; i < GridView1.Rows.Count; i++)
//{
// tot += Convert.ToDouble(GridView1.Rows[i].Cells[4].Text);
//}
//lblTotal.Text = "Rs. " + tot;
}
protected void Button1_Click(object sender, EventArgs e)
{
connection con = new connection();
GridView1.DataSource = con.DisplayData("sp_report_medicineWiseExpiry", startDate.Text, endDate.Text, DDMedicineName.SelectedValue);
GridView1.DataBind();
panelVisibility();
//double tot = 0;
//for(int i=0; i<GridView1.Rows.Count; i++)
//{
// tot += Convert.ToDouble(GridView1.Rows[i].Cells[2].Text);
//}
//lblTotal.Text = "Rs. " + tot;
}
protected void Button1_Click(object sender, EventArgs e)
{
connection con = new connection();
GridView1.DataSource = con.DisplayData("sp_report_doctorWiseSales", startDate.Text, endDate.Text, DDDoctorName.SelectedValue);
GridView1.DataBind();
panelVisibility();
double tot = 0;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
tot += Convert.ToDouble(GridView1.Rows[i].Cells[2].Text);
}
lblTotal.Text = "Rs. " + tot;
}
