public bool ForgotPassword(PasswordResetModel prEntity)
{
bool bresult = false;
using (var _acoubntContext = new DeluxeOrderManagementEntities())
{
var ety = _acoubntContext.UserModels.FirstOrDefault(e => e.Email == prEntity.Email && e.Active == true);
if (ety != null)
{
//Max
ety.LoginAttempts = 99;
_acoubntContext.Entry(ety).State = System.Data.Entity.EntityState.Modified;
prEntity.UserId = ety.UserId;
_acoubntContext.PasswordResetModels.Add(prEntity);
_acoubntContext.Entry(prEntity).State = System.Data.Entity.EntityState.Added;
_acoubntContext.SaveChanges();
prEntity.UserId = ety.UserId;
prEntity.Email = ety.Email;
bresult = true;
}
}
return(bresult);
}
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 Save(UserModel user)
{
using (var _context = new DeluxeOrderManagementEntities())
{
_context.UserModels.Add(user);
_context.Entry(user).State = System.Data.Entity.EntityState.Added;
_context.SaveChanges();
}
}
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 Update(UserModel user)
{
using (var _context = new DeluxeOrderManagementEntities())
{
var ety = _context.UserModels.FirstOrDefault(x => x.UserId == user.UserId);
if (ety != null)
{
ety.UserName = user.Email;
ety.FirstName = user.FirstName;
ety.LastName = user.LastName;
ety.Email = user.Email;
ety.PhoneNo = user.PhoneNo;
ety.Title = user.Title;
ety.Active = user.Active;
ety.ModifiedDate = user.ModifiedDate;
var userroles = ety.UserRoles.Where(x => x.UserId == user.UserId);
if (userroles != null && userroles.Any())
{
foreach (var userrole in userroles.ToList())
{
var ur = ety.UserRoles.FirstOrDefault(x => x.UserId == userrole.UserId && x.RoleId == userrole.RoleId);
ety.UserRoles.Remove(ur);
_context.Entry(ur).State = System.Data.Entity.EntityState.Deleted;
}
}
foreach (var selectedrole in user.UserRoles)
{
var insertedRole = new Repository.UserRoleModel()
{
UserId = user.UserId,
RoleId = selectedrole.RoleId
};
ety.UserRoles.Add(insertedRole);
_context.Entry(insertedRole).State = System.Data.Entity.EntityState.Added;
}
_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();
}
}
public void SetLastLoginInfo(int userId)
{
using (var _acoubntContext = new DeluxeOrderManagementEntities())
{
var ety = _acoubntContext.UserModels.FirstOrDefault(e => e.UserId == userId);
ety.LoginAttempts = 0;
ety.LastLogin = DateTime.UtcNow;
_acoubntContext.Entry(ety).State = System.Data.Entity.EntityState.Modified;
_acoubntContext.SaveChanges();
}
}
public void IncrementLoginAttempts(string userName)
{
using (var _acoubntContext = new DeluxeOrderManagementEntities())
{
var ety = _acoubntContext.UserModels.FirstOrDefault(e => e.UserName == userName);
if (ety != null)
{
ety.LoginAttempts += 1;
_acoubntContext.Entry(ety).State = System.Data.Entity.EntityState.Modified;
_acoubntContext.SaveChanges();
}
}
}
public void Delete(int id)
{
using (var _context = new DeluxeOrderManagementEntities())
{
var ety = _context.UserModels.FirstOrDefault(x => x.UserId == id);
if (ety != null)
{
//var upeties = _context.UserPasswordModels.Where(x => x.UserId == id);
//foreach (var up in upeties)
//{
// ety.UserPasswords.Remove(up);
// _context.Entry(up).State = System.Data.Entity.EntityState.Deleted;
//}
//_context.UserModels.Remove(ety);
ety.Active = false;
_context.Entry(ety).State = System.Data.Entity.EntityState.Modified;
_context.SaveChanges();
}
}
}
