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"); } }