private void button2_Click(object sender, EventArgs e) { switch (searchMode) { case 1: { //by length int length = int.Parse(numericUpDown1.Value.ToString()) * 60; length += int.Parse(numericUpDown2.Value.ToString()); searchVal = length.ToString(); if (radioEQ.Checked) { searchPar = "EQ"; } if (radioGT.Checked) { searchPar = "GT"; } if (radioLT.Checked) { searchPar = "LT"; } this.Close(); break; } case 2: { //by artist searchVal = searchCombo.SelectedValue.ToString(); this.Close(); break; } case 3: { // by year searchVal = searchCombo.SelectedValue.ToString(); this.Close(); break; } case 4: { //by genre searchVal = searchCombo.SelectedValue.ToString(); this.Close(); break; } case 5: { //delete song db.sqlProcedureQuery("P_DELETE_SONG", "songid", SqlDbType.Int, searchCombo.SelectedValue.ToString()); db.dbDestroy(); this.Close(); break; } case 6: { //delete artist if (db.sqlProcedureQuery("P_FETCH_SONGS_BY_ARTIST", "artistid", SqlDbType.Int, searchCombo.SelectedValue.ToString()).Rows.Count == 0 && db.sqlCustomQuery("SELECT * FROM AlbumTb WHERE ARTIST_ID = " + searchCombo.SelectedValue.ToString()).Rows.Count == 0) { db.sqlProcedureQuery("P_DELETE_ARTIST", "artistid", SqlDbType.Int, searchCombo.SelectedValue.ToString()); db.dbDestroy(); this.Close(); } else { MessageBox.Show("Cannot delete Artist! There are song or album entries who depend on this."); } break; } case 7: { //delete Album if (db.sqlCustomQuery("SELECT * FROM SongListTb WHERE ALBUM_ID = " + searchCombo.SelectedValue.ToString()).Rows.Count == 0) { db.sqlProcedureQuery("P_DELETE_ALBUM", "albumid", SqlDbType.Int, searchCombo.SelectedValue.ToString()); db.dbDestroy(); this.Close(); } else { MessageBox.Show("Album can not be deleted! It has dependencies in a song entry."); } break; } case 8: { //delete genre if (db.sqlCustomQuery("SELECT * FROM SongListTb WHERE SONG_GENRE_ID = " + searchCombo.SelectedValue.ToString()).Rows.Count == 0) { db.sqlProcedureQuery("P_DELETE_GENRE", "genreid", SqlDbType.Int, searchCombo.SelectedValue.ToString()); db.dbDestroy(); this.Close(); } else { MessageBox.Show("Genre can not be deleted! It has dependencies in a song entry."); } break; } } }
private void fetchSongs_Click(object sender, EventArgs e) { dataGridView1.DataSource = Database.sqlProcedureQuery("P_FETCH_SONGS"); }