public static async Task <List <SchoolYearTerm> > GetSchoolYearsTermsAsync(int schoolyearid) { List <SchoolYearTerm> lstResults = new List <SchoolYearTerm>(); await Task.Run(() => { using (var db = new dbSchoolAttendanceEntities()) { var dbresult = (from t in db.tblSchoolYearTerm.Where(trm => trm.SchoolYearID == schoolyearid) select t).ToList(); if (dbresult.Count > 0) { foreach (var term in dbresult) { SchoolYearTerm exSchoolYearTerm = new SchoolYearTerm(); exSchoolYearTerm.ID = term.ID; exSchoolYearTerm.SchoolYearID = Convert.ToInt32(term.SchoolYearID); exSchoolYearTerm.Description = term.Description; exSchoolYearTerm.AttendanceDaysRequire = Convert.ToDecimal(term.AttendanceDaysRequirement); exSchoolYearTerm.StartOfTerm = Convert.ToDateTime(term.StartOfTerm); exSchoolYearTerm.StartOfHalfTerm = Convert.ToDateTime(term.StartOfHalfTerm); exSchoolYearTerm.EndOfHalfTerm = Convert.ToDateTime(term.EndOfHalfTerm); exSchoolYearTerm.EndOfTerm = Convert.ToDateTime(term.EndOfTerm); exSchoolYearTerm.StartOfTerm = Convert.ToDateTime(term.StartOfTerm); exSchoolYearTerm.Notes = term.Notes; lstResults.Add(exSchoolYearTerm); } } } }); return(lstResults); }
public static async Task <List <SchoolYear> > GetSchoolYearsAsync() { List <SchoolYear> lstResults = new List <SchoolYear>(); await Task.Run(() => { using (var db = new dbSchoolAttendanceEntities()) { var dbresult = db.tblSchoolYear.ToList(); if (dbresult.Count > 0) { foreach (var year in dbresult) { SchoolYear exSchoolYear = new SchoolYear(); exSchoolYear.ID = year.ID; exSchoolYear.YearEndDate = Convert.ToDateTime(year.YearStartDate); exSchoolYear.YearEndDate = Convert.ToDateTime(year.YearEndDate); exSchoolYear.Description = year.Description; exSchoolYear.Notes = year.Notes; lstResults.Add(exSchoolYear); } } } }); return(lstResults); }
public static async Task <List <AttendanceViewModel> > GetAllAttendanceAsync() { List <AttendanceViewModel> results = new List <AttendanceViewModel>(); await Task.Run(() => { using (var db = new dbSchoolAttendanceEntities()) { var lstAttendances = db.tblSubjectAttendance.ToList(); if (lstAttendances.Count > 0) { foreach (var at in lstAttendances) { AttendanceViewModel exAttendance = new AttendanceViewModel(); exAttendance.ID = at.ID; exAttendance.SubjectID = Convert.ToInt32(at.SubjectID); exAttendance.SubjectName = string.Format("({0}) {1}", at.SubjectID, at.tblClassSubject.Description); exAttendance.StudentID = Convert.ToInt32(at.StudentID); exAttendance.StudentName = string.Format("({0}) {1}", at.StudentID, at.tblStudent.Name); exAttendance.Status = at.Status; exAttendance.AttendanceDate = Convert.ToDateTime(at.AttendanceDate); exAttendance.Notes = at.Notes; results.Add(exAttendance); } } } }); return(results); }
public static async Task <List <Classes> > GetAllLevelsClassAsync(int levelid) { List <Classes> lstResult = new List <Classes>(); await Task.Run(() => { using (var db = new dbSchoolAttendanceEntities()) { var dbResults = (from cls in db.tblSchoolClass.Where(clss => clss.SchoolLevelID == levelid) select cls).ToList(); if (dbResults.Count > 0) { foreach (var clss in dbResults) { Classes exClass = new Classes(); exClass.ID = clss.ID; exClass.LevelID = Convert.ToInt32(clss.SchoolLevelID); exClass.Description = clss.Description; exClass.Notes = clss.Notes; lstResult.Add(exClass); } } } }); return(lstResult); }
public static async Task <List <Level> > GetAllTermLevelsAsync(int termid) { List <Level> lstResult = new List <Level>(); await Task.Run(() => { using (var db = new dbSchoolAttendanceEntities()) { var dbResults = (from level in db.tblSchoolLevel.Where(lvl => lvl.SchoolTermID == termid) select level).ToList(); if (dbResults.Count > 0) { foreach (var lvl in dbResults) { Level exLevel = new Level(); exLevel.ID = lvl.ID; exLevel.SchoolTermID = Convert.ToInt32(lvl.SchoolTermID); exLevel.Description = lvl.Description; exLevel.Notes = lvl.Notes; lstResult.Add(exLevel); } } } }); return(lstResult); }