public CustomersV()
{
InitializeComponent();
CustomerService customerSrv = new CustomerService();
List<CustomerBO> customers = customerSrv.getAllFromTable();
listCustomers.ItemsSource = customers;
}
// constructor for current logged in admin
public ReportV(String adminName)
{
InitializeComponent();
// determine last available date for period date pickers
endDate.DisplayDateEnd = DateTime.Today.AddDays(-1);
startDate.DisplayDateEnd = DateTime.Today.AddDays(-1);
if (startDate.SelectedDate == null)
{
startDate.DisplayDate = DateTime.Today.AddDays(-1);
}
if (endDate.SelectedDate == null)
{
endDate.DisplayDate = DateTime.Today.AddDays(-1);
}
RoomService roomSrv = new RoomService();
CustomerService customerSrv = new CustomerService();
AdministratorService adminSrv = new AdministratorService();
//populate list of Customers with Customer Names from database.
List<CustomerBO> customers = customerSrv.getAllFromTable();
List<String> customerNames = new List<String>();
foreach (CustomerBO customer in customers)
{
String customerName = customer.CompanyName;
customerNames.Add(customerName);
}
listCustomers.ItemsSource = customerNames;
//populate comboBox of Rooms with room names from database
List<RoomBO> rooms = roomSrv.getAllFromTable();
List<String> roomNames = new List<String>();
foreach (RoomBO room in rooms)
{
String roomName = room.Name;
roomNames.Add(roomName);
}
cboxRooms.ItemsSource = roomNames;
}
/// <remarks>
/// reloads the view. useful for NavigationService.GoBack();
/// </remarks>
/// <param name="sender"></param>
/// <param name="e"></param>
private void updateView(object sender, RoutedEventArgs e)
{
CustomerService customerSrv = new CustomerService();
List<CustomerBO> customers = customerSrv.getAllFromTable();
listCustomers.ItemsSource = customers;
listContacts.ItemsSource = null;
Frame pageFrame = null;
DependencyObject currParent = VisualTreeHelper.GetParent(this);
while (currParent != null && pageFrame == null)
{
pageFrame = currParent as Frame;
currParent = VisualTreeHelper.GetParent(currParent);
}
// if current frame has any assigned tags, remove.
if (pageFrame.Tag != null)
{
pageFrame.Tag = null;
}
}
private static void emptyTableCustomer()
{
CustomerService customerSrv = new CustomerService();
customerSrv.emptyTable();
List<CustomerBO> customers = customerSrv.getAllFromTable();
Assert.AreEqual(0, customers.Count(), string.Format("'Customer' Table should be empty."));
}
private static void fullFillCustomerTable()
{
CustomerService customerSrv = new CustomerService();
customerSrv.addNew("ABC OÜ", "Anne");
customerSrv.addNew("XYZ AS", "Daria");
List<CustomerBO> customers = customerSrv.getAllFromTable();
Assert.AreNotEqual(0, customers.Count(), string.Format("There should be values in 'Customer' Table."));
}
private static void fullFillContactTable()
{
ContactTypeService contactTypeSrv = new ContactTypeService();
List<ContactTypeBO> contactTypes = contactTypeSrv.getAllFromTable();
Assert.AreNotEqual(0, contactTypes.Count(), string.Format("There should be values in 'ContactType' Table."));
int existingContactTypeID = contactTypes.ElementAt(0).ContactTypeID;
CustomerService customerSrv = new CustomerService();
List<CustomerBO> customers = customerSrv.getAllFromTable();
Assert.AreNotEqual(0, customers.Count(), string.Format("There should be values in 'Customer' Table."));
int existingCustomerID = customers.ElementAt(0).CustomerID;
//TODO: Verify that contact cannot be created before Customer (CustomerID foreign key)
//TODO: Verify that contact cannot be created before ContactType (ContactTypeID foreign key)
ContactService contactSrv = new ContactService();
contactSrv.addNew(existingCustomerID, existingContactTypeID, "val_skype", DateTime.Now);//TODO: take first from list
contactSrv.addNew(existingCustomerID, existingContactTypeID, "val_mail", DateTime.Now);
contactSrv.addNew(existingCustomerID, existingContactTypeID, "val_phone", DateTime.Now);
List<ContactBO> contacts = contactSrv.getAllFromTable();
Assert.AreNotEqual(0, contacts.Count(), string.Format("There should be values in 'Contact' Table."));
}
private static void fullFillTableBooking()
{
RoomService roomSrv = new RoomService();
List<RoomBO> rooms = roomSrv.getAllFromTable();
Assert.AreNotEqual(0, rooms.Count(), string.Format("There should be values in 'Rooms' Table."));
int existingRoomID = rooms.ElementAt(0).RoomID;
CustomerService customerSrv = new CustomerService();
List<CustomerBO> customers = customerSrv.getAllFromTable();
Assert.AreNotEqual(0, customers.Count(), string.Format("There should be values in 'Customer' Table."));
int existingCustomerID = customers.ElementAt(0).CustomerID;
AdministratorService adminSrv = new AdministratorService();
List<AdministratorBO> admins = adminSrv.getAllFromTable();
Assert.AreNotEqual(0, admins.Count(), string.Format("There should be values in 'Administrator' Table."));
int existingAdminID = admins.ElementAt(0).AdminID;
//Verify that booking cannot be created before Customer (CustomerID foreign key)
//Verify that booking cannot be created before Room (RoomID foreign key)
//Verify that booking cannot be created before Administrator (AdminID foreign key)
BookingService bookingSrv = new BookingService();
bookingSrv.addNew(DateTime.Now.AddDays(1), existingRoomID, existingCustomerID, 25, DateTime.Now, existingAdminID, "no smoking");// take first from list
bookingSrv.addNew(DateTime.Now.AddDays(1), existingRoomID, existingCustomerID, 40, DateTime.Now, existingAdminID, "no pets allowed");
bookingSrv.addNew(DateTime.Now.AddDays(10), existingRoomID, existingCustomerID, 77, DateTime.Now, existingAdminID, "reconfirm by phone");
bookingSrv.addNew(DateTime.Now.AddDays(17), existingRoomID, existingCustomerID, 55, DateTime.Now, existingAdminID, "reconfirm by phone tomorrow");
bookingSrv.addNew(DateTime.Now.AddDays(-5), existingRoomID, existingCustomerID, 10, DateTime.Now.AddDays(-8), existingAdminID, "catering ");
bookingSrv.addNew(DateTime.Now.AddDays(-2), existingRoomID, existingCustomerID, 100, DateTime.Now.AddDays(-5), existingAdminID, "no catering");
List<BookingBO> bookings = bookingSrv.getAllFromTable();
Assert.AreNotEqual(0, bookings.Count(), string.Format("There should be values in 'Booking' Table."));
}