public override string GetUserNameByEmail(string email)
{
using (HuythongDB dbContext = new HuythongDB())
{
string username = dbContext.Users
.Where(u => string.Compare(email, u.Email) == 0)
.Select(us => us.Username).FirstOrDefault();
return(!string.IsNullOrEmpty(username) ? username : string.Empty);
}
}
private void Dispose(bool disposing)
{
if (disposing)
{
if (dbContext != null)
{
dbContext.Dispose();
dbContext = null;
}
}
}
public override MembershipUser GetUser(string username, bool userIsOnline)
{
using (HuythongDB dbContext = new HuythongDB())
{
var user = dbContext.Users
.Where(us => string.Compare(username, us.Username, StringComparison.OrdinalIgnoreCase) == 0)
.Select(us => us).FirstOrDefault();
if (user == null)
{
return(null);
}
var selectedUser = new CustomMembershipUser(user);
return(selectedUser);
}
}
public override bool ValidateUser(string username, string password)
{
if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password))
{
return(false);
}
using (HuythongDB dbContext = new HuythongDB())
{
var user = dbContext.Users
.Where(us => string.Compare(username, us.Username, StringComparison.OrdinalIgnoreCase) == 0 &&
string.Compare(password, us.Password, StringComparison.OrdinalIgnoreCase) == 0 &&
us.IsActive)
.Select(us => us).FirstOrDefault();
return((user != null) ? true : false);
}
}
public override string[] GetRolesForUser(string username)
{
if (!HttpContext.Current.User.Identity.IsAuthenticated)
{
return(null);
}
var userRoles = new string[] { };
using (HuythongDB dbContext = new HuythongDB())
{
var selectedUser = dbContext.Users.Include("Roles")
.Where(us => string.Compare(us.Username, username, StringComparison.OrdinalIgnoreCase) == 0)
.Select(us => us)
.FirstOrDefault();
if (selectedUser != null)
{
userRoles = new[] { selectedUser.Roles.Select(r => r.RoleName).ToString() }
}
;
return(userRoles.ToArray());
}
}
public UnitOfWork(HuythongDB _dbContext)
{
dbContext = _dbContext;
}
public Repository(HuythongDB _context)
{
context = _context;
dbSet = context.Set <T>();
}
