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