public int EnrollCourseSave(EnrollCourses enroll) { Query = "INSERT INTO EnrollCourses VALUES(@studentId,@courseId,@enrollDate,'1')"; Command = new SqlCommand(Query, Connection); Command.Parameters.Clear(); Command.Parameters.Add("studentId", SqlDbType.Int); Command.Parameters["studentId"].Value = enroll.StudentId; Command.Parameters.Add("courseId", SqlDbType.Int); Command.Parameters["courseId"].Value = enroll.CourseId; Command.Parameters.Add("enrollDate", SqlDbType.DateTime); Command.Parameters["enrollDate"].Value = enroll.EnrollDate; Connection.Open(); int rowAffected = Command.ExecuteNonQuery(); Connection.Close(); return(rowAffected); }
public ActionResult EnrollCourse(EnrollCourses enroll) { var students = studentManager.GetRegNo(); ViewBag.Students = students; string msg = enrollStudentManager.Save(enroll); ViewBag.Messages = msg; return(View()); }
public ActionResult Enroll(EnrollCourses enroll) { ViewBag.Message = studentManager.EnrollCourseSave(enroll); List <Student> students = studentManager.GetAllStudent(); ViewBag.Students = students; List <Course> courses = courseManager.GetAllCourse(); ViewBag.Courses = courses; return(View()); }
public ActionResult EnrollCourse(EnrollCourses enrollCourses) { try { string Alart = _enrollCourseManager.SaveCourseEnroll(enrollCourses); ViewBag.Message = Alart; GetAllDetail(); return(View()); } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool IsStudentAssigned(EnrollCourses anEnrollCourse) { Query = "SELECT * FROM EnrollCourses WHERE StudentId = '" + anEnrollCourse.StudentId + "' AND CourseId = '" + anEnrollCourse.CourseId + "' AND AssignFlag = '1'"; Command = new SqlCommand(Query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); bool hasRows = false; if (Reader.HasRows) { hasRows = true; } Reader.Close(); Connection.Close(); return(hasRows); }
public string EnrollCourseSave(EnrollCourses enroll) { bool isStudentAssigned = studentGateway.IsStudentAssigned(enroll); if (isStudentAssigned) { return("This course has already been assigned to this student"); } else { int row = studentGateway.EnrollCourseSave(enroll); if (row > 0) { return("The course has been assigned to the student successfully"); } else { return("An error occured"); } } }