private void btnMuon_Click(object sender, EventArgs e)
{
btnMuon.Enabled = false;
btnTra.Enabled = true;
btnGiaHan.Enabled = true;
panel3.Enabled = true;
PhieuMuonDAO pm = new PhieuMuonDAO();
string maphieumuon = txtCTMaPhieuMuon.Text;
string madg = (cbMaDGMuon.SelectedItem as DocGia).MaDG;
DateTime ngaymuon = dateTimeCTMuonMuon.Value;
DateTime ngaytra = dateTimeCTTraMuon.Value;
string manhanvien = LoginAccount.MaNhanVien;
int trangthai = 0;
string masach = (cbMaSachMuon.SelectedItem as Book).MaSach;
int soluong = (int)numSLMuon.Value;
BookDAO book = new BookDAO();
if (book.CheckBookNumberByMaSach(masach) < soluong)
{
MessageBox.Show("Sách không đủ");
}
else
{
if (pm.InsertPhieuMuon(maphieumuon, madg, ngaymuon, ngaytra, manhanvien, trangthai, masach, soluong))
{
MessageBox.Show("Thêm Thành công");
ShowMuon();
}
else
{
MessageBox.Show("Có lỗi khi thêm");
}
}
}
int PhanTrang()
{
PhieuMuonDAO pm = new PhieuMuonDAO();
int sodong = 0;
if (ckhQuaHan.Checked == false)
{
string query = "Select count(*) from PhieuMuon Where TrangThaiTong=0";
sodong = pm.GetSoLuong(query);
}
else if (ckhQuaHan.Checked == true)
{
DateTime dt = DateTime.Now;
string query = "Select count(*) from PhieuMuon Where TrangThaiTong=0 and NgayTra < '" + dt.ToString() + "'";
sodong = pm.GetSoLuong(query);
}
int sotrang = sodong / 10;
if (sodong % 10 != 0)
{
sotrang += 1;
}
return(sotrang);
}
string TaoMoiMaPhieu()
{
PhieuMuonDAO pm = new PhieuMuonDAO();
string old = pm.GetMaxMaPhieu();
old = old.TrimStart('P');
int newCode = int.Parse(old);
newCode += 1;
string code = "P";
if (newCode < 10)
{
code = code + "00" + newCode;
}
else if (newCode < 100)
{
code = code + "0" + newCode;
}
else
{
code = code + newCode;
}
return(code);
}
public static void MakeLoan(string idDocGia, DateTime ngayMuon, string[] idSachs)
{
int idPhieuMuon = PhieuMuonDAO.AddPhieuMuon(Int32.Parse(idDocGia), ngayMuon);
foreach (string idSach in idSachs)
{
CT_PhieuMuonBUS.AddCT_PhieuMuon(idPhieuMuon, Int32.Parse(idSach));
SachBUS.UpdateTinhTrangSach(Int32.Parse(idSach), true);
}
}
private void txtSearchMuon_TextChanged(object sender, EventArgs e)
{
PhieuMuonDAO pm = new PhieuMuonDAO();
if (radMaDGMuon.Checked == true)
{
dgvMuon.DataSource = pm.GetListPhieuMuonByMaDG(txtSearchMuon.Text);
}
if (radMaPhieuMuon.Checked == true)
{
dgvMuon.DataSource = pm.GetListPhieuMuonByMaPhieu(txtSearchMuon.Text);
}
}
private void ckbChuaTra_CheckedChanged(object sender, EventArgs e)
{
txtPage.Text = "1";
PhieuMuonDAO pm = new PhieuMuonDAO();
if (ckhQuaHan.Checked == false)
{
listTK.DataSource = pm.GetListPhieuMuonbyPage(1, 0);
}
else if (ckhQuaHan.Checked == true)
{
listTK.DataSource = pm.GetListPhieuMuonbyPage(1, 1);
}
}
private void txtCTMaPhieuMuon_TextChanged(object sender, EventArgs e)
{
try
{
PhieuMuonDAO pm = new PhieuMuonDAO();
DateTime dt = new DateTime();
dt = pm.GetTimeNgayMuonByMaPhieu(txtCTMaPhieuMuon.Text);
dateTimeCTMuonMuon.Value = dt;
dt = pm.GetTimeNgayTraByMaPhieu(txtCTMaPhieuMuon.Text);
dateTimeCTTraMuon.Value = dt;
}
catch
{
}
}
private void XoaNV_Click(object sender, EventArgs e)
{
string manv = txtMaNV.Text;
PhieuMuonDAO pm = new PhieuMuonDAO();
NhanVienDAO nv = new NhanVienDAO();
pm.DeletePhieuMuonByMaNV(manv);
if (nv.DeleteNhanVien(manv))
{
MessageBox.Show("Xóa thành công");
ShowNhanVien();
}
else
{
MessageBox.Show("có lỗi khi xóa nv");
}
}
private void txtPage_TextChanged(object sender, EventArgs e)
{
PhieuMuonDAO pm = new PhieuMuonDAO();
if (ckhQuaHan.Checked == false)
{
PhanTrang();
int nowPage = int.Parse(txtPage.Text);
listTK.DataSource = pm.GetListPhieuMuonbyPage(nowPage, 0);
}
else if (ckhQuaHan.Checked == true)
{
PhanTrang();
int nowPage = int.Parse(txtPage.Text);
listTK.DataSource = pm.GetListPhieuMuonbyPage(nowPage, 1);
}
}
private void btnGiaHan_Click(object sender, EventArgs e)
{
string maphieu = txtCTMaPhieuMuon.Text;
DateTime giahan = dateTimeCTTraMuon.Value.AddMonths(1);
if (MessageBox.Show(string.Format("Bạn có muốn Gia hạn thêm cho Mã phiếu: {0} đến ngày: {1}", maphieu, giahan.ToString()), "Thông báo", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK)
{
PhieuMuonDAO pm = new PhieuMuonDAO();
if (pm.GiaHan(maphieu, giahan))
{
MessageBox.Show("Gia Hạn thành công");
ShowMuon();
}
else
{
MessageBox.Show("Gia hạn không thành công");
}
}
}
void SearchByMaSV(string masv)
{
PhieuMuonDAO pm = new PhieuMuonDAO();
addColumPhieuMuon();
List <PhieuMuon> list = pm.GetListPhieuMuonByMaSV(masv);
foreach (PhieuMuon item in list)
{
ListViewItem lsv = new ListViewItem(item.MaPhieuMuon.ToString());
lsv.SubItems.Add(item.MaDG.ToString());
lsv.SubItems.Add(item.MaSach.ToString());
lsv.SubItems.Add(item.SoLuong.ToString());
lsv.SubItems.Add(item.NgayMuon.ToString());
lsv.SubItems.Add(item.NgayTra.ToString());
lvSearch.Items.Add(lsv);
}
taohang();
}
private void btnTra_Click(object sender, EventArgs e)
{
string maphieu = txtCTMaPhieuMuon.Text;
string madg = (cbMaDGMuon.SelectedItem as DocGia).MaDG;
int soluong = (int)numSLMuon.Value;
string masach = txtMaSachMuon.Text;
PhieuMuonDAO pm = new PhieuMuonDAO();
if (MessageBox.Show(string.Format("Bạn có muốn trả cuốn sách: {0} của độc giả: {1} ,SL:{2}", masach, madg, soluong.ToString()), "Thông báo", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK)
{
if (pm.TraSach(masach, maphieu, soluong))
{
MessageBox.Show("Trả thành công");
ShowMuon();
}
else
{
MessageBox.Show("Có lỗi khi trả");
}
}
}
void showTkMuonAll()
{
PhieuMuonDAO pm = new PhieuMuonDAO();
listTK.DataSource = pm.GetListPhieuMuonbyPage(1, 0);
string query = "Select count(*) from PhieuMuon Where TrangThaiTong=0";
DateTime dt = DateTime.Now;
string query1 = "Select count(*) from PhieuMuon Where TrangThaiTong=0 and NgayTra < '" + dt.ToString() + "'";
int sodongquahan = pm.GetSoLuong(query1);
int sodong = pm.GetSoLuong(query);
thanhtrangthai.Items[0].Text += sodong.ToString();
thanhtrangthai.Items[1].Text += sodongquahan.ToString();
foreach (DataGridViewRow row in dgvThongKe.Rows)
{
if (row.Cells[7].Value.ToString() == "Quá hạn")
{
row.DefaultCellStyle.BackColor = Color.Red;
}
}
}
public static IList LocPhieuMuonByIDDocGia(int idDocGia)
{
return(PhieuMuonDAO.LocPhieuMuonByIDDocGia(idDocGia));
}
public static IList LocPhieuMuon(int idDocGia, DateTime ngayMuon)
{
return(PhieuMuonDAO.LocPhieuMuon(idDocGia, ngayMuon));
}
public static IList LoadPhieuMuon()
{
return(PhieuMuonDAO.LoadPhieuMuon());
}
public static DataTable LayTTSach(string MaSach)
{
return(PhieuMuonDAO.LayTTSach(MaSach));
}
void ShowMuon()
{
PhieuMuonDAO pm = new PhieuMuonDAO();
listMuon.DataSource = pm.GetListPhieuMuon();
}
public static int XoaPhieuMuon(int MaPhieu)
{
return(PhieuMuonDAO.XoaPhieuMuon(MaPhieu));
}
public static int XoaChiTiet(int MaPhieu)
{
return(PhieuMuonDAO.XoaChiTiet(MaPhieu));
}
public void Insert(PhieuMuonDTO phMuon)
{
PhieuMuonDAO.Insert(phMuon);
}
public static IList LocPhieuMuonByNgay(DateTime ngayMuon)
{
return(PhieuMuonDAO.LocPhieuMuonByNgay(ngayMuon));
}
public static DataTable LayData(string proc, string SoThe)
{
return(PhieuMuonDAO.LayData(proc, SoThe));
}
public static DataTable LayTTDG(string SoThe)
{
return(PhieuMuonDAO.LayTTDG(SoThe));
}
public static int ThemPhieuMuon(string SoThe, DateTime NgayMuon, DateTime NgayTra, string MaTT)
{
return(PhieuMuonDAO.ThemPhieuMuon(SoThe, NgayMuon, NgayTra, MaTT));
}
public static int ThemChiTiet(int Macs, int MaPhieu)
{
return(PhieuMuonDAO.ThemChiTiet(Macs, MaPhieu));
}
public static DataTable GetBook(int MaDG)
{
return(PhieuMuonDAO.GetBook(MaDG));
}
public static DataTable LoadDgvSach(string SoThe, string MaPhieu)
{
return(PhieuMuonDAO.LoadDgvSach(SoThe, MaPhieu));
}
public static DataTable KiemTraNgayTra(string SoThe)
{
return(PhieuMuonDAO.KiemTraNgayTra(SoThe));
}
public static int SuaPhieuMuon(int MaPhieu, string SoThe, DateTime NgayMuon, DateTime NgayTra, string MaTT)
{
return(PhieuMuonDAO.SuaPhieuMuon(MaPhieu, SoThe, NgayMuon, NgayTra, MaTT));
}
