private void btnLoc_Click(object sender, EventArgs e) { DateTime ngayTra = dtPickerNgayTra.Value.Date; if (IsValidate(ngayTra)) { gvDanhSachPhieuTra.DataSource = null; if (chbTenDocGia.Checked && chbNgayTra.Checked) { int idDocGia = ((DOCGIA)cbbTenDocGia.SelectedItem).IDDocGia; gvDanhSachPhieuTra.DataSource = PhieuTraBUS.LocPhieuTra(idDocGia, ngayTra); EditGridView(); } else if (chbTenDocGia.Checked) { int idDocGia = ((DOCGIA)cbbTenDocGia.SelectedItem).IDDocGia; gvDanhSachPhieuTra.DataSource = PhieuTraBUS.LocPhieuTraByIDDocGia(idDocGia); EditGridView(); } else { gvDanhSachPhieuTra.DataSource = PhieuTraBUS.LocPhieuTraByNgay(ngayTra); EditGridView(); } } }
private void dgvPT_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { var senderGrid = (DataGridView)sender; if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0) { String idPT, idDG, idNV, date; idPT = txtMaPT.Text; idDG = lbMaDocGia.Text; idNV = comboMaNV.SelectedValue.ToString(); date = ngayTra.Value.ToString(); PhieuTra pt = new PhieuTra(idPT, date, idDG, idNV); bool b = new PhieuTraBUS().DeletePT(pt); if (b) { MessageBox.Show("Xoa Thành Công"); } } Init(); } catch (SqlException ex) { MessageBox.Show("Xóa thất bại", ex.Message, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public frmTraSach() { InitializeComponent(); sachBUS = new SachBUS(); theDGBus = new TheDocGiaBUS(); phieumuonBUS = new PhieuMuonBUS(); phieutraBUS = new PhieuTraBUS(); }
public frmTraSach(PhieuMuonDTO selectedreceipt) { InitializeComponent(); sachBUS = new SachBUS(); theDGBus = new TheDocGiaBUS(); phieumuonBUS = new PhieuMuonBUS(); phieutraBUS = new PhieuTraBUS(); SelectedReceipt = selectedreceipt; SelectedBookIDs = new List <string>(); }
private void btnThem_Click(object sender, EventArgs e) { string idPhieuMuon = txtIDPhieuMuon.Text; string idSach = txtIDSach.Text; string tenSach = cbbTenSach.Text; DateTime ngayMuon = dtPickerNgayMuon.Value; DateTime ngayTra = dtPickerHomNay.Value; if (IsDuplicate(idSach, tenSach)) { return; } gvTraSach.Rows.Add(PhieuTraBUS.AddDetail(idPhieuMuon, idSach, tenSach, ngayMuon, ngayTra)); }
private void frmTraSach_Load(object sender, EventArgs e) { List <PhieuTra> list = new PhieuTraBUS().getPT(); dgvPT.DataSource = list; List <SachMuon> list2 = new PhieuTraBUS().getSM(); dgvPM.DataSource = list2; List <NhanVien> list3 = new NhanVienBUS().getNV(); comboMaNV.DataSource = list3; comboMaNV.DisplayMember = "TenNV"; comboMaNV.ValueMember = "IDNhanVien"; Init(); }
public void Init() { List <SachMuon> list = new PhieuTraBUS().getSM(); List <PhieuTra> list2 = new PhieuTraBUS().getPT(); dgvPM.DataSource = list; txtMaPT.DataBindings.Clear(); txtMaPT.DataBindings.Add("Text", list2, "MaPT"); lbMaDocGia.DataBindings.Clear(); lbMaDocGia.DataBindings.Add("Text", list, "MaDG"); ngayTra.DataBindings.Clear(); ngayTra.DataBindings.Add("Value", list2, "NgayTra"); comboMaNV.DataBindings.Clear(); comboMaNV.DataBindings.Add("Text", list2, "MaNV"); }
private void btnLapPhieuTra_Click(object sender, EventArgs e) { int[] idPhieuMuons = GetIDPhieuMuons(); int[] idSachs = GetIDSachs(); int[] soNgayMuons = GetSoNgayMuons(); int[] tienPhats = GetTienPhat(); PhieuTraBUS.MakePhieuTra(txtIDDocGia.Text, dtPickerHomNay.Value, idSachs, idPhieuMuons, soNgayMuons, tienPhats, txtTongNoMoi.Text); MessageBox.Show(this, "Lập phiếu trả thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); gvTraSach.Rows.Clear(); gvTraSach.Rows.Clear(); cbbTenSach.DataSource = null; cbbTenSach.Text = "Không có sách chưa trả"; txtIDSach.Text = ""; dtPickerNgayMuon.Value = DateTime.Now; txtIDPhieuMuon.Text = ""; txtIDDocGia.Text = ""; txtTenDocGia.Text = ""; txtNo.Text = ""; }
private void txtIDDocGia_TextChanged(object sender, EventArgs e) { gvTraSach.Rows.Clear(); cbbTenSach.DataSource = null; cbbTenSach.Text = "Không có sách chưa trả"; txtIDSach.Text = ""; dtPickerNgayMuon.Value = DateTime.Now; txtIDPhieuMuon.Text = ""; if (txtIDDocGia.Text != "") { int idDocGia = Int32.Parse(txtIDDocGia.Text); var sachChuaTras = PhieuTraBUS.GetSachChuaTra(idDocGia); if (sachChuaTras.Count > 0) { cbbTenSach.DataSource = sachChuaTras; cbbTenSach.DisplayMember = "TenSach"; AddSachDataBinding(); } } }
private void btnAdd_Click(object sender, EventArgs e) { String idPT, idDG, idNV, date; idPT = txtMaPT.Text; idDG = lbMaDocGia.Text; idNV = comboMaNV.SelectedValue.ToString(); date = ngayTra.Value.ToString(); PhieuTra pt = new PhieuTra(idPT, date, idDG, idNV); try { int numberOfRows = new PhieuTraBUS().Add(pt); dgvPT.DataSource = new PhieuTraBUS().getPT(); } catch (SqlException ex) { MessageBox.Show("Loi them phieu tra\n" + ex.Message); } }
private void btnUpdate_Click(object sender, EventArgs e) { String idPT, idDG, idNV, date; idPT = txtMaPT.Text; idDG = lbMaDocGia.Text; idNV = comboMaNV.SelectedValue.ToString(); date = ngayTra.Value.ToString(); PhieuTra pt = new PhieuTra(idPT, date, idDG, idNV); try { bool b = new PhieuTraBUS().UpdatePT(pt); Init(); dgvPT.DataSource = new PhieuTraBUS().getPT(); MessageBox.Show("Sửa thông tin phiếu trả thành công\n"); } catch (SqlException ex) { MessageBox.Show("Lỗi sửa thông tin phiếu trả\n" + ex.Message); } }
private void LoadPhieuTra() { gvDanhSachPhieuTra.DataSource = PhieuTraBUS.LoadPhieuTra(); EditGridView(); }
private void LoadDocGia() { cbbTenDocGia.DataSource = PhieuTraBUS.GetDocGias(); cbbTenDocGia.DisplayMember = "HoTen"; }