// public static void AddCourse(CourseViewModel course) // { // SWC_LMSEntities context = new SWC_LMSEntities(); // { // var startDate = DateTime.Parse(course.StartDate); // var endDate = DateTime.Parse(course.EndDate); // context.AddCourse(course.CourseId, course.SubjectId, course.CourseName, course.CourseDescription, course.IsArchived, startDate, endDate); //context.SaveChanges(); // } // } public static void EditCourse(CourseViewModel course) { SWC_LMSEntities context = new SWC_LMSEntities(); { Course newCourse = new Course(); newCourse.CourseName = "Test Info"; newCourse.CourseDescription = "Test Info Desc"; newCourse.StartDate = DateTime.Now; newCourse.EndDate = DateTime.Now; context.Courses.Add(newCourse); context.SaveChanges(); } }
public ActionResult SaveUserDetails(LmsUserViewModel user) { try { // grab user from DB using (var context = new SWC_LMSEntities()) { var dbUser = context.LmsUsers.FirstOrDefault(x => x.UserId == user.UserId); // update user with incoming view model dbUser.FirstName = user.FirstName; dbUser.LastName = user.LastName; dbUser.GradeLevelId = user.GradeLevelId; dbUser.IsApproved = user.IsApproved; //the following was an attempt to activate the stored procedure //to input this user's unique ID into the AspNetUserRoles table on DB. if (dbUser.SuggestedRole == "Administrator"){ var idToPass = dbUser.Email; TheOneRepo.InsertUserToAdmin(idToPass); } else if (dbUser.SuggestedRole == "Teacher") { var idToPass = dbUser.Email; TheOneRepo.InsertUserToTeacher(idToPass); } else if (dbUser.SuggestedRole == "Student") { var idToPass = dbUser.Email; TheOneRepo.InsertUserToStudent(idToPass); } else if (dbUser.SuggestedRole == "Parent") { var idToPass = dbUser.Email; TheOneRepo.InsertUserToParent(idToPass); } //THIS WORKS // TODO ROLEs... // save user context.SaveChanges(); ViewBag.Message = "Save successful"; } } catch (Exception) { ViewBag.Message = "Error saving user."; // throw; } return View("UserDetails", user); }
public ActionResult SaveCourse(Course course) { try { // grab course from DB using (var context = new SWC_LMSEntities()) { var dbCourse = context.Courses.FirstOrDefault(x => x.CourseId == course.CourseId); // update course with incoming view model dbCourse.CourseId = course.CourseId; dbCourse.CourseName = course.CourseName; dbCourse.CourseDescription = course.CourseDescription; context.SaveChanges(); ViewBag.Message = "Save successful"; } } catch (Exception) { ViewBag.Message = "Error saving user."; // throw; } return View("UserDetails", course); }