public RoomOverviewWindow() { InitializeComponent(); var connection = SqliteDatabaseConnection.GetInstance(Properties.Settings.Default.Postgaarden); var equipmentCrud = new SqliteEquipmentCrud(connection); var roomCrud = new SqliteRoomCrud(connection, equipmentCrud); roomHandler = new RoomHandler(roomCrud); }
public void TestCreateReturn() { var equipment = new Equipment("Kaffemaskine"); var mock = new Mock<DatabaseConnection>(); var crud = new SqliteEquipmentCrud(mock.Object); mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Returns(() => new object[][] { new object[] { 1 } }); crud.Create(equipment); Assert.AreEqual(1, equipment.Id); }
public void TestDelete() { var sql = ""; var equipment = new Equipment("Kaffemaskine") { Id = 1 }; var mock = new Mock<DatabaseConnection>(); var crud = new SqliteEquipmentCrud(mock.Object); mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s); crud.Delete(equipment); Assert.AreEqual("DELETE FROM Equipment WHERE Id = 1;", sql); }
public void TestCreateToSql() { var sql = ""; var equipment = new Equipment("Kaffemaskine"); var mock = new Mock<DatabaseConnection>(); var crud = new SqliteEquipmentCrud(mock.Object); mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s).Returns(() => new object[][] { new object[] { 1 } }); crud.Create(equipment); Assert.AreEqual("INSERT INTO Equipment (Name) VALUES ('Kaffemaskine'); SELECT MAX(Id) FROM Equipment;", sql); }
public MainWindow() { InitializeComponent(); string filePath = Properties.Settings.Default.Postgaarden; var sqliteInstance = SqliteDatabaseConnection.GetInstance(filePath); var empCrud = new SqliteEmployeeCrud(sqliteInstance); var cusCrud = new SqliteCustomerCrud(sqliteInstance); var equiCrud = new SqliteEquipmentCrud(sqliteInstance); var roomCrud = new SqliteRoomCrud(sqliteInstance, equiCrud); bookingCrud = new SqliteBookingCrud(sqliteInstance, roomCrud, cusCrud, empCrud); }
public void TestReadAll() { var mock = new Mock<DatabaseConnection>(); var crud = new SqliteEquipmentCrud(mock.Object); mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Returns(() => new[] {new object [] {1, "Kaffemaskine" } }); var equipments = crud.Read().ToList(); Assert.AreEqual(1, equipments.First().Id); Assert.AreEqual("Kaffemaskine", equipments.First().Name); }
public void TestUpdate() { var sql = ""; var equipment = new Equipment("F16 Fighting Falcon"); var mock = new Mock<DatabaseConnection>(); var crud = new SqliteEquipmentCrud(mock.Object); mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s); crud.Update(equipment); Assert.AreEqual("UPDATE Equipment SET Name = 'F16 Fighting Falcon';", sql); }
public void TestReadRoomToSql() { var sql = ""; var data = new RoomData(); var mock = new Mock<DatabaseConnection>(); var crud = new SqliteEquipmentCrud(mock.Object); mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s).Returns(() => new object[][] { new object[] { 1, "Kaffemaskiner" } }); crud.Read(data.Rooms.First()); Assert.AreEqual("SELECT Equipment.Id, Equipment.Name FROM Equipment JOIN Room ON Equipment.Id = Room.EquipmentId WHERE Room.Id = 1;", sql); }
public void TestReadOneToSql() { var sql = ""; var mock = new Mock<DatabaseConnection>(); var crud = new SqliteEquipmentCrud(mock.Object); mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s).Returns(() => new object[][] { new object[] { 1, "Kaffemaskine" } }); crud.Read(1); Assert.AreEqual("SELECT Id,Name FROM Equipment WHERE Id = 1;", sql); }