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)); }