public bool ResetPassword(PasswordReset passwordReset)
{
DateTime utctime = DateTime.UtcNow;
UserModel userEty = null;
bool bresult = false;
using (var _acoubntContext = new DeluxeOrderManagementEntities())
{
var prety = _acoubntContext.PasswordResetModels
.Include("User")
.FirstOrDefault(x => x.Email == passwordReset.Email && x.Token == passwordReset.Token &&
x.ExpireDateTime >= utctime && (x.User != null && x.User.Active == true));
//var user = (from pr in _acoubntContext.PasswordResetEntities
// join u in _acoubntContext.UserEntities on pr.UserId equals u.UserId
// where pr.Email == passwordReset.Email && pr.Token == passwordReset.Token && pr.ExpireDateTime >= utctime && u.Active
// select u).FirstOrDefault();
if (prety != null)
{
userEty = prety.User;
}
if (userEty != null)
{
UserPasswordModel upEty = new UserPasswordModel()
{
UserId = userEty.UserId,
Password = passwordReset.Password,
PasswordDate = utctime,
CreatedDate = utctime
};
_acoubntContext.UserPasswordModels.Add(upEty);
_acoubntContext.Entry(upEty).State = System.Data.Entity.EntityState.Added;
userEty.LoginAttempts = 0;
_acoubntContext.Entry(userEty).State = System.Data.Entity.EntityState.Modified;
//var pwdreset = (from pr in _acoubntContext.PasswordResetEntities
// where pr.UserId == user.UserId
// select pr).FirstOrDefault();
var prEty = _acoubntContext.PasswordResetModels.FirstOrDefault(x => x.UserId == userEty.UserId);
_acoubntContext.PasswordResetModels.Remove(prEty);
_acoubntContext.Entry(prEty).State = System.Data.Entity.EntityState.Deleted;
bresult = true;
_acoubntContext.SaveChanges();
}
}
return(bresult);
}
public void ChangePassword(UserPasswordModel upEntity)
{
using (var _context = new DeluxeOrderManagementEntities())
{
var ety = _context.UserModels.FirstOrDefault(e => e.UserId == upEntity.UserId);
if (ety != null)
{
_context.UserPasswordModels.Add(upEntity);
_context.Entry(upEntity).State = System.Data.Entity.EntityState.Added;
ety.LoginAttempts = 0;
_context.Entry(ety).State = System.Data.Entity.EntityState.Modified;
_context.SaveChanges();
}
}
}
public void ExpiredPassword(PasswordReset passwordReset)
{
using (var _acoubntContext = new DeluxeOrderManagementEntities())
{
var uety = _acoubntContext.UserModels.FirstOrDefault(e => e.Email == passwordReset.Email);
var upEty = new UserPasswordModel()
{
UserId = uety.UserId,
Password = passwordReset.Password,
PasswordDate = DateTime.UtcNow,
CreatedDate = DateTime.UtcNow
};
_acoubntContext.UserPasswordModels.Add(upEty);
_acoubntContext.Entry(upEty).State = System.Data.Entity.EntityState.Added;
uety.LoginAttempts = 0;
_acoubntContext.Entry(uety).State = System.Data.Entity.EntityState.Modified;
_acoubntContext.SaveChanges();
}
}
