protected virtual StudentClassSubject sumMarksInNewRecord(IEnumerable <StudentClassSubject> list)
{
int sum1 = list.Sum(x => Marks.firstSemester(x).sum());
int sum2 = list.Sum(x => Marks.secondSemester(x).sum());
return(new StudentClassSubject
{
Id = 0,
Oral1 = sum1,
//Homework1= sum1,
//Activity1 = sum1,
//FirstTestMark = sum1,
//ExamMark1 = sum1,
//Old_fstAvarage = sum1,
Oral2 = sum2,
//Homework2 = sum2,
//Activity2 = sum2,
//SecondTestMark = sum2,
//ExamMark2 = sum2,
//Old_sndAvarage = sum2,
});
}
protected abstract void DrawFinalYearResult(int rowOffest, StudentClassSubject m, Marks marks1, Marks marks2, string[] a);
protected abstract void DrawSemeterMarks(int rowOffest, StudentClassSubject m, Marks marks, string[] a);
protected void drawSecondSemesterMarks(int rowOffest, StudentClassSubject m)
{
string[] a = C.SecondSemesterMarksColumnsLetters.Split(',');
DrawSemeterMarks(rowOffest, m, Marks.secondSemester(m), a);
}
private void drawFinalResult(int rowOffest, StudentClassSubject m)
{
string[] a = C.FinalYearMarksColumnsLetters.Split(',');
DrawFinalYearResult(rowOffest, m, Marks.firstSemester(m), Marks.secondSemester(m), a);
}
protected override void DrawFinalYearResult(int rowOffest, StudentClassSubject m, Marks marks1, Marks marks2, string[] a)
{
Sheet.Cells[$"{a[0]}{rowOffest}"].Value = getWord(Round((marks1.sum() + marks2.sum()) / 2.0));
}
protected override void DrawSemeterMarks(int rowOffest, StudentClassSubject m, Marks marks, string[] a)
{
Sheet.Cells[$"{a[0]}{rowOffest}"].Value = getWord(marks.sum());
}
protected override void DrawFinalYearResult(int rowOffest, StudentClassSubject m, Marks marks1, Marks marks2, string[] a)
{
int sum = marks1.sum() + marks2.sum();
int final = Round(sum / 2.0);
Sheet.Cells[$"{a[0]}{rowOffest}"].Value = sum;
Sheet.Cells[$"{a[1]}{rowOffest}"].Value = final;
Sheet.Cells[$"{a[2]}{rowOffest}"].Value = final.ToArabic();
if (final < m.Subject?.MinMark)
{
MarkAsFailed($"{a[1]}{rowOffest}");
MarkAsFailed($"{a[2]}{rowOffest}");
m.StudentGroup.FailSubjectCount++;
}
}
protected override void DrawSemeterMarks(int rowOffest, StudentClassSubject m, Marks marks, string[] a)
{
if (m.Id > 0)
{
Sheet.Cells[$"{a[0]}{rowOffest}"].Value = marks.oral;
Sheet.Cells[$"{a[1]}{rowOffest}"].Value = marks.homework;
Sheet.Cells[$"{a[2]}{rowOffest}"].Value = marks.activity;
Sheet.Cells[$"{a[3]}{rowOffest}"].Value = marks.test;
Sheet.Cells[$"{a[4]}{rowOffest}"].Value = marks.exam;
}
int sum = marks.sum();
Sheet.Cells[$"{a[5]}{rowOffest}"].Value = sum;
if (a.Length >= 7)
{
Sheet.Cells[$"{a[6]}{rowOffest}"].Value = sum.ToArabic();
}
if (sum < m.Subject?.MinMark)
{
MarkAsFailed($"{a[5]}{rowOffest}");
if (a.Length >= 7)
{
MarkAsFailed($"{a[6]}{rowOffest}");
}
}
}
