public override MembershipUser GetUser(string username, bool userIsOnline)
{
try
{
using (DomesticViolenceContext db = new DomesticViolenceContext())
{
Login login = db.Logins.FirstOrDefault(l => l.UserLogin == username);
//Login login = (from l in db.Logins
// where l.UserLogin == username
// select l).FirstOrDefault();
if (login != null)
{
return(new MembershipUser("CustomMembershipProvider", login.UserLogin, null, null, null, null, false, false, DateTime.Now, DateTime.MinValue, DateTime.MinValue, DateTime.MinValue, DateTime.MinValue));
}
}
}
catch (Exception ex)
{
//string rt = ex.Message;
return(null);
}
return(null);
}
public override bool ValidateUser(string username, string password)
{
bool isValid = false;
using (DomesticViolenceContext db = new DomesticViolenceContext())
{
try
{
Models.User user = (from u in db.Users
from l in db.Logins
where l.UserLogin == username && u.UserId == l.Id
select u
).FirstOrDefault();
//User user = db.Users.AsEnumerable().FirstOrDefault(u => u.Login.UserLogin == username);
if (user != null &&
db.Logins.First(l => l.Id == user.UserId).Password.SequenceEqual(
new System.Security.Cryptography.MD5CryptoServiceProvider().ComputeHash(System.Text.Encoding.Unicode.GetBytes(password))))
{
isValid = true;
}
}
catch
{
isValid = false;
}
return(isValid);
}
}
public override void CreateRole(string roleName)
{
Role newRole = new Role()
{
RoleName = roleName
};
DomesticViolenceContext db = new DomesticViolenceContext();
db.Roles.Add(newRole);
db.SaveChanges();
}
public override bool IsUserInRole(string username, string roleName)
{
bool outputResult = false;
// Находим пользователя
using (DomesticViolenceContext db = new DomesticViolenceContext())
{
try
{
// Получаем пользователя
User user = db.Users.FirstOrDefault(u => u.Login.UserLogin == username);
/*User user = (from u in db.Users
* from l in db.Logins
* where l.UserLogin == username && u.Login == l
* select u).FirstOrDefault();*/
//User user = (from u in db.Users
// where u.Login == username
// select u).FirstOrDefault();
if (user != null)
{
// получаем роль
//Role userRole = db.Roles.Find(user.RoleId);
//сравниваем
//if (userRole != null && userRole.RoleName == roleName)
if (user.Role != null && user.Role.RoleName == roleName)
{
outputResult = true;
}
}
}
catch
{
outputResult = false;
}
}
return(outputResult);
}
public override string[] GetRolesForUser(string username)
{
string[] roles = new string[] { };
using (DomesticViolenceContext db = new DomesticViolenceContext())
{
try
{
// Получаем пользователя
User user = db.Users.FirstOrDefault(u => u.Login.UserLogin == username);
/*User user = (from u in db.Users
* from l in db.Logins
* where l.UserLogin == username && u.Login == l
* select u).FirstOrDefault();*/
//User user = (from u in db.Users
// where u.Login == username
// select u).FirstOrDefault();
if (user != null)
{
// получаем роль
//Role userRole = db.Roles.Find(user.RoleId);
//if (userRole != null)
if (user.Role != null)
{
roles = new string[] { user.Role.RoleName };
}
}
}
catch
{
roles = new string[] { };
}
}
return(roles);
}
public MembershipUser CreateUser(string lastname, string firstname, string login, byte[] password, string Role)
{
MembershipUser membershipUser = GetUser(login, false);
if (membershipUser == null)
{
try
{
using (DomesticViolenceContext db = new DomesticViolenceContext())
{
db.Logins.Add(
new Models.Login
{
UserLogin = login,
Password = password
});
db.SaveChanges();
User user = new User
{
LastName = lastname,
FirstName = firstname,
LoginId = db.Logins.AsEnumerable().Last().Id,
RoleId = 2
};
db.Users.Add(user);
db.SaveChanges();
return(GetUser(login, false));
}
}
catch (Exception)
{
return(null);
}
}
return(null);
}
