public MembershipUser CreateUser(string email, string password)
{
MembershipUser membershipUser = GetUser(email, false);
if (membershipUser == null)
{
try
{
using (SwanDbEntities db = new SwanDbEntities())
{
User user = new User();
user.Email = email;
user.Password = Crypto.HashPassword(password);
user.CreationDate = DateTime.Now;
if (db.Roles.Find(2) != null)
{
user.RoleId = 2;
}
db.Users.Add(user);
db.SaveChanges();
membershipUser = GetUser(email, false);
return(membershipUser);
}
}
catch
{
return(null);
}
}
return(null);
}
public override string[] GetRolesForUser(string email)
{
string[] role = new string[] { };
using (SwanDbEntities db = new SwanDbEntities())
{
try
{
// Получаем пользователя
User user = (from u in db.Users
where u.Email == email
select u).FirstOrDefault();
if (user != null)
{
// получаем роль
Role userRole = db.Roles.Find(user.RoleId);
if (userRole != null)
{
role = new string[] { userRole.Name };
}
}
}
catch
{
role = new string[] { };
}
}
return(role);
}
public override bool IsUserInRole(string username, string roleName)
{
bool outputResult = false;
// Находим пользователя
using (SwanDbEntities db = new SwanDbEntities())
{
try
{
// Получаем пользователя
User user = (from u in db.Users
where u.Email == username
select u).FirstOrDefault();
if (user != null)
{
// получаем роль
Role userRole = db.Roles.Find(user.RoleId);
//сравниваем
if (userRole != null && userRole.Name == roleName)
{
outputResult = true;
}
}
}
catch
{
outputResult = false;
}
}
return(outputResult);
}
public ActionResult DeleteConfirmed(int id)
{
var db = new SwanDbEntities();
User user = db.Users.Find(id);
db.Users.Remove(user);
db.SaveChanges();
return(RedirectToAction("ShowAllUsers", "Account"));
}
public override void CreateRole(string roleName)
{
Role newRole = new Role()
{
Name = roleName
};
SwanDbEntities db = new SwanDbEntities();
db.Roles.Add(newRole);
db.SaveChanges();
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
User user = new SwanDbEntities().Users.Find(id);
if (user == null)
{
return(HttpNotFound());
}
return(View(user));
}
public ActionResult Edit([Bind(Include = "Id,Email,Password,CreationDate,RoleId")] User user)
{
var db = new SwanDbEntities();
if (ModelState.IsValid)
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ShowAllUsers", "Account"));
}
ViewBag.RoleId = new SelectList(db.Roles, "Id", "Name", user.RoleId);
return(View(user));
}
public ActionResult Edit(int?id)
{
var db = new SwanDbEntities();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
User user = db.Users.Find(id);
if (user == null)
{
return(HttpNotFound());
}
ViewBag.RoleId = new SelectList(db.Roles, "Id", "Name", user.RoleId);
return(View(user));
}
public override bool ValidateUser(string username, string password)
{
bool isValid = false;
using (SwanDbEntities db = new SwanDbEntities())
{
try
{
User user = db.Users.FirstOrDefault(u => u.Email == username);
if (user != null && Crypto.VerifyHashedPassword(user.Password, password))
{
isValid = true;
}
}
catch
{
isValid = false;
}
}
return(isValid);
}
public override MembershipUser GetUser(string email, bool userIsOnline)
{
try
{
using (SwanDbEntities db = new SwanDbEntities())
{
var users = from u in db.Users
where u.Email == email
select u;
if (users.Count() > 0)
{
User user = users.First();
MembershipUser memberUser = new MembershipUser("MyMembershipProvider", user.Email, null, null, null, null,
false, false, user.CreationDate, DateTime.MinValue, DateTime.MinValue, DateTime.MinValue, DateTime.MinValue);
return(memberUser);
}
}
}
catch
{
return(null);
}
return(null);
}
public ActionResult ShowAllUsers()
{
var users = new SwanDbEntities().Users.ToList();
return(View(users));
}
