public void CanInsertTanksAndGetTanksFromDatabase()
{
_builder.UseInMemoryDatabase("CanInsertTanksAndGetTanks");
using (var context = new AdministrationContext(_builder.Options))
{
var guid = Guid.NewGuid();
var gasStation = new GasStation(guid);
var tank = new Tank();
tank.GasStationId = guid;
tank.Number = 1;
tank.ProductId = 1;
tank.Name = "Tank1";
tank.AddMeasurement(new Measurement(TankMeasurement.Gallons, 100, 100, 800));
gasStation.Tanks.Add(tank);
context.GasStations.Add(gasStation);
Assert.NotEqual(default(Guid), gasStation.Id);
Assert.NotEqual(default(Guid), tank.GasStationId);
Assert.Equal(EntityState.Added, context.Entry(tank).State);
context.SaveChanges();
var tanks = context.Tanks.Where(t => t.GasStationId == gasStation.Id).ToList();
Assert.Single(tanks);
}
}
public AdministrationDataFixture()
{
var _gasStationId = Guid.NewGuid();
var _dateTime1 = new DateTime(2020, 8, 1, 9, 30, 0);
var _dateTime2 = new DateTime(2020, 8, 2, 9, 30, 0);
_gasStation = new GasStation(_gasStationId);
var tank1 = new Tank();
var product = new Product();
_orderStrategy = new OrderStrategy();
_tanks = new List <Tank>();
_tankSales = new List <TankSale>();
tank1.GasStationId = _gasStationId;
tank1.Number = 1;
tank1.ProductId = 1;
tank1.Name = "Tank1";
tank1.AddMeasurement(new Measurement(TankMeasurement.Gallons, 100, 100, 500));
var tank2 = new Tank();
tank2.GasStationId = _gasStationId;
tank2.Number = 1;
tank2.Name = "Tank2";
tank2.AddMeasurement(new Measurement(TankMeasurement.Gallons, 100, 100, 500));
var tank1Sale1 = new TankSale();
tank1Sale1.Quantity = 100;
tank1Sale1.SaleTime = _dateTime1;
var tank1Sale2 = new TankSale();
tank1Sale2.Quantity = 100;
tank1Sale2.SaleTime = _dateTime2;
var tank2Sale1 = new TankSale();
tank2Sale1.Quantity = 100;
tank2Sale1.SaleTime = _dateTime1;
var tank2Sale2 = new TankSale();
tank2Sale2.Quantity = 100;
tank2Sale2.SaleTime = _dateTime2;
var dispatcherGrp = new DispatcherGroup {
Name = "DP1"
};
using (var context = new AdministrationContext())
{
_gasStation.Tanks.Add(tank1);
_gasStation.Tanks.Add(tank2);
context.DispatcherGroup.Add(dispatcherGrp);
if (context.GasStations.Any())
{
context.GasStations.RemoveRange(context.GasStations);
context.SaveChanges();
}
if (context.Products.Any())
{
context.Products.RemoveRange(context.Products);
context.SaveChanges();
}
if (context.TankSales.Any())
{
context.TankSales.RemoveRange(context.TankSales);
context.SaveChanges();
}
context.Products.Add(product);
context.SaveChanges();
tank1.ProductId = product.Id;
tank2.ProductId = product.Id;
_gasStation.DispatcherGroupId = dispatcherGrp.Id;
context.GasStations.Add(_gasStation);
context.SaveChanges();
_tanks.AddRange(new[] { tank1, tank2 });
tank1Sale1.TankId = tank1.Id;
tank1Sale2.TankId = tank1.Id;
tank2Sale1.TankId = tank2.Id;
tank2Sale2.TankId = tank2.Id;
context.TankSales.AddRange(new[] { tank1Sale1, tank1Sale2, tank2Sale1, tank2Sale2 });
_orderStrategy.GasStationId = _gasStation.Id;
_orderStrategy.OrderType = OrderType.Schedule;
context.OrderStrategies.Add(_orderStrategy);
context.SaveChanges();
_tankSales.AddRange(new[] { tank1Sale1, tank1Sale2, tank2Sale1, tank2Sale2 });
}
}
