public static void UnlockAccount(this DialogueStoreContext db, int userId)
{
var user = db.Get(userId);
if (user == null)
{
return;
}
user.Locked = false;
db.SaveChanges();
}
public static void UpdateLastLoginDate(this DialogueStoreContext db, string userName)
{
var user = db.Get(userName);
if (user == null)
{
return;
}
user.LastLogin = DateTime.UtcNow;
db.SaveChanges();
}
public static void RejectRequest(this DialogueStoreContext db, int userId)
{
var user = db.Get(userId);
if (user == null)
{
return;
}
user.Approved = false;
db.SaveChanges();
}
public static void Update(this DialogueStoreContext db, User row)
{
var user = db.Get(row.UserName);
if (user == null)
{
return;
}
user.Approved = row.Approved;
user.DisplayName = row.DisplayName;
user.Locked = row.Locked;
user.Role = row.Role;
user.SecretAnswer = row.SecretAnswer;
user.SecretQuestion = row.SecretQuestion;
db.SaveChanges();
}
public static ResetPasswordResult ResetPassword(this DialogueStoreContext db, string userName, string question, string answer, string password)
{
var user = db.Get(userName);
if (user == null)
{
return(ResetPasswordResult.InvalidUserName);
}
if (user.SecretAnswer != answer)
{
return(ResetPasswordResult.InvalidAnswer);
}
user.Password = password;
db.SaveChanges();
return(ResetPasswordResult.Success);
}
protected BaseRepository(DialogueStoreContext db)
{
Db = db;
}
protected BaseController()
{
Db = new DialogueStoreContext();
Mapper.AddProfile <DialogueStoreProfile>();
}
public MovementRepository(DialogueStoreContext db)
: base(db)
{
}
public LocationRepository(DialogueStoreContext context)
: base(context)
{
}
protected EntityRepository(DialogueStoreContext db)
: base(db)
{
}
public StockConditionRepository(DialogueStoreContext db)
: base(db)
{
}
public ItemRepository(DialogueStoreContext db)
: base(db)
{
}
public static User Get(this DialogueStoreContext db, int userId)
{
return(db.Users.SingleOrDefault(u => u.UserId == userId));
}
public static bool Authenticate(this DialogueStoreContext db, string userName, string password)
{
return(db.Users.Any(x => x.UserName == userName && x.Password == password));
}
public static int CreateUser(this DialogueStoreContext db, User u)
{
db.Users.Add(u);
db.SaveChanges();
return(u.UserId);
}
public static User Get(this DialogueStoreContext db, string userName)
{
return(db.Users.SingleOrDefault(x => x.UserName == userName));
}
