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