private void btnBook_Remove_Click(object sender, EventArgs e)
{
if (dtgBook.SelectedRows.Count > 0)
{
if (dtgBook.SelectedRows.Count > 0)
{
DialogResult result = MessageBox.Show("Do you want to remove this reader", "Confirm",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
if (sach_BUS.XoaSach(strMaSach))
{
frmSuccess frm_Success = new frmSuccess(3);
frm_Success.ShowDialog();
}
else
{
frmFailed frm_failed = new frmFailed(2);
frm_failed.ShowDialog();
}
frmBook_Load(sender, e);
}
}
}
else
{
MessageBox.Show("You haven't selected a reader !", "Warning !",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnLibrarianAdd_Add_Click(object sender, EventArgs e)
{
NhanVien_DTO nv_DTO = new NhanVien_DTO();
nv_DTO.MaNV = lblLibrarian_ID.Text;
nv_DTO.HoTenNV = txtLibrarianAdd_Name.Text;
nv_DTO.NgSinh = dtpLibrarianAdd_DayOfBirth.Value.Date;
nv_DTO.SDT = txtLibrarianAdd_Phone.Text;
nv_DTO.TaiKhoan = txtLibrarianAdd_UserName.Text;
nv_DTO.Quyen = 0;
nv_DTO.MatKhau = nv_BUS.GetMD5(txtLibrarianAdd_Password.Text);
nv_DTO.TrangThai = true;
if (nv_BUS.ThemNhanVien(nv_DTO))
{
frmSuccess frmSuccess = new frmSuccess(1);
frmSuccess.ShowDialog();
this.Close();
}
else
{
frmFailed frmFailed = new frmFailed(1);
frmFailed.ShowDialog();
}
}
private void btnBookUpdate_Update_Click(object sender, EventArgs e)
{
Sach_DTO sach_DTO = new Sach_DTO
{
MaSach = lblBookUpdate_ID.Text,
TenSach = txtBookUpdate_TitleOfBook.Text,
MaDauSach = lblBookUpdate_TitleID.Text,
TenTacGia = txtBookUpdate_Author.Text,
TenNhaXuatBan = txtBookUpdate_Publisher.Text,
SoLuong = int.Parse(numBookUpdate_NumberOfBooks.Value.ToString()),
NamXuatBan = int.Parse(txtBookUpdate_PublicDate.Text),
DonGia = decimal.Parse(txtBookUpdate_Prices.Text),
TrangThai = true
};
DauSach_DTO dauSach_DTO = new DauSach_DTO
{
MaDauSach = lblBookUpdate_TitleID.Text,
TenDauSach = txtBookUpdate_TitleOfBook.Text,
MaTheLoai = comBookUpdate_Category.SelectedValue.ToString(),
TrangThai = true
};
DauSach_BUS dauSach_BUS = new DauSach_BUS();
if (dauSach_BUS.SuaDauSach(dauSach_DTO) == true)
{
Sach_BUS sach_BUS = new Sach_BUS();
if (sach_BUS.SuaSach(sach_DTO) == true)
{
CTNhapSach_BUS cTNhapSach_BUS = new CTNhapSach_BUS();
CTNhapSach_DTO cTNhapSach_DTO = cTNhapSach_BUS.TimCTNhapSachTheoMaSach(lblBookUpdate_ID.Text);
cTNhapSach_DTO.SoLuong = int.Parse(numBookUpdate_NumberOfBooks.Value.ToString());
cTNhapSach_DTO.DonGia = double.Parse(txtBookUpdate_Prices.Text);
if (cTNhapSach_BUS.SuaCTNhapSach(cTNhapSach_DTO) == true)
{
NhapSach_BUS nhapSach_BUS = new NhapSach_BUS();
NhapSach_DTO nhapSach_DTO = nhapSach_BUS.TimNhapSachTheoMaNhap(cTNhapSach_DTO.MaNhap);
nhapSach_DTO.ThanhTien = double.Parse(txtBookUpdate_Prices.Text) *
int.Parse(numBookUpdate_NumberOfBooks.Value.ToString());
if (nhapSach_BUS.SuaNhapSach(nhapSach_DTO) == true)
{
frmSuccess frm_Success = new frmSuccess(2);
frm_Success.ShowDialog();
this.Hide();
}
}
}
}
else
{
frmFailed frm_Failed = new frmFailed(2);
frm_Failed.Show();
}
}
private void btnReader_Remove_Click(object sender, EventArgs e)
{
if (dtgReader.SelectedRows.Count > 0)
{
DialogResult result = MessageBox.Show("Do you want to remove this reader", "Confirm",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (DialogResult.Yes == result)
{
if (docGia_BUS.XoaDocGia(MaDG))
{
frmSuccess frm_Success = new frmSuccess(3);
frm_Success.ShowDialog();
}
else
{
frmFailed frm_Failed = new frmFailed(3);
frm_Failed.ShowDialog();
}
}
}
else
{
MessageBox.Show("You haven't selected a reader !", "Warning !",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
frmReader_Load(sender, e);
}
private void btnBookAdd_Add_Click(object sender, EventArgs e)
{
Sach_DTO sachDTO = new Sach_DTO();
sachDTO.MaSach = lblBook_ID.Text;
sachDTO.TenSach = txtBookAdd_TitleOfBook.Text;
sachDTO.MaDauSach = lblBook_SeriesOfBook.Text;
sachDTO.TenTacGia = txtBookAdd_Author.Text;
sachDTO.TenNhaXuatBan = txtBookAdd_Publisher.Text;
sachDTO.SoLuong = int.Parse(numBookAdd_NumberOfBooks.Value.ToString());
sachDTO.NamXuatBan = int.Parse(txtBookAdd_PublicDate.Text);
sachDTO.DonGia = decimal.Parse(txtBookAdd_Prices.Text);
sachDTO.TrangThai = true;
DauSach_DTO dauSachDTO = new DauSach_DTO();
dauSachDTO.MaDauSach = lblBook_SeriesOfBook.Text;
dauSachDTO.TenDauSach = txtBookAdd_TitleOfBook.Text;
dauSachDTO.MaTheLoai = comBook_Category.SelectedValue.ToString();
dauSachDTO.TrangThai = true;
CTNhapSach_DTO cTNhapSach_DTO = new CTNhapSach_DTO();
cTNhapSach_DTO.MaNhap = nhapSach_BUS.PhatSinhMaNhapSach();
cTNhapSach_DTO.MaSach = lblBook_ID.Text;
cTNhapSach_DTO.SoLuong = int.Parse(numBookAdd_NumberOfBooks.Value.ToString());
cTNhapSach_DTO.DonGia = double.Parse(txtBookAdd_Prices.Text);
cTNhapSach_DTO.TrangThai = true;
NhapSach_DTO nhapSach_DTO = new NhapSach_DTO();
nhapSach_DTO.MaNhap = nhapSach_BUS.PhatSinhMaNhapSach();
nhapSach_DTO.MaNV = DoAn.frmLOGIN.MaNV;
nhapSach_DTO.NgayNhap = DateTime.Now;
nhapSach_DTO.ThanhTien = int.Parse(numBookAdd_NumberOfBooks.Value.ToString()) *
double.Parse(txtBookAdd_Prices.Text);
nhapSach_DTO.TrangThai = true;
if (dauSach_BUS.ThemDauSach(dauSachDTO) == true)
{
if (sach_BUS.ThemSachMotDongSach(sachDTO) == true)
{
if (nhapSach_BUS.ThemNhapSach(nhapSach_DTO) == true)
{
if (cTNhapSach_BUS.ThemCTNhapSach(cTNhapSach_DTO) == true)
{
frmSuccess frmSuccess = new frmSuccess(1);
frmSuccess.ShowDialog();
this.Hide();
}
}
}
else
{
frmFailed frmFailed = new frmFailed(1);
frmFailed.ShowDialog();
}
}
}
private void btnBorrowReturn_Return_Click(object sender, EventArgs e)
{
TraSach_DTO ts_DTO = new TraSach_DTO
{
MaTra = txtBorrowReturn_ReturnID.Text,
NgayLap = (DateTime)dtpReturnReturn_DateFound.Value,
MaMuon = txtBorrowReturn_BorrowID.Text,
TrangThai = true
};
CTTraSach_DTO ctt_DTO = new CTTraSach_DTO
{
MaTra = txtBorrowReturn_ReturnID.Text,
MaSach = dtgBorrow_Return.Rows[dtgBorrow_Return.SelectedRows[0].Index].Cells[2].Value.ToString(),
NgayTra = DateTime.Now,
SoLuong = int.Parse(txtBorrowReturn_Quantity.Text),
TienThue = 0,
TrangThai = true
};
if (trasach_BUS.ThemTraSach(ts_DTO))
{
if (ctts_BUS.ThemCTTS(ctt_DTO) && sach_BUS.UpLoadSLTra(ctt_DTO.MaSach, ctt_DTO.SoLuong) && ctms_BUS.UpDateTraSach(ts_DTO.MaMuon, ctt_DTO.MaSach))
{
frmSuccess frmSuccess = new frmSuccess(5);
frmSuccess.ShowDialog();
this.Hide();
frmBorrow_Return_Load(sender, e);
}
else
{
frmFailed frmFailed = new frmFailed(5);
frmFailed.ShowDialog();
}
}
else
{
frmFailed frmFailed = new frmFailed(5);
frmFailed.ShowDialog();
}
}
private void btnLibrarian_Remove_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Do you want to remove this Librarian ?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
if (nv_BUS.XoaNhanVien(MaNVien))
{
frmSuccess frmSuccess = new frmSuccess(3);
frmSuccess.ShowDialog();
}
else
{
frmFailed frmFailed = new frmFailed(3);
frmFailed.ShowDialog();
}
frmLibrarian_Load(sender, e);
}
}
private void btnReaderAdd_Add_Click(object sender, EventArgs e)
{
TheThuVien_DTO ttv_DTO = new TheThuVien_DTO
{
SoThe = lblReader_CardNumberID.Text,
NgayBatDau = DateTime.Now,
TrangThai = true
};
DocGia_DTO dg_DTO = new DocGia_DTO
{
MaDocGia = lblReader_ID.Text,
TenDocGia = txtReaderAdd_Name.Text,
CMND = txtReaderAdd_IdentityNumber.Text,
SoThe = lblReader_CardNumberID.Text,
DiaChi = txtReaderAdd_Address.Text,
TrangThai = true
};
if (ttv_BUS.ThemTheThuVien(ttv_DTO))
{
if (dg_BUS.ThemDocGia(dg_DTO))
{
frmSuccess frmSuccess = new frmSuccess(1);
frmSuccess.ShowDialog();
this.Hide();
}
else
{
frmFailed frmFailed = new frmFailed(1);
frmFailed.ShowDialog();
}
}
else
{
frmFailed frmFailed = new frmFailed(1);
frmFailed.ShowDialog();
}
}
private void btnReaderUpdate_Update_Click(object sender, EventArgs e)
{
DocGia_DTO dg_DTO = new DocGia_DTO();
dg_DTO.MaDocGia = DoAn.MANAGER_Buttons.frmReader.MaDG;
dg_DTO.TenDocGia = txtReaderUpdate_Name.Text;
dg_DTO.CMND = txtReaderUpdate_IdentityNumber.Text;
dg_DTO.DiaChi = txtReaderUpdate_Address.Text;
dg_DTO.SoThe = txtReaderUpdate_TagNumber.Text;
if (dg_BUS.UpDateDoGia(dg_DTO))
{
frmSuccess frmSuccess = new frmSuccess(1);
frmSuccess.ShowDialog();
this.Hide();
}
else
{
frmFailed frmFailed = new frmFailed(1);
frmFailed.ShowDialog();
}
}
private void Bill_btnOK_Click(object sender, EventArgs e)
{
MuonSach_DTO muonsach_DTO = new MuonSach_DTO
{
MaMuon = txtBorrowUpdate_ID.Text,
SoThe = txtBorrowUpdate_TagNumber.Text,
MaNV = txtBorrowUpdate_LibrarianID.Text,
NgayMuon = dtpBorrowUpdate_BorrowDate.Value,
NgayPhaiTra = dtpBorrowUpdate_PayDate.Value,
TrangThai = true,
};
//ct muon sach
List <CTMuonSach_DTO> lstCTMuon = new List <CTMuonSach_DTO>();
List <DanhSachMuon_DTO> lstDSMuon = new List <DanhSachMuon_DTO>();
foreach (ListViewItem item in lsvBill.Items)
{
CTMuonSach_DTO CTMuon = new CTMuonSach_DTO
{
MaMuon = txtBorrowUpdate_ID.Text,
MaSach = item.Text,
SoLuong = int.Parse(item.SubItems[2].Text),
TrangThai = true,
GiaSach = 0
};
DanhSachMuon_DTO DSMuon = new DanhSachMuon_DTO
{
MaSach = item.Text,
TenSach = item.SubItems[1].Text,
SoLuong = int.Parse(item.SubItems[2].Text)
};
lstCTMuon.Add(CTMuon);
lstDSMuon.Add(DSMuon);
}
MuonSach_BUS muonSach_BUS = new MuonSach_BUS();
CTMuonSach_BUS cTMuonSach_BUS = new CTMuonSach_BUS();
Sach_BUS sach_BUS = new Sach_BUS();
if (muonSach_BUS.MuonSach(muonsach_DTO))
{
if (cTMuonSach_BUS.ThemCTMuonSach(lstCTMuon) && sach_BUS.UpdateSL(lstDSMuon))
{
frmSuccess frmSuccess = new frmSuccess(4);
frmSuccess.ShowDialog();
this.Hide();
DoAn.MANAGER.Borrow.Add_Update_borrow.frmBorrow_Borrow.dsMuon.Clear();
}
else
{
frmFailed frmFailed = new frmFailed(4);
frmFailed.ShowDialog();
}
}
else
{
frmFailed frmFailed = new frmFailed(4);
frmFailed.ShowDialog();
}
}
