public ActionResult EnrollCourse(StudentEnrollCourses studentEnrollCourses)
{
bool result = false;
_studentManager.ValidateStudent(studentEnrollCourses);
if (ModelState.IsValid)
{
if (_studentManager.Message == null)
{
result = _studentEnrollCoursesManager.Save(studentEnrollCourses);
if (result)
{
ViewBag.SuccessMessage = "Student Enrolled Successfully";
}
else
{
ViewBag.ErrorMessage = "Student Enrolled Failed";
}
}
else
{
ViewBag.ErrorMessage = _studentManager.Message;
}
}
else
{
ViewBag.ErrorMessage = "Student Enrolled Failed";
}
ViewBag.Student = _studentManager.GetAllStudent();
return(View());
}
public StudentEnrollCourses GetStudentByEnrollCourseId(StudentEnrollCourses studentEnrollCourses)
{
Command.CommandText = @"Select * from StudentEnroleCourse where StudentId='" + studentEnrollCourses.StudentId + "' and CourseId='" + studentEnrollCourses.CourseId + "'";
Connection.Open();
SqlDataReader reader = Command.ExecuteReader();
StudentEnrollCourses sec = null;
if (reader.HasRows)
{
while (reader.Read())
{
sec = new StudentEnrollCourses()
{
Id = (int)reader["Id"],
StudentId = (int)reader["StudentId"],
CourseId = (int)reader["CourseId"],
DepartmentId = (int)reader["DepartmentId"]
};
}
}
reader.Close();
Connection.Close();
return(sec);
}
public void ValidateStudent(StudentEnrollCourses studentEnrollCourses)
{
StudentEnrollCourses st = IsStudentEnrolledTheCourseBefore(studentEnrollCourses);
if (st != null)
{
Message = "Student Already Enrolled this Course";
}
}
public bool Save(StudentEnrollCourses studentEnrollCourses)
{
bool result = false;
string query = @"INSERT INTO StudentEnroleCourse(StudentId,CourseId,DepartmentId,CreatedDate) Values (" + studentEnrollCourses.StudentId + "," + studentEnrollCourses.CourseId + "," + studentEnrollCourses.DepartmentId + ",'" + studentEnrollCourses.CreatedDateTime + "')";
Command.CommandText = query;
Connection.Open();
result = Command.ExecuteNonQuery() > 0;
Connection.Close();
return(result);
}
private StudentEnrollCourses IsStudentEnrolledTheCourseBefore(StudentEnrollCourses studentEnrollCourses)
{
return(_studentGateway.GetStudentByEnrollCourseId(studentEnrollCourses));
}
public bool Save(StudentEnrollCourses studentEnrollCourses)
{
return(_studentEnrollCoursesGateway.Save(studentEnrollCourses));
}