private void toDeclinedListButton_Click(object sender, RoutedEventArgs e) { if (pendingMeetingsListBox.SelectedIndex >= 0) { MeetModel meetingToMove = pendingMeetingsList.ElementAt(pendingMeetingsListBox.SelectedIndex); meetingToMove.Accepted = 0; meetingToMove.New = 0; OracleSQLConnectorTrainerWindow oraclesql = new OracleSQLConnectorTrainerWindow(); if (oraclesql.updateMeetingStatus(meetingToMove)) { pendingMeetingsList.Remove(meetingToMove); declinedMeetingsList.Add(meetingToMove); pendingMeetingsListBox.Items.Refresh(); declinedMeetingsListBox.Items.Refresh(); } else { meetingToMove.Accepted = 0; meetingToMove.New = 1; } } }
/// <summary> /// Updates row in Oracle DataBase and changes List and ListBox values for this specific object. /// </summary> private void updatePlace() { if (isPlaceTextBoxesGood()) { PlaceModel place = new PlaceModel(cityTextBox.Text, postcodeTextBox.Text, streetTextBox.Text, descriptionTextBox.Text); OracleSQLConnectorTrainerWindow oraclesql = new OracleSQLConnectorTrainerWindow(); if (oraclesql.updatedPlaceToDataBase(place, currentlySelectedItemID)) { placesList.ElementAt(placesListBox.SelectedIndex).setCity(place.getCity()); placesList.ElementAt(placesListBox.SelectedIndex).setPostCode(place.getPostCode()); placesList.ElementAt(placesListBox.SelectedIndex).setStreet(place.getStreet()); placesList.ElementAt(placesListBox.SelectedIndex).setDescription(place.getDescription()); placesListBox.Items[placesListBox.SelectedIndex] = place.getCity() + ", " + place.getDescription(); communicationLabel.Content = "Place updated!"; } else { communicationLabel.Content = "Failed to update palce."; } } }
/// <summary> /// Adds new PlaceModel object to Oracle DataBase /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void addPlaceButton_Click(object sender, RoutedEventArgs e) { if (isPlaceTextBoxesGood()) { PlaceModel place = new PlaceModel(cityTextBox.Text, postcodeTextBox.Text, streetTextBox.Text, descriptionTextBox.Text); { OracleSQLConnectorTrainerWindow oraclesql = new OracleSQLConnectorTrainerWindow(); int placeID = oraclesql.insertPlaceToDBReturnItsID(place); if (placeID < 0) { communicationLabel.Content = "Record not inserted"; } else { place.setID(placeID); placesList.Add(place); placesListBox.Items.Add(place.getCity() + ", " + place.getDescription()); placesListBox.UnselectAll(); currentlySelectedItemID = -1; communicationLabel.Content = "Success! Place has been created"; } } } }