public bool Update(User user)
{
using (var connection = OpenConnection())
{
const string sql = "UPDATE [Users] SET Email = @Email, Password = @Password, Name = @Name, Surname = @Surname, PhotoUrl = @PhotoUrl, ThumbnailUrl = @ThumbnailUrl WHERE Id = @Id";
return connection.Execute(sql, new { user.Id, user.Email, user.Name, user.Password, user.PhotoUrl, user.Surname, user.ThumbnailUrl }) == 1;
}
}
public long Save(User user)
{
using (IDbConnection connection = OpenConnection())
{
// TODO: check if user already exist
const string query =
"INSERT INTO [Users] (Email, Name, Password, PhotoUrl, Surname, ThumbnailUrl)" +
"VALUES (@Email, @Name, @Password, @PhotoUrl, @Surname, @ThumbnailUrl);" +
"SELECT cast(scope_identity() as int)";
return connection.Query<int>(query, new
{
user.Email,
user.Name,
user.Password,
user.PhotoUrl,
user.Surname,
user.ThumbnailUrl
}).First();
}
}
public void Save(User user)
{
_userRepository.Save(user);
}
public bool Update(User member)
{
return _userRepository.Update(member);
}
public void UpdateUser_ReturnTrueWhenUserExists()
{
var user = new User
{
Email = Email,
Name = "Name",
Password = "******",
PhotoUrl = "ThumbnailUrl",
Surname = "Surname"
};
user.Id = _userRepository.Save(user);
bool result = _userRepository.Update(user);
Assert.AreEqual(true, result);
}
