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";
}
