Exemplo n.º 1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Session["PostID"]   = "1001";
            ViewState["PostID"] = Session["PostID"].ToString();


            if (Session["UData"] != null)
            {
                DataSet MyRecDataSet = (DataSet)Session["UData"];

                if (Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["Gov"]) == true || Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["SystemAdmin"]) == true || (Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["ApprovPermission"]) == true))
                {
                    /// Log Data Start

                    String Users = "Governorate";

                    if (Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["ApprovPermission"]) == true)
                    {
                        Users = "Internal Audit";
                    }
                    else if (Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["SystemAdmin"]) == true)
                    {
                        Users = "System Administrator";
                    }
                    Obj.ExecuteProcedureStringID("NewLogTable", Convert.ToInt32(MyRecDataSet.Tables[0].Rows[0]["EmpID"]), "View All Notes and Recommendations Charts by " + Users + "Permission");

                    /// Log Data End
                    ///
                    DropYear.Items.Clear();
                    DropYear.DataSource     = Obj.GetDataSet("GetPlans");
                    DropYear.DataTextField  = "YearName";
                    DropYear.DataValueField = "ID";
                    DropYear.DataBind();

                    ListItem aa = new ListItem("جميع السنوات", "0");

                    DropYear.Items.Insert(0, aa);
                    DropYear.SelectedItem.Value = "0";
                    BindChart();
                    BindChartAdm();
                    BindImportChart();
                    BindStatChart();

                    RepTotalsYears.DataSource = Obj.GetDataSet("GetRepSectionAll");
                    RepTotalsYears.DataBind();


                    Repeater2Years.DataSource = EmployeesDataYears.DataSource = Obj.GetDataSet("GetAllSectionsChart");
                    EmployeesDataYears.DataBind();

                    Repeater2Years.DataBind();


                    DataSet ds = Obj.GetDataSet("GetAllAdmins");
                    Repeater2.DataSource = EmployeesData.DataSource = ds;
                    EmployeesData.DataBind();
                    Repeater2.DataBind();

                    RepTotals.DataSource = Obj.GetDataSet("GetReportsCounts");
                    RepTotals.DataBind();
                }

                else
                {
                    Response.Redirect("NoPermissions.aspx");
                }
            }
        }

        else
        {
            if (ViewState["PostID"].ToString() == Session["PostID"].ToString())
            {
                Session["PostID"] = (Convert.ToInt16(Session["PostID"]) + 1).ToString();

                ViewState["PostID"] = Session["PostID"].ToString();
            }
            else
            {
                ViewState["PostID"] = Session["PostID"].ToString();

                hidden.Value    = "0";
                hiddenAdm.Value = "0";
            }
            if (hidden.Value != "0")
            {
                LoadDataChart();
            }

            if (hiddenAdm.Value != "0")
            {
                LoadDataChartAdm();
            }
        }
    }
