public void TestSetTime_True() { DateTime startTime = new DateTime(2000, 1, 1, 12, 00, 00); DateTime endTime = new DateTime(2001, 1, 1, 15, 00, 00); Booking booking = new Booking(); bool result = booking.SetTime(startTime, endTime); Assert.AreEqual(startTime, booking.StartTime); Assert.AreEqual(endTime, booking.EndTime); Assert.IsTrue(result); }
private void OKButton_Click(object sender, RoutedEventArgs e) { switch (createEdit.ToUpper()) { case "CREATE": Booking booking = new Booking(); if (!booking.SetTime(Convert.ToDateTime(StartTimePicker.Text), Convert.ToDateTime(EndTimeTextBox.Text))) { Xceed.Wpf.Toolkit.MessageBox.Show("Sluttidspunktet skal være senere end starttidspunktet."); return; } booking.Room = roomCrud.Read(Convert.ToInt32(ConferenceRoomIdTextBox.Text)); booking.Customer = cusCrud.Read(CustomerCVRTextBox.Text); booking.Employee = empCrud.Read(Convert.ToInt32(EmployeeIdTextBox.Text)); booking.Price = Convert.ToDouble(PriceTextBox.Text); bookingCrud.Create(booking); Bookings.Add(booking); break; case "EDIT": booking = Booking; if (!booking.SetTime(Convert.ToDateTime(StartTimePicker.Text), Convert.ToDateTime(EndTimeTextBox.Text))) { Xceed.Wpf.Toolkit.MessageBox.Show("Sluttidspunktet skal være senere end starttidspunktet."); return; } booking.Room = roomCrud.Read(Convert.ToInt32(ConferenceRoomIdTextBox.Text)); booking.Customer = cusCrud.Read(CustomerCVRTextBox.Text); booking.Employee = empCrud.Read(Convert.ToInt32(EmployeeIdTextBox.Text)); booking.Price = Convert.ToDouble(PriceTextBox.Text); bookingCrud.Update(booking); break; } Close(); }
public override IEnumerable<Booking> Read() { var rows = DBConnection.ExecuteQuery("SELECT Id, StartTime, EndTime, ConferenceRoomId, EmployeeId, CustomerCVR, Price FROM Booking;"); var bookings = new List<Booking>(); foreach (var row in rows) { Booking b = new Booking { Id = Convert.ToInt32(row.ElementAt(0)), Price = Convert.ToDouble(row.ElementAt(6)) }; b.Room = RoomCrud.Read(b); b.Employee = EmployeeCrud.Read(b); b.Customer = CustomerCrud.Read(b); DateTime StartTime = Convert.ToDateTime(row.ElementAt(1).ToString()); DateTime EndTime = Convert.ToDateTime(row.ElementAt(2).ToString()); b.SetTime(StartTime, EndTime); bookings.Add(b); } return bookings; }
public override Booking Read(int key) { var booking = DBConnection.ExecuteQuery($"SELECT Id, StartTime, EndTime, ConferenceRoomId, EmployeeId, CustomerCVR, Price FROM Booking WHERE Id={key};").First(); Booking b = new Booking { Id = Convert.ToInt32(booking.ElementAt(0)), Price = Convert.ToDouble(booking.ElementAt(6)) }; b.Room = RoomCrud.Read(b); b.Employee = EmployeeCrud.Read(b); b.Customer = CustomerCrud.Read(b); b.SetTime(Convert.ToDateTime(booking.ElementAt(1).ToString()), Convert.ToDateTime(booking.ElementAt(2).ToString())); return b; }