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
{ }
}