// GET: Admin/Create
public ActionResult Create()
{
int userID = Convert.ToInt32(Session["UserID"] != null ? Session["UserID"].ToString() : "0"); // Convert session user id to integer for comparison and prevent from NULL
var usr = from u in db.users
select u.UserID; // Get current user IDs in database
TempData["usrMax"] = Convert.ToInt32(usr.Max().ToString()) + 1; // Put next user id into temp data
var Role = db.roles.Select(r => new SelectListItem // Create role selection list
{
Text = r.RoleName,
Value = r.RoleID.ToString()
});
ViewBag.UserRoleID = new SelectList(Role.OrderBy(r => r.Text), "Value", "Text"); // Pass role selection list
ViewBag.userName = (from u in db.users
where (u.UserID == userID)
select u.UserFName).FirstOrDefault().ToString(); // Passing user first name to view
UserAcctViewModels uaModel = new UserAcctViewModels(); // Create a new user account view model
return(View(uaModel));
}
public ActionResult Create(UserAcctViewModels uaModel, string UserRoleID)
{
int userID = Convert.ToInt32(Session["UserID"].ToString()); // Get session user id
uaModel.User.UserRoleID = Convert.ToInt32(UserRoleID != null ? UserRoleID.ToString() : "1"); // Set user role id
int acctID = Convert.ToInt32(TempData["usrMax"] != null ? TempData["usrMax"].ToString() : "1000"); // Set account id
account acct = new account() // Create a new account
{
AcctID = acctID,
AcctLName = uaModel.AcctLName,
AcctPasswd = uaModel.AcctPasswd
};
if (ModelState.IsValid) // Add user and account
{
db.users.Add(uaModel.User);
db.SaveChanges();
db.accounts.Add(acct);
db.SaveChanges();
return(RedirectToAction("Index", new { sucMsg = "New user created" })); // Go back to list and display successful message
}
// If the model was invalid, display and do it over again
var usr = from u in db.users
select u.UserID; // Get current user IDs in database
TempData["usrMax"] = Convert.ToInt32(usr.Max().ToString()) + 1; // Put next user id into temp data
var Role = db.roles.Select(r => new SelectListItem // Create role selection list
{
Text = r.RoleName,
Value = r.RoleID.ToString()
});
ViewBag.UserRoleID = new SelectList(Role.OrderBy(r => r.Text), "Value", "Text"); // Pass role selection list
ViewBag.userName = (from u in db.users
where (u.UserID == userID)
select u.UserFName).FirstOrDefault().ToString(); // Passing user first name to view
UserAcctViewModels uaModelA = new UserAcctViewModels(); // Create a new user account view model
return(View(uaModelA));
}