public async Task <Truck> CreateTruckAsync(Truck truck)
{
ContainerDbContext dbContext = _containerDbContextFactory.CreateDbContext();
var truckToAdd = (await dbContext.Trucks.AddAsync(truck)).Entity;
await dbContext.SaveChangesAsync();
return(truckToAdd);
}
public async Task <Container> CreateContainerAsync(Container container)
{
ContainerDbContext dbContext = _containerDbContextFactory.CreateDbContext();
var containerToAdd = (await dbContext.Containers.AddAsync(container)).Entity;
await dbContext.SaveChangesAsync();
return(containerToAdd);
}
public async Task <Ship> CreateShip(Ship ship)
{
ContainerDbContext dbContext = _containerDbContextFactory.CreateDbContext();
var shipToAdd = (await dbContext.Ships.AddAsync(ship)).Entity;
await dbContext.SaveChangesAsync();
return(shipToAdd);
}
public async Task DeleteTruckAsync(string plate)
{
ContainerDbContext dbContext = _containerDbContextFactory.CreateDbContext();
var truckToDelete = new Truck()
{
LicensePlate = plate
};
dbContext.Entry(truckToDelete).State = EntityState.Deleted;
await dbContext.SaveChangesAsync();
}
public async Task DeleteContainerAsync(Guid id)
{
ContainerDbContext dbContext = _containerDbContextFactory.CreateDbContext();
var shipToDelete = new Container()
{
Id = id
};
dbContext.Entry(shipToDelete).State = EntityState.Deleted;
await dbContext.SaveChangesAsync();
}
public static void OnServicesSetup(IServiceProvider serviceProvider)
{
Console.WriteLine("Connecting to database and migrating if required");
var dbContextFactory = serviceProvider.GetService <ContainerDbContextFactory>();
ContainerDbContext dbContext = dbContextFactory.CreateDbContext();
Policy
.Handle <Exception>()
.WaitAndRetry(9, r => TimeSpan.FromSeconds(5), (ex, ts) =>
{
Console.Error.WriteLine("Error connecting to database. Retrying in 5 sec.");
})
.Execute(() =>
{
dbContext.Database.Migrate();
Console.WriteLine("Completed connecting to database");
});
}
public Task <List <Truck> > GetTrucks()
{
ContainerDbContext dbContext = _containerDbContextFactory.CreateDbContext();
return(dbContext.Trucks.Where(x => x.Container == null).ToListAsync());
}
public Task <Truck> GetTruck(string plate)
{
ContainerDbContext dbContext = _containerDbContextFactory.CreateDbContext();
return(dbContext.Trucks.LastOrDefaultAsync(x => x.LicensePlate == plate));
}
public Task <Ship> GetShip(Guid id)
{
ContainerDbContext dbContext = _containerDbContextFactory.CreateDbContext();
return(dbContext.Ships.LastOrDefaultAsync(x => x.Id == id));
}
public ContainersController(ContainerDbContext context)
{
_context = context;
}
