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