public eThongKeSLDia ThongKeSoLuongDiaTheoTinhTrang(eTieuDe tieuDe)
{
var listdia = db.Dias.Where(x => x.MaTieuDe.Equals(tieuDe.MaTieuDe)).ToList();
eThongKeSLDia eThongKe = new eThongKeSLDia();
List <Dia> listDiaDaThue = new List <Dia>();
List <Dia> listDiaDaDatTruoc = new List <Dia>();
List <Dia> listDiaSanSang = new List <Dia>();
foreach (Dia dia in listdia)
{
if (dia.TrangThaiDia.Equals("Đã thuê"))
{
listDiaDaThue.Add(dia);
}
else if (dia.TrangThaiDia.Equals("Đã đặt"))
{
listDiaDaDatTruoc.Add(dia);
}
else
{
listDiaSanSang.Add(dia);
}
}
eThongKe.TenTieuDe = tieuDe.TenTieuDe;
eThongKe.TongSoLuong = listdia.Count;
eThongKe.SoLuongDaDatTruoc = listDiaDaDatTruoc.Count;
eThongKe.SoLuongDaThue = listDiaDaThue.Count;
eThongKe.SoLuongSanSang = listDiaSanSang.Count;
return(eThongKe);
}
private void datagridTieuDeGame_RowStateChanged(object sender, DataGridViewRowStateChangedEventArgs e)
{
if (datagridTieuDeGame.SelectedRows.Count > 0)
{
etd = new eTieuDe();
etd.MaTieuDe = datagridTieuDeGame.SelectedRows[0].Cells["maTieuDe"].Value.ToString();
etd.TenTieuDe = datagridTieuDeGame.SelectedRows[0].Cells["tenTieuDe"].Value.ToString();
etd.NhaSanXuat = datagridTieuDeGame.SelectedRows[0].Cells["nhaSanXuat"].Value.ToString();
etd.MaLoaiDia = datagridTieuDeGame.SelectedRows[0].Cells["maLoaiDia"].Value.ToString();
etk = busdia.ThongKeSoLuongDiaTheoTinhTrang(etd);
lblTenTieuDe.Text = "";
lblTongSoLuongDia.Text = "";
lblSoLuongDaDuocThue.Text = "";
lblSoLuongDatTruoc.Text = "";
lblSoLuongSanSang.Text = "";
}
}
