//for Promotion Situation2 View public bool PromotionExists(PromotionSituation promotionSituation) { var query = base.db.Students .FirstOrDefault(s => s.Specialization == promotionSituation.Specialization && s.YearOfStudy == promotionSituation.YearOfStudy); return((query == null) ? false : true); }
public List <int> GetPromotionIDs(PromotionSituation promotionSituation) { var query = from s in base.db.Students where ((s.Specialization == promotionSituation.Specialization) && (s.YearOfStudy == promotionSituation.YearOfStudy)) select s.StudentId; return(query.ToList()); }
// for Promotion public static PromotionSituation ConvertPromotionSituationVM(PromotionSituationFormVM promotionSituationVM) { var promotionSituation = new PromotionSituation(); promotionSituation.Specialization = (int)promotionSituationVM.Specialization; promotionSituation.YearOfStudy = (int)promotionSituationVM.YearOfStudy; return(promotionSituation); }
public static PromotionSituationVM GetPromotionStatistics(List <PromotionSituationTableAux> auxTable, PromotionSituation promotionSituation) { StudentsRepository studentsRepo = new StudentsRepository(); var finalsituation = new PromotionSituationVM(); var promotionsTable = GetPromotionTable(auxTable); finalsituation.PromotionSituationTable = promotionsTable.OrderByDescending(p => p.StudentName).ToList(); finalsituation.PromotionAverage = studentsRepo.GetPromotionAverage(auxTable).ToString("F2"); finalsituation.HighestAverage = studentsRepo.GetHighestAverage(auxTable).ToString("F2"); finalsituation.Scholarships = studentsRepo.GetScholarships(auxTable); finalsituation.Specialization = (Specialization)promotionSituation.Specialization; finalsituation.YearOfStudy = (YearOfStudy)promotionSituation.YearOfStudy; return(finalsituation); }