private void btnXoaList_Click(object sender, EventArgs e) { if (id != -1) { PhieuMuon pm = new PhieuMuon(); List <int> listID = new List <int>(); foreach (DataGridViewRow check in GridViewPM.Rows) { if ((bool)check.Cells["status"].FormattedValue) { listID.Add((int)check.Cells["MaPhieuMuon"].Value); } } foreach (int a in listID) { pm.xoaPM(a); } id = -1; loadPM(); } else { ErrorMessage("Vui lòng chọn ít nhất một checkbox", "Missing ID"); } }
private void BtnSua_Click(object sender, EventArgs e) { int MaDocGia = 0; int MaSach = 0; if (id == -1) { ErrorMessage("Vui lòng chọn PM để sửa!!!", "Data Error"); } else { DataRowView rowDocGia = (DataRowView)cbHoTenDocGia.SelectedItem; if (rowDocGia != null) { MaDocGia = (int)rowDocGia[0]; } DataRowView rowSach = (DataRowView)cbTenSach.SelectedItem; if (rowSach != null) { MaSach = (int)rowSach[0]; } PhieuMuon pm = new PhieuMuon(); pm.suaPM(datePickerNM.Value, MaDocGia, id, MaSach, Int32.Parse(txtTienNo.Text), Int32.Parse(txtSoTienThu.Text)); setNullForText(); loadPM(); id = -1; } }
private void loadPM() { //LVPM.Items.Clear(); PhieuMuon pm = new PhieuMuon(); DataTable dt = pm.layDSPM(); GridViewPM.DataSource = dt; }
private void loadCBDocGia() { cbHoTenDocGia.DataSource = null; PhieuMuon pm = new PhieuMuon(); DataTable dt = pm.layDSDG(); cbHoTenDocGia.DisplayMember = "HoTenDocGia"; cbHoTenDocGia.ValueMember = "MaDocGia"; cbHoTenDocGia.DataSource = dt; cbHoTenDocGia.SelectedIndex = -1; cbHoTenDocGia.Text = "--Select--"; }
private void loadCBSach() { cbTenSach.DataSource = null; PhieuMuon pm = new PhieuMuon(); DataTable dt = pm.layDSSach(); cbTenSach.DataSource = dt; cbTenSach.DisplayMember = "TenSach"; cbTenSach.ValueMember = "MaSach"; cbTenSach.SelectedIndex = -1; cbTenSach.Text = "--Select--"; }
private void loadCBNV() { //cbHoTenNV.Items.Clear(); cbHoTenNV.DataSource = null; PhieuMuon pm = new PhieuMuon(); DataTable dt = pm.layDSNV(); cbHoTenNV.DisplayMember = "HoTenNhanVien"; cbHoTenNV.ValueMember = "MaNhanVien"; cbHoTenNV.DataSource = dt; cbHoTenNV.SelectedIndex = -1; cbHoTenNV.Text = "--Select--"; }
private void BtnThem_Click(object sender, EventArgs e) { int MaDocGia = -1; int MaSach = -1; int MaNV = -1; DataRowView rowDocGia = (DataRowView)cbHoTenDocGia.SelectedItem; if (rowDocGia != null) { MaDocGia = (int)rowDocGia[0]; } DataRowView rowSach = (DataRowView)cbTenSach.SelectedItem; if (rowSach != null) { MaSach = (int)rowSach[0]; } DataRowView rowNV = (DataRowView)cbHoTenNV.SelectedItem; if (rowNV != null) { MaNV = (int)rowNV[0]; } if (MaDocGia.Equals(-1)) { ErrorMessage("Vui lòng chọn Độc Giả", "Missing Customer ID"); } else if (MaSach.Equals(-1)) { ErrorMessage("Vui lòng chọn Sách", "Missing Book ID"); } else if (MaNV.Equals(-1)) { ErrorMessage("Vui lòng chọn Nhân Viên", "Missing EmployeeID"); } else { if (txtTienNo.Text.Trim().Equals("") && txtSoTienThu.Text.Trim().Equals("")) { txtSoTienThu.Text = "0"; txtTienNo.Text = "0"; } PhieuMuon pm = new PhieuMuon(); pm.themPM(DateTime.Now, MaDocGia, MaSach, Int32.Parse(txtTienNo.Text), Int32.Parse(txtSoTienThu.Text), MaNV); setNullForText(); loadPM(); } }
private void BtnXoa_Click(object sender, EventArgs e) { if (id != -1) { PhieuMuon pm = new PhieuMuon(); pm.xoaPM(id); setNullForText(); loadPM(); id = -1; } else { ErrorMessage("Vui lòng chọn Phiếu Mượn để xóa", "Missing ID"); } }
private void btnTraSach_Click(object sender, EventArgs e) { PhieuMuon pm = new PhieuMuon(); if (id != -1) { pm.TraSach(id, datePickerNgayTra.Value); id = -1; } else { ErrorMessage("Vui lòng click chọn Phiếu Mượn để xóa", "Missing ID"); } loadPM(); }