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