public eThongKeYeuCauDat ThongKeSoLuongDiaYeuCauDat(eTieuDe tieuDe)
{
var listphieudat = db.PhieuDats.Where(x => x.MaTieuDe.Equals(tieuDe.MaTieuDe)).ToList();
var listdia = db.Dias.Where(x => x.MaTieuDe.Equals(tieuDe.MaTieuDe)).ToList();
List <PhieuDat> listSLDaDuocDat = new List <PhieuDat>();
List <PhieuDat> listSLChuaDuocTra = new List <PhieuDat>();
foreach (PhieuDat pd in listphieudat)
{
if (pd.MaDia != null)
{
listSLDaDuocDat.Add(pd);
}
else
{
listSLChuaDuocTra.Add(pd);
}
}
eThongKeYeuCauDat etk = new eThongKeYeuCauDat();
etk.TenTieuDe = tieuDe.TenTieuDe;
etk.SoLuongYeuCau = listphieudat.Count();
etk.TongSoLuongDia = listdia.Count();
etk.SoLuongDiaDaDuocDat = listSLDaDuocDat.Count;
etk.SoLuongDiaChuaDuocDat = listSLChuaDuocTra.Count;
return(etk);
}
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 = buspd.ThongKeSoLuongDiaYeuCauDat(etd);
lblTenTieuDe.Text = "";
lblTongSoLuongDia.Text = "";
lblSoLuongYeuCauDat.Text = "";
lblSoLuongDaDuocDat.Text = "";
lblSoLuongChuaDuocDat.Text = "";
}
}
