public void UpdateGrade(List <string> grade, string courseName) { cours course = new cours(); try { using (var context = new BAProjectEntities()) { course = context.courses.FirstOrDefault(x => x.name.Equals(courseName)); foreach (var gradeDatabase in course.grades_database) { gradeDatabase.grade = grade.First(); grade.Remove(grade.First()); } context.SaveChanges(); } } catch (Exception ex) { if (ex is EntityException || ex is NullReferenceException) { MessageBox.Show("Couldn't connect to the database. Please try again later."); } else { throw; } } Response.Redirect("~/ReportCard/LecturerView/" + course.course_id); }
public void UpdateData(string desc, string addressline1, string addressline2, string postcode, string phone, string email, string city, string name, string office) { user user = GetUser(); if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(email) || string.IsNullOrEmpty(desc) || string.IsNullOrEmpty(city) || string.IsNullOrEmpty(addressline1) || string.IsNullOrEmpty(postcode) || string.IsNullOrEmpty(phone)) { MessageBox.Show("Not all information has been filled in. Please try again."); } else { try { using (var context = new BAProjectEntities()) { user databaseUser = context.users.FirstOrDefault(u => u.username.Equals(user.username)); databaseUser.full_name = name; databaseUser.description = desc; databaseUser.email = email; databaseUser.address_city = city; databaseUser.address_firstline = addressline1; databaseUser.address_secondline = addressline2; databaseUser.postcode = postcode; databaseUser.phone_number = phone; databaseUser.office = office; context.SaveChanges(); } } catch (Exception ex) { if (ex is EntityException || ex is NullReferenceException) { MessageBox.Show("Couldn't connect to the database. Please try again later."); } else { throw; } } } Response.Redirect("~/Profile/Index"); }
public void AddNewCourse(string name, string outline, string startdate, string enddate, int lecturer) { bool messageBox = true; if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(outline) || string.IsNullOrEmpty(startdate) || string.IsNullOrEmpty(enddate)) { MessageBox.Show("Not all details have been filled out. Please try again."); } else { try { string username = Request.Cookies["user"].Value; bool approved = false; DateTime start = Convert.ToDateTime(startdate); DateTime end = Convert.ToDateTime(enddate); if (start < end) { using (var context = new BAProjectEntities()) { user user = context.users.FirstOrDefault(x => x.username.Equals(username)); int type = user.type_of_user; if (type == 3) { approved = true; } cours course = new cours() { name = name, outline = outline, start_date = start, finish_date = end, available = true, approved = approved, lecturer = lecturer }; context.courses.Add(course); context.SaveChanges(); if (approved) { MessageBox.Show(name + " has been added as a course."); } else { messageBox = false; Response.Redirect("~/CourseCatalogue/confirmationPage"); } } } else { MessageBox.Show("The start date is after the end date. Please try again."); } } catch (Exception ex) { if (ex is EntityException || ex is NullReferenceException) { MessageBox.Show("Couldn't connect to the database. Please try again later."); } else { throw; } } } if (messageBox) { Response.Redirect("~/CourseCatalogue/courseInfo"); } }