public bool AssignGrade(AssignGradeModel model)
{
using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
SqlCommand command = new SqlCommand("AssignGrade", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@StudentId", model.StudentId);
command.Parameters.AddWithValue("@CourseId", model.CourseId);
command.Parameters.AddWithValue("@Grade", model.Grade);
connection.Open();
try
{
int i = command.ExecuteNonQuery();
connection.Close();
if (i > 0)
{
return(true);
}
}
catch (Exception e)
{
return(false);
}
}
return(false);
}
public ActionResult AssignGrades(AssignGradeModel model, int CourseId)
{
var objUtilities = new Utilities.Utilities();
var validateAssignGrade = objUtilities.AssignGrade(model);
if (validateAssignGrade)
{
return(RedirectToAction("TeacherHome", "Home", new { courseId = CourseId }));
}
ModelState.AddModelError("", "Enter Valid StudentId.");
return(View());
}
