//TODO: remove the context here.
public override string GetUserNameByEmail(string email)
{
var entities = new CTSContext();
UserProfile user = (from u in entities.UserProfiles
where u.Email == email
select u).SingleOrDefault();
return(user.UserName);
}
public override MembershipUser GetUser(string username, bool userIsOnline)
{
var entities = new CTSContext();
UserProfile user = (from u in entities.UserProfiles
where u.UserName == username
select u).SingleOrDefault();
return((user != null) ? GetMembershipUser(user) : null);
}
// TODO: Remove the context here.
public override bool ValidateUser(string username, string password)
{
var entities = new CTSContext();
string pass = MD5Hashing.MD5Hash(password);
UserProfile user = (from u in entities.UserProfiles
where u.UserName == username && u.Password == pass &&
!u.LockedInInd && u.ActiveInd
select u).SingleOrDefault();
return((user != null) ? true : false);
}
public override bool ChangePassword(string username, string oldPassword, string newPassword)
{
if (ValidateUser(username, oldPassword))
{
var context = new CTSContext();
UserProfile user = context.UserProfiles.Where(p => p.UserName == username).SingleOrDefault();
if (user != null)
{
user.Password = MD5Hashing.MD5Hash(newPassword);
context.SaveChanges();
return(true);
}
}
return(false);
}
public ReportRepository(CTSContext context)
{
_context = context;
}
public GenericRepository(CTSContext context)
{
_entities = context;
}
public ReportRepository(CTSContext context)
{
_context = context;
}
