private void btLuu_Click(object sender, EventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
bool tmt = false;
var ListMaTG = from kq in qltv.TacGias select kq.MaTacGia;
foreach (var item in ListMaTG)
{
if (cbbMaTG.Text == item)
{
tmt = true;
}
}
if (tmt == true)
{
try
{
qltv.Database.ExecuteSqlCommand($"exec ThemSangTac '{QuanLyDauSach.MaDS}','{cbbMaTG.Text}',{txbViTriVaiTro.Text}");
MessageBox.Show("Them thanh cong tac gia");
Load_TacGia();
TrangThaiBanDau();
}
catch (Exception) { MessageBox.Show("Tac gia nay da ton tai"); }
}
else
{
qltv.Database.ExecuteSqlCommand($"exec ThemTacGia '{cbbMaTG.Text}',N'{txbTenTG.Text}','{dTP_NgaySinhTG.Text}'");
qltv.Database.ExecuteSqlCommand($"exec ThemSangTac '{QuanLyDauSach.MaDS}','{cbbMaTG.Text}',{txbViTriVaiTro.Text}");
MessageBox.Show("Them thanh cong tac gia");
Load_TacGia();
TrangThaiBanDau();
}
}
}
public void load_MuonTra()
{
Model_QuanLi_ThuVien MtV1 = new Model_QuanLi_ThuVien();
var lstMuonTra = MtV1.ThongTinMuons.SqlQuery("select * from ThongTinMuon").ToList();
dtgrdView_Muon.DataSource = lstMuonTra;
}
private void dtgv_loadDG_CellClick(object sender, DataGridViewCellEventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
TrangThaiBanDau();
int i = e.RowIndex;
txbMaDG.Text = dtgv_loadDG.Rows[i].Cells[0].Value.ToString();
txbTenDG.Text = dtgv_loadDG.Rows[i].Cells[1].Value.ToString();
dtpNgaySinhDG.Text = dtgv_loadDG.Rows[i].Cells[2].Value.ToString();
txbDonViDG.Text = dtgv_loadDG.Rows[i].Cells[3].Value.ToString();
txbSdtDG.Text = dtgv_loadDG.Rows[i].Cells[4].Value.ToString();
dtpNgayDK.Text = dtgv_loadDG.Rows[i].Cells[5].Value.ToString();
dtpNgayHH.Text = dtgv_loadDG.Rows[i].Cells[6].Value.ToString();
TaiKhoanDG TK = qltv.TaiKhoanDGs.Where(p => p.MaDocGia == txbMaDG.Text).FirstOrDefault();
txbTaiKhoanDG.Text = TK.TenDangNhap;
txbMatKhauDG.Text = TK.MatKhau;
if (dtgv_loadDG.Rows[i].Cells[7].Value == null)
{
txbLoaiDG.Text = "NULL";
}
else
{
txbLoaiDG.Text = dtgv_loadDG.Rows[i].Cells[7].Value.ToString();
}
}
}
private void giaHanSach()
{
if (Hieusongay(dtpNgayMuon.Text, dtpNgayTra.Text) > 0)
{ //---- tiến hành up date ngày tháng luôn
Model_QuanLi_ThuVien MtV2 = new Model_QuanLi_ThuVien();
SqlParameter[] idParam =
{ new SqlParameter {
ParameterName = "NgayMuon", Value = dtpNgayMuon.Text
},
new SqlParameter {
ParameterName = "NgayHanTra", Value = dtpNgayTra.Text
},
new SqlParameter {
ParameterName = "MaMuonTra", Value = MaMT
} };
int i = MtV2.Database.ExecuteSqlCommand("exec GiaHan @NgayMuon,@NgayHanTra,@MaMuonTra", idParam);
if (i < 0)
{
MessageBox.Show("Xảy ra lỗi , thông tin mượn trả không có trong hệ thống.", "Thông Báo");
}
else
{
MessageBox.Show("Gia hạn thành công.", "Thông Báo");
this.Close();
}
}
else
{
MessageBox.Show("Xem lại thời gian cho mượn.", "Thông Báo");
}
}
public ReportViPham(string lydo, int sotien, string MaDG)
{
InitializeComponent();
// đặt chế độ hiển thị ở Local
reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local;
reportViewer1.LocalReport.ReportEmbeddedResource = "Quan_Ly_Thu_Vien.XuLyViPham.rdlc";
// chế độ xem report
reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout);
reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent;
reportViewer1.ZoomPercent = 100;
//// import dữ liệu tên độc giả và đơn vị
Model_QuanLi_ThuVien MtV1 = new Model_QuanLi_ThuVien();
SqlParameter idParam = new SqlParameter {
ParameterName = "MaDocGia", Value = MaDG
};
var lstMuonTra = MtV1.ThongTinDocGias.SqlQuery("ThongTinCaNhan @MaDocGia", idParam).ToList();
/// fill data vào trong báo cáo
Microsoft.Reporting.WinForms.ReportParameter[] rParrams = new Microsoft.Reporting.WinForms.ReportParameter[]
{ new Microsoft.Reporting.WinForms.ReportParameter("HoTen", lstMuonTra[0].TenDocGia.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("DonVi", lstMuonTra[0].DonVi.ToString()),
new Microsoft.Reporting.WinForms.ReportParameter("LyDo", lydo),
new Microsoft.Reporting.WinForms.ReportParameter("SoTien", sotien.ToString()) };
reportViewer1.LocalReport.SetParameters(rParrams);
reportViewer1.RefreshReport();
}
void Load_ThongKeDG()
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
int SoLuongDG_DangMuon = 0;
var listDG = qltv.DocGias.ToList();
txbSoLuongDG.Text = listDG.Count.ToString();
var listMuonTra = from kq in qltv.MuonTras where kq.DaTra == false select kq.MaDocGia;
//var listMuonTraQuaHan = from kq in qltv.MuonTras where kq.DaTra == false && kq. select kq.MaDocGia;
foreach (var itemlistDG in listDG)
{
foreach (var itemlistMuonTra in listMuonTra)
{
if (itemlistDG.MaDocGia == itemlistMuonTra)
{
SoLuongDG_DangMuon++;
break;
}
}
}
txbSoLuongDG_DangMuon.Text = SoLuongDG_DangMuon.ToString();
var listViPham = from kq in qltv.XuLyViPhams select kq.MaDocGia;
txbSoLuotViPham.Text = listViPham.ToList().Count.ToString();
}
}
private void txtNDTimKiem_TextChanged(object sender, EventArgs e)
{
setControlsMuon(false);
btnNhap.Enabled = false;
btnChoMuon0.Enabled = false;
btnHuy0.Enabled = false;
if (radMaDG.Checked)
{
SqlParameter idParam = new SqlParameter {
ParameterName = "NoiDung", Value = txtNDTimKiem.Text
};
Model_QuanLi_ThuVien MtV1 = new Model_QuanLi_ThuVien();
var lstTimkiemDocGia = MtV1.ThongTinMuonTras.SqlQuery("TimKiemMaDG @NoiDung", idParam).ToList();
dtgrdView_Muon.DataSource = lstTimkiemDocGia;
dtgrdView_Muon.AutoGenerateColumns = false;
}
else if (radMaSach.Checked)
{
SqlParameter idParam = new SqlParameter {
ParameterName = "NoiDung", Value = txtNDTimKiem.Text
};
Model_QuanLi_ThuVien MtV1 = new Model_QuanLi_ThuVien();
var lstTimkiemSach = MtV1.ThongTinMuonTras.SqlQuery("TimKiemMaSach @NoiDung", idParam).ToList();
dtgrdView_Muon.DataSource = lstTimkiemSach;
dtgrdView_Muon.AutoGenerateColumns = false;
}
}
private void cbbMaVT_TextChanged(object sender, EventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
bool tmt = false;
var listMaVT = from kq in qltv.ViTriSaches select kq.MaViTri;
foreach (var item in listMaVT)
{
if (cbbMaVT.Text == item)
{
tmt = true;
}
}
if (tmt == true)
{
ViTriSach VTS = qltv.ViTriSaches.Where(p => p.MaViTri == cbbMaVT.Text).SingleOrDefault();
txbTenGiaSach.Text = VTS.TenGiaSach;
txbTang.Text = VTS.Tang;
txbNgan.Text = VTS.Ngan;
txbTenGiaSach.Enabled = false;
txbTang.Enabled = false;
txbNgan.Enabled = false;
}
else
{
txbTenGiaSach.Text = "";
txbTang.Text = "";
txbNgan.Text = "";
txbTenGiaSach.Enabled = true;
txbTang.Enabled = true;
txbNgan.Enabled = true;
}
}
}
private void btnChoMuon0_Click(object sender, EventArgs e)
{
{
Model_QuanLi_ThuVien MtV2 = new Model_QuanLi_ThuVien();
SqlParameter[] idParam =
{ new SqlParameter {
ParameterName = "MaSach", Value = txbMaCuonSach.Text
},
new SqlParameter {
ParameterName = "MaDocGia", Value = txbMaDG.Text
},
new SqlParameter {
ParameterName = "MaNVMuon", Value = Login.MaNguoiDung
},
new SqlParameter {
ParameterName = "NgayMuon", Value = dtpNgayMuon.Text
},
new SqlParameter {
ParameterName = "NgayHanTra", Value = dtpNgayTra.Text
}, };
// int Check_Sach = MtV2.Database.ExecuteSqlCommand("MuonMoiSach @MaSach,@MaDocGia,@MaNVMuon,@NgayMuon,@NgayHanTra", idParam);
int Check_Sach = MtV2.Database.ExecuteSqlCommand("MuonMoiSach @MaSach,@MaDocGia,@MaNVMuon,@NgayMuon,@NgayHanTra", idParam);
if (Check_Sach >= 0)
{
MessageBox.Show("cho mượn sách thành công ");
load_TTmuon();
}
btnChoMuon0.Enabled = false;
}
}
private void btLuu_Click(object sender, EventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
bool tmt = false;
var ListMaTL = from kq in qltv.TheLoais select kq.MaTheLoai;
foreach (var item in ListMaTL)
{
if (cbbMaTheLoai.Text == item)
{
tmt = true;
}
}
if (tmt == true)
{
try
{
qltv.Database.ExecuteSqlCommand($"exec ThemTheLoaiDauSach '{QuanLyDauSach_NV.MaDS}','{cbbMaTheLoai.Text}',{txbViTriVaiTro.Text}");
MessageBox.Show("Them thanh cong The Loai");
Load_TheLoai();
TrangThaiBanDau();
}
catch (Exception) { MessageBox.Show("The loai da ton tai!"); }
}
else
{
qltv.Database.ExecuteSqlCommand($"exec ThemTheLoai '{cbbMaTheLoai.Text}',N'{txbTenTheLoai.Text}'");
qltv.Database.ExecuteSqlCommand($"exec ThemTheLoaiDauSach '{QuanLyDauSach_NV.MaDS}','{cbbMaTheLoai.Text}',{txbViTriVaiTro.Text}");
MessageBox.Show("Them thanh cong The Loai");
Load_TheLoai();
TrangThaiBanDau();
}
}
}
private void cbbMaTG_TextChanged(object sender, EventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
bool tmt = false;
var ListMaTG = from kq in qltv.TacGias select kq.MaTacGia;
foreach (var item in ListMaTG)
{
if (cbbMaTG.Text == item)
{
tmt = true;
}
}
if (tmt == true)
{
TacGia TG = qltv.TacGias.Where(p => p.MaTacGia == cbbMaTG.Text).SingleOrDefault();
var ViTri = from kq in qltv.SangTacs where kq.MaDauSach == QuanLyDauSach.MaDS && kq.MaTacGia == cbbMaTG.Text select kq.ViTriVaiTro;
txbTenTG.Text = TG.TenTacGia;
dTP_NgaySinhTG.Text = TG.NgaySinh.ToString();
txbViTriVaiTro.Text = "";
dTP_NgaySinhTG.Enabled = false;
txbTenTG.Enabled = false;
}
else
{
txbTenTG.Enabled = true;
dTP_NgaySinhTG.Enabled = true;
txbTenTG.Text = "";
txbViTriVaiTro.Text = "";
dTP_NgaySinhTG.Value = DateTime.Now;
}
}
}
private void cbbMaTheLoai_TextChanged(object sender, EventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
var listMaTheLoai = from kq in qltv.TheLoais select kq.MaTheLoai;
bool tmt = false;
foreach (var item in listMaTheLoai)
{
if (cbbMaTheLoai.Text == item)
{
tmt = true;
}
}
if (tmt == true)
{
TheLoai TL = qltv.TheLoais.Where(p => p.MaTheLoai == cbbMaTheLoai.Text).SingleOrDefault();
txbTenTheLoai.Enabled = false;
txbTenTheLoai.Text = TL.TenTheLoai;
txbViTriVaiTro.Text = "";
}
else
{
txbTenTheLoai.Enabled = true;
txbTenTheLoai.Text = "";
txbViTriVaiTro.Text = "";
}
}
}
void Load_ChucVu()
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
var TenCV = from kq in qltv.ChucVus select kq.TenChucVu;
cbbChucVu.DataSource = TenCV.ToList();
}
}
void Load_DauSach()
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
var ListDS = qltv.ThongTinDauSaches.SqlQuery("exec LoadThongTinDauSach");
dtGV_DauSach.DataSource = ListDS.ToList();
}
}
void Load_DSMuon()
{
Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien();
var lstMuonTra = qltv.ThongTinMuons.SqlQuery("select * from ThongTinMuon").ToList();
dtgrdView_Tra.DataSource = lstMuonTra;
txtNDTimKiem.Text = "";
}
public void Load_DG()
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
var listDG = qltv.Database.SqlQuery <ThongTinDocGia>($"exec LoadThongTinDocGia");
dtgv_loadDG.DataSource = listDG.ToList();
}
}
private void cbbChucVu_MouseClick(object sender, MouseEventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
var listChucVu = from kq in qltv.ChucVus select kq.TenChucVu;
cbbChucVu.DataSource = listChucVu.ToList();
}
}
void Load_MaTheLoai()
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
var listMaTheLoai = from kq in qltv.TheLoais select kq.MaTheLoai;
cbbMaTheLoai.DataSource = listMaTheLoai.ToList();
}
}
void Load_ThongKeDS()
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
var ThongKe = qltv.Database.SqlQuery <ThongKeDauSach>("exec show_ThongKeDauSach ");
dtgv_ThongKeDS.DataSource = ThongKe.ToList();
}
}
void Load_MaTG()
{
using (var qltv = new Model_QuanLi_ThuVien())
{
var ListMaTG = from kq in qltv.TacGias select kq.MaTacGia;
cbbMaTG.DataSource = ListMaTG.ToList();
}
}
private void txbTimKiemCS_TextChanged(object sender, EventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
var ListCS = qltv.Database.SqlQuery <TT_CuonSach>($"exec TimKiemCuonSach @MaDauSach='{QuanLyDauSach_NV.MaDS}', @MaSach='{txbTimKiemCS.Text}'");
dtGV_CuonSach.DataSource = ListCS.ToList();
}
}
void Load_MaViTri()
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
var listMaVT = from kq in qltv.ViTriSaches select kq.MaViTri;
cbbMaVT.DataSource = listMaVT.ToList();
}
}
void Load_CuonSach()
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
var ListCS = qltv.Database.SqlQuery <TT_CuonSach>($"exec LoadThongTinCuonSach @MaDauSach='{QuanLyDauSach_NV.MaDS}'");
dtGV_CuonSach.DataSource = ListCS.ToList();
}
}
private void btXoa_Click(object sender, EventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
qltv.Database.ExecuteSqlCommand($"exec XoaTheLoai '{QuanLyDauSach_NV.MaDS}','{cbbMaTheLoai.Text}'");
MessageBox.Show("Xoa thanh cong the loai");
Load_TheLoai();
}
}
private void btXoa_Click(object sender, EventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
qltv.Database.ExecuteSqlCommand($"exec XoaSangTac '{QuanLyDauSach.MaDS}','{cbbMaTG.Text}'");
MessageBox.Show("Xoa thanh cong tac gia");
Load_TacGia();
}
}
void Load_SachDangMuon()
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
SqlParameter param = new SqlParameter {
ParameterName = "MaDocGia", Value = Login.MaNguoiDung
};
var listCuonSachDangMuon = qltv.Database.SqlQuery <TT_MuonSach_DocGia>($"exec Show_SoSachDocGiaDangMuon @MaDocGia", param);
dtGV_SachChoMuon.DataSource = listCuonSachDangMuon.ToList();
}
}
private void btLuu_Click(object sender, EventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
ChucVu cv = qltv.ChucVus.Where(p => p.TenChucVu == cbbChucVu.Text).FirstOrDefault();
qltv.Database.ExecuteSqlCommand($"exec SuaNhanVien '{txbMaNV.Text}',N'{txbTenNV.Text}','{dTP_NgaySinhNV.Text}','{txbSDTNV.Text}','{cv.MaChucVu}'");
MessageBox.Show("Thay đổi thành công !!!");
btHuy.Visible = false;
btLuu.Visible = false;
}
}
void Load_TacGia()
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
btLuu.Enabled = false;
btThem.Enabled = true;
btXoa.Enabled = true;
var listTg = qltv.Database.SqlQuery <TT_TacGia_DauSach>($"exec LoadThongTinTacGia_CuaDauSach '{QuanLyDauSach.MaDS}'");
dtGV_TacGia.DataSource = listTg.ToList();
}
}
void Load_NvChoMuon(string MaNV)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
txbMaNV_Muon.Text = MaNV;
NhanVien NV = qltv.NhanViens.Where(p => p.MaNhanVien == MaNV).FirstOrDefault();
ChucVu CV = qltv.ChucVus.Where(p => p.MaChucVu == NV.MaChucVu).FirstOrDefault();
txbTenNV_Muon.Text = NV.HoTen;
txbSDTNV_Muon.Text = NV.SDT;
txbChucVuNV_Muon.Text = CV.TenChucVu;
}
}
void Load_CsDangMuon(string MaCS)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
txbMaSach.Text = MaCS;
CuonSach CS = qltv.CuonSaches.Where(p => p.MaSach == MaCS).FirstOrDefault();
DauSach DS = qltv.DauSaches.Where(p => p.MaDauSach == CS.MaDauSach).FirstOrDefault();
txbTenSach.Text = DS.TenDauSach;
txbGiaTien.Text = DS.GiaTien.ToString();
ptbAnhCS.Image = ByteToImage((byte[])DS.HinhAnh);
}
}
