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); }
public static string GetId(string email) { using (var db = new SWC_LMSEntities()) { var results = db.GetGUID(email).FirstOrDefault(); return results; } }
public static List<AspNetRole> GetAllRoles() { using (var db = new SWC_LMSEntities()) { var roles = db.AspNetRoles; // from r in db.AspNetRoles select r; // db.AspNetRoles.ToList(); return roles.OrderBy(r => r.Name).ToList(); } }
public static List<LmsUserSelectUnassignedResult> LmsUserSelectUnassigned() { using (var db = new SWC_LMSEntities()) { var results = db.LmsUserSelectUnassigned().FirstOrDefault(); return LmsUserSelectUnassigned(); } }
public static void InsertNewUserToAspNetUserRoles(LmsUserViewModel reg, string id) { using (var db = new SWC_LMSEntities()) { var output = new ObjectParameter("UserId", typeof(int)); db.InsertToAspNetUserRoles(reg.UserId.ToString(), reg.Roles.ToString()); } }
public static void InsertNewUserToDb(RegisterViewModel reg, string id) { using (var db = new SWC_LMSEntities()) { var output = new ObjectParameter("UserId", typeof(int)); db.LmsUserInsert(id, reg.Fname, reg.Lname, reg.Email, reg.GradeLevelId, reg.SuggestedRole, output); } }
public static LmsUser GetUserWithRoles(int id) { using (var db = new SWC_LMSEntities()) { var dbUser = db.LmsUsers.FirstOrDefault(x => x.UserId == id); // dbUser.Roles = } return null; }
// 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 UserDetails(int? UserId) { if (UserId.HasValue) { LmsUserViewModel user = null; using (var context = new SWC_LMSEntities()) { var dbUser = context.LmsUsers.FirstOrDefault(x => x.UserId == UserId); user = new LmsUserViewModel { FirstName = dbUser.FirstName, LastName = dbUser.LastName, UserId = dbUser.UserId, GradeLevelId = dbUser.GradeLevelId, IsApproved = dbUser.IsApproved ?? false }; ViewBag.UserRoles = TheOneRepo.GetAllRoles(); } return View(user); } ViewBag.Message = "Invalid User Id."; return View(new LmsUserViewModel()); }
public static void InsertUserToTeacher(string email) { using (var db = new SWC_LMSEntities()) { db.InsertUserToTeacherRole(email); } }
public static void InsertUserToStudent(string email) { using (var db = new SWC_LMSEntities()) { db.InsertUserToStudentRole(email); } }
public List<LmsUser> Search(string firstName, string lastName, string eMail) { using (var context = new SWC_LMSEntities()) { return context.LmsUsers.Where(x => x.FirstName.ToUpper().Contains(firstName.ToUpper()) || x.LastName.ToUpper().Contains(lastName.ToUpper()) || x.Email.ToUpper().Contains(eMail.ToUpper())).ToList(); } }