async Task <IEnumerable <SchoolStudent> > FetchStudentList() { var sqlString = KontrolaSQL.SelectStudent(UserSession.User.Settings.SchoolID.ToString(), UserSession.User.Settings.SchoolYear); using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); return(await dbs.FetchRecordSetAsync(sqlString, (R) => { DateTime.TryParse(R["DataDeaktywacji"].ToString(), out var dd); return new SchoolStudent { Student = new IdentUnit { ID = Convert.ToInt32(R["IdUczen"]), Name = R["Student"].ToString() }, StudentClass = new IdentUnit { ID = Convert.ToInt32(R["IdKlasa"]), Name = R["NazwaKlasy"].ToString() }, ActivationStatus = Convert.ToBoolean(R["StatusAktywacji"]), ActivationDate = Convert.ToDateTime(R["DataAktywacji"]), DeactivationDate = dd, MasterRecord = Convert.ToBoolean(R["MasterRecord"]) }; })); } }
async Task <IEnumerable <ScoreInfo> > FetchScoreList() { var sqlString = KontrolaSQL.SelectWynik(UserSession.User.Settings.SchoolID.ToString(), UserSession.User.Settings.SchoolYear, rbOkres.Tag.ToString()); using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); return(await dbs.FetchRecordSetAsync(sqlString, (R) => new ScoreInfo { StudentID = Convert.ToInt32(R["IdUczen"]), ScoreName = Convert.ToString(R["Ocena"]), ScoreWeight = Convert.ToSingle(R["WagaOceny"]), ScoreSubject = new SubjectColumn { ColumnWeight = Convert.ToSingle(R["WagaKolumny"]), SubjectInfo = new ClassSubject { ClassID = Convert.ToInt32(R["Klasa"]), Subject = new SchoolSubject { SubjectID = Convert.ToInt32(R["IdPrzedmiot"]) } } } })); } }
async Task <IEnumerable <ClassSubject> > FetchSubjectList() { var sqlString = KontrolaSQL.SelectPrzedmiot(UserSession.User.Settings.SchoolID.ToString(), UserSession.User.Settings.SchoolYear); using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); return(await dbs.FetchRecordSetAsync(sqlString, (R) => new ClassSubject { ClassID = Convert.ToInt32(R["Klasa"]), SubjectID = Convert.ToInt32(R["Przedmiot"]), Group = (YesNo)Convert.ToUInt64(R["Grupa"]), SubjectName = R["Nazwa"].ToString(), SubjectPriority = Convert.ToByte(R["Priorytet"]) })); } //lstPrzedmiot.Clear(); //foreach (var R in await lst) //{ // lstPrzedmiot.Add(new ClassSubject // { // ClassID = Convert.ToInt32(R["Klasa"]), // SubjectID = Convert.ToInt32(R["Przedmiot"]), // Group = (YesNo)Convert.ToUInt64(R["Grupa"]), // SubjectName = R["Nazwa"].ToString(), // SubjectPriority = Convert.ToByte(R["Priorytet"]) // }); //} }
//ToDo: Sprawdzić działanie wszystkich metod, szczególnie ComputeAbsence async Task <IEnumerable <StudentAbsence> > FetchAbsenceList() { var sqlString = KontrolaSQL.CountAbsence(UserSession.User.Settings.SchoolID.ToString(), UserSession.User.Settings.SchoolYear, SchoolDateRange); using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); return(await dbs.FetchRecordSetAsync(sqlString, (R) => new StudentAbsence { StudentID = Convert.ToInt32(R["IdUczen"]), SubjectID = Convert.ToInt32(R["Przedmiot"]), AbsenceType = R["Typ"].ToString(), AbsenceCount = Convert.ToInt32(R["Abs"]), AbsenceDate = Convert.ToDateTime(R["Data"]) })); } }
async Task <IEnumerable <SchoolSubjectGroup> > FetchGroupList() { var sqlString = KontrolaSQL.SelectGrupaPrzedmiotowaBySchool(UserSession.User.Settings.SchoolID.ToString(), UserSession.User.Settings.SchoolYear); using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); return(await dbs.FetchRecordSetAsync(sqlString, (R) => new SchoolSubjectGroup { GroupID = Convert.ToInt32(R["ID"]), ClassID = Convert.ToInt32(R["IdKlasa"]), SubjectID = Convert.ToInt32(R["Przedmiot"]), StudentID = Convert.ToInt32(R["IdUczen"]), StartDate = Convert.ToDateTime(R["StartDate"]), EndDate = Convert.ToDateTime(R["EndDate"]) })); } }
async Task <IEnumerable <ClassSubject> > FetchSubjectList() { var sqlString = KontrolaSQL.SelectPrzedmiot(UserSession.User.Settings.SchoolID.ToString(), UserSession.User.Settings.SchoolYear); using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); return(await dbs.FetchRecordSetAsync(sqlString, (R) => new ClassSubject { ClassID = Convert.ToInt32(R["Klasa"]), Subject = new SchoolSubject { SubjectID = Convert.ToInt32(R["ID"]), SubjectName = Convert.ToString(R["Nazwa"]), SubjectPriority = Convert.ToByte(R["Priorytet"]) } })); } }
async Task <IEnumerable <SchoolLesson> > FetchLessonList() { var sqlString = KontrolaSQL.SelectLekcja(UserSession.User.Settings.SchoolID.ToString(), UserSession.User.Settings.SchoolYear, SchoolDateRange); using (var scope = AppSession.TypeContainer.BeginLifetimeScope()) { var dbs = scope.Resolve <IDataBaseService>(); return(await dbs.FetchRecordSetAsync(sqlString, (R) => new SchoolLesson { LessonID = Convert.ToInt32(R["ID"]), LessonDate = Convert.ToDateTime(R["Data"]), Subject = new ClassSubject { ClassID = Convert.ToInt32(R["Klasa"]), SubjectID = Convert.ToInt32(R["Przedmiot"]), Group = (YesNo)Convert.ToUInt64(R["Grupa"]), SubjectName = R["Nazwa"].ToString(), SubjectPriority = Convert.ToByte(R["Priorytet"]) } })); } }