public void GetPetNameProcedure()
{
var cars = new CarsDb();
cars.OpenConnection(ConnectionString);
var carId = InsertTestAutoInTheInventoryTable(cars);
var petName = cars.GetPetNameProcedure(carId);
Assert.AreEqual("p", petName);
cars.DeleteAuto(carId);
cars.CloseConnection();
}
public void UpdateAutoPetName()
{
var cars = new CarsDb();
cars.OpenConnection(ConnectionString);
var carId = InsertTestAutoInTheInventoryTable(cars);
const string expectedPetName = "p2";
cars.UpdateAutoPetName(carId, expectedPetName);
var petName = cars.GetPetNameProcedure(carId);
Assert.AreEqual(expectedPetName, petName);
cars.DeleteAuto(carId);
cars.CloseConnection();
}
private static void GetPetNameByCarId()
{
while (true)
{
TryConnectTo(CarsDb);
if (!FindId("Enter CarId: ", "Inventory", out _carId))
{
continue;
}
_petName = CarsDb.GetPetNameProcedure(_carId);
CarsDb.CloseConnection();
var okMessage = string.Format("PetName is: '{0}'", _petName);
PrintColored(okMessage, OkForegroungColor);
break;
}
}