public static async Task <int> UpdateAsync(this DataMapObject mapObject)
{
var selectQuery = "SELECT * FROM " + mapObject.TableName + " WHERE " + mapObject.GetAttribute(nameof(mapObject.Guid)).ColumnName + " = '" + mapObject.Guid + "'";
using (var results = await DBFactory.GetMySqlDatabase().DataTableFromQueryStringAsync(selectQuery))
{
results.Rows[0][Tables.Extensions.ModifyUser] = Security.SecurityFunctions.LocalUser.UserName;
PopulateRowFromObject(results.Rows[0], mapObject);
return(await DBFactory.GetMySqlDatabase().UpdateTableAsync(selectQuery, results));
}
}
public static string DeleteMapObject(DataMapObject mapObject)
{
return(string.Format("DELETE FROM {0} WHERE {1} ='{2}'", mapObject.TableName, mapObject.GetAttribute(nameof(mapObject.Guid)).ColumnName, mapObject.Guid));
}