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