public void GetDashBoardData()
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataSet ds = obje.GetDashBoardDataBL(Session["UserId"].ToString(), Session["ministry"].ToString(), Session["Rolls"].ToString());
lblTotalPPR.Text = ds.Tables[0].Rows[0]["TotalPpr"].ToString();
//lblFinalPprSubmitted.Text = ds.Tables[1].Rows[0]["FinalPprSubmitte"].ToString();
lblMeetingSchedule.Text = ds.Tables[2].Rows[0]["MeetingSchedule"].ToString();
lblMom.Text = ds.Tables[3].Rows[0]["MOM"].ToString();
//lblCreatedPprMoreThanOneMonth.Text = ds.Tables[4].Rows[0]["CreatedPprMoreThanOneMonth"].ToString();
//lblSubmittedPprMoreThanOneMonth.Text = ds.Tables[5].Rows[0]["SubmittedPprMoreThanOneMonth"].ToString();
//lblDeferredppr.Text = ds.Tables[6].Rows[0]["DeferredPPR"].ToString();
// lblRejectPpr.Text = ds.Tables[7].Rows[0]["RejectedPPR"].ToString();
lblMarKPpr.Text = ds.Tables[8].Rows[0]["MarkPpr"].ToString();
//spss.InnerText= ds.Tables[0].Rows[0]["TotalPpr"].ToString();
//************** New code for mom pose pending
lblPendingPPR.Text = ds.Tables[10].Rows[0]["PPRPendingList"].ToString();
lblMoMnotIssued.Text = ds.Tables[9].Rows[0]["PendingMOm"].ToString();
lblPosedToBank.Text = ds.Tables[11].Rows[0]["PosedPPR"].ToString();
lblPendingtoPosed.Text = ds.Tables[12].Rows[0]["PendingtoPosed"].ToString();
if (lblTotalPPR.Text == "0" || lblTotalPPR.Text == "1")
{
RemoveCSS.RemoveCssClass(lblTotalPPR, "sps");
RemoveCSS.AddCssClass(lblTotalPPR, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblTotalPPR, "hom_but_a");
RemoveCSS.AddCssClass(lblTotalPPR, "sps");
}
if (lblMarKPpr.Text == "0" || lblMarKPpr.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMarKPpr, "sps");
RemoveCSS.AddCssClass(lblMarKPpr, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMarKPpr, "hom_but_a");
RemoveCSS.AddCssClass(lblMarKPpr, "sps");
}
if (lblMeetingSchedule.Text == "0" || lblMeetingSchedule.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMeetingSchedule, "sps");
RemoveCSS.AddCssClass(lblMeetingSchedule, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMeetingSchedule, "hom_but_a");
RemoveCSS.AddCssClass(lblMeetingSchedule, "sps");
}
if (lblMom.Text == "0" || lblMom.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMom, "sps");
RemoveCSS.AddCssClass(lblMom, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMom, "hom_but_a");
RemoveCSS.AddCssClass(lblMom, "sps");
}
//**************** other code
if (lblMoMnotIssued.Text == "0" || lblMoMnotIssued.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMoMnotIssued, "sps");
RemoveCSS.AddCssClass(lblMoMnotIssued, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMoMnotIssued, "hom_but_a");
RemoveCSS.AddCssClass(lblMoMnotIssued, "sps");
}
if (lblPendingPPR.Text == "0" || lblPendingPPR.Text == "1")
{
RemoveCSS.RemoveCssClass(lblPendingPPR, "sps");
RemoveCSS.AddCssClass(lblPendingPPR, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblPendingPPR, "hom_but_a");
RemoveCSS.AddCssClass(lblPendingPPR, "sps");
}
if (lblPosedToBank.Text == "0" || lblPosedToBank.Text == "1")
{
RemoveCSS.RemoveCssClass(lblPosedToBank, "sps");
RemoveCSS.AddCssClass(lblPosedToBank, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblPosedToBank, "hom_but_a");
RemoveCSS.AddCssClass(lblPosedToBank, "sps");
}
if (lblPendingtoPosed.Text == "0" || lblPendingtoPosed.Text == "1")
{
RemoveCSS.RemoveCssClass(lblPendingtoPosed, "sps");
RemoveCSS.AddCssClass(lblPendingtoPosed, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblPendingtoPosed, "hom_but_a");
RemoveCSS.AddCssClass(lblPendingtoPosed, "sps");
}
}
catch (Exception ex)
{
LogError(ex);
}
}
public void GetDashBoardData()
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataSet ds = obje.GetDashBoardDataBL(Session["UserId"].ToString(), Session["ministry"].ToString(), Session["Rolls"].ToString());
lblTotalPpr.Text = ds.Tables[0].Rows[0]["TotalPpr"].ToString();
lblApprovePpr.Text = ds.Tables[1].Rows[0]["ApprovePpr"].ToString();
lblMarKPpr.Text = ds.Tables[2].Rows[0]["MarkPpr"].ToString();
lblSendToDea.Text = ds.Tables[3].Rows[0]["SendToDea"].ToString();
lblMeetingSchedule.Text = ds.Tables[4].Rows[0]["MeetingSchedule"].ToString();
lblMoM.Text = ds.Tables[5].Rows[0]["Mom"].ToString();
lblPendingPpr.Text = ds.Tables[6].Rows[0]["PendingPpr"].ToString();
lblRejectPpr.Text = ds.Tables[7].Rows[0]["RejectPpr"].ToString();
lblMoMnotIssued.Text = ds.Tables[8].Rows[0]["PendingMOM"].ToString();
lblPosedToBank.Text = ds.Tables[9].Rows[0]["Pose"].ToString();
lblPendingtoPosed.Text = ds.Tables[10].Rows[0]["PendingtoPosed"].ToString();
if (lblTotalPpr.Text == "0" || lblTotalPpr.Text == "1")
{
RemoveCSS.RemoveCssClass(lblTotalPpr, "sps");
RemoveCSS.AddCssClass(lblTotalPpr, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblTotalPpr, "hom_but_a");
RemoveCSS.AddCssClass(lblTotalPpr, "sps");
}
if (lblApprovePpr.Text == "0" || lblApprovePpr.Text == "1")
{
RemoveCSS.RemoveCssClass(lblApprovePpr, "sps");
RemoveCSS.AddCssClass(lblApprovePpr, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblApprovePpr, "hom_but_a");
RemoveCSS.AddCssClass(lblApprovePpr, "sps");
}
if (lblMarKPpr.Text == "0" || lblMarKPpr.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMarKPpr, "sps");
RemoveCSS.AddCssClass(lblMarKPpr, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMarKPpr, "hom_but_a");
RemoveCSS.AddCssClass(lblMarKPpr, "sps");
}
if (lblMeetingSchedule.Text == "0" || lblMeetingSchedule.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMeetingSchedule, "sps");
RemoveCSS.AddCssClass(lblMeetingSchedule, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMeetingSchedule, "hom_but_a");
RemoveCSS.AddCssClass(lblMeetingSchedule, "sps");
}
if (lblMoM.Text == "0" || lblMoM.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMoM, "sps");
RemoveCSS.AddCssClass(lblMoM, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMoM, "hom_but_a");
RemoveCSS.AddCssClass(lblMoM, "sps");
}
//**************** other code
if (lblMoMnotIssued.Text == "0" || lblMoMnotIssued.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMoMnotIssued, "sps");
RemoveCSS.AddCssClass(lblMoMnotIssued, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMoMnotIssued, "hom_but_a");
RemoveCSS.AddCssClass(lblMoMnotIssued, "sps");
}
if (lblPosedToBank.Text == "0" || lblPosedToBank.Text == "1")
{
RemoveCSS.RemoveCssClass(lblPosedToBank, "sps");
RemoveCSS.AddCssClass(lblPosedToBank, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblPosedToBank, "hom_but_a");
RemoveCSS.AddCssClass(lblPosedToBank, "sps");
}
if (lblPendingtoPosed.Text == "0" || lblPendingtoPosed.Text == "1")
{
RemoveCSS.RemoveCssClass(lblPendingtoPosed, "sps");
RemoveCSS.AddCssClass(lblPendingtoPosed, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblPendingtoPosed, "hom_but_a");
RemoveCSS.AddCssClass(lblPendingtoPosed, "sps");
}
}
catch (Exception ex)
{
LogError(ex);
}
}