private void load_BaiHat_home()
{
dtBaiHat_home = new BaiHat_BUS().getBaiHat_home();
foreach (DataRow dr in dtBaiHat_home.Rows)
{
ListViewItem li = lvwBaiHat_Home.Items.Add("");
li.SubItems.Add(dr["tenbaihat"].ToString());
li.SubItems.Add(dr["tenalbum"].ToString());
DataTable dt = new Casi_Baihat_BUS().getCasi_BaiHat_by_mabaihat(dr["mabaihat"].ToString());
string cac_casi = "";
foreach (DataRow r in dt.Rows)
{
DataTable dtcasi = new CaSi_BUS().getCasi_by_macasi(r["macasi"].ToString());
foreach (DataRow r1 in dtcasi.Rows)
{
cac_casi += r1["tencasi"].ToString() + ", ";
}
}
li.SubItems.Add(cac_casi + "...");
li.SubItems.Add(dr["tentheloai"].ToString());
li.SubItems.Add(dr["loibaihat"].ToString());
li.Tag = dr["mabaihat"];
}
stt(lvwBaiHat_Home);
}
private void lvwTheLoai_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvwTheLoai.SelectedItems.Count == 0)
{
return;
}
lvwBaiHat_TheLoai.Items.Clear();
try
{
DataTable dt = new BaiHat_BUS().getBaiHat_by_TheLoai(lvwTheLoai.SelectedItems[0].Tag.ToString());
foreach (DataRow dr in dt.Rows)
{
ListViewItem li = lvwBaiHat_TheLoai.Items.Add("");
li.SubItems.Add(dr["tenbaihat"].ToString());
DataTable dtA = new Album_BUS().getAlbum_by_ma(dr["maalbum"].ToString());
DataRow r = dtA.Rows[0];
li.SubItems.Add(r["tenalbum"].ToString());
DataTable dtt = new Casi_Baihat_BUS().getCasi_BaiHat_by_mabaihat(dr["mabaihat"].ToString());
string cac_casi = "";
foreach (DataRow rt in dtt.Rows)
{
DataTable dtcasi = new CaSi_BUS().getCasi_by_macasi(rt["macasi"].ToString());
foreach (DataRow r1 in dtcasi.Rows)
{
cac_casi += r1["tencasi"].ToString() + ", ";
}
}
li.SubItems.Add(cac_casi + "...");
li.SubItems.Add(dr["loibaihat"].ToString());
}
}
catch (Exception)
{
MessageBox.Show("Lỗi không xác định ");
return;
}
stt(lvwBaiHat_TheLoai);
lblBaiHatTrongTheLoai.Text = "Danh sách các bài hát có trong Thể loại: [" + lvwTheLoai.SelectedItems[0].SubItems[1].Text + "]";
}
