public SqlQuery GetFromAssetId(AssetAndDescriptionId info)
{
return(new SqlQuery("SELECT * FROM [RakeItem] WHERE AssetId =@assetId AND DescriptionId =@descId", new Dictionary <string, object>
{
{ "@assetId", info.AssetId },
{ "@descId", info.DescriptionId }
}));
}
public SqlQuery DeleteSingle(AssetAndDescriptionId item)
{
return(new SqlQuery($"DELETE FROM [ITEM] WHERE AssetId =@assetId AND DescriptionId =@descId", new Dictionary <string, object>
{
{ "@assetId", item.AssetId },
{ "@descId", item.DescriptionId }
}));
}
public async Task <DatabaseModel.Item> FindAsync(AssetAndDescriptionId info)
{
var query = _itemQueries.GetFromAssetId(info);
using (var sqlResult = await _databaseConnection.ExecuteSqlQueryAsync(query))
{
return(await sqlResult.GetSingleAsync <DatabaseModel.Item>());
}
}
public async Task <int> DeleteAsync(AssetAndDescriptionId item)
{
var query = _itemQueries.DeleteSingle(item);
return(await _databaseConnection.ExecuteNonQueryAsync(query));
}
