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