Exemplo n.º 2
0
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (!IsPostBack)
            {
                Session["PostID"]   = "1001";
                ViewState["PostID"] = Session["PostID"].ToString();

                if (Session["UData"] != null)
                {
                    DataSet MyRecDataSet = (DataSet)Session["UData"];


                    if ((Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["SystemAdmin"]) == true) || (Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["ApprovPermission"]) == true))
                    {
                        DropYear.DataSource     = Obj.GetDataSet("GetPlans");
                        DropYear.DataTextField  = "YearName";
                        DropYear.DataValueField = "ID";
                        DropYear.DataBind();

                        ListItem aa = new ListItem("جميع السنوات", "0");

                        DropYear.Items.Insert(0, aa);

                        if (Request.QueryString["ReqYR"] != "0")
                        {
                            DropYear.SelectedValue = Request.QueryString["ReqYR"];
                            Admins.DataSource      = Obj.GetDataSetByID("GetPlansSection", Convert.ToInt32(Request.QueryString["ReqYR"]));
                            Admins.DataTextField   = "SectionName";
                            Admins.DataValueField  = "SectionID";
                            Admins.DataBind();
                            ListItem LstNew = new ListItem("اختر الإدارة العليا", "0");

                            Admins.Items.Insert(0, "");
                            Admins.Items.Insert(1, LstNew);



                            if (Request.QueryString["Reqq"] != null)
                            {
                                Admins.SelectedValue = Request.QueryString["Reqq"];

                                ReportingLnk.NavigateUrl = "ReportingAdmSections.aspx?ReqYR=" + Request.QueryString["ReqYR"] + "&Reqq=" + Request.QueryString["Reqq"];
                            }
                        }
                        else
                        {
                            Admins.DataSource     = Obj.GetDataSet("GetSectionsDashboard");
                            Admins.DataTextField  = "SectionName";
                            Admins.DataValueField = "SectionID";
                            Admins.DataBind();

                            ListItem aaSection = new ListItem
                            {
                                Text  = "اختر الإدارة العليا",
                                Value = ""
                            };

                            Admins.Items.Insert(0, aaSection);
                            if (Request.QueryString["Reqq"] != null)
                            {
                                Admins.SelectedValue = Request.QueryString["Reqq"];

                                ReportingLnk.NavigateUrl = "ReportingAdmSections.aspx?ReqYR=0" + Request.QueryString["ReqYR"] + "&Reqq=" + Request.QueryString["Reqq"];
                            }
                        }
                    }
                    else
                    {
                        Response.Redirect("NoPermissions.aspx");
                    }
                }


                if (Admins.SelectedValue != null)
                {
                    string YearSelectedValue = Request.QueryString["Year"];
                    if (!string.IsNullOrEmpty(YearSelectedValue))
                    {
                        DropYear.SelectedValue = YearSelectedValue;
                    }

                    if (Admins.SelectedValue != "")
                    {
                        //Completed
                        BindImportChart();
                        //Tomorrow
                        BindStatChart();
                        BindChart();


                        DataSet ds = null;
                        if (string.IsNullOrEmpty(YearSelectedValue))
                        {
                            ds = Obj.GetDataSetByID("GetAllAdminsBySection", Convert.ToInt32(Admins.SelectedValue));
                        }
                        else
                        {
                            ds = Obj.GetDataSetBy2ID("GetAllSectionsChartPlanSEC", Convert.ToInt32(Admins.SelectedValue), Convert.ToInt32(DropYear.SelectedValue));
                        }


                        PrntView.Attributes.Remove("style");
                        PrntView.Style.Add("display", "block");

                        //    PrevAll.Attributes.Remove("style");
                        //   PrevAll.Style.Add("display", "block");

                        NoRep.Visible = false;

                        //RepYears.DataSource = Obj.GetDataSetByID("GetPlansBySection", Convert.ToInt32(Admins.SelectedValue));
                        //RepYears.DataBind();

                        if (string.IsNullOrEmpty(YearSelectedValue))
                        {
                            RepTotals.DataSource = Obj.GetDataSetByID("GetRepSectionCounts", Convert.ToInt32(Admins.SelectedValue));
                        }
                        else
                        {
                            RepTotals.DataSource = Obj.GetDataSetBy2ID("GetRepSectionAllPlansBySec", Convert.ToInt32(Admins.SelectedValue), Convert.ToInt32(DropYear.SelectedValue));
                        }

                        RepTotals.DataBind();


                        Repeater2.DataSource = EmployeesData.DataSource = ds;
                        EmployeesData.DataBind();

                        Repeater2.DataBind();
                    }
                    else
                    {
                        PrntView.Attributes.Remove("style");
                        PrntView.Style.Add("display", "none");

                        //PrevAll.Attributes.Remove("style");
                        //PrevAll.Style.Add("display", "none");
                    }
                }
            }

            else
            {
                if (ViewState["PostID"].ToString() == Session["PostID"].ToString())
                {
                    Session["PostID"] = (Convert.ToInt16(Session["PostID"]) + 1).ToString();

                    ViewState["PostID"] = Session["PostID"].ToString();
                }
                else
                {
                    ViewState["PostID"] = Session["PostID"].ToString();

                    hidden.Value      = "0";
                    HiddenTitle.Value = "0";
                }
                if (HiddenTitle.Value != "0")
                {
                    LoadDataChart();
                }

                if (HiddenYear.Value != "0")
                {
                    //RepYears.DataSource = Obj.GetDataSetByID("GetPlansBySection", Convert.ToInt32(Admins.SelectedValue));
                    //RepYears.DataBind();
                }
            }

            try
            {
                DataSet ds = null;
                if (Request.QueryString["ReqYR"] != "0")
                {
                    ds = Obj.GetDataSetBy2ID("GetAllSectionsChartPlanSEC", Convert.ToInt32(Request.QueryString["Reqq"].ToString()), Convert.ToInt32(Request.QueryString["ReqYR"].ToString()));
                }
                else
                {
                    ds = Obj.GetDataSetByID("GetAllAdminsBySection", Convert.ToInt32(Request.QueryString["Reqq"].ToString()));
                }

                Repeater2.DataSource = EmployeesData.DataSource = ds;
                EmployeesData.DataBind();

                Repeater2.DataBind();

                if (Request.QueryString["ReqYR"] != "0")
                {
                    RepTotals.DataSource = Obj.GetDataSetBy2ID("GetRepSectionAllPlansBySec", Convert.ToInt32(Request.QueryString["Reqq"].ToString()), Convert.ToInt32(Request.QueryString["ReqYR"].ToString()));
                }
                else
                {
                    RepTotals.DataSource = Obj.GetDataSetByID("GetRepSectionCounts", Convert.ToInt32(Request.QueryString["Reqq"].ToString()));
                }

                RepTotals.DataBind();
            }
            catch { }
        }
        catch
        { }
    }
