public Task Merge(DealerManifest.Asset asset) =>
_dealerOnDb.ExecuteAction(connection =>
{
var sql = $@"
update
VehiclePhotos
set
caption = @Caption
where
path = @Path
if @@rowcount = 0
begin
insert into VehiclePhotos
(
year,
make,
model,
number,
path,
caption,
responsive,
is_campaign
)
values
(
null,
'toyota',
null,
1,
@Path,
@Caption,
0,
1
)
end
";
return(connection.ExecuteAsync(sql, new
{
Path = _bannerPath.GetPath(asset.File.Name),
asset.Caption
}));
});
void Given(DealerManifestDownloaded e) => _asset = e.Assets.First(asset => asset.Id == Id);
