public ActionResult Index()
{
var db = new CarsDb();
var x = db.Cars.ToList();
return(View());
}
public void CanCloseOpenedConnection()
{
var cars = new CarsDb();
cars.OpenConnection(ConnectionString);
cars.CloseConnection();
Assert.IsTrue(cars.Connection.State == ConnectionState.Closed);
}
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 DeleteAutoFromInventoryTable()
{
var cars = new CarsDb();
cars.OpenConnection(ConnectionString);
var carId = InsertTestAutoInTheInventoryTable(cars);
cars.DeleteAuto(carId);
Assert.IsFalse(cars.IsPresentId("Inventory", carId));
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 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 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();
}
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();
}
static Program()
{
MainForegroungColor = ConsoleColor.White;
ActiveMenuTitleColor = ConsoleColor.Yellow;
OkForegroungColor = ConsoleColor.Green;
ErrorForegroungColor = ConsoleColor.Red;
System.Console.ForegroundColor = MainForegroungColor;
ConnectionString =
"Data Source=(local)\\SQLEXPRESS;Initial Catalog=AutoLot;Integrated Security=True;Pooling=False";
CarsDb = new CarsDb();
CustomersDb = new CustomersDb();
MainMenuList = new object[3, 3];
CustomersMenuList = new object[3, 3];
CarsMenuList = new object[6, 3];
MainMenuList[0, 0] = "Customers";
MainMenuList[0, 1] = new MenuLinkToMethod(PrintMenu);
MainMenuList[0, 2] = CustomersMenuList;
MainMenuList[1, 0] = "Cars";
MainMenuList[1, 1] = new MenuLinkToMethod(PrintMenu);
MainMenuList[1, 2] = CarsMenuList;
MainMenuList[2, 0] = "Exit";
MainMenuList[2, 1] = new MenuLinkToMethod(Exit);
CustomersMenuList[0, 0] = "Show Customers";
CustomersMenuList[0, 1] = new MenuLinkToMethod(ShowCustomers);
CustomersMenuList[1, 0] = "Add to risk category";
CustomersMenuList[1, 1] = new MenuLinkToMethod(AddToRisks);
CustomersMenuList[2, 0] = "Back";
CustomersMenuList[2, 1] = new MenuLinkToMethod(PrintMenu);
CustomersMenuList[2, 2] = MainMenuList;
CarsMenuList[0, 0] = "Show Cars";
CarsMenuList[0, 1] = new MenuLinkToMethod(ShowCars);
CarsMenuList[1, 0] = "Insert Auto";
CarsMenuList[1, 1] = new MenuLinkToMethod(InsertAuto);
CarsMenuList[2, 0] = "Delete Auto";
CarsMenuList[2, 1] = new MenuLinkToMethod(DeleteAuto);
CarsMenuList[3, 0] = "Update auto PetName";
CarsMenuList[3, 1] = new MenuLinkToMethod(UpdateAutoPetName);
CarsMenuList[4, 0] = "Get PetName by CarId";
CarsMenuList[4, 1] = new MenuLinkToMethod(GetPetNameByCarId);
CarsMenuList[5, 0] = "Back";
CarsMenuList[5, 1] = new MenuLinkToMethod(PrintMenu);
CarsMenuList[5, 2] = MainMenuList;
}
public void ConnectionIsClosedAfterCreatingTheInstance()
{
var cars = new CarsDb();
Assert.IsTrue(cars.Connection == null);
}
public CarsController()
{
db = new CarsDb();
}
public HomeController(CarsDb context)
{
db = context;
}