Exemplo n.º 3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["UData"] != null)
        {
            DataSet MyRecDataSet = (DataSet)Session["UData"];


            if (!IsPostBack)
            {
                Session["PostID"] = "1001";
                ViewState["PostID"] = Session["PostID"].ToString();

                HyperLink1.NavigateUrl = "ReportAdmAllMang.aspx?S=" + Request.QueryString["S"] + "&Reqq" + Request.QueryString["Reqq"];

                if ((Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["SystemAdmin"]) == true) || (Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["ApprovPermission"]) == true))
                {
                    MainYear.DataSource = Obj.GetDataSet("GetPlans");
                    MainYear.DataTextField = "YearName";
                    MainYear.DataValueField = "ID";

                    MainYear.DataBind();

                    if (Request.QueryString["ReqY"] != null)
                    {
                        DataSet SectionsDS = Obj.GetDataSet("GetSections");
                        if (Request.QueryString["ReqY"] != "0")
                        {
                            SectionsDS = Obj.GetDataSetByID("GetPlansSection", Convert.ToInt32(Request.QueryString["ReqY"]));

                        }


                        MainYear.SelectedValue = Request.QueryString["ReqY"];
                        MainSector.Items.Clear();
                        MainSector.DataSource = SectionsDS;
                        MainSector.DataTextField = "SectionName";
                        MainSector.DataValueField = "SectionID";
                        MainSector.DataBind();
                        ListItem aa = new ListItem();
                        aa.Text = "اختر الإدارة العليا";
                        aa.Value = "0";
                        MainSector.Items.Insert(0, aa);
                        MainSector.SelectedValue = "0";

                        if (Request.QueryString["S"] != null)
                        {
                            MainSector.SelectedValue = Request.QueryString["S"];

                            DataSet DepartsDS = Obj.GetDataSetByID("GetAdministrations", Convert.ToInt32(Request.QueryString["S"]));
                            if (Request.QueryString["ReqY"] != "0")
                            {

                                DepartsDS = Obj.GetPlansAdmins(Convert.ToInt32(Request.QueryString["ReqY"]), Convert.ToInt32(MainSector.SelectedValue));


                            }
                           
                                MainDepart.Items.Clear();

                                MainDepart.DataSource = DepartsDS;
                                MainDepart.DataTextField = "AdmName";
                                MainDepart.DataValueField = "AdmID";
                                MainDepart.DataBind();
                                ListItem aa0 = new ListItem();
                                aa0.Text = "اختر الادارة";
                                aa0.Value = "0";

                                MainDepart.Items.Insert(0, aa0);

                            


                        }
                        HyperLink1.NavigateUrl = "ReportAdmAllMang.aspx?S=" + Request.QueryString["S"] + "&Reqq=" + Request.QueryString["Reqq"] + "&YQ=" + Request.QueryString["ReqY"];
                    }



                    if (Request.QueryString["Reqq"] != null)
                    {
                        MainDepart.SelectedValue = Request.QueryString["Reqq"];

                        NoRep.Attributes.Remove("Style");
                        NoRep.Style.Add("display", "none");

                        MainsAll.Attributes.Remove("Style");
                        MainsAll.Style.Add("display", "block");

                        if (Request.QueryString["ReqY"] == "0")
                        {
                            var Vall = Obj.ExecuteProcedureID("GetReportCountByAdmin", Convert.ToInt32(Request.QueryString["Reqq"]));
                            if (Vall != 0)
                            {
                                BindImportChart(Convert.ToInt32(Request.QueryString["Reqq"]));
                                BindStatChart(Convert.ToInt32(Request.QueryString["Reqq"]));
                                BindChart(Convert.ToInt32(Request.QueryString["Reqq"]));

                                DataSet ds = Obj.GetDataSetByID("GetCountsByAdmin", Convert.ToInt32(Request.QueryString["Reqq"]));
                                NoRep.Attributes.Remove("Style");
                                NoRep.Style.Add("display", "none");

                                MainsAll.Attributes.Remove("Style");
                                MainsAll.Style.Add("display", "block");

                                FillSectorChart();
                                RepTotals.DataSource = Obj.GetDataSetByID("GetRepAdminCounts", Convert.ToInt32(Request.QueryString["Reqq"]));
                                RepTotals.DataBind();

                                Repeater2.DataSource = ds;

                                Repeater2.DataBind();
                            }
                            else
                            {
                                NoRep.Attributes.Remove("Style");
                                NoRep.Style.Add("display", "block");

                                MainsAll.Attributes.Remove("Style");
                                MainsAll.Style.Add("display", "none");
                            }
                        }

                        else if (Request.QueryString["ReqY"] != "0" && Request.QueryString["ReqY"] != null)
                        {
                            var Vall = Obj.GetReportCountByAdminPlan(Convert.ToInt32(Request.QueryString["Reqq"]), Convert.ToInt32(Request.QueryString["ReqY"]));
                            if (Vall != 0)
                            {
                                BindImportChartAdmin(Convert.ToInt32(Request.QueryString["Reqq"]), Convert.ToInt32(Request.QueryString["ReqY"]));
                                BindStatChartAdmin(Convert.ToInt32(Request.QueryString["Reqq"]), Convert.ToInt32(Request.QueryString["ReqY"]));
                                BindChartAdmin(Convert.ToInt32(Request.QueryString["Reqq"]), Convert.ToInt32(Request.QueryString["ReqY"]));

                                DataSet ds = Obj.GetDataSetBy2ID("GetAllSectionsChartPlanADM", Convert.ToInt32(Request.QueryString["Reqq"]), Convert.ToInt32(Request.QueryString["ReqY"]));
                                NoRep.Attributes.Remove("Style");
                                NoRep.Style.Add("display", "none");

                                MainsAll.Attributes.Remove("Style");
                                MainsAll.Style.Add("display", "block");

                                FillSectorChart();
                                RepTotals.DataSource = Obj.GetDataSetBy2ID("GetRepSectionAllPlansByAdm", Convert.ToInt32(Request.QueryString["Reqq"]), Convert.ToInt32(Request.QueryString["ReqY"]));
                                RepTotals.DataBind();

                                Repeater2.DataSource = ds;

                                Repeater2.DataBind();
                            }
                            else {
                                NoRep.Attributes.Remove("Style");
                                NoRep.Style.Add("display", "block");

                                MainsAll.Attributes.Remove("Style");
                                MainsAll.Style.Add("display", "none");
                            }
                        }




                    }
                    else
                    {

                        NoRep.Attributes.Remove("Style");
                        NoRep.Style.Add("display", "block");

                        MainsAll.Attributes.Remove("Style");
                        MainsAll.Style.Add("display", "none");
                    }


                }
                else
                {
                    Response.Redirect("NoPermissions.aspx");
                }
            }
            else
            {

                if (ViewState["PostID"].ToString() == Session["PostID"].ToString())
                {

                    Session["PostID"] = (Convert.ToInt16(Session["PostID"]) + 1).ToString();

                    ViewState["PostID"] = Session["PostID"].ToString();


                }
                else
                {
                    ViewState["PostID"] = Session["PostID"].ToString();

                    hidden.Value = "0";
                    Stat.Value = "0";

                }
                if (Stat.Value != "Non")
                {
                    LoadDataChart();
                }

                if (HiddenYear.Value != "0")
                {
                    MainYear.DataSource = Obj.GetDataSetByID("GetPlansByAdmin", Convert.ToInt32(Request.QueryString["Reqq"]));
                    MainYear.DataBind();
                }

            }
        }
    }
