public int SaveEnrollMent(CourseEnrollmentVm aCourseEnrollmentVm)
{
Query =
"INSERT INTO CourseEnrollment(StudentId,CourseId,DepartmentId,Date) VALUES(@sId, @cId, @dId, @date)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("dId", SqlDbType.Int);
Command.Parameters["dId"].Value = aCourseEnrollmentVm.DepartmentId;
Command.Parameters.Add("sId", SqlDbType.Int);
Command.Parameters["sId"].Value = aCourseEnrollmentVm.StudentId;
Command.Parameters.Add("cId", SqlDbType.Int);
Command.Parameters["cId"].Value = aCourseEnrollmentVm.CourseId;
Command.Parameters.Add("date", SqlDbType.Date);
Command.Parameters["date"].Value = aCourseEnrollmentVm.Date;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public JsonResult GetCourseEnrollmentInfoByDepartmentId(int id)
{
List <Student> students = aStudentManager.GetStudentByDepartmentId(id);
var courseInfo = anAcademicManager.GetCourseByDepartmentId(id);
CourseEnrollmentVm aCourseEnrollmentVm = new CourseEnrollmentVm();
aCourseEnrollmentVm.Students = students;
aCourseEnrollmentVm.Courses = courseInfo;
return(Json(aCourseEnrollmentVm));
}
public ActionResult EnrollInACourse(CourseEnrollmentVm aCourseEnrollmentVm)
{
ViewBag.Departments = GetDepartmentsForDropdownList();
DateTime myDateTime = new DateTime();
myDateTime = DateTime.ParseExact(aCourseEnrollmentVm.Date, "dd-MM-yyyy", null);
String date = myDateTime.ToString("yyyy-MM-dd");
aCourseEnrollmentVm.Date = date;
ViewBag.Message = aStudentManager.SaveEnrollMent(aCourseEnrollmentVm);
return(View());
}
public string SaveEnrollMent(CourseEnrollmentVm aCourseEnrollmentVm)
{
if (aStudentGateway.IsCourseEnrolled(aCourseEnrollmentVm))
{
return("Course already enrolled");
}
int rowAffected = aStudentGateway.SaveEnrollMent(aCourseEnrollmentVm);
if (rowAffected > 0)
{
return("Course enrolled suucessfully!!");
}
else
{
return("Enrollment failed");
}
}
public bool IsCourseEnrolled(CourseEnrollmentVm aCourseEnrollmentVm)
{
Query = "SELECT * FROM CourseEnrollment WHERE CourseId = @cId And StudentId = @sId";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("cId", SqlDbType.Int);
Command.Parameters["cId"].Value = aCourseEnrollmentVm.CourseId;
Command.Parameters.Add("sId", SqlDbType.Int);
Command.Parameters["sId"].Value = aCourseEnrollmentVm.StudentId;
Connection.Open();
Reader = Command.ExecuteReader();
bool hasRow = false;
if (Reader.HasRows)
{
hasRow = true;
}
Reader.Close();
Connection.Close();
return(hasRow);
}
