private void btnAddBand_Click(object sender, EventArgs e)
{
try
{
if (validate.IsInList(txtBandName, lbBandList) &&
validate.IsPresent(txtBandName, "Band Name"))
{
// the band name is added to the listbox
// then clears the textbox and moves the focus to the album name textbox
Band newBand = new Band {
BandName = txtBandName.Text
};
BandAlbumTrackDB.InsertBand(newBand);
List <string> bandList = BandAlbumTrackDB.FetchBandData();
FillListBox(bandList, lbBandList, lbAlbumList, lbTrackList);
txtBandName.Clear();
txtBandName.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\n\n" +
ex.GetType().ToString() + "\n" +
ex.StackTrace, "Exception");
}
}
public Band_Organizer()
{
InitializeComponent();
BandAlbumTrackDB.CreateDatabase(); // Create database
BandAlbumTrackDB.CreateTables(); // Create tables
FillListBox(BandAlbumTrackDB.FetchBandData(), lbBandList); // Fill band listbox
}
private void btnDeleteBand_Click(object sender, EventArgs e)
{
// deletes band (and associated albums and tracks) from database
if (validate.IsSelected(lbBandList, "Band List"))
{
string band = TrimString(lbBandList);
BandAlbumTrackDB.DeleteBand(band);
List <string> bandList = BandAlbumTrackDB.FetchBandData();
FillListBox(bandList, lbBandList, lbAlbumList, lbTrackList);
}
}
