public void clear_erases_vehicles_from_DB()
{
IVehicleStorage databaseVehicleStorage = new SqlVehicleStorage(this.connectionString, this.vehicleBuilder);
databaseVehicleStorage.clear();
IEnumerable <IVehicle> vehicles = databaseVehicleStorage.get();
Assert.AreEqual(0, vehicles.Count());
databaseVehicleStorage = new SqlVehicleStorage(this.connectionString, this.vehicleBuilder);
vehicles = databaseVehicleStorage.get();
Assert.AreEqual(0, vehicles.Count());
}
public void save_vehicle_to_DB_and_retrieve_it()
{
IVehicleStorage databaseVehicleStorage = new SqlVehicleStorage(this.connectionString, this.vehicleBuilder);
databaseVehicleStorage.clear();
IEnumerable <IVehicle> vehicles = databaseVehicleStorage.get();
Assert.AreEqual(0, vehicles.Count());
IVehicle firstVehicle = new Vehicle
{
Enrollment = new Enrollment
{
Serial = "AZD",
Number = 4444
},
Engine = new Engine
{
IsStarted = true,
HorsePower = 1000,
},
Color = CarColor.Purple,
Doors = new Door[] { new Door {
IsOpen = false
}, new Door {
IsOpen = true
} },
Wheels = new Wheel[] { new Wheel {
Pressure = 2.3
}, new Wheel {
Pressure = 1.2
} },
};
databaseVehicleStorage.set(firstVehicle);
databaseVehicleStorage = new SqlVehicleStorage(this.connectionString, this.vehicleBuilder);
IVehicle retrievedVehicle = databaseVehicleStorage.get().First();
Assert.AreEqual(firstVehicle.Enrollment.Serial, retrievedVehicle.Enrollment.Serial);
Assert.AreEqual(firstVehicle.Enrollment.Number, retrievedVehicle.Enrollment.Number);
Assert.AreEqual(firstVehicle.Color, retrievedVehicle.Color);
Assert.AreEqual(firstVehicle.Engine.HorsePower, retrievedVehicle.Engine.HorsePower);
Assert.AreEqual(firstVehicle.Doors[0].IsOpen, retrievedVehicle.Doors[0].IsOpen);
Assert.AreEqual(firstVehicle.Doors[1].IsOpen, retrievedVehicle.Doors[1].IsOpen);
Assert.AreEqual(firstVehicle.Wheels[0].Pressure, retrievedVehicle.Wheels[0].Pressure);
Assert.AreEqual(firstVehicle.Wheels[1].Pressure, retrievedVehicle.Wheels[1].Pressure);
}
