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