private static int InsertTestAutoInTheInventoryTable(CarsDb carsDb)
{
var dataTable = carsDb.GetAllFrom("Inventory");
var carId = GenerateNewUnicIdInTheTable(dataTable);
carsDb.InsertAuto(carId, "n", "c", "m", "p");
return(carId);
}
public void ProcessCreditRisks()
{
var cars = new CarsDb();
cars.OpenConnection(ConnectionString);
var customersTable = cars.GetAllFrom("Customers");
//CarsDb.ProcessCredirRisk(true, custId);
cars.CloseConnection();
}
public void GetAllFromDbTable(
[Values("Inventory", "Customers")] string tableDb)
{
var cars = new CarsDb();
cars.OpenConnection(ConnectionString);
var dataTable = cars.GetAllFrom(tableDb);
Assert.IsNotNull(dataTable);
Assert.AreNotEqual(0, dataTable.Rows.Count);
cars.CloseConnection();
}
public void PresentId(
[Values("Inventory", "Customers")] string tableDb)
{
var cars = new CarsDb();
cars.OpenConnection(ConnectionString);
var dataTable = cars.GetAllFrom(tableDb);
var firstRow = dataTable.Rows[0];
var firstId = (int)firstRow[0];
Assert.IsTrue(cars.IsPresentId(tableDb, firstId));
cars.CloseConnection();
}
