public static int InitializeScoresheetTable(string scoreID, string courseID, string teacherID, string studentID, string semesterID, float attendanceScore, float labScore, float homeworkScore, float finalExamScore, float totalScore, string grade, string remark) { ScoresheetViewModel data = new ScoresheetViewModel { ScoreID = scoreID, CourseID = courseID, TeacherID = teacherID, StudentID = studentID, SemesterID = semesterID, AttendanceScore = attendanceScore, LabScore = labScore, HomeworkScore = homeworkScore, FinalExamScore = finalExamScore, TotalScore = totalScore, Grade = grade, Remark = remark }; string sql = @"INSERT into dbo.Scoresheets (EnrollStudentID, CourseID, TeacherID, StudentID, SemesterID, AttendanceScore, LabScore, HomeworkScore, FinalExamScore, TotalScore, Grade, Remark) values (@ScoreID, @CourseID, @TeacherID, @StudentID, @SemesterID, @AttendanceScore, @LabScore, @HomeworkScore, @FinalExamScore, @TotalScore, @Grade, @Remark);"; return(SqlDataAccess.SaveData(sql, data)); }
public static int UpdateGrade(string id, string grade) { var list = GetScoresheet(id); if (list[0].TotalScore >= 90) { grade = "A"; } else if (list[0].TotalScore >= 80) { grade = "B"; } else if (list[0].TotalScore >= 70) { grade = "C"; } else if (list[0].TotalScore >= 60) { grade = "D"; } else { grade = "F"; } ScoresheetViewModel data = new ScoresheetViewModel { ScoreID = id, Grade = grade }; string sql = @"UPDATE dbo.Scoresheets SET Grade = @Grade WHERE EnrollStudentID = @ScoreID"; return(SqlDataAccess.SaveData(sql, data)); }