public ActionResult Register()
{
ViewBag.PasswordLength = MembershipService.MinPasswordLength;
SelectList sl = new SelectList(Roles.GetAllRoles(), "roleNames");
string password = Membership.GeneratePassword(8, 1);
ViewData["roleNames"] = sl;
RegisterModel rM = new RegisterModel();
rM.Password = password;
return View(rM);
}
public ActionResult Register(RegisterModel model)
{
// model.roleName = "School";
if (ModelState.IsValid)
{
// Attempt to register the user
MembershipCreateStatus createStatus = MembershipService.CreateUser(model.UserName, model.Password, model.Email);
if (createStatus == MembershipCreateStatus.Success)
{
//FormsService.SignIn(model.UserName, false /* createPersistentCookie */);
Roles.AddUserToRole(model.UserName, model.roleName.ToString());
MembershipUser user = Membership.GetUser(model.UserName);
Guid guid = (Guid)user.ProviderUserKey;
if (model.FirstName == null) { model.FirstName = ""; }
if (model.Surname == null) { model.Surname = ""; }
//...Add School Details...
UserRepository userRep = new UserRepository();
userRep.InsertUserSchool(guid, model.ClientId);
return RedirectToAction("Index", "Home");
}
else
{
ModelState.AddModelError("", AccountValidation.ErrorCodeToString(createStatus));
return View(model);
}
}
// If we got this far, something failed, redisplay form
ViewBag.PasswordLength = MembershipService.MinPasswordLength;
SelectList sl = new SelectList(Roles.GetAllRoles(), "roleNames");
//remove items as needed
ViewData["roleNames"] = sl;
return View(model);
}
public ActionResult _InsertUser(FormCollection form)
{
ViewData["Clients"] = schReP.GetSchoolList();
string x = form["x[]"].ToString();
List<string> roles = x.Split(',').ToList();
RegisterModel model = new RegisterModel();
model.Approved = false;
model.FirstName = form["FirstName"].ToString();
model.Surname = form["Surname"].ToString();
model.UserName = form["UserName"].ToString();
model.Email = form["Email"].ToString();
model.Password = form["Password"].ToString();
model.ConfirmPassword = form["ConfirmPassword"].ToString();
model.ClientId = Convert.ToInt32(form["ClientId"]);
//....Insert User...
if (ModelState.IsValid)
{
// Attempt to register the user
MembershipCreateStatus createStatus = MembershipService.CreateUser(model.UserName, model.Password, model.Email);
if (createStatus == MembershipCreateStatus.Success)
{
//FormsService.SignIn(model.UserName, false /* createPersistentCookie */);
//Roles.AddUserToRole(model.UserName, model.roleName.ToString());
foreach (string role in roles)
{
Roles.AddUserToRole(model.UserName, role);
}
MembershipUser user = Membership.GetUser(model.UserName);
Guid guid = (Guid)user.ProviderUserKey;
if (model.FirstName == null) { model.FirstName = ""; }
if (model.Surname == null) { model.Surname = ""; }
//...Add School Details...
//UserRepository userRep = new UserRepository();
userRep.InsertUserSchool(guid, model.ClientId);
}
else
{
ModelState.AddModelError("", AccountValidation.ErrorCodeToString(createStatus));
}
}
//...Repopulate Grid...
//...Initialize List...
List<RegisterModel> lst = new List<RegisterModel>();
//...Populate List...
lst = userRep.GetUsers();
//...Return List to Grid...
return View(new GridModel(lst));
}
public ActionResult _UpdateUser(RegisterModel model)
{
ViewData["Clients"] = schReP.GetSchoolList();
//...Repopulate Grid...
List<Client> lst = new List<Client>();
lst = schReP.GetListClient();
return View(new GridModel(lst));
}
public List<RegisterModel> GetUsers()
{
List<RegisterModel> list = new List<RegisterModel>();
RegisterModel ins;
//...Database Connection...
DataBaseConnection dbConn = new DataBaseConnection();
SqlConnection con = dbConn.SqlConn();
SqlCommand cmdI;
//...SQL Commands...
cmdI = new SqlCommand("SELECT us.UsersId, u.UserId, u.UserName, u.LastActivityDate, us.ClientId, m.LoweredEmail, m.IsApproved, m.IsLockedOut FROM aspnet_Users u INNER JOIN Users us ON u.UserId = us.UserId INNER JOIN aspnet_Membership m ON u.UserId = m.UserId", con);
cmdI.Connection.Open();
SqlDataReader drI = cmdI.ExecuteReader();
//...Retrieve Data...
if (drI.HasRows)
{
while (drI.Read())
{
ins = new RegisterModel();
ins.UserId = (Guid)drI["UserId"];
ins.UserName = drI["UserName"].ToString();
ins.LastLogin = Convert.ToDateTime(drI["LastActivityDate"]);
ins.ClientId = Convert.ToInt32(drI["ClientId"]);
ins.Email = drI["LoweredEmail"].ToString();
ins.Approved = Convert.ToBoolean(drI["IsApproved"]);
ins.Locked = Convert.ToBoolean(drI["IsLockedOut"]);
ins.UsersId = Convert.ToInt32(drI["UsersId"]);
list.Add(ins);
}
}
drI.Close();
con.Close();
return list;
}
