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