public ActionResult SaveStudentResult(StudentResultSave studentResultSave)
{
var studentList = _studentRegisterManager.GetAllStudents();
ViewBag.Students = new SelectList(studentList, "StudentId", "RegNumber");
var gradeList = _studentResultManager.GetGradeList();
ViewBag.Grades = new SelectList(gradeList, "GradeId", "GradeName");
var courses = _studentEnrollManager.GetEnrolledCoursesByStudentId(studentResultSave.StudentRegisterId);
ViewBag.Courses = new SelectList(courses, "CourseId", "CourseName");
int rowAffected = _studentResultManager.SaveStudentResult(studentResultSave);
if (ModelState.IsValid)
{
if (rowAffected > 0)
{
studentResultSave.GradeId = 0;
studentResultSave.EnrollCourseId = 0;
ViewBag.ValidationMsg = "Successfull.";
ModelState.Clear();
return(View(studentResultSave));
}
}
if (rowAffected == -1)
{
ViewBag.ValidationMsg = "Please select course.";
return(View(studentResultSave));
}
ViewBag.ValidationMsg = "Saving failed.Try again.";
return(View(studentResultSave));
}
public int SaveStudentResult(StudentResultSave studentResult)
{
if (studentResult.EnrollCourseId == 0)
{
return(-1);
}
if (CheckIfCourseAlreadyGraded(studentResult))
{
return(UpdateStudentResult(studentResult));
}
return(_studentResultGateway.SaveStudentResult(studentResult));
}
public int UpdateStudentResult(StudentResultSave studentResult)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "Update SaveStudentResult set GradeId='" + studentResult.GradeId + "' where StudentId='" + studentResult.StudentRegisterId + "'and CourseId='" + studentResult.EnrollCourseId + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
public int SaveStudentResult(StudentResultSave studentResult)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO SaveStudentResult VALUES('" + studentResult.EnrollCourseId + "','" + studentResult.GradeId + "','" + studentResult.StudentRegisterId + "' )";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
public bool CheckIfCourseAlreadyGraded(StudentResultSave studentResult)
{
SqlConnection connection = new SqlConnection(connectionString);
connection.ConnectionString = connectionString;
string query = "SELECT * FROM SaveStudentResult WHERE CourseId = '" + studentResult.EnrollCourseId + "'and StudentId='" + studentResult.StudentRegisterId + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
connection.Close();
return(true);
}
connection.Close();
return(false);
}
public int UpdateStudentResult(StudentResultSave studentResult)
{
return(_studentResultGateway.UpdateStudentResult(studentResult));
}
public bool CheckIfCourseAlreadyGraded(StudentResultSave studentResult)
{
return(_studentResultGateway.CheckIfCourseAlreadyGraded(studentResult));
}
