public EnrollCourseModel GateRegisterNumberByStudentId(int StudentId) { SqlConnection con = new SqlConnection(connectingString); string query = "select * from EnrollByDepartment where StudentId = '" + StudentId + "'"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); EnrollCourseModel enrollCourseModel = new EnrollCourseModel(); if (dataReader.HasRows) { while (dataReader.Read()) { enrollCourseModel.DepartmentId = Convert.ToInt32(dataReader["DepartmentID"]); enrollCourseModel.RegistationNumber = dataReader["RegistationNumber"].ToString(); enrollCourseModel.StudentName = dataReader["StudentName"].ToString(); enrollCourseModel.StudentEmail = dataReader["StudentEmail"].ToString(); enrollCourseModel.DepartmentName = dataReader["DepartName"].ToString(); } dataReader.Close(); } con.Close(); return(enrollCourseModel); }
public IActionResult Put(string userId, [FromBody] EnrollCourseModel model) { if (!Guid.TryParse(userId, out var parsedUserId)) { return(BadRequest()); } var user = _userService.GetUser(parsedUserId); if (user == null) { return(NotFound($"User {userId} was not found")); } var status = _courseService.AddCourseForUser(user.Id, model.CourseId); if (status == ActionStatus.CourseNotFound) { return(NotFound($"Course {model.CourseId} was not found")); } var courses = _courseService.GetCoursesForUser(user.Id); return(Ok(_mapper.Map <IEnumerable <CourseModel> >(courses))); }
public int GateAllEnrollCourseGateway(EnrollCourseModel enrollCourseModel) { SqlConnection con = new SqlConnection(connectingString); string query = "insert into EnrollCourse values('" + enrollCourseModel.StudentId + "','" + enrollCourseModel.CourseId + "','" + enrollCourseModel.Date + "')"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); int rowAffect = cmd.ExecuteNonQuery(); con.Close(); return(rowAffect); }
//----------------------------------------------------------- public string Enroll(EnrollCourseModel student) { int rowEffect = enrollCourseGateway.Enroll(student); if (rowEffect > 0) { return("Save Success"); } else { return("Save Faild"); } }
public ActionResult Enroll(EnrollCourseModel enrollcourse) { ViewBag.Title = "Enroll Courses"; ViewBag.studentRegNos = enrollCoursesManager.RegNoDropdown(); if (enrollCoursesManager.IsCourseAvailable(enrollcourse.StudentId, enrollcourse.CourseId) == false) { ViewBag.message = enrollCoursesManager.Enroll(enrollcourse); } else { ViewBag.message = "Already Enrolled This course"; } return(View()); }
//------------------------------------------------------------------------- public int Enroll(EnrollCourseModel student) { query = "INSERT INTO EnrollCourseTable VALUES(@studentId,@courseId,@date,1)"; Command = new SqlCommand(query, Connection); Command.Parameters.AddWithValue("@studentId", student.StudentId); Command.Parameters.AddWithValue("@courseId", student.CourseId); Command.Parameters.AddWithValue("@date", student.Date); Connection.Open(); int rowEffect = Command.ExecuteNonQuery(); Connection.Close(); return(rowEffect); }
public string GateAllEnrollCourseManager(EnrollCourseModel enrollCourseModel) { if (enrollCourseGateway.IsExist(enrollCourseModel) == null) { if (enrollCourseGateway.GateAllEnrollCourseGateway(enrollCourseModel) > 0) { return("Save Successfull"); } else { return("Save Fail"); } } else { return(enrollCourseGateway.IsExist(enrollCourseModel)); } }
public string IsExist(EnrollCourseModel enrollCourseModel) { string message = null; SqlConnection con = new SqlConnection(connectingString); string query = "select * from EnrollCourse Where StudentId='" + enrollCourseModel.StudentId + "' AND CourseId='" + enrollCourseModel.CourseId + "' "; SqlCommand cmd = new SqlCommand(query, con); con.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); if (dataReader.HasRows) { message = "Sorry, Already Enrolled"; } con.Close(); return(message); }
//----------------------------------------------------------- public List <EnrollCourseModel> Courses(int studentId) { query = "SELECT * FROM EnrollCourseView where studentId=" + studentId; Command = new SqlCommand(query, Connection); List <EnrollCourseModel> CourseList = new List <EnrollCourseModel>(); Connection.Open(); Reader = Command.ExecuteReader(); while (Reader.Read()) { EnrollCourseModel course = new EnrollCourseModel(); course.CourseId = Convert.ToInt32(Reader["Id"]); course.CoursesName = Reader["Name"].ToString(); CourseList.Add(course); } Connection.Close(); return(CourseList); }
public JsonResult GateRegisterNumberByStudentId(int StudentId) { EnrollCourseModel register = enrollCourseManager.GateRegisterNumberByStudentId(StudentId); return(Json(register, JsonRequestBehavior.AllowGet)); }
public IActionResult Enroll([FromBody] EnrollCourseModel model) { _courseService.EnrollCourse(model.StudentId, model.CourseId); return(Ok()); }
public ActionResult EnrollCourseSave(EnrollCourseModel enrollCourseModel) { ViewBag.message = enrollCourseManager.GateAllEnrollCourseManager(enrollCourseModel); TempData["Msg"] = ViewBag.message; return(RedirectToAction("EnrollCourseSave")); }