protected void Page_PreInit(object sender, EventArgs e) { string serverURLPath = LSKYCommon.getServerURLPath(Request); if (Request.Form.AllKeys.Contains("selectedMenuItem")) { int selectedID = 0; if (int.TryParse(Request.Form["selectedMenuItem"], out selectedID)) { if (selectedID != 0) { List <NavMenuItem> NavMenu = getMainMenu(); foreach (NavMenuItem mi in NavMenu) { if (mi.id == selectedID) { //Response.Redirect(serverURLPath + mi.url); Redirect(LSKYCommon.translateLocalURL(mi.url)); } } } } } Redirect(LSKYCommon.translateLocalURL("/")); }
public void expireSession() { /* Remove the session from the server */ if (loggedInUser != null) { String dbConnectionString = ConfigurationManager.ConnectionStrings["DataExplorerDatabase"].ConnectionString; using (SqlConnection dbConnection = new SqlConnection(dbConnectionString)) { session.expireSession(dbConnection, loggedInUser.getHash()); } } /* Expire the cookie on the client side */ if (Request.Cookies.AllKeys.Contains("lskyDataExplorer")) { HttpCookie newCookie = new HttpCookie("lskyDataExplorer"); newCookie.Value = "NOTHING TO SEE HERE"; newCookie.Expires = DateTime.Now.AddDays(-1D); newCookie.Domain = LSKYCommon.getServerName(Request); newCookie.Secure = true; //Response.SetCookie(Response.Cookies["lskyDataExplorer"]); Response.Cookies.Add(newCookie); } /* Get rid of the object in memory... just in case...*/ loggedInUser = null; /* Redirect to the login page */ redirectToLogin(); }
private TableRow addNavItem(NavMenuItem item) { TableRow newRow = new TableRow(); TableCell nameCell = new TableCell(); string cssClass = "nav_link_normal"; if (item.admin_only) { cssClass = "nav_link_admin"; } nameCell.Text = "<a href=\"" + LSKYCommon.translateLocalURL(item.url) + "\" class=\"" + cssClass + "\">" + item.name + "</a>"; nameCell.CssClass = "navigation_table_name"; newRow.Cells.Add(nameCell); TableCell descriptionCell = new TableCell(); descriptionCell.Text = item.description; descriptionCell.CssClass = "navigation_table_description"; newRow.Cells.Add(descriptionCell); return(newRow); }
protected void Page_Load(object sender, EventArgs e) { foreach (string var in Request.ServerVariables) { tblVars.Rows.Add(addRow(var, Request.ServerVariables[var])); } lblTest.Text = LSKYCommon.getServerURLPath(Request); }
public static session loadThisSession(SqlConnection connection, string hash, string ip, string useragent) { session returnMe = null; SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Connection = connection; sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "SELECT * FROM sessions WHERE id_hash=@Hash AND ip=@IP AND useragent=@UA;"; sqlCommand.Parameters.AddWithValue("@Hash", hash); sqlCommand.Parameters.AddWithValue("@IP", ip); sqlCommand.Parameters.AddWithValue("@UA", useragent); sqlCommand.Connection.Open(); SqlDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.HasRows) { List <string> adminUsers = LSKYCommon.getGroupMembers("lskysd", LSKYCommon.adminGroupName); while (dataReader.Read()) { bool is_admin = false; if (adminUsers.Contains(dataReader["username"].ToString())) { is_admin = true; } returnMe = new session( dataReader["username"].ToString(), dataReader["ip"].ToString(), dataReader["id_hash"].ToString(), dataReader["useragent"].ToString(), DateTime.Parse(dataReader["sessionstarts"].ToString()), DateTime.Parse(dataReader["sessionends"].ToString()), is_admin ); } } sqlCommand.Connection.Close(); return(returnMe); }
public static List <session> loadActiveSessions(SqlConnection connection) { List <session> returnMe = new List <session>(); using (SqlCommand sqlCommand = new SqlCommand()) { sqlCommand.Connection = connection; sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = "SELECT * FROM sessions WHERE sessionstarts < {fn NOW()} AND sessionends > {fn NOW()};"; sqlCommand.Connection.Open(); SqlDataReader dbDataReader = sqlCommand.ExecuteReader(); if (dbDataReader.HasRows) { List <string> adminUsers = LSKYCommon.getGroupMembers("lskysd", LSKYCommon.adminGroupName); while (dbDataReader.Read()) { bool is_admin = false; if (adminUsers.Contains(dbDataReader["username"].ToString())) { is_admin = true; } returnMe.Add(new session( dbDataReader["username"].ToString(), dbDataReader["ip"].ToString(), dbDataReader["id_hash"].ToString(), dbDataReader["useragent"].ToString(), DateTime.Parse(dbDataReader["sessionstarts"].ToString()), DateTime.Parse(dbDataReader["sessionends"].ToString()), is_admin )); } } sqlCommand.Connection.Close(); } return(returnMe); }
public override string ToString() { return("Track: { Name: " + this.name + ", ID: " + this.ID + ", Daily: " + LSKYCommon.boolToYesOrNo(this.daily) + ", SchoolID: " + this.schoolID + ", Starts: " + this.startDate.ToShortDateString() + ", Ends: " + this.endDate.ToShortDateString() + "}"); }
public void displayNavDropdown() { /* Load the menu items */ if (MainMenu == null) { MainMenu = Nav.getMainMenu(); } // Figure out which menu items to display List <NavMenuItem> displayedMenuItems = new List <NavMenuItem>(); foreach (NavMenuItem item in MainMenu) { if (!item.hidden) { if (loggedInUser.is_admin) { displayedMenuItems.Add(item); } else { if ((!item.admin_only) && (!item.hidden)) { displayedMenuItems.Add(item); } } } } displayedMenuItems.Sort(); // Figure out which categories to display List <string> MenuCategories = new List <string>(); foreach (NavMenuItem item in displayedMenuItems) { if (!MenuCategories.Contains(item.category)) { MenuCategories.Add(item.category); } } // Display the list in a dropdown box Response.Write("<form method=\"post\" action=\"" + LSKYCommon.translateLocalURL("Nav.aspx") + "\" style=\"margin: 0; padding: 0;\">"); Response.Write("<span class=\"nav_link\">Navigation:</span> "); Response.Write("<select name=\"selectedMenuItem\">"); Response.Write("<option value=\"0\" selected=\"selected\"> -- Front Page --</option>"); foreach (string MenuCat in MenuCategories) { Response.Write("<option value=\"0\" style=\"font-weight: bold;\">" + MenuCat.ToUpper() + "</option>"); foreach (NavMenuItem mi in displayedMenuItems) { if (mi.category == MenuCat) { Response.Write("<option value=\"" + mi.id + "\"> " + mi.name + "</option>"); } } } Response.Write("</select>"); Response.Write(" <input type=\"submit\" value=\"Go\">"); Response.Write("</form>"); }
public override string ToString() { return("Class: { Name: " + this.name + ", Course Name: " + this.courseName + ", ClassID: " + this.classid + ", CourseID: " + this.courseid + ", Has Objectives: " + this.Outcomes.Count + ", IsHighSchool: " + LSKYCommon.boolToYesOrNo(this.isHighSchoolLevel()) + ", LowGrade: " + this.lowestGrade + ", HighGrade: " + this.highestGrade + ", Translated grade: " + this.getGradeLevel() + ", Grade Legend: " + this.gradeLegend + "}"); }
public override string ToString() { bool hasObjectiveAlso = false; if (this.outcome != null) { hasObjectiveAlso = true; } bool hasReportPeriod = false; if (this.reportPeriod != null) { hasReportPeriod = true; } return("OutcomeMark: { ID: " + this.objectiveMarkID + ", Objective ID: " + this.objectiveID + ", Course ID: " + this.courseID + ", nMark: " + this.nMark + ", cMark: " + this.cMark + ", Report Period: " + this.reportPeriodID + ", HasOutcomeInfo: " + LSKYCommon.boolToYesOrNo(hasObjectiveAlso) + " , HasReportPeriod: " + LSKYCommon.boolToYesOrNo(hasReportPeriod) + " }"); }