public async Task GetTourByDate(string date, TaskCompletionSource <Tour> receivedTask)
{
if (string.IsNullOrWhiteSpace(date))
{
throw new ArgumentNullException(nameof(date));
}
using (var context = ToursContextFactory.Create())
{
try
{
DateTime dt = DateTime.Parse(date);
Tour tourEntity = await context.Tours.SingleAsync(t => t.Date == dt);
if (tourEntity is null)
{
receivedTask.TrySetCanceled();
return;
}
receivedTask.TrySetResult(tourEntity);
}
catch (Exception e)
{
receivedTask.TrySetException(e);
}
}
}
private ToursContext CreateContextAndMigrateDb()
{
var context = ToursContextFactory.Create();
context.Database.Migrate();
return(context);
}
public async Task GetTourById(int id, TaskCompletionSource <Tour> receivedTask)
{
using (var context = ToursContextFactory.Create())
{
try
{
var entity = await context.Tours.SingleOrDefaultAsync(t => t.Id == id);
if (entity is null)
{
receivedTask.TrySetCanceled();
}
receivedTask.TrySetResult(entity);
}
catch (Exception e)
{
receivedTask.TrySetException(e);
}
}
}
public TestDbFixture()
{
ToursContextFactory = new ToursContextFactory(
"Server=(localdb)\\mssqllocaldb;Database=FliGen.Tours.Test;Trusted_Connection=True;MultipleActiveResultSets=true");
Context = GetInitiatedToursContext();
}