private void Btn_DeleteConflict_Click(object sender, RoutedEventArgs e) { string selected; selected = Convert.ToString(ListBox_ConflictDetails.SelectedValue); // Verify the user selected a record to delete if (!string.IsNullOrEmpty(selected)) { MessageBoxResult result; result = MessageBox.Show(Tools.deleteMessage, Tools.deleteTitle, MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { foreach (ConflictDBInfo conflict in conflictList) { if (conflict.Conflict == selected) { // Remove from the database conflict.DeleteFromDatabase(); } } conflictList = ConflictDBInfo.LoadObjectList(); ListBox_ConflictDetails.DataContext = conflictList; } } else { MessageBox.Show(Tools.RecordDeleteMessage, Tools.RecordSelectTitle); } }
// Copy Constructor public ConflictDBInfo(ConflictDBInfo other) { hasDataChanged = other.hasDataChanged; isNewRecord = other.isNewRecord; conflict = other.conflict; oldName = other.oldName; }
public Conflicts() { InitializeComponent(); conflictList = ConflictDBInfo.LoadObjectList(); ListBox_ConflictDetails.DataContext = conflictList; DataContext = this; }
// Loads data into the bound observable collection for the dropdown private void LoadData() { conflictList = ConflictDBInfo.LoadStringList(); Conflicts = new ObservableCollection <string>(); foreach (string item in conflictList) { Conflicts.Add(item); } }
private void Save() { CurrentConflict.WriteDataToDatabase(); conflictList = ConflictDBInfo.LoadObjectList(); ListBox_ConflictDetails.DataContext = conflictList; HideControls(); CurrentConflict = null; }
public Queries(MainWindow parent) { InitializeComponent(); parentWin = parent; DataContext = this; // Load lists from the database BranchList = BranchDBInfo.LoadStringList(); CemList = CemeteryDBInfo.LoadStringList(); ConflictList = ConflictDBInfo.LoadStringList(); SetupQueryLists(); }
private void Btn_EditConflict_Click(object sender, RoutedEventArgs e) { string selected; selected = Convert.ToString(ListBox_ConflictDetails.SelectedValue); // Verify the user selected a record to edit if (!string.IsNullOrEmpty(selected)) { CurrentConflict = new ConflictDBInfo(selected); ShowControls(); } else { MessageBox.Show(Tools.RecordSelectMessage, Tools.RecordSelectTitle); } }
// Loads the conflicts into a list of objects public static List <ConflictDBInfo> LoadObjectList() { List <ConflictDBInfo> records = new List <ConflictDBInfo>(); ConflictDBInfo current; try { using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString)) { conn.OpenAsync(); using (MySqlCommand command = conn.CreateCommand()) { command.CommandText = "SELECT CLName FROM ConflictList;"; using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { if (!reader.IsDBNull(0)) { current = new ConflictDBInfo(reader.GetString(0)); records.Add(current); } } } } } } catch (InvalidOperationException) { MessageBox.Show(Tools.DBErrorMessage, Tools.DBErrorTitle); } catch (MySqlException e) { Tools.HandleSQLExceptions(e); } return(records); }
private void Btn_AddConflict_Click(object sender, RoutedEventArgs e) { CurrentConflict = new ConflictDBInfo(); ShowControls(); }
private void ListBox_ConflictDetails_SelectionChanged(object sender, SelectionChangedEventArgs e) { HideControls(); CurrentConflict = null; }
private void Btn_ConflictCancel_Click(object sender, RoutedEventArgs e) { HideControls(); CurrentConflict = null; }