private void searchByGenre_Click(object sender, EventArgs e)
{
searchGenerics frm = new searchGenerics(4);
frm.ShowDialog();
if (frm.searchVal != null)
{
dataGridView1.DataSource = Database.sqlProcedureQuery("P_FETCH_SONGS_BY_GENRE", "genre_id", SqlDbType.Int, frm.searchVal);
}
}
private void searchByLength_Click(object sender, EventArgs e)
{
searchGenerics frm = new searchGenerics(1);
frm.ShowDialog();
string par = frm.searchPar;
if (par == "GT")
{
dataGridView1.DataSource = Database.sqlProcedureQuery("P_FETCH_SONGS_BY_LENGTH_GT", "length", SqlDbType.Int, frm.searchVal);
}
if (par == "LT")
{
dataGridView1.DataSource = Database.sqlProcedureQuery("P_FETCH_SONGS_BY_LENGTH_LT", "length", SqlDbType.Int, frm.searchVal);
}
if (par == "EQ")
{
dataGridView1.DataSource = Database.sqlProcedureQuery("P_FETCH_SONGS_BY_LENGTH_EQ", "length", SqlDbType.Int, frm.searchVal);
}
}
private void removeSong_Click(object sender, EventArgs e)
{
searchGenerics frm = new searchGenerics(5);
frm.ShowDialog();
}
