//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);
}
