public void DashBoard()
{
try
{
DataTable dt = new DataTable();
dt = objRptDL.DashBoardCount_CntryDAL(Session["ConnStr"].ToString());
try
{
lblFinYear.Text = dt.Rows[0]["FinYear"].ToString() == "" ? "0" : dt.Rows[0]["FinYear"].ToString();
}
catch { }
lblNewReg.Text = dt.Rows[0]["NewReg"].ToString() == "" ? "0" : dt.Rows[0]["NewReg"].ToString();
lblRevist.Text = dt.Rows[0]["ReVisit"].ToString() == "" ? "0" : dt.Rows[0]["ReVisit"].ToString();
lblTotEnrollments.Text = dt.Rows[0]["Insutionsenrolled"].ToString() == "" ? "0" : dt.Rows[0]["Insutionsenrolled"].ToString();
lblTotalValueofdrug.Text = dt.Rows[0]["ValueOfDrugs"].ToString() == "" ? "0" : dt.Rows[0]["ValueOfDrugs"].ToString();
lblDayIns.Text = dt.Rows[0]["DayIns"].ToString() == "" ? "0" : dt.Rows[0]["DayIns"].ToString();
lblMnthIns.Text = dt.Rows[0]["MnthIns"].ToString() == "" ? "0" : dt.Rows[0]["MnthIns"].ToString();
lblYearIns.Text = dt.Rows[0]["YearIns"].ToString() == "" ? "0" : dt.Rows[0]["YearIns"].ToString();
lblDayNewR.Text = dt.Rows[0]["DayNewR"].ToString() == "" ? "0" : dt.Rows[0]["DayNewR"].ToString();
lblMnthNewR.Text = dt.Rows[0]["MnthNewR"].ToString() == "" ? "0" : dt.Rows[0]["MnthNewR"].ToString();
lblYearNewR.Text = dt.Rows[0]["YearNewReg"].ToString() == "" ? "0" : dt.Rows[0]["YearNewReg"].ToString();
lblDayRV.Text = dt.Rows[0]["DayRV"].ToString() == "" ? "0" : dt.Rows[0]["DayRV"].ToString();
lblMnthRV.Text = dt.Rows[0]["MnthRV"].ToString() == "" ? "0" : dt.Rows[0]["MnthRV"].ToString();
lblYearRV.Text = dt.Rows[0]["YearReVisit"].ToString() == "" ? "0" : dt.Rows[0]["YearReVisit"].ToString();
lblDayI.Text = dt.Rows[0]["DayI"].ToString() == "" ? "0" : dt.Rows[0]["DayI"].ToString();
lblMnthI.Text = dt.Rows[0]["MnthI"].ToString() == "" ? "0" : dt.Rows[0]["MnthI"].ToString();
lblYearI.Text = dt.Rows[0]["YearValueOfDrugs"].ToString() == "" ? "0" : dt.Rows[0]["YearValueOfDrugs"].ToString();
}
catch (Exception ex)
{
Response.Redirect("~/Error.aspx");
}
}