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); }