public CreateMeetingPage() { InitializeComponent(); OracleSQLConnectorUserWindow oraclesql = new OracleSQLConnectorUserWindow(); trainerList = oraclesql.loadAllTrainersFromDataBase(); //putIntoTrainersListBoxTrainerList(trainerList); //trainersListBox.ItemsSource = trainerList; setTable(); }
private void addMeetingButton_Click(object sender, RoutedEventArgs e) { if (isDataValidForInsert()) { DateTime dateTime = new DateTime(); String dateStr = datePicker.SelectedDate.ToString(); dateStr = dateStr.Substring(0, 11); String timeStr = hourPicker.Text + ":" + minutePicker.Text + ":00"; String dateAndTimeStr = dateStr + " " + timeStr; dateTime = Convert.ToDateTime(dateAndTimeStr); durationComboBox.SelectedValue.ToString().Trim(); MeetModel meet = new MeetModel(GlobalClass.getUserID(), GlobalClass.getTrainerID(), GlobalClass.getPlaceID(), dateTime, Int32.Parse(durationComboBox.SelectedValue.ToString().Trim())); OracleSQLConnectorUserWindow oraclesql = new OracleSQLConnectorUserWindow(); if (oraclesql.insertMeetingToDBReturnItsID(meet)) { addLabelFailed.Visibility = Visibility.Hidden; addLabelSuccess.Visibility = Visibility.Visible; } else { addLabelFailed.Visibility = Visibility.Visible; addLabelSuccess.Visibility = Visibility.Hidden; } // date + timepicker = DateTime // to model //send } else { addLabelSuccess.Visibility = Visibility.Hidden; addLabelFailed.Visibility = Visibility.Visible; //Data invalid error } //check for empty //insert }