private void buttonUploadTerm_Click(object sender, EventArgs e)
{
string fullName = comboBoxSelectCourse.Text;
string nameCourse = fullName.Remove(fullName.Length - 2, 2);
string nameSection = comboBoxSelectCourse.Text;
nameSection = "" + nameSection[fullName.Length - 1];
string selectedId = comboBoxSelectStudent.Text;
selectedId = selectedId.Substring(0, selectedId.IndexOf(" ")).Trim();
CourseResults cr = new CourseResults();
CourseResultsRepository crr = new CourseResultsRepository();
cr.CourseName = nameCourse;
cr.Section = nameSection;
cr.Semester = comboBoxSelectSemester.Text;
cr.AccountId = selectedId;
cr.Quiz = 0;
cr.Term = (double)numericUpDownUploadTermMark.Value;
cr.FinalMark = 0;
cr.Grade = 0;
cr.Status = "Active";
double term = cr.Term;
double quiz = crr.GetQuizMark(cr);
cr.FinalMark = quiz + term;
if (cr.FinalMark >= 80)
{
cr.Grade = 4.00;
}
if (cr.FinalMark >= 70 && cr.FinalMark <= 79)
{
cr.Grade = 3.75;
}
if (cr.FinalMark >= 60 && cr.FinalMark <= 69)
{
cr.Grade = 3.5;
}
if (cr.FinalMark >= 50 && cr.FinalMark <= 59)
{
cr.Grade = 3.25;
}
if (cr.FinalMark >= 40 && cr.FinalMark <= 49)
{
cr.Grade = 3.0;
}
if (cr.FinalMark >= 30 && cr.FinalMark <= 39)
{
cr.Grade = 2.75;
}
if (cr.FinalMark < 30)
{
cr.Grade = 0;
}
if (crr.UpdateTermMark(cr))
{
MessageBox.Show("Term Mark uploaded Successfully");
}
if (!crr.UpdateTermMark(cr))
{
MessageBox.Show("OOPS !!! Something went wrong");
}
}
