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");
}
}
