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();
}
}
