private void Btn_DeleteCemetery_Click(object sender, RoutedEventArgs e)
{
string selected;
selected = Convert.ToString(ListBox_CemeteryDetails.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 (CemeteryDBInfo cemetery in cemList)
{
if (cemetery.Details == selected)
{
// Remove from the database
cemetery.DeleteFromDatabase();
}
}
cemList = CemeteryDBInfo.LoadObjectList();
ListBox_CemeteryDetails.DataContext = cemList;
}
}
else
{
MessageBox.Show(Tools.RecordDeleteMessage, Tools.RecordSelectTitle);
}
}
public Veterans(MainWindow parent)
{
InitializeComponent();
parentWin = parent;
DataContext = this;
CemList = CemeteryDBInfo.LoadStringList();
}
public Cemeteries()
{
InitializeComponent();
cemList = CemeteryDBInfo.LoadObjectList();
ListBox_CemeteryDetails.DataContext = cemList;
DataContext = this;
}
private void Save()
{
CurrentCemetery.WriteDataToDatabase();
cemList = CemeteryDBInfo.LoadObjectList();
ListBox_CemeteryDetails.DataContext = cemList;
HideControls();
CurrentCemetery = null;
}
public VeteranRecord(MainWindow main)
{
InitializeComponent();
mainWin = main;
DataContext = this;
Tools.hasDataChanged = false;
CemList = CemeteryDBInfo.LoadStringList();
}
// Loads the cemeteries into a list of objects
public static List <CemeteryDBInfo> LoadObjectList()
{
List <CemeteryDBInfo> records = new List <CemeteryDBInfo>();
CemeteryDBInfo current;
try
{
using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString))
{
conn.OpenAsync();
using (MySqlCommand command = conn.CreateCommand())
{
command.CommandText = "SELECT CName,CCity FROM Cemeteries;";
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
string name = "";
string city = "";
if (!reader.IsDBNull(0))
{
name = reader.GetString(0);
}
if (!reader.IsDBNull(1))
{
city = reader.GetString(1);
}
current = new CemeteryDBInfo(name, city);
records.Add(current);
}
}
}
}
}
catch (InvalidOperationException)
{
MessageBox.Show(Tools.DBErrorMessage, Tools.DBErrorTitle);
}
catch (MySqlException e)
{
Tools.HandleSQLExceptions(e);
}
return(records);
}
// Copy Constructor
public CemeteryDBInfo(CemeteryDBInfo other)
{
name = other.name;
oldName = other.oldName;
city = other.city;
oldCity = other.oldCity;
address = other.address;
gps = other.gps;
airPicLoc = other.airPicLoc;
dirPicLoc = other.dirPicLoc;
hasDataChanged = other.hasDataChanged;
isNewRecord = other.isNewRecord;
}
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_EditCemetery_Click(object sender, RoutedEventArgs e)
{
string selected;
selected = Convert.ToString(ListBox_CemeteryDetails.SelectedValue);
// Verify the user selected a record to edit
if (!string.IsNullOrEmpty(selected))
{
CurrentCemetery = new CemeteryDBInfo(selected);
ShowControls();
}
else
{
MessageBox.Show(Tools.RecordSelectMessage, Tools.RecordSelectTitle);
}
}
private void ListBox_CemeteryDetails_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
HideControls();
CurrentCemetery = null;
}
private void Btn_CemCancel_Click(object sender, RoutedEventArgs e)
{
HideControls();
CurrentCemetery = null;
}
private void Btn_AddCemetery_Click(object sender, RoutedEventArgs e)
{
CurrentCemetery = new CemeteryDBInfo();
ShowControls();
}
