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}");
}
}
}
protected override void DrawSemeterMarks(int rowOffest, StudentClassSubject m, int avarage, int test, int exam, string[] a)
{
if (a.Length == 4)
{
DrawSecondSemeterMarks(rowOffest, m, avarage, test, exam, a);
return;
}
int sum1 = Round((avarage + test) / 2.0);
int sum2 = sum1 + exam;
if (m.Id > 0)
{
Sheet.Cells[$"{a[0]}{rowOffest}"].Value = avarage;
Sheet.Cells[$"{a[1]}{rowOffest}"].Value = test;
Sheet.Cells[$"{a[3]}{rowOffest}"].Value = exam;
Sheet.Cells[$"{a[2]}{rowOffest}"].Value = sum1;
Sheet.Cells[$"{a[4]}{rowOffest}"].Value = sum2;
}
int mark = Round(sum2 / 2.0);
Sheet.Cells[$"{a[5]}{rowOffest}"].Value = mark;
Sheet.Cells[$"{a[6]}{rowOffest}"].Value = mark.ToArabic();
if (mark < m.Subject?.MinMark)
{
MarkAsFailed($"{a[5]}{rowOffest}");
MarkAsFailed($"{a[6]}{rowOffest}");
}
}
protected void drawSecondSemesterMarks(int rowOffest, StudentClassSubject m)
{
int avarage = m.Old_sndAvarage.GetValueOrDefault();
int test = m.SecondTestMark.GetValueOrDefault();
int exam = m.ExamMark2.GetValueOrDefault();
string[] a = C.SecondSemesterMarksColumnsLetters.Split(',');
DrawSemeterMarks(rowOffest, m, avarage, test, exam, a);
}
public static Marks firstSemester(StudentClassSubject data)
{
return(new Marks
{
oral = data.Oral1.GetValueOrDefault(),
homework = data.Homework1.GetValueOrDefault(),
activity = data.Activity1.GetValueOrDefault(),
test = data.FirstTestMark.GetValueOrDefault(),
exam = data.ExamMark1.GetValueOrDefault(),
avarage = data.Old_fstAvarage.GetValueOrDefault(),
});
}
public static Marks sumOfBothSemesters(StudentClassSubject data)
{
return(new Marks
{
oral = data.Oral2.GetValueOrDefault() + data.Oral1.GetValueOrDefault(),
homework = data.Homework2.GetValueOrDefault() + data.Homework1.GetValueOrDefault(),
activity = data.Activity2.GetValueOrDefault() + data.Activity1.GetValueOrDefault(),
test = data.SecondTestMark.GetValueOrDefault() + data.FirstTestMark.GetValueOrDefault(),
exam = data.ExamMark2.GetValueOrDefault() + data.ExamMark1.GetValueOrDefault(),
avarage = data.Old_sndAvarage.GetValueOrDefault() + data.Old_fstAvarage.GetValueOrDefault(),
});
}
private void drawFinalResult(int rowOffest, StudentClassSubject m)
{
int avarage1 = m.Old_fstAvarage.GetValueOrDefault();
int test1 = m.FirstTestMark.GetValueOrDefault();
int exam1 = m.ExamMark1.GetValueOrDefault();
int avarage2 = m.Old_sndAvarage.GetValueOrDefault();
int test2 = m.SecondTestMark.GetValueOrDefault();
int exam2 = m.ExamMark2.GetValueOrDefault();
string[] a = C.FinalYearMarksColumnsLetters.Split(',');
DrawFinalYearResult(rowOffest, m, avarage1, test1, exam1, avarage2, test2, exam2, a);
}
protected override void DrawFinalYearResult(int rowOffest, StudentClassSubject m, int avarage1, int test1, int exam1, int avarage2, int test2, int exam2, string[] a)
{
int sum = Round((avarage1 + test1) / 2.0) + exam1 + Round((avarage2 + test2) / 2.0);
Sheet.Cells[$"{a[0]}{rowOffest}"].Value = sum;
Sheet.Cells[$"{a[1]}{rowOffest}"].Value = Round(sum / 3.0);
Sheet.Cells[$"{a[2]}{rowOffest}"].Value = Round(sum / 3.0).ToArabic();
if (Round(sum / 3.0) < m.Subject?.MinMark)
{
MarkAsFailed($"{a[1]}{rowOffest}");
MarkAsFailed($"{a[2]}{rowOffest}");
m.StudentGroup.FailSubjectCount++;
}
}
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++;
}
}
private void drawFaildOrPassed(int rowOffest, StudentClassSubject m)
{
if (string.IsNullOrWhiteSpace(C.FaildOrPassedLetter))
{
return;
}
try
{
string[] className = new string[] {
"",
"الاول",
"الثاني",
"الثالث",
"الرابع",
"الخامس",
"السادس",
"السابع",
"الثامن",
"التاسع",
"الاول الثانوي",
"الثاني الثانوي",
"الثالث الثانوي",
};
int classAsNumber = (int)double.Parse(m.StudentGroup.Group.ClassYear.Class.Old_SubOrder);
if (classAsNumber <= 4)
{
Sheet.Cells[C.FaildOrPassedLetter + "" + (rowOffest + C.FaildOrPassedRow)].Value = className[classAsNumber + 1];
}
else
{
if (m.StudentGroup.FailSubjectCount < 3)
{
Sheet.Cells[C.FaildOrPassedLetter + "" + (rowOffest + C.FaildOrPassedRow)].Value = className[classAsNumber + 1];
}
else
{
Sheet.Cells[C.FaildOrPassedLetter + "" + (rowOffest + C.FaildOrPassedRow + 1)].Value = className[classAsNumber];
}
}
}
catch { }
}
private void DrawSecondSemeterMarks(int rowOffest, StudentClassSubject m, int avarage, int test, int exam, string[] a)
{
int sum1 = Round((avarage + test) / 2.0);
if (m.Id > 0)
{
Sheet.Cells[$"{a[0]}{rowOffest}"].Value = avarage;
Sheet.Cells[$"{a[1]}{rowOffest}"].Value = test;
}
Sheet.Cells[$"{a[2]}{rowOffest}"].Value = sum1;
Sheet.Cells[$"{a[3]}{rowOffest}"].Value = sum1.ToArabic();
if (sum1 < m.Subject?.MinMark)
{
MarkAsFailed($"{a[2]}{rowOffest}");
MarkAsFailed($"{a[3]}{rowOffest}");
}
}
protected override void DrawSemeterMarks(int rowOffest, StudentClassSubject m, int avarage, int test, int exam, string[] a)
{
int sum1 = Round((avarage + test) / 2.0);
//if (m.id > 0)
{
Sheet.Cells[$"{a[0]}{rowOffest}"].Value = sum1;
Sheet.Cells[$"{a[1]}{rowOffest}"].Value = sum1.ToArabic();
}
if (a.Length == 2)
{
return;
}
Sheet.Cells[$"{a[2]}{rowOffest}"].Value = exam;
Sheet.Cells[$"{a[3]}{rowOffest}"].Value = exam.ToArabic();
if (exam < m.Subject?.MinMark)
{
MarkAsFailed($"{a[2]}{rowOffest}");
MarkAsFailed($"{a[3]}{rowOffest}");
}
}
protected abstract void DrawSemeterMarks(int rowOffest, StudentClassSubject m, int avarage, int test, int exam, string[] a);
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 abstract void DrawFinalYearResult(int rowOffest, StudentClassSubject m, int avarage1, int test1, int exam1, int avarage2, int test2, int exam2, string[] a);
protected override void DrawSemeterMarks(int rowOffest, StudentClassSubject m, Marks marks, string[] a)
{
Sheet.Cells[$"{a[0]}{rowOffest}"].Value = getWord(marks.sum());
}
