public tblStudent GetStudentData(string rowGuid) { using (leonardc_WebDemoEntities1 ent = new leonardc_WebDemoEntities1()) { return(ent.tblStudents.Where(a => a.RowGuid.ToString() == rowGuid).FirstOrDefault()); } }
public tblModule[] GetStudentModules(string courseID) { using (leonardc_WebDemoEntities1 ent = new leonardc_WebDemoEntities1()) { return(ent.tblModules.Where(a => a.CourseID == courseID).ToArray()); } }
public qryStudentGrade[] GetStudentGrades(int?studentID) { using (leonardc_WebDemoEntities1 ent = new leonardc_WebDemoEntities1()) { return(ent.qryStudentGrades.AsNoTracking().Where(a => a.StudentID == studentID).ToArray()); } }
public tblCourseWork[] GetStudentCourseWork(int[] modules) { using (leonardc_WebDemoEntities1 ent = new leonardc_WebDemoEntities1()) { return(ent.tblCourseWorks.Where(x => modules.Contains((int)x.ModuleID)).ToArray()); } }
public qryLatestStudentGrade[] GetLatestStudentGrades(int?studentID) { using (leonardc_WebDemoEntities1 ent = new leonardc_WebDemoEntities1()) { return(ent.qryLatestStudentGrades.Where(x => x.StudentID == studentID).ToArray()); } }
public tblCours GetCourseInfo(int courseID) { using (leonardc_WebDemoEntities1 ent = new leonardc_WebDemoEntities1()) { return(ent.tblCourses.Where(x => x.CourseID == courseID).FirstOrDefault()); } }
public StudentModel SaveStudentDetails(StudentModel model, string studentRowGuid) { using (leonardc_WebDemoEntities1 ent = new leonardc_WebDemoEntities1()) { ent.tblStudents.Where(x => x.RowGuid.ToString() == studentRowGuid).FirstOrDefault().Password = model.StudentInfo.Password; ent.SaveChanges(); } return(GetStudentModel(studentRowGuid)); }
public ActionResult Login(StudentModel student) { if (ModelState.IsValid) { using (leonardc_WebDemoEntities1 ent = new leonardc_WebDemoEntities1()) { tblStudent locStudent = ent.tblStudents.Where(a => a.UserName.Equals(student.StudentInfo.UserName) && a.Password.Equals(student.StudentInfo.Password)).FirstOrDefault(); if (locStudent != null) { Session["StudentUniqueIdentifier"] = locStudent.RowGuid; return(RedirectToAction("DashBoard", Data.GetStudentModel(locStudent.RowGuid.ToString()))); } } } return(View()); }
public StudentModel GetStudentModel(string studentRowGuid) { StudentModel result = new StudentModel(); using (leonardc_WebDemoEntities1 ent = new leonardc_WebDemoEntities1()) { result.StudentInfo = GetStudentData(studentRowGuid); result.StudentInfo.Password = null; if (result.StudentInfo != null) { result.StudentGrades = GetStudentGrades(result.StudentInfo.ID); } result.StudentModules = GetStudentModules(result.StudentInfo.CourseID.ToString()); int[] moduleIDs = result.StudentModules.Select(y => (int)y.ModuleID).ToArray(); result.ModuleCourseWork = GetStudentCourseWork(moduleIDs); result.LatestStudentGrades = GetLatestStudentGrades(result.StudentInfo.ID); result.CourseInfo = GetCourseInfo(result.StudentInfo.CourseID); } return(result); }