} /* end of the function when the page loads */ protected void Ddl_LevelOfCourse_SelectedIndexChanged(object sender, EventArgs e) /* when the level of course dropdown box is selected which doesn't return anything*/ { SubjectArea LevelOfCourse = Cache[cacheKey] as SubjectArea; /* creating a new instance of the object under the class SubjectArea called LevelOfCourse */ SubjectAreaId = Convert.ToInt32(Request.QueryString.Get("SubjectAreaId")); /*setting SubjectArea depending on the SubjectAreaId passed from the previous variable */ int level = Convert.ToInt32(Ddl_LevelOfCourse.SelectedValue); /* setting the level of the course by an integer by converting value from drop down box */ // creating a new instance of class by calling the object myEntities using (HigherEducationChesterfieldCollegeEntities myEntities = new HigherEducationChesterfieldCollegeEntities()) { // statement updates the level of courses; var levelOfCourseReviews = from course in myEntities.Courses orderby course.Name_Course ascending where course.SubjectAreaID == SubjectAreaId where course.LevelOfCourse == level select course; Repeater1.DataSource = levelOfCourseReviews.ToList(); // outputting repeater to pass variable through to the page Repeater1.DataBind(); LevelOfCourse = (from r in myEntities.SubjectAreas // outputting the courses that changes depending on the level of course that is selected where r.ID == SubjectAreaId select r).SingleOrDefault(); if (LevelOfCourse != null) // when the level of course is nothing { Cache.Insert(cacheKey, LevelOfCourse, null, DateTime.Now.AddSeconds(1), System.Web.Caching.Cache.NoSlidingExpiration); // updates the page every second } } // updating page infromation below just in case an administrator has changed information on the web page TitleLabel.Text = LevelOfCourse.Name_SA; BodyLabel.Text = LevelOfCourse.AdditionalInformation; Title = LevelOfCourse.Name_SA; } /* end of level of course dropdown box method */
} /* end of level of course dropdown box method */ protected void Ddl_TypeOfCourse_SelectedIndexChanged(object sender, EventArgs e) // start of the type of course selected item method { SubjectArea TypeOfCourse = Cache[cacheKey] as SubjectArea; /* creating a new instance of the object under the class SubjectArea called TypeOfCourse */ SubjectAreaId = Convert.ToInt32(Request.QueryString.Get("SubjectAreaId")); /*setting SubjectArea depending on the SubjectAreaId passed from the previous variable */ string typeOfCourse = Ddl_TypeOfCourse.SelectedValue; // selecting the value based on the part time of full time course selected using (HigherEducationChesterfieldCollegeEntities myEntities = new HigherEducationChesterfieldCollegeEntities()) // creating a new instance of class by calling the object myEntities { // statement updates the type of course and outputs it onto the subject area page var levelOfCourseReviews = from course in myEntities.Courses orderby course.Name_Course ascending where course.SubjectAreaID == SubjectAreaId && course.PartFullTime == typeOfCourse select course; Repeater1.DataSource = levelOfCourseReviews.ToList(); Repeater1.DataBind(); // selecting the subject areas again just in case they have been updated TypeOfCourse = (from r in myEntities.SubjectAreas where r.ID == SubjectAreaId select r).SingleOrDefault(); if (TypeOfCourse != null) // when the type of null is not nothing { Cache.Insert(cacheKey, TypeOfCourse, null, DateTime.Now.AddSeconds(1), System.Web.Caching.Cache.NoSlidingExpiration); // updates the information every second } } // updating page infromation below just in case an administrator has changed information on the web page TitleLabel.Text = TypeOfCourse.Name_SA; BodyLabel.Text = TypeOfCourse.AdditionalInformation; Title = TypeOfCourse.Name_SA; } //end of the type of course selected item method
protected void Page_Load(object sender, EventArgs e) /* start of pageLoad method */ { /* new instance of class as an object called tables */ using (HigherEducationChesterfieldCollegeEntities tables = new HigherEducationChesterfieldCollegeEntities()) { /* var for authorised reviews is for all subject areas to be liste dinto the reepater */ var authorizedReviews = from subjectArea in tables.SubjectAreas orderby subjectArea.Name_SA ascending select subjectArea; Repeater1.DataSource = authorizedReviews.ToList(); Repeater1.DataBind(); } }
public string cacheKey; /* string called cacheKey is public */ protected void Page_Load(object sender, EventArgs e) /* start of the function when the page first loads which doesn't return anything */ { SubjectAreaId = Convert.ToInt32(Request.QueryString.Get("SubjectAreaId")); /* converts the passed variable through url into an integer */ cacheKey = "SubjectArea" + SubjectAreaId.ToString(); /*setting the cache key */ SubjectArea mySubjectArea = Cache[cacheKey] as SubjectArea; /* creating a new instance of class by calling the object mySubjectArea */ if (mySubjectArea == null) // when mySubejctArea is null { // creating a new instance of class by calling the object myEntities using (HigherEducationChesterfieldCollegeEntities myEntities = new HigherEducationChesterfieldCollegeEntities()) { // statement below outputs all the courses that are part of that subject area var authorizedReviews = from course in myEntities.Courses orderby course.Name_Course ascending where course.SubjectAreaID == SubjectAreaId select course; Repeater1.DataSource = authorizedReviews.ToList(); // output courses to the page Repeater1.DataBind(); mySubjectArea = (from r in myEntities.SubjectAreas // used to output data based on that subject area where r.ID == SubjectAreaId select r).SingleOrDefault(); if (mySubjectArea != null) // when mySubjectArea is not empty { Cache.Insert(cacheKey, mySubjectArea, null, DateTime.Now.AddSeconds(1), System.Web.Caching.Cache.NoSlidingExpiration); // updates changes every second, not possible to set it to 0 } } } if (mySubjectArea != null) // when mySubjectArea is not empty { TitleLabel.Text = mySubjectArea.Name_SA; // title label is set dynamically depending on what subject area is selected BodyLabel.Text = mySubjectArea.AdditionalInformation; // setting BodyLabel.Text to what information from the database Title = "Higher Education Chesterfield College - " + mySubjectArea.Name_SA; // setting the title of the page which depends on whcih subject area is selected */ } } /* end of the function when the page loads */
public string cacheKey; /* string called cacheKey is public */ protected void Page_Load(object sender, EventArgs e) // start of method whe the page first loads { // sql connection for connecting the database SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["HigherEducationChesterfieldCollegeConnectionString"].ConnectionString); con.Open(); // database is connection is open SqlCommand cmd = new SqlCommand("SELECT * FROM [UserLogin] WHERE [LoggedOn]=@LoggedOn", con); // sql command where the all rows are seleted when the user has logged on cmd.Parameters.AddWithValue("@LoggedOn", 1); // replaced @LoggedOn value with 1 in the statement above SqlDataAdapter da = new SqlDataAdapter(cmd); // outputting the data into the sql data adapter DataTable dt = new DataTable(); // creating new instance of class DataTable as an object dt da.Fill(dt); // fills the data adapter with the data table if (dt.Rows.Count > 0) // when their are rows of data when the sql command has been done { TurnOnFavCourses.Visible = true; // turn on favourite courses to be visible TurnOffFavCourses.Visible = false; // turn off favourite courses is not to be visible } else // otherwise { TurnOnFavCourses.Visible = false; // turn on favourite courses not to be visible TurnOffFavCourses.Visible = false; // turn off favourite courses not to be visible } courseId = Convert.ToInt32(Request.QueryString.Get("CourseId")); // courseId is set to the variable set through as a session variable converted to an integer Session["CourseID"] = courseId; // courseId value is from the value passed form the previous page cacheKey = "Course" + courseId.ToString(); // when the cache is key is the course plus the courseId Course myReview = Cache[cacheKey] as Course; // new instance of the class course when object is called myreview if (myReview == null) // when myReview statement doesn't contain any data { // creating a new instance of class by calling the object myEntities using (HigherEducationChesterfieldCollegeEntities myEntities = new HigherEducationChesterfieldCollegeEntities()) { // outputComment which is a general variable used to store an sql command to select the comments linked to that course page and output to that page var outputComments = from comment in myEntities.Comments orderby comment.ID descending where comment.CourseID == courseId select comment; Repeater2.DataSource = outputComments.ToList(); Repeater2.DataBind(); // when myReview updates the courses in the subject area myReview = (from r in myEntities.Courses where r.ID == courseId select r).SingleOrDefault(); if (myReview != null) { Cache.Insert(cacheKey, myReview, null, DateTime.Now.AddSeconds(1), System.Web.Caching.Cache.NoSlidingExpiration); // updates values vevery second } } } if (myReview != null) // when the review is not null { Title = "Higher Education Chesterfield College - " + myReview.Name_Course; // set the title of the web page to the title of the coruse TitleLabel.Text = myReview.Name_Course; // title label is set to the title of the course FullPartTime.Text = "<b>Type Of Course: </b>" + myReview.PartFullTime; // full part time label sets to the partFullTime selected from the database LevelOfCourse.Text = "<b>Level Of Course: </b>" + Convert.ToString(myReview.LevelOfCourse); // LevelOfCourse label sets to the LevelOfCourse selected from the database BriefInformation.Text = "<b> Other Information: </b>" + myReview.AdditionalInformation; // Brief information label sets to the AdditionalInformation selected from the database } }