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";
}
}
}
}
