public ActionResult Save(List <string> chkApprove, string qual) { db_tafebuddyEntities _db = new db_tafebuddyEntities(); List <string> list = chkApprove as List <string>; parchment_approved pa = new parchment_approved() { StudentID = list[0], LecturerID = list[1], QualCode = qual, ApproveDate = DateTime.Now }; List <parchment_approved> paList = _db.parchment_approved.ToList(); var students = _db.students.ToList(); if (paList.Any(a => a.StudentID.Equals(pa.StudentID) && a.QualCode.Equals(pa.QualCode))) { ViewBag.AddParchment = "false"; return(RedirectToAction("SelectQual", "SRVLogin", new { studentId = list[0], qual = qual })); } else { // add to the db. _db.Entry(pa).State = EntityState.Added; _db.SaveChanges(); ViewBag.AddParchment = "true"; return(RedirectToAction("SelectQual", "SRVLogin", new { studentId = list[0], qual = qual, save = 1 })); } }
//private db_tafebuddyEntities db = new db_tafebuddyEntities(); public static List <string> GetSubjectsByQualification(db_tafebuddyEntities db, string qual) { List <string> result = new List <string>(); List <subject_qualification> subjects = db.subject_qualification.Where(a => a.QualCode.Equals(qual)).ToList(); List <string> subCodes = new List <string>(); subjects.ForEach(a => subCodes.Add(a.SubjectCode)); return(subCodes); }
public static List <student_grade> GetStudentGradeListByQual(db_tafebuddyEntities db, string studentId, string qual) { List <student_grade> listGrades = new List <student_grade>(); student_studyplan ssp = db.student_studyplan.Where(a => a.QualCode.ToUpper().Equals(qual.ToUpper())).FirstOrDefault(); Dictionary <string, string> subjects = new Dictionary <string, string>(); var grades = db.student_grade.Where(a => a.StudentID.Equals(studentId)).ToList(); grades.ForEach(a => subjects.Add(a.CRN, a.crn_detail.SubjectCode)); // all the subjects according to the qualification List <string> subCodes = SRVReusltFunc.GetSubjectsByQualification(db, qual); foreach (var item in subCodes) { bool found = false; foreach (var i in subjects) { if (i.Value.ToUpper().Equals(item.ToUpper())) { student_grade grade = db.student_grade.Where(a => a.crn_detail.CRN.ToUpper().Equals(i.Key.ToUpper()) && a.StudentID.Equals(studentId)).FirstOrDefault() as student_grade; listGrades.Add(grade); found = true; } } if (!found) { crn_detail cd = db.crn_detail.Where(a => a.SubjectCode.ToUpper().Equals(item.ToUpper())).FirstOrDefault(); student_studyplan ss = db.student_studyplan.Where(a => a.StudentID.Equals(studentId) && a.QualCode.Equals(qual)).FirstOrDefault(); if (cd != null) { listGrades.Add(new student_grade() { StudentID = studentId, CRN = cd.CRN, TafeCompCode = cd.TafeCompCode, TermCode = ss.TermCodeStart, TermYear = ss.TermYearStart, Grade = "NS", GradeDate = null, crn_detail = cd, student = grades[0].student }); } } } return(listGrades); }