private void b_save_Click(object sender, RoutedEventArgs e)
{
if (tb_busride_id.Text == "" || tb_traveller.Text == "" || tb_seats.Text == "")
{
MessageBox.Show("Empty fields are not allowed.", "Error!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
BookingObject newObject = new BookingObject(Int32.Parse(tb_busride_id.Text), tb_traveller.Text, Int32.Parse(tb_seats.Text));
if (DBConnection.CheckIfBookingAllowed(newObject))
{
int rowsChanged = -1;
if (newbooking)
{
rowsChanged = DBConnection.InsertBooking(newObject);
}
else
{
rowsChanged = DBConnection.UpdateBooking(newObject, oldObject);
}
if (rowsChanged > 0)
{
parentWindow.parentWindow.UpdateAllChain();
Close();
}
}
else
{
MessageBox.Show("Not enough free seats on the busride.", "Error!", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
private void b_save_Click(object sender, RoutedEventArgs e)
{
if (tb_seats.Text == "")
{
MessageBox.Show("Empty fields are not allowed.", "Error!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
BookingObject newObject = new BookingObject(oldObject.busride_id, ((TravellerObject)Authenticator.currentUser).email, Int32.Parse(tb_seats.Text));
if (DBConnection.CheckIfBookingAllowed(newObject))
{
if (DBConnection.InsertBooking(newObject) > 0)
{
parentWindow.UpdateAllChain();
Close();
}
}
else
{
MessageBox.Show("Not enough free seats on the busride.", "Error!", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
public IActionResult AddBooking([FromBody] BookingObject booking)
{
if (booking != null)
{
_service.AddBooking(booking);
}
return(Ok());
}
public static int DeleteBooking(BookingObject oldObject)
{
int affectedRows = -1;
MessageBoxResult result = MessageBox.Show("Do you wish to remove this booking?", "Warning", MessageBoxButton.YesNo, MessageBoxImage.Warning);
if (result == MessageBoxResult.Yes)
{
affectedRows = ExecuteAndGetNonQuery("DELETE FROM booking WHERE busride_id = :p0 AND traveller = :p1;", oldObject.busride_id, oldObject.traveller);
}
return(affectedRows);
}
public string DeleteBooking(string bookingId)
{
BookingObject delbooking = _data.Bookings.SingleOrDefault(item => item.bookingId == bookingId);
if (delbooking != null)
{
_data.Remove(delbooking);
_data.SaveChanges();
return("1");
}
return("0");
}
public ChangeBookingWindow(HandleBookingWindow _parent, BookingObject _oldObject)
{
InitializeComponent();
Title = "Edit Booking - " + Authenticator.GetUserInfo();
oldObject = _oldObject;
tb_busride_id.Text = oldObject.busride_id.ToString();
tb_traveller.Text = oldObject.traveller;
tb_seats.Text = oldObject.seats.ToString();
parentWindow = _parent;
newbooking = false;
}
public BookingObject Post(Dictionary <string, string> newBooking)
{
BookingObject booking = new BookingObject {
bookingId = newBooking["bookingId"], bookingDate = newBooking["bookingDate"],
meetingDate = newBooking["meetingDate"], meetingTime = newBooking["meetingTime"], employeeId = newBooking["employeeId"],
roomId = newBooking["roomId"], actionRequired = newBooking["actionRequired"], additionalEquipments = newBooking["equip"],
layoutRequired = newBooking["layoutRequired"]
};
// add in try catch blocks
//check if the user is not already signed in!
_data.Add(booking);
_data.SaveChanges();
return(booking);
}
private void b_deleteselected_Click(object sender, RoutedEventArgs e)
{
if (lv_lista.SelectedItem != null)
{
MyBookingObject minBooking = (MyBookingObject)lv_lista.SelectedItem;
BookingObject booking = new BookingObject(minBooking.busride.busride_id, minBooking.traveller, minBooking.seats);
if (DBConnection.DeleteBooking(booking) > 0)
{
parentWindow.UpdateAllChain();
}
}
else
{
MessageBox.Show("Nothing selected.", "Error!", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
public static bool CheckIfBookingAllowed(BookingObject newObject)
{
int max_seats = ExecuteAndGetScalar("SELECT max_seats FROM busride WHERE busride_id = :p0;", newObject.busride_id);
int currently_booked = ExecuteAndGetScalar("SELECT COALESCE(sum(seats),0) FROM booking WHERE busride_id = :p0;", newObject.busride_id);
int possibly_current_Selected = ExecuteAndGetScalar("SELECT seats FROM booking WHERE busride_id = :p0 AND traveller = :p1;", newObject.busride_id, newObject.traveller);
if (possibly_current_Selected == -1)
{
possibly_current_Selected = 0;
}
if (currently_booked - possibly_current_Selected + newObject.seats <= max_seats)
{
return(true);
}
return(false);
}
private void b_cancelselected_Click(object sender, RoutedEventArgs e)
{
if (lv_busrides.SelectedItem != null)
{
if (!DBConnection.CheckIfHasBooking(((BusrideObject)lv_busrides.SelectedItem).busride_id, ((TravellerObject)Authenticator.currentUser).email))
{
MessageBox.Show("You are not booked on this busride.", "Error!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
BookingObject finderObject = new BookingObject(((BusrideObject)lv_busrides.SelectedItem).busride_id, ((TravellerObject)Authenticator.currentUser).email, -1);
if (DBConnection.DeleteBooking(finderObject) > 0)
{
UpdateAllChain();
}
}
else
{
MessageBox.Show("Nothing selected.", "Error!", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
public IActionResult UpdateBooking(string id, [FromBody] BookingObject booking)
{
_service.UpdateBooking(id, booking);
return(Ok(booking));
}
public static int UpdateBooking(BookingObject newObject, BookingObject oldObject)
{
return(ExecuteAndGetNonQuery("UPDATE booking SET busride_id = :p0, traveller = :p1, seats = :p2 WHERE busride_id = :p3 AND traveller = :p4;", newObject.busride_id, newObject.traveller, newObject.seats, oldObject.busride_id, oldObject.traveller));
}
public static int InsertBooking(BookingObject newObject)
{
return(ExecuteAndGetNonQuery("INSERT INTO booking (busride_id, traveller, seats) values (:p0, :p1, :p2);", newObject.busride_id, newObject.traveller, newObject.seats));
}
