private void btnThem_Click(object sender, EventArgs e) { string user = Properties.Settings.Default.useName; string pass = Properties.Settings.Default.passWord; if (user.Equals("Empty") && pass.Equals("Empty")) { Login frm = new Login(); frm.ShowDialog(); } else { if (txtSL.Text != "") { List <eTieuDe> list = new List <eTieuDe>(); list = tdbul.getTieuDes(); eTieuDe etd = new eTieuDe(); etd = list.FirstOrDefault(a => a.tenTieuDe == cbbTieuDe.Text); eDVD dVD = new eDVD(); dVD.id_TieuDe = etd.id_TieuDe; dVD.trangThai = -1; //onshelf for (int i = 0; i < Convert.ToInt32(txtSL.Text.Trim()); i++) { dvdbul.Save(dVD); } MessageBox.Show("Thêm thành công"); } else { MessageBox.Show("Vui lòng nhập số lượng"); } } }
private void btnDelete_Click(object sender, EventArgs e) { foreach (DataGridViewRow row in dsDiaThue.SelectedRows) { if (!row.Cells[0].Value.ToString().Equals("")) { int iddia = Convert.ToInt32(row.Cells[0].Value.ToString()); int id_tieude = Convert.ToInt32(row.Cells[1].Value.ToString()); eDVD dvd = new eDVD(); dvd.id_DVD = iddia; dvd.id_TieuDe = id_tieude; dvd.trangThai = -1; dsDiaThue.Rows.Remove(row); phiThue -= Convert.ToInt32(tlbus.GetTheLoaiByID(tieuDeBUL.Find(id_tieude).id_TheLoai).giaThue); tongPhi = phiThue + phiTreHen; listDsDVD.Add(dvd); foreach (eDVD item in listThue) { if (iddia == item.id_DVD) { listThue.Remove(item); break; } } } } LoadData(dgvDSDia, listDsDVD); txtPhiThue.Text = phiThue.ToString(); txtTong.Text = tongPhi.ToString(); }
private void btn_tkDia_Click(object sender, EventArgs e) { if (!txt_IDDia.Text.Trim().Equals("")) { listDsDVD.Clear(); List <eDVD> list = new List <eDVD>(); eDVD dvd = dVDBUL.FindDVDById(Convert.ToInt32(txt_IDDia.Text.Trim())); if (dvd != null) { list.Add(dvd); LoadData(dgvDSDia, list); } listDsDVD = list; } if (!txt_tendia.Text.Trim().Equals("")) { listDsDVD.Clear(); List <eDVD> listDVD = new List <eDVD>(); List <eTieuDe> list = tieuDeBUL.getTieuDeByTen(txt_tendia.Text.Trim()); foreach (eTieuDe item in list) { listDVD = dVDBUL.getDVDsByTieuDe(item.id_TieuDe); } LoadData(dgvDSDia, listDVD); listDsDVD = listDVD; } }
private void btn_thue_Click(object sender, EventArgs e) { // add dvd to grid view foreach (DataGridViewRow row in dgvDSDia.SelectedRows) { if (!row.Cells[0].Value.ToString().Equals("")) { int iddia = Convert.ToInt32(row.Cells[0].Value.ToString()); int id_tieude = Convert.ToInt32(row.Cells[1].Value.ToString()); eDVD dvd = new eDVD(); dvd.id_DVD = iddia; dvd.id_TieuDe = id_tieude; dvd.trangThai = -1; dgvDSDia.Rows.Remove(row); foreach (eDVD item in listDsDVD) { if (iddia == item.id_DVD) { listDsDVD.Remove(item); break; } } phiThue += Convert.ToInt32(tlbus.GetTheLoaiByID(tieuDeBUL.Find(id_tieude).id_TheLoai).giaThue); tongPhi = phiThue + phiTreHen; listThue.Add(dvd); } } dsDiaThue.DataSource = ConvertListToDataTable(listThue); FormatGridViewDiaThue(dsDiaThue); txtPhiThue.Text = phiThue.ToString(); txtTong.Text = tongPhi.ToString(); }
private void btn_timkiem_Click(object sender, EventArgs e) { Clearr(); if (nhapid.Text != "") { int id = Convert.ToInt32(nhapid.Text); eDVD dvd = dVDBUL.FindDVDById(id); if (dvd != null) { eTieuDe tieuDe = tieuDe = tieuDeBUL.Find(dvd.id_TieuDe); eTheLoai theLoai = tieuDeBUL.FindTheLoaiById(tieuDe.id_TieuDe); txt_tendia.Text = tieuDe.tenTieuDe; txtgiathue.Text = theLoai.giaThue.ToString(); txttgthue.Text = theLoai.thoiGianThue.ToString(); txt_iddia.Text = dvd.id_DVD.ToString(); txt_tragthai.Text = dvd.trangThai.ToString(); btn_timkiem.Text = " Tìm kiếm"; } else { MessageBox.Show("Không có đĩa trong danh sách"); } } else { MessageBox.Show("Nhap ma can tim"); } }
private void btnCheck_Click(object sender, EventArgs e) { if (!txtIDdia.Text.ToString().Trim().Equals("")) { eDVD dvd = dVDBUL.FindDVDById(Convert.ToInt32(txtIDdia.Text.ToString())); if (dvd != null) { this.Size = new Size(319, 137); lblTieuDe1.Visible = true; lblTrangThai1.Visible = true; lblTieuDe.Visible = true; lblTrangThai.Visible = true; lblTieuDe.Text = tieuDeBUL.Find(dvd.id_TieuDe).tenTieuDe; if (dvd.trangThai == -1) { lblTrangThai.Text = "Trên kệ"; } else if (dvd.trangThai == 0) { this.Size = new Size(319, 223); grCho.Visible = true; grThue.Visible = false; lblTrangThai.Text = "Đang giữ"; ePhieuDatTruoc phieu = phieuDatTruocBUL.GetPhieuDatTruocByID(dvd.id_DVD); lblNguoiDatTrc.Text = khachHangBUL.Find(phieu.id_KhachHang).tenKhachHang; lblNgayLay.Text = phieu.ngayDatTruoc.ToShortDateString(); } else { this.Size = new Size(319, 223); grThue.Visible = true; grCho.Visible = false; lblTrangThai.Text = "Đang thuê"; ePhieuThueTra phieu = phieuThueTraBUL.getPhieuThueTraByIdDVD(dvd.id_DVD); if (phieu != null) { lblNguoiThue.Text = khachHangBUL.Find(phieu.id_KhachHang).tenKhachHang; int tgianThue = theLoaiBUL.GetTheLoaiByID(tieuDeBUL.Find(dvd.id_TieuDe).id_TheLoai).thoiGianThue; DateTime ngayTraDuKien = phieu.ngayThue.AddDays(tgianThue); lblDenHan.Text = ngayTraDuKien.ToShortDateString(); } } } else { this.Size = new Size(319, 79); grThue.Visible = false; grCho.Visible = false; lblTieuDe1.Visible = false; lblTrangThai1.Visible = false; lblTieuDe.Visible = false; lblTrangThai.Visible = false; MessageBox.Show("Không tồn tại DVD"); return; } } }
public void Save(eDVD d) { DVD item = new DVD(); item.id_DVD = d.id_DVD; item.trangThai = d.trangThai; item.id_TieuDe = d.id_TieuDe; dvddal.Save(item); }
private void cb_listkh_SelectedIndexChanged(object sender, EventArgs e) { if (cb_listkh.SelectedIndex == 1) { List <eKhachHang> lskh = khbul.getKhachHangs(); List <eKhachHang> lskh1 = new List <eKhachHang>(); foreach (var item in lskh) { List <ePhieuThueTra> lsp = phieu.getPhieuThueTraByKHBaoCao(item.id_KhachHang); foreach (var item1 in lsp) { eDVD dvd1 = dvd.FindDVDById(item1.id_DVD); eTieuDe t = td.GetTieuDeByID(dvd1.id_TieuDe); eTheLoai theloai = tl.GetTheLoaiByID(t.id_TheLoai); DateTime dt = (DateTime)item1.ngayThue; DateTime today = DateTime.Now; if (item1.ngayTra == null && DateTime.Compare(today, dt.AddDays(theloai.thoiGianThue)) == 1) { lskh1.Add(item); break; } } } dgv_dskh.DataSource = lskh1; FormatLaiDataGridviewkh(dgv_dskh); } else if (cb_listkh.SelectedIndex == 0) { List <eKhachHang> ls = khbul.getKhachHangs(); dgv_dskh.DataSource = ls; FormatLaiDataGridviewkh(dgv_dskh); } else { List <eKhachHang> lskh = khbul.getKhachHangs(); List <eKhachHang> lskh1 = new List <eKhachHang>(); foreach (var item in lskh) { List <ePhieuThueTra> lsp = phieu.getPhieuThueTraByKHBaoCao(item.id_KhachHang); foreach (var item1 in lsp) { if (item1.ngayTraPhiTreHen == null) { lskh1.Add(item); break; } } } dgv_dskh.DataSource = lskh1; FormatLaiDataGridviewkh(dgv_dskh); } }
public List <eDVD> getDVDsByTieuDe(int tieude) { List <eDVD> list = new List <eDVD>(); foreach (var item in dvddal.getDVDsByTieuDe(tieude)) { eDVD tam = new eDVD(); tam.id_DVD = item.id_DVD; tam.trangThai = item.trangThai; tam.id_TieuDe = item.id_TieuDe; list.Add(tam); } return(list); }
public eDVD getDVDOnShelf(int id_tieude) { DVD item = dvddal.getDVDOnShelf(id_tieude); if (item != null) { eDVD tam = new eDVD(); tam.id_DVD = item.id_DVD; tam.trangThai = item.trangThai; tam.id_TieuDe = item.id_TieuDe; return(tam); } return(null); }
public eDVD FindDVDById(int id) { DVD t = dvddal.Find(id); if (t != null) { eDVD e = new eDVD(); e.id_DVD = t.id_DVD; e.trangThai = t.trangThai; e.id_TieuDe = t.id_TieuDe; return(e); } return(null); }
public eDVD Updatee(int id) { DVD dv = dvddal.Find(id); if (dv != null) { dv = dvddal.Update(id); eDVD t = new eDVD(); t.id_DVD = dv.id_DVD; t.trangThai = dv.trangThai; t.id_TieuDe = dv.id_TieuDe; return(t); } return(null); }
private void btn_tradia_Click(object sender, EventArgs e) { DateTime now = DateTime.Now; listKH = new List <eKhachHang>(); listDVD = new List <eDVD>(); int count = 0; foreach (DataGridViewRow row in dgvDsTra.Rows) { int id_phieu = Convert.ToInt32(row.Cells[0].Value.ToString()); DateTime ngayThue = Convert.ToDateTime(row.Cells[2].Value.ToString()); int id_dvd = Convert.ToInt32(row.Cells[1].Value.ToString()); double time = theLoaiBUL.GetTheLoaiByID(tieuDeBUL.GetTieuDeByID(dvdBul.FindDVDById(id_dvd).id_TieuDe).id_TheLoai).thoiGianThue; eDVD dvd = dvdBul.FindDVDById(id_dvd); if (!listDVD.Contains(dvd)) { listDVD.Add(dvd); } eKhachHang kh = khBul.Find(Convert.ToInt32(row.Cells[3].Value.ToString())); if (!listKH.Contains(kh)) { listKH.Add(kh); } if ((now - ngayThue).TotalDays > time) { count = phieuTTBul.UpdatePhieuThue_Tre(id_phieu, now, PHI_TRE_HEN); } else { count = phieuTTBul.UpdatePhieuThue(id_phieu, now, now, 0); } dvdBul.UpdateTrangThaiDVD(id_dvd, -1); } if (count == 1) { MessageBox.Show("Trả đĩa thành công"); table.Clear(); LoadData(); } CheckPhiTreHen(); UpdateDVDDatTruoc(); }
private void btn_dat_Click(object sender, EventArgs e) { DataGridViewRow row = this.dgv_dstieude.Rows[vitri]; //Ma tieu de int s = Convert.ToInt32(row.Cells[0].Value.ToString()); ePhieuDatTruoc pdt = new ePhieuDatTruoc(); int id = Convert.ToInt32(txt_idkh.Text); eKhachHang kh = khachHangBUL.Find(id); if (kh != null) { eDVD dvd = dVDBUL.getDVDOnShelf(s); if (dvd != null) { pdt.id_DVD = dvd.id_DVD; pdt.id_TieuDe = s; pdt.ngayDatTruoc = DateTime.Today; pdt.id_KhachHang = kh.id_KhachHang; pdt.trangThai = 0; phieuDatTruocBUL.Save(pdt); MessageBox.Show("Đặt trước thành công"); dVDBUL.UpdateTrangThaiDVD(dvd.id_DVD, 0); } else { pdt.id_TieuDe = s; pdt.ngayDatTruoc = DateTime.Today; pdt.id_KhachHang = kh.id_KhachHang; pdt.trangThai = 0; phieuDatTruocBUL.Save(pdt); MessageBox.Show("Đặt trước thành công"); } } else { MessageBox.Show("Không tìm thấy khách hàng"); return; } dgv_dstieude.DataSource = tieuDeBUL.getTieuDes(); }
private void btnThem_Click(object sender, EventArgs e) { if (txtSL.Text != "") { List <eTieuDe> list = new List <eTieuDe>(); list = tdbul.getTieuDes(); eTieuDe etd = new eTieuDe(); etd = list.FirstOrDefault(a => a.tenTieuDe == cbbTieuDe.Text); eDVD dVD = new eDVD(); dVD.id_TieuDe = etd.id_TieuDe; dVD.trangThai = 1; dvdbul.Save(dVD); MessageBox.Show("Them Thanh Cong"); } else { MessageBox.Show("Vui long nhap so luong"); } }
private void btnThem_Click(object sender, EventArgs e) { if (txtSL.Text != "") { List <eTieuDe> list = new List <eTieuDe>(); list = tdbul.getTieuDes(); eTieuDe etd = new eTieuDe(); etd = list.FirstOrDefault(a => a.tenTieuDe == cbbTieuDe.Text); eDVD dVD = new eDVD(); dVD.id_TieuDe = etd.id_TieuDe; dVD.trangThai = 0; //onshelf for (int i = 0; i < Convert.ToInt32(txtSL.Text.Trim()); i++) { dvdbul.Save(dVD); } MessageBox.Show("Thêm thành công"); } else { MessageBox.Show("Vui lòng nhập số lượng"); } }