private void Btn_DeleteAward_Click(object sender, RoutedEventArgs e) { int selectedIndex; VetAwardDBInfo removeItem = null; // Get the index from the UI selectedIndex = ListBox_AwardDetails.SelectedIndex; if (selectedIndex >= 0 && selectedIndex < Veteran.AwardDetails.Count) { MessageBoxResult result; result = MessageBox.Show(Tools.deleteMessage, Tools.deleteTitle, MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { removeItem = Veteran.AwardDetails[selectedIndex]; // Remove from the database removeItem.DeleteFromDatabase(); // Remove from the list Veteran.AwardDetails.Remove(removeItem); ListBox_AwardDetails.Items.Refresh(); } } else { MessageBox.Show(Tools.RecordDeleteMessage, Tools.RecordSelectTitle); } }
private void Btn_EditAward_Click(object sender, RoutedEventArgs e) { int selectedIndex; VetAwardDBInfo selectedItem = null; // Get the index from the UI selectedIndex = ListBox_AwardDetails.SelectedIndex; if (selectedIndex >= 0 && selectedIndex < Veteran.AwardDetails.Count) { selectedItem = Veteran.AwardDetails[selectedIndex]; AwardDetails awardWin = new AwardDetails(selectedItem); awardWin.ShowDialog(); Veteran.AwardDetails[selectedIndex] = awardWin.AwardInfo; ListBox_AwardDetails.Items.Refresh(); } else { MessageBox.Show(Tools.RecordSelectMessage, Tools.RecordSelectTitle); } }
// Copy Constructor public VetAwardDBInfo(VetAwardDBInfo other) { hasDataChanged = other.hasDataChanged; id = other.id; aNum = other.aNum; award = other.award; branch = other.branch; }
// Default Constructor public AwardDetails() { InitializeComponent(); AwardInfo = new VetAwardDBInfo(); IsOk = false; dataPreviouslyChanged = Tools.hasDataChanged; DataContext = this; BranchList = BranchDBInfo.LoadStringList(); }
// Loads the award details into a list private List <VetAwardDBInfo> LoadAwardDetails() { List <VetAwardDBInfo> records = new List <VetAwardDBInfo>(); int awardIdNum; try { using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString)) { conn.OpenAsync(); using (MySqlCommand command = conn.CreateCommand()) { command.CommandText = "SELECT ANum FROM Awards WHERE ID=@idNum;"; command.Parameters.Add("@idNum", MySqlDbType.Int32).Value = id; using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { if (!reader.IsDBNull(0)) { awardIdNum = reader.GetInt32(0); VetAwardDBInfo record = new VetAwardDBInfo(awardIdNum); records.Add(record); } } } } } } catch (InvalidOperationException) { MessageBox.Show(Tools.DBErrorMessage, Tools.DBErrorTitle); } catch (MySqlException e) { Tools.HandleSQLExceptions(e); } return(records); }