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