public void Save(string[] columns, object[] values)
{
if (columns.Length < 1 || columns.Length != values.Length)
{
return;
}
string query = "UPDATE rooms SET ";
MySqlParameter[] parameters = new MySqlParameter[columns.Length + 1];
for (int i = 0; i < columns.Length && i < values.Length; i++)
{
if (i > 0)
{
query += ", ";
}
query += $"{columns[i]} = @{columns[i]}";
parameters[i] = new MySqlParameter($"@{columns[i]}", values[i]);
}
query += " WHERE id = @roomId";
parameters[parameters.Length - 1] = new MySqlParameter("@roomId", Id);
using (DatabaseConnection dbConnection = Engine.Locator.ConnectionPool.PopConnection())
{
dbConnection.SetQuery(query);
dbConnection.AddParameters(parameters);
dbConnection.Execute();
}
}
