protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["UData"] != null) { DataSet MyRecDataSet = (DataSet)Session["UData"]; if (Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["SystemAdmin"]) == true) { BindEmployeesData(); SectorU.DataSource = Admins.DataSource = Obj.GetDataSet("GetSections"); SectorU.DataTextField = Admins.DataTextField = "SectionName"; SectorU.DataValueField = Admins.DataValueField = "SectionID"; Admins.DataBind(); Admins.Items.Insert(0, ""); SectorU.DataBind(); SectorU.Items.Insert(0, ""); } else { Response.Redirect("NoPermissions.aspx"); } } } }
public void loadAdmins() { //this function will load the data into grid myDAL objDAL = new myDAL(); Admins.DataSource = objDAL.GetAdminsList_DAL(); Admins.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { 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)) {/// 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 Sections 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"; Admins.DataSource = Obj.GetDataSet("GetSectionsDashboard"); Admins.DataTextField = "SectionName"; Admins.DataValueField = "SectionID"; Admins.DataBind(); ListItem aaSection = new ListItem { Text = "اختر الإدارة العليا", Value = "" }; Admins.Items.Insert(0, aaSection); } else { Response.Redirect("NoPermissions.aspx"); } } } }
protected void Sector_SelectedIndexChanged(object sender, EventArgs e) { if (Sector.SelectedValue != "") { Admins.DataSource = Obj.GetDataSetByID("GetAdministrations", Convert.ToInt32(Sector.SelectedValue)); // Bind the Admins (Administrations) DropdownList Admins.DataTextField = "AdmName"; // Set the text in the dropdown list Admins.DataValueField = "AdmID"; // Set the value in the dropdown list Admins.DataBind(); Admins.Items.Insert(0, ""); } }
protected void DropYear_SelectedIndexChanged(object sender, EventArgs e) { if (DropYear.SelectedValue != "0") { 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)) { Admins.Items.Clear(); Admins.DataSource = Obj.GetDataSetByID("GetPlansSection", Convert.ToInt32(DropYear.SelectedValue)); Admins.DataTextField = "SectionName"; Admins.DataValueField = "SectionID"; Admins.DataBind(); ListItem Lst = new ListItem("اختر إدارة عليا", "0"); Admins.Items.Insert(0, ""); Admins.Items.Insert(1, Lst); Admins.SelectedValue = "0"; } else { DataSet DSSections = Obj.GetDataSetByID("GetSectionsByManager", Convert.ToInt32(MyRecDataSet.Tables[0].Rows[0]["EmpID"])); if (DSSections.Tables[0].Rows.Count > 0) { Response.Redirect("PieDashboard02.aspx?ReqYR=" + DropYear.SelectedValue + "&Reqq=" + MyRecDataSet.Tables[0].Rows[0]["SectionID"]); } } } } }
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 { } }