public SqliteBookingCrudUnitTest()
{
booking.SetTime(new DateTime(2000, 1, 1, 12, 00, 00), new DateTime(2001, 1, 1, 12, 00, 00));
booking.Room.Equipments.Add(new Equipment("CoffeeMACHINIMA") { Id = 1 });
mock = new Mock<DatabaseConnection>();
roomCrud = new Mock<RoomCrud>();
customerCrud = new Mock<CustomerCrud>();
employeeCrud = new Mock<EmployeeCrud>();
crud = new SqliteBookingCrud(mock.Object, roomCrud.Object, customerCrud.Object, employeeCrud.Object);
}
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 TestDeleteBooking()
{
string sql = "";
mock = new Mock<DatabaseConnection>();
roomCrud = new Mock<RoomCrud>();
customerCrud = new Mock<CustomerCrud>();
employeeCrud = new Mock<EmployeeCrud>();
crud = new SqliteBookingCrud(mock.Object, roomCrud.Object, customerCrud.Object, employeeCrud.Object);
mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s).Returns(() => new object[][] { new[] { "0" } });
crud.Delete(booking);
Assert.AreEqual($"DELETE FROM Booking WHERE Id={booking.Id};", sql);
}
public void TestCreateToSqlBooking()
{
string sql = "";
mock = new Mock<DatabaseConnection>();
roomCrud = new Mock<RoomCrud>();
customerCrud = new Mock<CustomerCrud>();
employeeCrud = new Mock<EmployeeCrud>();
crud = new SqliteBookingCrud(mock.Object, roomCrud.Object, customerCrud.Object, employeeCrud.Object);
mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s).Returns(() => new Object[][] { new[] { "1" } });
crud.Create(booking);
Assert.AreEqual($"INSERT INTO Booking (StartTime, EndTime, ConferenceRoomId, EmployeeId, CustomerCvr, Price) VALUES ({booking.StartTime.ToString("yyyy-MM-dd hh:mm")}, {booking.EndTime.ToString("yyyy-MM-dd hh:mm")}, {booking.Room.Id}, {((Employee)booking.Employee).Id}, {((Customer)booking.Customer).Cvr}, {booking.Price}); SELECT MAX (Id) FROM Booking;", sql);
}
public CreateEdit(string createEdit, ObservableCollection<Booking> bookings, Booking booking = null)
{
InitializeComponent();
string filePath = Properties.Settings.Default.Postgaarden;
var sqliteInstance = SqliteDatabaseConnection.GetInstance(filePath);
empCrud = new SqliteEmployeeCrud(sqliteInstance);
cusCrud = new SqliteCustomerCrud(sqliteInstance);
equiCrud = new SqliteEquipmentCrud(sqliteInstance);
roomCrud = new SqliteRoomCrud(sqliteInstance, equiCrud);
bookingCrud = new SqliteBookingCrud(sqliteInstance, roomCrud, cusCrud, empCrud);
this.createEdit = createEdit;
Bookings = bookings;
if (booking != null)
Booking = booking;
}
public void TestReadAllBooking()
{
mock = new Mock<DatabaseConnection>();
roomCrud = new Mock<RoomCrud>();
customerCrud = new Mock<CustomerCrud>();
employeeCrud = new Mock<EmployeeCrud>();
crud = new SqliteBookingCrud(mock.Object, roomCrud.Object, customerCrud.Object, employeeCrud.Object);
roomCrud.Setup(x => x.Read(It.IsAny<Booking>())).Returns(new ConferenceRoom { Id = 1, Size = 4 });
customerCrud.Setup(x => x.Read(It.IsAny<Booking>())).Returns(new Customer { Cvr = "12345678", Name = "Jens", CompanyName = "Bang og Olufsen", EmailAddress = "*****@*****.**" });
employeeCrud.Setup(x => x.Read(It.IsAny<Booking>())).Returns(new Employee { Id = 1, EmailAddress = "*****@*****.**", Name = "Anders" });
mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Returns(() => new object[][] { new object[] { booking.Id,
booking.StartTime.ToString("yyyy-MM-dd,hh:mm"),
booking.EndTime.ToString("yyyy-MM-dd,hh:mm"),
booking.Room.Id,
((Employee)booking.Employee).Id,
((Customer)booking.Customer).Cvr,
booking.Price
} });
var bookings = crud.Read();
var customer = bookings.First().Customer as Customer;
var employee = bookings.First().Employee as Employee;
var room = bookings.First().Room as Room;
Assert.AreEqual(booking.StartTime.ToString("yyyy-MM-dd hh:mm"), bookings.First().StartTime.ToString("yyyy-MM-dd hh:mm"));
Assert.AreEqual(booking.EndTime.ToString("yyyy-MM-dd hh:mm"), bookings.First().EndTime.ToString("yyyy-MM-dd hh:mm"));
Assert.AreEqual(1, room.Id);
Assert.AreEqual(4, room.Size);
Assert.AreEqual(1, employee.Id);
Assert.AreEqual("*****@*****.**", employee.EmailAddress);
Assert.AreEqual("Anders", employee.Name);
Assert.AreEqual("12345678", customer.Cvr);
Assert.AreEqual("Jens", customer.Name);
Assert.AreEqual("Bang og Olufsen", customer.CompanyName);
Assert.AreEqual("*****@*****.**", customer.EmailAddress);
Assert.AreEqual(booking.Price, bookings.First().Price);
}
public void TestUpdateBooking()
{
string sql = "";
mock = new Mock<DatabaseConnection>();
roomCrud = new Mock<RoomCrud>();
customerCrud = new Mock<CustomerCrud>();
employeeCrud = new Mock<EmployeeCrud>();
crud = new SqliteBookingCrud(mock.Object, roomCrud.Object, customerCrud.Object, employeeCrud.Object);
mock.Setup(x => x.ExecuteQuery(It.IsAny<string>())).Callback((string s) => sql = s).Returns(() => new object[][] { new[] { "0" } });
crud.Update(booking);
Assert.AreEqual($"UPDATE Booking SET StartTime={booking.StartTime}, EndTime={booking.EndTime}, ConferenceRoomId={booking.Room.Id}, Price={booking.Price} WHERE Id={booking.Id};", sql);
}
