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
}
