public JsonResult RetrieveSPFs(int pupilID) { if (IsAuthorized()) { Teacher user = VaKEGradeRepository.Instance.GetTeacher(((Teacher)Session["User"]).ID); Session["User"] = user; Pupil pupil = VaKEGradeRepository.Instance.GetPupil(pupilID); //Session["SelPupilID"] = pupil.ID; if (pupil != null) { List<Database.SPF> spfs = pupil.SPFs.ToList(); GridData gData = new GridData() { page = 1 }; List<RowData> rows = new List<RowData>(); Session["pupilID"] = pupilID; foreach (SPF spf in spfs) { rows.Add(new RowData() { id = spf.ID, cell = new string[] { spf.Subject.Name, spf.Level.ToString() } }); } gData.records = rows.Count(); gData.total = rows.Count(); gData.rows = rows.ToArray(); return Json(gData, JsonRequestBehavior.AllowGet); } return null; } return null; }
public JsonResult RetrieveAllStudents() { if (IsAuthorized()) { Teacher user = VaKEGradeRepository.Instance.GetTeacher(((Teacher)Session["User"]).ID); Session["User"] = user; List<Database.Pupil> pupils = user.PrimaryClasses.First().Pupils.ToList(); GridData gData = new GridData() { page = 1 }; List<RowData> rows = new List<RowData>(); foreach (Database.Pupil pupil in pupils) { rows.Add(new RowData() { id = pupil.ID, cell = new string[] { pupil.LastName, pupil.FirstName, pupil.Religion, pupil.Birthdate.ToShortDateString(), pupil.Gender } }); } gData.records = rows.Count(); gData.total = rows.Count(); gData.rows = rows.ToArray(); return Json(gData, JsonRequestBehavior.AllowGet); } return null; }
public JsonResult RetrieveClassList() { if (IsAuthorized()) { try { List<Database.SchoolClass> classes = VaKEGrade.Database.VaKEGradeRepository.Instance.GetClasses().ToList<Database.SchoolClass>(); GridData gData = new GridData() { page = 1 }; List<RowData> rows = new List<RowData>(); foreach (Database.SchoolClass sclass in classes) { rows.Add(new RowData() { id = sclass.ID, cell = new string[] { sclass.Level.ToString(), sclass.Name, sclass.PrimaryClassTeacher.LastName } }); } gData.records = rows.Count(); gData.total = rows.Count(); gData.rows = rows.ToArray(); JsonResult jres = Json(gData, JsonRequestBehavior.AllowGet); return jres; } catch (Exception e) { } } ViewData["error"] = "Bitte melden sie sich am System an"; return null; }
public JsonResult RetrieveSubjects() { if (IsAuthorized()) { List<Database.Subject> subjects = VaKEGrade.Database.VaKEGradeRepository.Instance.GetSubjects().ToList<Database.Subject>(); GridData gData = new GridData() { page = 1 }; List<RowData> rows = new List<RowData>(); string obligatoryTranlation = ""; foreach (Database.Subject subject in subjects) { if (subject.IsVoluntary) { obligatoryTranlation = "Nein"; } else { obligatoryTranlation = "Ja"; } //List<Database.Subject> subjects = branch.BranchSubjectAssignments.Select(x => x.Subject).Distinct().ToList(); rows.Add(new RowData() { id = subject.ID, cell = new string[] { subject.Name, obligatoryTranlation, subject.SPFs.Count.ToString() } }); } gData.records = rows.Count(); gData.total = rows.Count(); gData.rows = rows.ToArray(); JsonResult jres = Json(gData, JsonRequestBehavior.AllowGet); return jres; } ViewData["error"] = "Bitte melden sie sich am System an"; return null; }
public JsonResult RetrieveAllSubjects() { if (IsAuthorized()) { List<Database.Pupil> pupils = VaKEGrade.Database.VaKEGradeRepository.Instance.GetPupils().ToList<Database.Pupil>(); GridData gData = new GridData() { page = 1 }; List<RowData> rows = new List<RowData>(); foreach (Database.Pupil pupil in pupils) { rows.Add(new RowData() { id = pupil.ID, cell = new string[] { pupil.LastName, pupil.FirstName, pupil.Birthdate.ToString(), pupil.Gender } }); } gData.records = rows.Count(); gData.total = rows.Count(); gData.rows = rows.ToArray(); JsonResult jres = Json(gData, JsonRequestBehavior.AllowGet); return jres; } ViewData["error"] = "Bitte melden sie sich am System an"; return null; }