protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) { Response.Redirect("~/login.aspx"); } var user = (User)Session["User"]; lblGreeting.Text = String.Format("Welcome {0}!", user.Name.ToUpper()); if (!IsPostBack) { Session["Employee"] = null; DataTable dt = sqC.GetJob(user.Name); var employee = EmployeeService.GetEmployee(user.Name, dt.Rows[0]["Job"].ToString()); employee.ID = user.ID.ToString(); Session["Employee"] = employee; if (employee.Title == EmployeeRoles.Server.ToString() || employee.Title == EmployeeRoles.Management.ToString()) { DataTable Opentables = sqC.getOpenTables(employee); openTblList.DataSource = Opentables; if (Opentables.Rows.Count > 0) { LoadObjects(employee, Opentables); } openTblList.DataBind(); } } }