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