public bool Update(User user)
{
using (IDbConnection connection = OpenConnection())
{
return 1 == connection.Execute(
string.Format(@"UPDATE `users` SET {0} WHERE `UserId` = @UserId;",
SqlHelper.Sets(_userUpdateColumns)),
user);
}
}
public bool Add(User user)
{
using (IDbConnection connection = OpenConnection())
{
return 1 == connection.Execute(
string.Format(@"INSERT INTO `users` ({0}) VALUES ({1});",
SqlHelper.Columns(_userColumns),
SqlHelper.Params(_userColumns)),
user);
}
}
public static User Create(CreateUser command)
{
User user = new User();
user.State = UserState.Initial;
user.EnsoureAndUpdateState(command);
user.UserId = command.UserId;
user.Name = command.Name;
user.Email = command.Email;
user.CreateAt = command.CreateAt;
user.CreateBy = command.CreateBy;
user.UpdateAt = command.CreateAt;
user.UpdateBy = command.CreateBy;
return user;
}