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