public IActionResult Update(long id, CourseSession request) { RequiredFields model = new RequiredFields(); model.CourseSession = request; Object validateFields = _validationService.ValidateRequest("Course Session", model); if (JsonConvert.SerializeObject(validateFields).Length > 2) { return(BadRequest(validateFields)); } try { var output = _courseSessionRepository.Update(id, request); if (output == true) { return(Ok(new GenericResult { Response = true, Message = "Session has been successfully updated" })); } else { return(NotFound(_NotFound)); } } catch (Exception e) { return(BadRequest(e)); } }
public ActionResult DeleteConfirmed(int id) { CourseSession courseSession = db.CourseSessions.Find(id); db.CourseSessions.Remove(courseSession); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult ChangeStatus(TeacherChangeCourse cs) { DAL.DataContext dt = new DAL.DataContext(); CourseSession myCs = dt.CourseSessions.Where(c => c.Id == cs.SeId).FirstOrDefault(); myCs.Status = "Accepted"; dt.SaveChanges(); return(RedirectToAction("TeacherSchedule", "Account")); }
public bool Add(CourseSession request) { //var output = false; //return output; request.createdAt = DateTime.Now; _context.CourseSession.Add(request); Save(); return(true); //await _context.SaveChangesAsync(); }
public HttpResponseMessage<CourseSession> AddCourseSession(CourseSession coursesession) { // Add the region that was passed in as the argument context.CourseSessions.Add(coursesession); context.SaveChanges(); // Prepare the response - we want to return "201 Created" HttpResponseMessage<CourseSession> response = new HttpResponseMessage<CourseSession>(coursesession, HttpStatusCode.Created); return response; }
public ActionResult Edit([Bind(Include = "Sessionid,CourseID,CourseDuration,CourseStartTime,CourseEndTime,CourseStartDate,CourseEndDate,CourseLocation,SessionName,CoursePrerequisite")] CourseSession courseSession) { if (ModelState.IsValid) { db.Entry(courseSession).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "CourseName", courseSession.CourseID); return(View(courseSession)); }
public ActionResult Edit([Bind(Include = "ID,InstructorID,CourseID,DayOfWeek,DateTime,HourStart,HourEnd")] CourseSession courseSession) { if (ModelState.IsValid) { db.Entry(courseSession).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title", courseSession.CourseID); ViewBag.InstructorID = new SelectList(db.Instructors, "ID", "LastName", courseSession.InstructorID); return(View(courseSession)); }
// GET: CourseSessions/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CourseSession courseSession = db.CourseSessions.Find(id); if (courseSession == null) { return(HttpNotFound()); } return(View(courseSession)); }
// GET: CourseSessions/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CourseSession courseSession = db.CourseSessions.Find(id); if (courseSession == null) { return(HttpNotFound()); } ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "CourseName", courseSession.CourseID); return(View(courseSession)); }
public long Save(CourseSessionModel model) { CourseSession _tbl_courseSession = new CourseSession(model); if (model.Id != null && model.Id != 0) { _CourseSession.Update(_tbl_courseSession); } else { _tbl_courseSession.CreatedOn = System.DateTime.Now; _CourseSession.Insert(_tbl_courseSession); } return(_tbl_courseSession.Id); }
public ActionResult ChangeStatus(TeacherChangeCourse cs) { DAL.DataContext dt = new DAL.DataContext(); CourseSession myCss = dt.CourseSessions.Where(c => c.Id == cs.SeId).First(); int fee = myCss.Course.Cost; User teacher = myCss.Teacher; User stu = myCss.Student; myCss.Status = "Completed"; teacher.Balance = teacher.Balance + fee; stu.Balance = stu.Balance - fee; dt.SaveChanges(); return(RedirectToAction("MySchedule", "Account")); }
public ActionResult Create([Bind(Include = "ID,InstructorID,CourseID,DayOfWeek,DateTime,HourStart,HourEnd")] CourseSession courseSession) { if (ModelState.IsValid) { //Check Instructor can have only one coursesession of the same course List <CourseSession> sessions = new List <CourseSession>(); sessions = db.CourseSessions.ToList(); foreach (var item in sessions) { if (courseSession.InstructorID == item.InstructorID && courseSession.CourseID == item.CourseID) { ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title"); ViewBag.InstructorID = new SelectList(db.Instructors, "ID", "LastName"); ViewBag.ErrorMessage = ErrorMessages.ErrorMessageSameCourse(); return(View()); } } //Check minimal duration of one coursesession if ((courseSession.Duration) < 1) { ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title"); ViewBag.InstructorID = new SelectList(db.Instructors, "ID", "LastName"); ViewBag.ErrorMessage = ErrorMessages.ErrorMessageNegativeTime(); return(View()); } //Check that the day of course is the same of the date start if (courseSession.DayOfWeek.ToString() != courseSession.DateTime.DayOfWeek.ToString()) { ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title"); ViewBag.InstructorID = new SelectList(db.Instructors, "ID", "LastName"); ViewBag.ErrorMessage = ErrorMessages.ErrorMessageNotSameDay(); return(View()); } db.CourseSessions.Add(courseSession); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title", courseSession.CourseID); ViewBag.InstructorID = new SelectList(db.Instructors, "ID", "LastName", courseSession.InstructorID); return(View(courseSession)); }
public IHttpActionResult SaveCourseSession(UserSaveCourse cs) { DAL.DataContext dt = new DAL.DataContext(); Course my_cs = dt.Courses.Include("Teacher").Where(c => c.Id == cs.CourseId).FirstOrDefault(); CourseSession css = new CourseSession(); css.Teacher = my_cs.Teacher; css.Course = my_cs; DateTime oDate = DateTime.ParseExact(cs.MyTime, "yyyy-MM-dd HH:mm", null); css.When = oDate; User current = dt.Users.Find(User.Identity.GetUserId()); css.Student = current; css.Status = "Waiting Accept"; dt.CourseSessions.Add(css); dt.SaveChanges(); return(Ok()); }
public void Test_UpdateSessionCapacity() { var data = new EfData(); TimeSpan startTime = new TimeSpan(0, 15, 25, 00); TimeSpan endTime = new TimeSpan(0, 17, 00, 00); CourseSession sessionToUpdate = new CourseSession { CourseId = 1, Professor = "Bob Smith", Capacity = 40, DaysInSession = "TH", StartTime = startTime, EndTime = endTime }; //Add test session data.InsertSession(sessionToUpdate); int updatedCapacity = 50; var actual = data.UpdateSessionCapacity(updatedCapacity, sessionToUpdate.Id); Assert.True(actual); //Remove any test data data.RemoveSession(sessionToUpdate); }
public bool DuplicateSession(long id, CourseSession request) { var output = false; var currentRecord = _context.CourseSession.Where(x => x.id == id) .FirstOrDefault(); if (currentRecord != null) { CourseSession newRequest = new CourseSession(); newRequest = request; newRequest.id = 0; newRequest.createdAt = DateTime.Now; newRequest.updatedAt = DateTime.Now; _context.CourseSession.Add(newRequest); _context.SaveChanges(); output = true; } return(output); }
public IActionResult CopySession(long id, CourseSession request) { try { var response = _courseSessionRepository.DuplicateSession(id, request); if (response == true) { return(Ok(new GenericResult { Response = response, Message = "Session has been copied!" })); } else { return(NotFound(_NotFound)); } } catch (Exception e) { return(BadRequest()); } }
public bool Update(long id, CourseSession request) { var output = false; CourseSession model = GetById(id); if (model != null) { model.courseId = request.courseId; model.sessionTypeId = request.sessionTypeId; model.sessionLocation = request.sessionLocation; model.userGroupId = request.userGroupId; model.capacity = request.capacity; model.startDate = request.startDate; model.endDate = request.endDate; model.duration = request.duration; model.courseInstructorId = request.courseInstructorId; model.title = request.title; model.description = request.description; model.updatedAt = DateTime.Now; Save(); output = true; } return(output); }
public IActionResult Store(CourseSession request) { RequiredFields model = new RequiredFields(); model.CourseSession = request; object validateFields = _validationService.ValidateRequest("Course Session", model); if (JsonConvert.SerializeObject(validateFields).Length > 2) { return(BadRequest(validateFields)); } try { _courseSessionRepository.Add(request); return(Ok(new GenericResult { Response = true, Message = "Session has been successfully added" })); } catch (Exception e) { return(BadRequest(e)); } }
private bool isExists(CourseSession request) { return(_context.CourseSession.Where(x => x.id == request.id).Any()); }
public async Task <ActionResult> LaunchCourse(int CourseId, string code) { TenantRepository tr = new TenantRepository(); var tenantList = tr.VerifyTenantDomain(Request.Url.Host); TblUser sessionUser = (TblUser)Session["UserSession"]; var courseBaseURL = System.Configuration.ConfigurationManager.AppSettings["CourseBaseURL"]; if (sessionUser == null) { if (string.IsNullOrEmpty(code)) { CourseSession courseSession = new CourseSession(); courseSession.CourseId = CourseId; Session["CourseId"] = CourseId; return(Redirect("https://pumplace.plek.co/oidc/auth?client_id=1663f8ca-7b8a-42eb-ae3b-845e32be1baf&scope=openid&response_type=code&redirect_uri=https://quiz.rockettech.co.nz/")); } else { using (var client = new HttpClient()) { client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json")); client.DefaultRequestHeaders.Add("Access-Control-Allow-Origin", "*"); string tokenApi = "https://pumplace.plek.co/oidc/token"; var values = new Dictionary <string, string>(); values.Add("client_id", "1663f8ca-7b8a-42eb-ae3b-845e32be1baf"); values.Add("client_secret", "TZD4Jr837e6uymsJdyxH2jk8qxGQiK7gXDCmYqtC"); values.Add("grant_type", "authorization_code"); values.Add("code", code); values.Add("redirect_uri", "https://quiz.rockettech.co.nz/"); var content = new FormUrlEncodedContent(values); var responseTask = await client.PostAsync(tokenApi, content); var result = await responseTask.Content.ReadAsStringAsync(); var data = (JObject)JsonConvert.DeserializeObject(result); string token = data["access_token"].Value <string>();//Access Token Received //Now get User Details string userApi = "https://pumplace.plek.co/oidc/me"; client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json")); client.DefaultRequestHeaders.Add("Authorization", "Bearer " + token); HttpResponseMessage response = await client.GetAsync(userApi); if (response.IsSuccessStatusCode) { string jsondata = await response.Content.ReadAsStringAsync(); var userData = (JObject)JsonConvert.DeserializeObject(jsondata); string email = userData["email"].Value <string>(); string name = userData["username"].Value <string>(); var userId = ur.IsUserExist(email, Request.Url.Host); if (userId == 0) { try { //Create user TblUser newUser = new TblUser(); newUser.FirstName = name; newUser.EmailId = email; newUser.RoleId = 3; newUser.IsActive = true; newUser.CreatedBy = 1; CommonFunctions common = new CommonFunctions(); newUser.Password = common.GetEncodePassword("123456"); newUser.TenantId = tenantList[0].TenantId; var newUserId = ur.AddUser(newUser); var assign = cr.AssignCourse(CourseId, newUserId, null); userId = newUserId; } catch (Exception ex) { newException.AddException(ex); } } else { try { var isAssigned = cr.CheckCourseAssignedUser(CourseId, userId); if (!isAssigned) { var assign = cr.AssignCourse(CourseId, userId, null); } } catch (Exception ex) { newException.AddException(ex); } } var urlNew = courseBaseURL + "?AID=" + CourseId + "&LID=" + userId; return(Redirect(urlNew)); //return Content("<script>window.open('" + urlNew + "','_blank')</script>"); } } } } List <tblCourse> CourseDetails = new List <tblCourse>(); CoursesRepository courseRepo = new CoursesRepository(); CourseDetails = courseRepo.GetCourseById(CourseId); var url = courseBaseURL + "?AID=" + CourseId + "&LID=" + sessionUser.UserId; CourseDetails[0].ContentModuleURL = url; if (tenantList[0].TenantId == 6) { return(Content("<script>window.open('" + url + "','_blank')</script>")); } else { return(View(CourseDetails[0])); } //return Redirect(url); //return Content("<script>window.open('" + url + "','_blank')</script>"); }