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