private Nera_User checkUser(string UserName, string Password, ref string mess)
{
IQueryable <Nera_User> us1;
List <Nera_User> us = new List <Nera_User>();
using (var db2 = new AuthenContext())
{
us1 = (from s in db2.Nera_Users where s.UserName.Equals(UserName) select s);
us = us1.ToList();
}
if (us.Count == 0)
{
mess = "user error";
return(new Nera_User());
}
else
{
if (!MD5_Hash(Password).Equals(us.First().PasswordHash) || !us.First().IsEnable)
{
mess = "pass error";
}
}
return(us.First());
}
public override string GetUserNameByEmail(string email)
{
using (AuthenContext dbContext = new AuthenContext())
{
string username = (from u in dbContext.Nera_Users
where string.Compare(email, u.Email) == 0
select u.UserName).FirstOrDefault();
return(!string.IsNullOrEmpty(username) ? username : string.Empty);
}
}
/// <summary>
///
/// </summary>
/// <param name="username"></param>
/// <param name="userIsOnline"></param>
/// <returns></returns>
public override MembershipUser GetUser(string username, bool userIsOnline)
{
using (AuthenContext dbContext = new AuthenContext())
{
var user = (from us in dbContext.Nera_Users
where string.Compare(username, us.UserName, StringComparison.OrdinalIgnoreCase) == 0
select us).FirstOrDefault();
if (user == null)
{
return(null);
}
var selectedUser = new CustomMembershipUser(user);
return(selectedUser);
}
}
/// <summary>
///
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public override bool ValidateUser(string username, string password)
{
if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password))
{
return(false);
}
using (AuthenContext dbContext = new AuthenContext())
{
var user = (from us in dbContext.Nera_Users
where string.Compare(username, us.UserName, StringComparison.OrdinalIgnoreCase) == 0 &&
string.Compare(password, us.PasswordHash, StringComparison.OrdinalIgnoreCase) == 0 &&
us.IsEnable == true
select us).FirstOrDefault();
return((user != null) ? true : false);
}
}
