public IEnumerable<UserRole> GetRolesForUser(User user) { if (user == null) throw new ArgumentNullException("user"); return GetRolesForUser(user.Id); }
public UpdateResult CreateRoleForUser(User user, string role) { if (user == null) throw new ArgumentNullException("user"); return CreateRoleForUser(user.Email, role, user.Stamp); }
public void TestDeleteAndListAndInsert() { _userRepo.DeleteAll(); var items = _userRepo.List(); Assert.True(items.Count() == 0); List<User> userCollection = new List<User>(); int userCounter = 20; for (int i = 0; i < userCounter; i++) { User user = new User { Locale = "en", Name = i.ToString(), Password = "******", TimeZone = 1000 }; _userRepo.Insert(user); Assert.GreaterOrEqual(user.Id, 1); Assert.GreaterOrEqual(user.Stamp, DateTime.UtcNow.AddMinutes(-1)); userCollection.Add(user); } _userRepo.List(); }
public User Insert(User user) { if (user == null) throw new ArgumentNullException("user"); return SqlQueryExecutor.Exceute(() => { String query = string.Format(CultureInfo.InvariantCulture, "INSERT INTO {1} {0}; SELECT LAST_INSERT_ID();", InsertFieldList, TableName); int insertedId = (int)Connectionprovider.CurrentConnection.Query<long>(query, new { user.Name, user.Email, user.Password, user.Locale, user.TimeZone }).FirstOrDefault(); if (insertedId <= 0) throw new StorageMonsterDbException("User insertion failed"); String idAndStampQuery = string.Format(CultureInfo.InvariantCulture, "SELECT id AS Id, stamp AS Stamp FROM {0} WHERE id=@Id;", TableName); IdAndStamp idAndStamp = Connectionprovider.CurrentConnection.Query<IdAndStamp>(idAndStampQuery, new { Id = insertedId }).FirstOrDefault(); if (idAndStamp == null) throw new StorageMonsterDbException("User insertion failed"); user.Id = idAndStamp.Id; user.Stamp = idAndStamp.Stamp; return user; }); }
public User Update(User user) { if (user == null) throw new ArgumentNullException("user"); return SqlQueryExecutor.Exceute(() => { String query = string.Format(CultureInfo.InvariantCulture, "UPDATE {1} SET {0} WHERE Id=@Id", UpdateFieldList, TableName); Connectionprovider.CurrentConnection.Execute(query, new { user.Email, user.Name, user.Password, user.Locale, user.TimeZone, user.Id }); String idAndStampQuery = string.Format(CultureInfo.InvariantCulture, "SELECT id AS Id, stamp AS Stamp FROM {0} WHERE id=@Id;", TableName); IdAndStamp idAndStamp = Connectionprovider.CurrentConnection.Query<IdAndStamp>(idAndStampQuery, new { user.Id }).FirstOrDefault(); if (idAndStamp == null) throw new StorageMonsterDbException("User update failed"); user.Id = idAndStamp.Id; user.Stamp = idAndStamp.Stamp; return user; }); }
public User Select(User user) { if (user == null) throw new ArgumentNullException("user"); return Select(user.Id); }