/// <summary>
/// delete by id
/// </summary>
/// <param name="id">id</param>
/// <returns>delete record count</returns>
internal int DeleteById(long id)
{
var sql = new SqlBuilder();
sql.AppendSql("DELETE FROM profiles")
.AppendSql("WHERE id = @id");
var paramList = new ParameterList();
paramList.Add("@id", id);
var count = 0;
using (var database = new SystemDatabase()) {
database.Open();
count = database.ExecuteNonQuery(sql, paramList);
}
return(count);
}
/// <summary>
/// update display name by id
/// </summary>
/// <param name="model">profile model</param>
/// <returns>affected record count</returns>
internal int UpdateDisplayNameById(ProfileModel model)
{
var sql = new SqlBuilder();
sql.AppendSql("UPDATE profiles SET")
.AppendSql(" display_name = @display_name")
.AppendSql("WHERE id = @id");
var paramList = new ParameterList();
paramList.Add("@display_name", model.DisplayName)
.Add("@id", model.Id);
var count = 0;
using (var database = new SystemDatabase()) {
database.Open();
count = database.ExecuteNonQuery(sql, paramList);
}
return(count);
}