Exemplo n.º 4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["UData"] != null)
        {
            DataSet MyRecDataSet = (DataSet)Session["UData"];


            if (!IsPostBack)
            {
                Session["PostID"]   = "1001";
                ViewState["PostID"] = Session["PostID"].ToString();


                if (Obj.ExecuteProcedureID("CheckAdminManger", Convert.ToInt32(MyRecDataSet.Tables[0].Rows[0]["EmpID"])) == 1)
                {
                    HyperLink1.NavigateUrl = "ReportAdmAll.aspx";

                    MainYear.DataSource     = Obj.GetDataSetByID("GetPlansByAdmin", Convert.ToInt32(MyRecDataSet.Tables[0].Rows[0]["AdmID"]));
                    MainYear.DataTextField  = "YearName";
                    MainYear.DataValueField = "ID";

                    MainYear.DataBind();

                    if (Request.QueryString["ReqY"] != null)
                    {
                        MainYear.SelectedValue = Request.QueryString["ReqY"];

                        HyperLink1.NavigateUrl = "ReportAdmAll.aspx?YQ=" + Request.QueryString["ReqY"];
                    }



                    if (Request.QueryString["Reqq"] != null)
                    {
                        NoRep.Visible = false;
                        if (Request.QueryString["ReqY"] == "0")
                        {
                            var Vall = Obj.ExecuteProcedureID("GetReportCountByAdmin", Convert.ToInt32(Request.QueryString["Reqq"]));
                            if (Vall != 0)
                            {
                                BindImportChart(Convert.ToInt32(Request.QueryString["Reqq"]));
                                BindStatChart(Convert.ToInt32(Request.QueryString["Reqq"]));
                                BindChart(Convert.ToInt32(Request.QueryString["Reqq"]));

                                DataSet ds = Obj.GetDataSetByID("GetCountsByAdmin", Convert.ToInt32(Request.QueryString["Reqq"]));
                                NoRep.Visible = false;

                                FillSectorChart();
                                RepTotals.DataSource = Obj.GetDataSetByID("GetRepAdminCounts", Convert.ToInt32(Request.QueryString["Reqq"]));
                                RepTotals.DataBind();

                                Repeater2.DataSource = ds;

                                Repeater2.DataBind();
                            }
                            else
                            {
                                NoRep.Visible = true;
                            }
                        }

                        else if (Request.QueryString["ReqY"] != "0" && Request.QueryString["ReqY"] != null)
                        {
                            var Vall = Obj.GetReportCountByAdminPlan(Convert.ToInt32(Request.QueryString["Reqq"]), Convert.ToInt32(Request.QueryString["ReqY"]));
                            if (Vall != 0)
                            {
                                BindImportChartAdmin(Convert.ToInt32(Request.QueryString["Reqq"]), Convert.ToInt32(Request.QueryString["ReqY"]));
                                BindStatChartAdmin(Convert.ToInt32(Request.QueryString["Reqq"]), Convert.ToInt32(Request.QueryString["ReqY"]));
                                BindChartAdmin(Convert.ToInt32(Request.QueryString["Reqq"]), Convert.ToInt32(Request.QueryString["ReqY"]));

                                DataSet ds = Obj.GetDataSetBy2ID("GetAllSectionsChartPlanADM", Convert.ToInt32(Request.QueryString["Reqq"]), Convert.ToInt32(Request.QueryString["ReqY"]));
                                NoRep.Visible = false;

                                FillSectorChart();
                                RepTotals.DataSource = Obj.GetDataSetBy2ID("GetRepSectionAllPlansByAdm", Convert.ToInt32(Request.QueryString["Reqq"]), Convert.ToInt32(Request.QueryString["ReqY"]));
                                RepTotals.DataBind();

                                Repeater2.DataSource = ds;

                                Repeater2.DataBind();
                            }
                            else
                            {
                                NoRep.Visible = true;
                            }
                        }
                    }
                    else
                    {
                        PrntView.Attributes.Remove("style");
                        PrntView.Style.Add("display", "none");

                        NoRep.Visible = true;
                    }
                }
                else
                {
                    Response.Redirect("NoPermissions.aspx");
                }
            }
            else
            {
                if (ViewState["PostID"].ToString() == Session["PostID"].ToString())
                {
                    Session["PostID"] = (Convert.ToInt16(Session["PostID"]) + 1).ToString();

                    ViewState["PostID"] = Session["PostID"].ToString();
                }
                else
                {
                    ViewState["PostID"] = Session["PostID"].ToString();

                    hidden.Value = "0";
                    Stat.Value   = "0";
                }
                if (Stat.Value != "Non")
                {
                    LoadDataChart();
                }

                if (HiddenYear.Value != "0")
                {
                    MainYear.DataSource = Obj.GetDataSetByID("GetPlansByAdmin", Convert.ToInt32(Request.QueryString["Reqq"]));
                    MainYear.DataBind();
                }
            }
        }
    }
