private void Button_Click(object sender, RoutedEventArgs e) { SQL_STATEMENT option = (SQL_STATEMENT)Enum.ToObject(typeof(SQL_STATEMENT), SqlOption.SelectedIndex); Game gameObject = new Game(nameField.Text, genreField.Text, typeField.Text, reviewField.Text); List <string> result; switch (option) { case SQL_STATEMENT.INSERT: application.RunSQL(insert.InsertIntoGame(gameObject)); break; case SQL_STATEMENT.UPDATE: application.RunSQL(update.UpdateRowByName(genreField.Text, typeField.Text, nameField.Text)); break; case SQL_STATEMENT.SELECT: application.RunSQL(select.SelectAll(), out result); if (result != null) { PrintToListBox(result); } break; case SQL_STATEMENT.DELETE: application.RunSQL(delete.DeleteFromGame(nameField.Text)); break; default: break; } ClearTextBoxes(); }
private void SqlOption_SelectionChanged(object sender, SelectionChangedEventArgs e) { ComboBox cb = sender as ComboBox; SQL_STATEMENT option = (SQL_STATEMENT)Enum.ToObject(typeof(SQL_STATEMENT), cb.SelectedIndex); switch (option) { case SQL_STATEMENT.INSERT: EnableTextBoxes(); break; case SQL_STATEMENT.UPDATE: EnableTextBoxes(); nameField.Text = "Game name"; genreField.Text = "Column to update"; typeField.Text = "Value"; reviewField.Clear(); reviewField.IsEnabled = false; break; case SQL_STATEMENT.SELECT: DisableTextBoxes(); break; case SQL_STATEMENT.DELETE: EnableTextBoxes(); break; default: break; } }