private void butDeleteTrophy_Click(object sender, EventArgs e) { int trophyID = CurrentTrophyID; // Cannot delete if there are winners if ((int)tblWinnersTableAdapter.GetWinnerCountByTrophy(trophyID) > 0) { MessageBox.Show(this, "A trophy cannot be deleted if it has any winners.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } // Cannot delete if there are photos using (TrophyDataSetTableAdapters.tblPhotosTableAdapter adapter = new LDYC_Trophies.TrophyDataSetTableAdapters.tblPhotosTableAdapter()) { if ((int)adapter.GetPhotoCountByTrophy(trophyID) > 0) { MessageBox.Show(this, "A trophy cannot be deleted if it has any photos.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } DialogResult res = MessageBox.Show(this, "Are you sure you want to delete this trophy?", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (res == DialogResult.No) { return; } this.tblTrophiesBindingSource.RemoveCurrent(); this.tblTrophiesTableAdapter.Update(this.trophyDataSet.tblTrophies); OnTrophyPositionChanged(); }
private void butDeleteTrophy_Click(object sender, EventArgs e) { int trophyID = CurrentTrophyID; // Cannot delete if there are winners if ((int)tblWinnersTableAdapter.GetWinnerCountByTrophy(trophyID) > 0) { MessageBox.Show(this, "A trophy cannot be deleted if it has any winners.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } // Cannot delete if there are photos using (TrophyDataSetTableAdapters.tblPhotosTableAdapter adapter = new LDYC_Trophies.TrophyDataSetTableAdapters.tblPhotosTableAdapter()) { if ((int)adapter.GetPhotoCountByTrophy(trophyID) > 0) { MessageBox.Show(this, "A trophy cannot be deleted if it has any photos.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } } DialogResult res = MessageBox.Show(this, "Are you sure you want to delete this trophy?", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (res == DialogResult.No) return; this.tblTrophiesBindingSource.RemoveCurrent(); this.tblTrophiesTableAdapter.Update(this.trophyDataSet.tblTrophies); OnTrophyPositionChanged(); }