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");
}
