public static List <PromotionSituationTableAux> GetPromotionTableAux(List <int> ids)
{
StudentsRepository studentRepo = new StudentsRepository();
List <PromotionSituationTableAux> promotionResults = new List <PromotionSituationTableAux>();
foreach (var id in ids)
{
PromotionSituationTableAux promotionStudentRecord = new PromotionSituationTableAux();
promotionStudentRecord.StudentId = id;
promotionStudentRecord.StudentName = studentRepo.GetStudentFullName(id);
promotionStudentRecord.Average = studentRepo.CalculateAvgerage(id);
promotionStudentRecord.Credits = studentRepo.GetCreditsAcummulated(id);
promotionStudentRecord.ExamsCount = studentRepo.GetTotalNumberOfExams(id);
promotionStudentRecord.ExamsToRetakeCount = studentRepo.GetExamsToRetake(id).Count();
promotionResults.Add(promotionStudentRecord);
}
return(promotionResults);
}
// for Student
public static StudentSituationVM GetStudentStatistics(int id)
{
StudentsRepository studentRepo = new StudentsRepository();
var situationResult = new StudentSituationVM();
situationResult.StudentName = studentRepo.GetStudentFullName(id);
situationResult.StudentProfile = studentRepo.GetStudentProfile(id);
situationResult.ExamsCount = studentRepo.GetTotalNumberOfExams(id);
if (situationResult.ExamsCount > 0)
{
situationResult.Average = studentRepo.CalculateAvgerage(id).ToString("F2");
situationResult.Credits = studentRepo.GetCreditsAcummulated(id).ToString();
situationResult.ExamsToRetake = studentRepo.GetExamsToRetake(id);
situationResult.ExamsToRetakeCount = situationResult.ExamsToRetake.Count();
return(situationResult);
}
situationResult.Average = "-";
situationResult.Credits = "-";
situationResult.ExamsToRetakeCount = 0;
return(situationResult);
}