private static void AddStudentSemestrInfo(DataLayer.ServicesDataContextDataContext ctx, StudentProgressDTO result, StudentMainInfo Stud)
{
int SemCount = Convert.ToInt16(Stud.CurrStudGroup.Grup.Relation_spec_fac.YearObuch) * 2;
int YearPost = Convert.ToInt16(Stud.CurrStudGroup.Grup.nYear_post);
int CurrYear;
SemesterInfo[] si = new SemesterInfo[SemCount]; // Массив по количеству семестров в учебном плане
for (int i = 1; i <= SemCount; i++)
{
si[i - 1] = new SemesterInfo()
{
SemesterNum = i,
IsPassed = false
//Prolong = new StudentSemesterProlong() { ProlongReason = "по состоянию здоровья", ProlongTo = DateTime.Parse("01.02.2010") }
};
CurrYear = YearPost + Convert.ToInt16((i - 1) / 2);
DataLayer.Shedule shedule = ctx.Shedules.Where(shed =>
(shed.Year_uch_pl.year_value == CurrYear) && ((shed.ik_sem_type - 1) == ((i + 1) % 2))).FirstOrDefault();
if (shedule != null)
{
si[i - 1].shedule = shedule.ik_shedule;
DataLayer.Semester_length_exception Sem = shedule.Semester_length_exceptions.Where(sem =>
(sem.ik_spec_fac == Stud.CurrStudGroup.Grup.ik_spec_fac) && (sem.course_number == CurrYear - YearPost + 1)).FirstOrDefault();
if (Sem != null)
{
si[i - 1].SemesterStartDate = Sem.d_sem_start;
si[i - 1].SemesterEndDate = Sem.d_sem_end;
si[i - 1].SessionStartDate = Sem.d_session_start;
si[i - 1].SessionEndDate = Sem.d_session_end;
}
else
{
si[i - 1].SemesterStartDate = shedule.d_sem_start;
si[i - 1].SemesterEndDate = shedule.d_sem_end;
si[i - 1].SessionStartDate = shedule.d_session_start;
si[i - 1].SessionEndDate = shedule.d_session_end;
}
}
// Добавить результататы успеваемости
AddStudentSemesterProgressInfo(ctx, si[i - 1], Stud);
// Добавить результаты аттестаций
AddStudentCheckPointsInfo(ctx, si[i - 1], Stud);
}
result.Semesters = si;
//Загрузить продления сессии
IOrderedQueryable <DataLayer.Prikaz_Stud> Prikazs = ctx.Prikaz_Studs.Where(prik => (prik.Pricina.ikTypePric == 29) && (prik.Zach.Nn_zach == Stud.ID)).OrderBy(prik => prik.LastProp); //
foreach (DataLayer.Prikaz_Stud Prik in Prikazs)
{
//подбираем семестр, к которому относится данное продление
int i = 0;
while ((i < (SemCount - 1)) && !((Convert.ToDateTime(Prik.LastProp) >= si[i].SessionEndDate) && (Convert.ToDateTime(Prik.LastProp) <= si[i + 1].SessionStartDate)))
{
i++;
}
if ((i < (SemCount - 1)) || ((Convert.ToDateTime(Prik.LastProp) >= si[i].SemesterEndDate) && (i == (SemCount - 1))))
{
if (result.Semesters[i].Prolong == null)
{
result.Semesters[i].Prolong = new StudentSemesterProlong();
}
result.Semesters[i].Prolong.ProlongTo = Convert.ToDateTime(Prik.LastProp);
result.Semesters[i].Prolong.ProlongReason = Prik.Pricina.Cname_pric;
}
}
}
private static void AddStudentSemesterProgressInfo(DataLayer.ServicesDataContextDataContext ctx, SemesterInfo semesterInfo, StudentMainInfo Stud)
{
IEnumerable <DataLayer.SheduleExamForSiteUGTU> shedExams = ctx.SheduleExamForSiteUGTUs.Where(shed =>
(shed.ik_shedule == semesterInfo.shedule) && (shed.ik_vid_nagruzki == 1));
//загружаем планируемую дату экзамена
semesterInfo.Progress =
(from usp in ctx.UspevViews
join shed in shedExams
on new { ik = (int?)usp.iK_disc, Ik_grup = (int?)usp.Ik_grup, iK_vid_zanyat = (int?)usp.iK_vid_zanyat }
equals new { ik = (int?)shed.ik_disc, Ik_grup = (int?)shed.ik_grup, iK_vid_zanyat = (int?)shed.ik_vid_zanyat }
into ShedUspev
where (usp.n_sem == semesterInfo.SemesterNum) && (usp.Nn_zach == Stud.ID)
from shd in ShedUspev.DefaultIfEmpty()
select new ProgressInfo
{
Discipline = usp.cName_disc,
LessonType = usp.cName_vid_zanyat,
idLessonType = usp.iK_vid_zanyat,
ByChoice = usp.lVibor,
ChoiceGroupNumber = usp.ViborGroup,
Mark = usp.Name_osenca,
PassDate = usp.Dd_exam,
PlanDate = (shd.dt_time_start == null) ? ((usp.bitExam) ? semesterInfo.SessionEndDate : semesterInfo.SemesterEndDate) : shd.dt_time_start // (ur.FirstName == null) ? "N/A" : ur.FirstName,
}).OrderBy(usp => usp.LessonType).ThenBy(usp => usp.Discipline).ToArray();
//проверяем, сдана ли сессия
IEnumerable <ProgressInfo> NotPassed = semesterInfo.Progress.Where(uspev => uspev.PassDate == null);
if (NotPassed.Count() == 0)
{
semesterInfo.IsPassed = true;
}
else
{
//если кол-во несданных, но обязательных экзаменов равно 0
if (NotPassed.Where(uspev => !uspev.ByChoice).Count() == 0)
{
//проверяем дисциплины по-выбору
IEnumerable <int> ChoiceGroups = (NotPassed.Select(usp => Convert.ToInt32(usp.ChoiceGroupNumber)));
bool IsPassed = false;
//для каждой группы проверяем наличие хотя бы 1 сданной дисциплины
foreach (int CurrChoiceGroup in ChoiceGroups)
{
foreach (string CurrDisc in semesterInfo.Progress.Where(progr =>
progr.ChoiceGroupNumber == CurrChoiceGroup).Select(progr => progr.Discipline))
{
if (semesterInfo.Progress.Where(progr =>
(progr.Discipline == CurrDisc) && (progr.PassDate == null)).Count() == 0)
{
IsPassed = true;
break;
}
}
if (!IsPassed)
{
break;
}
}
semesterInfo.IsPassed = IsPassed;
}
}
}
private static void AddStudentCheckPointsInfo(DataLayer.ServicesDataContextDataContext ctx, SemesterInfo semesterInfo, StudentMainInfo Stud)
{
/*CheckPointInfo[] cp = ctx.AttestViews.Where(att => (att.n_sem == semesterInfo.SemesterNum) && (att.Nn_zach == Stud.ID)).Select(att =>
* new CheckPointInfo()
* {
* CheckPointNum = Convert.ToInt32(att.AttestNumber)
* }).Distinct().OrderBy(att => att.CheckPointNum).ToArray();
*/
CheckPointInfo[] cp = ctx.AttestViews.Where(att => (att.n_sem == semesterInfo.SemesterNum) && (att.Nn_zach == Stud.ID)).GroupBy(att => att.AttestNumber).Select(grAtt =>
new CheckPointInfo()
{
CheckPointNum = Convert.ToInt32(grAtt.Key),
CheckPointStartDate = grAtt.Min(att => att.DateBegin).GetValueOrDefault(),
CheckPointEndDate = grAtt.Max(att => att.DateEnd).GetValueOrDefault()
}).Distinct().OrderBy(att => att.CheckPointNum).ToArray();
int idGroup;
foreach (CheckPointInfo check in cp)
{
idGroup = ctx.AttestViews.Where(att => (att.n_sem == semesterInfo.SemesterNum) && (att.Nn_zach == Stud.ID) && (att.AttestNumber == check.CheckPointNum)).First().Ik_grup;
//check.CheckPointStartDate = ctx.AttestViews.Where(att => (att.n_sem == semesterInfo.SemesterNum) && (att.Nn_zach == Stud.ID) && (att.AttestNumber == check.CheckPointNum)).First().DateBegin.GetValueOrDefault();
//check.CheckPointEndDate = ctx.AttestViews.Where(att => (att.n_sem == semesterInfo.SemesterNum) && (att.Nn_zach == Stud.ID) && (att.AttestNumber == check.CheckPointNum)).First().DateEnd.GetValueOrDefault();
var GroupRes = ctx.AttestViews.Where(att => (att.n_sem == semesterInfo.SemesterNum) && (att.Ik_grup == idGroup) && (att.AttestNumber == check.CheckPointNum) && (att.Cosenca > -1)).GroupBy(att => att.Nn_zach /*, e => e.Cosenca*/).Select(grAtt
=> new
{
nnZach = grAtt.Key,
AVMark = grAtt.Average(att => att.Cosenca) //,
//Number = grAtt.
}).OrderBy(AVMark => AVMark.AVMark);
if (GroupRes.Where(AVM => AVM.nnZach == Stud.ID).Count() > 0)
{
CheckRatingInfo checkRating = new CheckRatingInfo();
checkRating.StudentCount = GroupRes.Count();
checkRating.CheckAVMark = Convert.ToDouble(GroupRes.Where(AVM => AVM.nnZach == Stud.ID).FirstOrDefault().AVMark);
checkRating.StudentPosition = GroupRes.Where(AVM => AVM.AVMark >= checkRating.CheckAVMark).Count();
check.CheckRating = checkRating;
}
//.Aggregate( att => att.Cosenca)//.GroupBy(att => att.Nn_zach, e => e.Cosenca).Select(att => att.Aggregate);//.Average(att => att.Cosenca);
check.Disciplines = ctx.AttestViews.Where(att => (att.n_sem == semesterInfo.SemesterNum) &&
(att.Nn_zach == Stud.ID) && (att.AttestNumber == check.CheckPointNum)).Select(att =>
new CheckDisciplinePointInfo()
{
Discipline = att.cName_disc,
HasPassed = (att.Cosenca == -3) ? "не указано" : ((att.Cosenca == -2) ? "не аттестован" :
((att.Cosenca == -1) ? "аттестован" : Convert.ToString(att.Cosenca) + " из " + Convert.ToString(att.maxBall) + " баллов")),
AbsentHours = att.PropCount.GetValueOrDefault(),
AbsentByReasonHours = att.Uvag_PropCount.GetValueOrDefault(),
IsClosed = att.lClose
}
).OrderBy(att => att.Discipline).ToArray();
}
semesterInfo.CheckPoints = cp;
}