private void LoadDsThongKeTitle() { bTua = new bTitle(); bReserveDetail = new bChiTietPhieuDatTruoc(); bDVD = new bDvd(); dgvThongKeTitle.Rows.Clear(); var list = bTua.getAllTitle().Where(n => n.TrangThai1 == true); foreach (var item in list) { string name = item.TenTitle; string theLoai; if (item.TheLoai == true) { theLoai = "Phim"; } else { theLoai = "Game"; } var listDvd = bDVD.getAllDvd().Where(n => n.IdTiltle == item.IdTitle && n.TrangThai1 == true); int soLuongThue = listDvd.Where(n => n.TinhTrang == "Thue").Count(); int soLuongDatTruoc = listDvd.Where(n => n.TinhTrang == "DatTruoc").Count(); int soLuongStock = listDvd.Where(n => n.TinhTrang == "TrenKe").Count(); int tongCopy = listDvd.Count(); int soLuongCho = bReserveDetail.getAllChiTietPhieuDatTruoc().Where(n => n.IdTitle == item.IdTitle && n.TrangThai1 == false).Count(); dgvThongKeTitle.Rows.Add(name, theLoai, tongCopy, soLuongThue, soLuongDatTruoc, soLuongStock, soLuongCho); } }
private void LoadDSTitle() { dgvListTitle.Rows.Clear(); bTua = new bTitle(); foreach (var item in bTua.getAllTitle().Where(n => n.TrangThai1 == true)) { dgvListTitle.Rows.Add(item.IdTitle, item.TenTitle); } }
private void btnDatTruocFunction_Click(object sender, EventArgs e) { txtIdKhachDatTruoc.Clear(); tabCtrlMenuTong.SelectedTab = tabPageBack; tabCtrlInput.SelectedTab = tabPageDatTruoc; bTua = new bTitle(); cbTitleDatTruoc.DataSource = bTua.getAllTitle().ToList(); cbTitleDatTruoc.DisplayMember = "tenTitle"; cbTitleDatTruoc.ValueMember = "idTitle"; txtIdKhachDatTruoc.Focus(); }
private void LoadDSDvd() { bTua = new bTitle(); bDVD = new bDvd(); dgvListDvd.Rows.Clear(); var list = bTua.getAllTitle().Where(n => n.TrangThai1 == true); var listDvd = bDVD.getAllDvd().Where(n => n.TrangThai1 == true).ToList(); foreach (var item in list) { int listDvdSameTitle = listDvd.Where(n => n.IdTiltle == item.IdTitle).Count(); dgvListDvd.Rows.Add(item.TenTitle, listDvdSameTitle); } }
private void btnThemDvdFunction_Click(object sender, EventArgs e) { if (lbHello.Text != "Hello!") { bTua = new bTitle(); tabCtrlTemp.SelectedTab = tabPageDsDvd; tabCtrlInput.SelectedTab = tabPageDvd; tabCtrlMenuTong.SelectedTab = tabPageBack; cbTitle.DataSource = bTua.getAllTitle().ToList(); cbTitle.DisplayMember = "tenTitle"; cbTitle.ValueMember = "idTitle"; LoadDSDvd(); } else { checkRoleFunction(); } }