public static hunterEntities GetContext() { hunterEntities context = new hunterEntities(); ((IObjectContextAdapter)context).ObjectContext.CommandTimeout = 180; //#if DEBUG //context.Database.Log = (s) => deb //#endif return(context); }
public static bool DoesUserEmailExist(string email, hunterEntities context) { return(context.users.Any(u => u.Email == email)); }
public static List <usercharacter> GetUserCharacters(long _userId, hunterEntities context) { return(context.usercharacters.Where(p => p.UserId == _userId).ToList()); }
public static user GetUser(string username, hunterEntities context) { return(context.users.FirstOrDefault(u => u.Name == username || u.Email == username)); }
public static usercharacter AddNewCharacter(string _userName, string _newCharacterName, hunterEntities context) { var user = context.users.FirstOrDefault(u => u.Name == _userName || u.Email == _userName); var newCharacter = new usercharacter { Name = _newCharacterName }; if (user != null) { user.usercharacters.Add(newCharacter); context.SaveChanges(); return(newCharacter); } else { //Throw Error can't create user return(null); } }
public static void AddNewUser(string username, string email, string password, hunterEntities context) { var u = new user { Name = username, Email = email }; u.Password = PasswordHelper.GeneratePasswordSaltAndKey(password); //PasswordHelper.GeneratePasswordSaltAndKey(new RandomPasswordGenerator().Generate()); context.users.Add(u); context.SaveChanges(); }
public static bool UserCredentialsCorrect(string userName, string pAttempt, hunterEntities context) { var user = context.users.FirstOrDefault(u => u.Name == userName || u.Email == userName); return(user != null?PasswordHelper.IsPasswordValid(user.Password, pAttempt) : false); }