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 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()); }