public async Task <ImageInfo> InsertImage(ImageInfo imageInfo, Stream image,
CancellationToken token)
{
using (var transaction = _connection.BeginTransaction())
{
imageInfo.ImageId = await _largeObjectManager.CreateAsync(imageInfo.ImageId, token);
using (var stream = await _largeObjectManager.OpenReadWriteAsync(imageInfo.ImageId, token))
{
await image.CopyToAsync(stream);
}
imageInfo.Id = _connection.InsertId(imageInfo);
transaction.Commit();
return(imageInfo);
}
}
private Site Add(Site site)
{
site.Id = _connection.InsertId(site);
return(site);
}
public RideRequest Add(RideRequest rideRequest)
{
rideRequest.Id = _connection.InsertId(rideRequest);
return(rideRequest);
}
public SiteVisit Add(SiteVisit visit)
{
visit.Id = _connection.InsertId(visit);
return(visit);
}
