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