public async Task SubmitCourseWork(CourseWorkSubmissionModel model)
{
var submitCommand = db.CreateCommand();
submitCommand.CommandText = "EXEC SubmitCourseWork @studentId, @theme, @task";
submitCommand.Parameters.AddWithValue("@studentId", model.StudentId);
submitCommand.Parameters.AddWithValue("@theme", model.Theme);
submitCommand.Parameters.AddWithValue("@task", model.Task ?? string.Empty);
await submitCommand.ExecuteNonQueryAsync();
}
public async Task <IActionResult> SubmitCourseWork(CourseWorkSubmissionModel model)
{
try
{
await courseWorks.OpenConnectionAsync();
await courseWorks.SubmitCourseWork(model);
}
finally
{
courseWorks.CloseConnection();
}
return(View(model));
}
