public ActionResult SaveResult(StudentResultSaveModel studentResultSaveModel)
{
ViewBag.listOfStudentRegNo = studentManager.GetAllStudents.ToList();
ViewBag.listOfGrade = getAllGradeList();
ViewBag.message = studentResultSaveManager.SaveStudentResult(studentResultSaveModel);
ModelState.Clear();
return(View());
}
public int SaveStudentResult(StudentResultSaveModel studentResultSaveModel)
{
Query = "INSERT INTO StudentResult VALUES('" + studentResultSaveModel.StudentId + "','" + studentResultSaveModel.CourseId + "','" + studentResultSaveModel.Grade + "')";
Command.CommandText = Query;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public string FindSameCourseForAStudentWhichAssignAGrade(StudentResultSaveModel studentResultSaveModel)
{
Query = "SELECT * FROM StudentResult WHERE StudentId='" + studentResultSaveModel.StudentId + "' AND CourseId='" + studentResultSaveModel.CourseId + "'";
Command.CommandText = Query;
string message = null;
Connection.Open();
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
message = "Grade Already assign for this Course by this Student";
}
Reader.Close();
Connection.Close();
return(message);
}
public string SaveStudentResult(StudentResultSaveModel studentResultSaveModel)
{
if (studentResultSaveGateway.FindSameCourseForAStudentWhichAssignAGrade(studentResultSaveModel) == null)
{
if (studentResultSaveGateway.SaveStudentResult(studentResultSaveModel) > 0)
{
return("Save Student Result Successfully.");
}
else
{
return("Sorry! Student Result not Save");
}
}
else
{
return(studentResultSaveGateway.FindSameCourseForAStudentWhichAssignAGrade(studentResultSaveModel));
}
}
