public bool CheckLogin(string _username, string _password) { try { //var result = new SignInStatus(); using (var context = new BAProjectEntities()) { var existingUser = context.users.FirstOrDefault(x => x.username.Contains(_username)); if (existingUser != null) { if (existingUser.password.Equals(_password)) { return true; } } } } catch (Exception ex) { if (ex is EntityException || ex is NullReferenceException) { MessageBox.Show("Couldn't connect to the database. Please try again later."); } else { throw; } } return false; }
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 ActionResult courseInfo() { List<user> listOfProfessors = new List<user>(); using (var context = new BAProjectEntities()) { listOfProfessors = context.users.Where(x => x.type_of_user.Equals(1)).ToList(); } return View(listOfProfessors); }
public user GetUser() { user user = new user(); string cookie = HttpContext.Request.Cookies["user"].Value; using (var context = new BAProjectEntities()) { user = context.users.FirstOrDefault(x => x.username.Equals(cookie)); } return user; }
//profile for Lecturers public ActionResult LecturerProfile(string id) { user lecturer = new user(); using (var context = new BAProjectEntities()) { lecturer = context.users.FirstOrDefault(x => x.users_id.ToString().Equals(id)); } return View(lecturer); }
public user GetProfessorById(string id) { user lecturer; using (var context = new BAProjectEntities()) { lecturer = context.courses.FirstOrDefault(l => l.course_id.ToString().Equals(id)).user; } return lecturer; }
public void Index() { user user = new user(); string cookie = HttpContext.Request.Cookies["user"].Value; using (var context = new BAProjectEntities()) { user = context.users.FirstOrDefault(x => x.username.Equals(cookie)); } if (user.type_of_user == 2) { Response.Redirect("~/ReportCard/StudentView/" + user.users_id); } }
public List<cours> GetAllCourses() { List<cours> courses = new List<cours>(); using (var context = new BAProjectEntities()) { foreach (cours course in context.courses) { courses.Add(course); } } return courses; }
//view for the lecturer public ActionResult LecturerView(string id) { Dictionary<string, string> usernamesAndGrades = new Dictionary<string, string>(); using (var context = new BAProjectEntities()) { cours course = context.courses.FirstOrDefault(x => x.course_id.ToString() == id); ViewBag.courseName = course.name; foreach (var grade in course.grades_database) { usernamesAndGrades.Add(grade.user.full_name, grade.grade); } } return View(usernamesAndGrades); }
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"); }
//view for student report card public ActionResult StudentView(int id) { Dictionary<string, string> grades = new Dictionary<string, string>(); using (var context = new BAProjectEntities()) { List<grades_database> gradeDB = context.grades_database.ToList(); List<grades_database> gradeForStudent = gradeDB.FindAll(x => x.student_id.Equals(id)).ToList(); foreach (var item in gradeForStudent) { if (item.history == false) { grades.Add(item.cours.name, item.grade); } } } return View(grades); }
public Dictionary <cours, grades_database> GetCoursesAndGrades() { Dictionary <cours, grades_database> previousResult = new Dictionary <cours, grades_database>(); using (var context = new DatabaseModel.BAProjectEntities()) { foreach (DatabaseModel.grades_database grade in context.grades_database) { if (grade.history.Equals(true)) { cours course = context.courses.FirstOrDefault(c => c.course_id == grade.course_id); if (!previousResult.ContainsKey(course)) { previousResult.Add(course, grade); } } } } return(previousResult); }
public Dictionary<cours, grades_database> GetCoursesAndGrades() { Dictionary<cours, grades_database> previousResult = new Dictionary<cours, grades_database>(); using (var context = new DatabaseModel.BAProjectEntities()) { foreach (DatabaseModel.grades_database grade in context.grades_database) { if (grade.history.Equals(true)) { cours course = context.courses.FirstOrDefault(c => c.course_id == grade.course_id); if (!previousResult.ContainsKey(course)) { previousResult.Add(course, grade); } } } } return previousResult; }
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"); } }