Example #1
0
    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);
        }
    }
Example #2
0
    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);
        }
    }