Exemplo n.º 5
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Session["PostID"]   = "1001";
            ViewState["PostID"] = Session["PostID"].ToString();

            if (Session["UData"] != null)
            {
                DataSet MyRecDataSet = (DataSet)Session["UData"];

                if (Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["Gov"]) == true || Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["SystemAdmin"]) == true || (Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["ApprovPermission"]) == true))
                {
                    HyperLink1.NavigateUrl = "ReportingAll.aspx?ReqY=" + Request.QueryString["Reqq"];

                    DropYear.Items.Clear();
                    DropYear.DataSource     = Obj.GetDataSet("GetPlans");
                    DropYear.DataTextField  = "YearName";
                    DropYear.DataValueField = "ID";
                    DropYear.DataBind();

                    ListItem aa = new ListItem("جميع السنوات", "0");

                    DropYear.Items.Insert(0, aa);
                    DropYear.SelectedItem.Value = "0";

                    if (Request.QueryString["Reqq"] != "")
                    {
                        DropYear.SelectedValue = Request.QueryString["Reqq"];

                        SectionCharts.PostBackUrl = "SectionsCharts.aspx?Reqq=" + Request.QueryString["Reqq"];

                        AdminCharts.PostBackUrl = "AdminsCharts.aspx?Reqq=" + Request.QueryString["Reqq"];
                    }
                    BindChartAdm();
                    BindChart();
                    BindImportChart();
                    BindStatChart();
                    RepTotalsYears.DataSource = Obj.GetDataSetByID("GetRepSectionAllPlans", Convert.ToInt32(DropYear.SelectedValue));
                    RepTotalsYears.DataBind();


                    Repeater2Years.DataSource = EmployeesDataYears.DataSource = Obj.GetDataSetByID("GetAllSectionsChartPlans", Convert.ToInt32(DropYear.SelectedValue));
                    EmployeesDataYears.DataBind();

                    Repeater2Years.DataBind();

                    DataSet ds = Obj.GetDataSetByID("GetAllSectionsChartPlans", Convert.ToInt32(DropYear.SelectedValue));



                    DataSet dsYear = Obj.GetDataSetByID("GetAllAdminsByPlanNoSec", Convert.ToInt32(DropYear.SelectedValue));

                    Repeater2.DataSource = EmployeesData.DataSource = dsYear;
                    EmployeesData.DataBind();
                    Repeater2.DataBind();
                    RepTotals.DataSource = Obj.GetDataSetByID("GetYearCounts", Convert.ToInt32(DropYear.SelectedValue));
                    RepTotals.DataBind();
                }

                else
                {
                    Response.Redirect("NoPermissions.aspx");
                }
            }
        }
        else
        {
            if (ViewState["PostID"].ToString() == Session["PostID"].ToString())
            {
                Session["PostID"] = (Convert.ToInt16(Session["PostID"]) + 1).ToString();

                ViewState["PostID"] = Session["PostID"].ToString();
            }
            else
            {
                ViewState["PostID"] = Session["PostID"].ToString();

                hidden.Value    = "0";
                hiddenAdm.Value = "0";
            }
            if (hidden.Value != "0")
            {
                LoadDataChart();
            }
            if (hiddenAdm.Value != "0")
            {
                LoadDataChartAdm();
            }
        }
    }
