public bool Add(UserSecurity userSecurity)
{
using (IDbConnection connection = OpenConnection())
{
return 1 == connection.Execute(
string.Format(@"INSERT INTO `user_security` ({0}) VALUES ({1});",
SqlHelper.Columns(_userSecurityColumns),
SqlHelper.Params(_userSecurityColumns)),
userSecurity);
}
}
public static UserSecurity Create(CreateUserSecurity command)
{
UserSecurity userSecurity = new UserSecurity();
userSecurity.UserId = command.UserId;
userSecurity.PasswordHash = command.PasswordHash;
userSecurity.CreateAt = command.CreateAt;
userSecurity.CreateBy = command.CreateBy;
userSecurity.UpdateAt = command.CreateAt;
userSecurity.UpdateBy = command.CreateBy;
return userSecurity;
}
public bool Update(UserSecurity userSecurity)
{
using (IDbConnection connection = OpenConnection())
{
return 1 == connection.Execute(
string.Format(@"UPDATE `user_security` SET {0} WHERE `UserId` = @UserId;",
SqlHelper.Sets(_userSecurityUpdateColumns)),
userSecurity);
}
}