public async Task InsertSights(IEnumerable <Sight> sights)
{
var connection = SQLiteService.CreateAsyncConnection();
var result = await connection.InsertAllAsync(sights);
foreach (var sight in sights)
{
await InsertSightFiles(sight.SightFiles);
}
}
public async Task DeleteSightAsync(Sight sight)
{
foreach (var sightFile in sight.SightFiles)
{
await DeleteSightFileAsync(sightFile);
}
var connection = SQLiteService.CreateAsyncConnection();
await connection.DeleteAsync(sight);
}
public async Task <Sight> LoadSightAsync(Guid sightId)
{
var connection = SQLiteService.CreateAsyncConnection();
var sight = await connection.Table <Sight>().Where(s => s.Id == sightId).FirstAsync();
sight.Trip = await connection.Table <Trip>().Where(t => t.Id == sight.TripId).FirstAsync();
sight.SightFiles = await connection.Table <SightFile>().Where(s => s.SightId == sight.Id).ToListAsync();
return(sight);
}
public async Task <Trip> LoadTripAsync(Guid tripId)
{
var connection = SQLiteService.CreateAsyncConnection();
var trip = await connection.Table <Trip>().Where(t => t.Id == tripId).FirstAsync();
trip.Sights = await connection.Table <Sight>().Where(s => s.TripId == trip.Id).ToListAsync();
foreach (var sight in trip.Sights)
{
sight.SightFiles = await connection.Table <SightFile>().Where(s => s.SightId == sight.Id).ToListAsync();
sight.Trip = trip;
}
return(trip);
}
public Task <List <Trip> > LoadTripsWithAttractionsAsync()
{
var connection = SQLiteService.CreateAsyncConnection();
return(connection.Table <Trip>().ToListAsync());
}
public async Task UpdateSightFileAsync(SightFile sightFile)
{
var connection = SQLiteService.CreateAsyncConnection();
await connection.UpdateAsync(sightFile);
}
public async Task SaveSightAsync(Sight sight)
{
var connection = SQLiteService.CreateAsyncConnection();
await connection.UpdateAsync(sight);
}
public async Task InsertTripAsync(Trip trip)
{
var connection = SQLiteService.CreateAsyncConnection();
await connection.InsertAsync(trip);
}
public async Task InsertSightFiles(IEnumerable <SightFile> sightFiles)
{
var connection = SQLiteService.CreateAsyncConnection();
await connection.InsertAllAsync(sightFiles);
}