Exemplo n.º 6
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Session["PostID"]   = "1001";
            ViewState["PostID"] = Session["PostID"].ToString();

            if (Session["UData"] != null)
            {
                DataSet MyRecDataSet = (DataSet)Session["UData"];


                if (Obj.ExecuteProcedureID("CheckSectionManger", Convert.ToInt32(MyRecDataSet.Tables[0].Rows[0]["EmpID"])) == 1)
                {/// Log Data Start
                    Obj.ExecuteProcedureStringID("NewLogTable", Convert.ToInt32(MyRecDataSet.Tables[0].Rows[0]["EmpID"]), "View Notes and Recommendations Charts by Section manager permission");

                    /// Log Data End

                    DropYear.Items.Clear();
                    DropYear.DataSource     = Obj.GetDataSetByID("GetPlansBySection", Convert.ToInt32(MyRecDataSet.Tables[0].Rows[0]["SectionID"]));
                    DropYear.DataTextField  = "YearName";
                    DropYear.DataValueField = "ID";
                    DropYear.DataBind();

                    ListItem aa = new ListItem("جميع السنوات ", "0");

                    DropYear.Items.Insert(0, aa);

                    if (Request.QueryString["ReqYR"] != null)
                    {
                        DropYear.SelectedValue = Request.QueryString["ReqYR"];


                        HyperLink1.NavigateUrl = "ReportingAllSections.aspx?ReqY=" + DropYear.SelectedValue + "&Reqq=" + Convert.ToString(MyRecDataSet.Tables[0].Rows[0]["SectionID"]);
                    }
                    else
                    {
                        HyperLink1.NavigateUrl = "ReportingAllSections.aspx?ReqY=0&Reqq=" + Convert.ToString(MyRecDataSet.Tables[0].Rows[0]["SectionID"]);
                    }
                }

                else
                {
                    Response.Redirect("NoPermissions.aspx");
                }
            }


            if (Request.QueryString["Reqq"] != null)
            {
                string YearSelectedValue = Request.QueryString["ReqYR"];
                if (!string.IsNullOrEmpty(YearSelectedValue))
                {
                    DropYear.SelectedValue = YearSelectedValue;
                }

                if (Request.QueryString["Reqq"] != "")
                {
                    //Completed
                    BindImportChart();
                    //Tomorrow
                    BindStatChart();
                    BindChart();


                    DataSet ds = null;
                    if (string.IsNullOrEmpty(YearSelectedValue))
                    {
                        ds = Obj.GetDataSetByID("GetAllAdminsBySection", Convert.ToInt32(Request.QueryString["Reqq"]));
                    }
                    else
                    {
                        ds = Obj.GetDataSetBy2ID("GetAllSectionsChartPlanSEC", Convert.ToInt32(Request.QueryString["Reqq"]), Convert.ToInt32(Request.QueryString["ReqYR"]));
                    }


                    PrntView.Attributes.Remove("style");
                    PrntView.Style.Add("display", "block");

                    //    PrevAll.Attributes.Remove("style");
                    //   PrevAll.Style.Add("display", "block");

                    NoRep.Visible = false;

                    //RepYears.DataSource = Obj.GetDataSetByID("GetPlansBySection", Convert.ToInt32(Request.QueryString["Reqq"]));
                    //RepYears.DataBind();

                    if (string.IsNullOrEmpty(YearSelectedValue))
                    {
                        RepTotals.DataSource = Obj.GetDataSetByID("GetRepSectionCounts", Convert.ToInt32(Request.QueryString["Reqq"]));
                    }
                    else
                    {
                        RepTotals.DataSource = Obj.GetDataSetBy2ID("GetRepSectionAllPlansBySec", Convert.ToInt32(Request.QueryString["Reqq"]), Convert.ToInt32(Request.QueryString["ReqYR"]));
                    }

                    RepTotals.DataBind();


                    Repeater2.DataSource = EmployeesData.DataSource = ds;
                    EmployeesData.DataBind();

                    Repeater2.DataBind();
                }
                else
                {
                    PrntView.Attributes.Remove("style");
                    PrntView.Style.Add("display", "none");

                    //PrevAll.Attributes.Remove("style");
                    //PrevAll.Style.Add("display", "none");

                    NoRep.Visible = true;
                }
            }
        }

        else
        {
            if (ViewState["PostID"].ToString() == Session["PostID"].ToString())
            {
                Session["PostID"] = (Convert.ToInt16(Session["PostID"]) + 1).ToString();

                ViewState["PostID"] = Session["PostID"].ToString();
            }
            else
            {
                ViewState["PostID"] = Session["PostID"].ToString();

                hidden.Value      = "0";
                HiddenTitle.Value = "0";
            }
            if (HiddenTitle.Value != "0")
            {
                LoadDataChart();
            }

            if (HiddenYear.Value != "0")
            {
                //RepYears.DataSource = Obj.GetDataSetByID("GetPlansBySection", Convert.ToInt32(Request.QueryString["Reqq"]));
                //RepYears.DataBind();
            }
        }
    }