public static void CreateNewGrade(gradeModel grade)
{
using (IDbConnection cnn = new SqlConnection("Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=rockBottomHigh_DB;Integrated Security=True;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
{
cnn.Query <gradeModel>("insert into Grades (StudentId, grade, Semester,finalGradeForHistory," +
" commentsForHistory,finalGradeForGrammar, commentsForGrammar," +
"finalGradeForLiterature, commentsForLiterature,finalGradeForVocabulary," +
" commentsForVocabulary,finalGradeForMath, commentsForMath, finalGradeForScience, " +
"commentsForScience) values(@StudentId, @grade, @Semester,@finalGradeForHistory," +
"@commentsForHistory,@finalGradeForGrammar, @commentsForGrammar," +
"@finalGradeForLiterature, @commentsForLiterature,@finalGradeForVocabulary, " +
"@commentsForVocabulary,@finalGradeForMath, @commentsForMath, @finalGradeForScience, " +
"@commentsForScience)", grade);
}
}
public IActionResult GradeCreate(gradeModel m)
{
ClassDataAccess.CreateNewGrade(m);
return(RedirectToAction("Index"));
}
