public async Task MapShow() { try { var shows = await MazeHelper.GetShows(); using (var db = new MediaDbContext()) { foreach (var show in shows) { if (db.Shows.Find(show.Id) == null) { await db.AddAsync(show); await db.SaveChangesAsync(); } await MapPerson(show.Id); } } } catch (Exception ex) { var message = ex.Message; } }
public async Task MapPerson(int showId) { try { var casts = await MazeHelper.GetCasts(showId); using (var db = new MediaDbContext()) { foreach (var cast in casts) { if (await db.Persons.FindAsync(cast.Person.Id) == null) { await db.AddAsync(cast.Person); await db.SaveChangesAsync(); } await MapShowPerson(showId, cast.Person.Id); } } } catch (Exception ex) { var message = ex.Message; } }
public async Task MapShowPerson(int showId, int personId) { try { using (var db = new MediaDbContext()) { if (await db.ShowPersons.FindAsync(showId, personId) == null) { await db.AddAsync(new ShowPerson() { ShowId = showId, PersonId = personId }); await db.SaveChangesAsync(); } } } catch (Exception ex) { var message = ex.Message; } }