private void dtGV_CuonSach_CellClick(object sender, DataGridViewCellEventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
int i = e.RowIndex;
TrangThaiBanDau();
txbMaCS.Text = dtGV_CuonSach.Rows[i].Cells[0].Value.ToString();
txbTenCS.Text = dtGV_CuonSach.Rows[i].Cells[1].Value.ToString();
txbTinhTrangCS.Text = dtGV_CuonSach.Rows[i].Cells[2].Value.ToString();
ThongTinCuonSach TTCS = qltv.ThongTinCuonSaches.Where(p => p.MaSach == txbMaCS.Text).SingleOrDefault();
txbTenGiaSach.Text = TTCS.TenGiaSach;
txbTang.Text = TTCS.Tang;
txbNgan.Text = TTCS.Ngan;
}
}
private void btSuaCS_Click(object sender, EventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
Load_MaViTri();
ThongTinCuonSach TTCS = qltv.ThongTinCuonSaches.Where(p => p.MaSach == txbMaCS.Text).SingleOrDefault();
CuonSach CS = qltv.CuonSaches.Where(p => p.MaSach == txbMaCS.Text).SingleOrDefault();
cbbMaVT.Text = CS.MaViTri;
txbTenGiaSach.Text = TTCS.TenGiaSach;
txbTang.Text = TTCS.Tang;
txbNgan.Text = TTCS.Ngan;
ThemOrSua = false;
TrangThaiThemOrSua();
cbbMaVT.Visible = true;
lbMaVT.Visible = true;
}
}
private void btKiemTra_Click(object sender, EventArgs e)
{
using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien())
{
if (txbMaDG.Text == "")
{
MessageBox.Show("Bạn đã nhập thiếu thông tin độc giả");
}
else if (txbMaCuonSach.Text == "")
{
MessageBox.Show("Bạn đã nhập thiếu thông tin cuốn sách");
}
else
{ //////////////////////////
try
{ /// thông tin cuốn sach
ThongTinCuonSach TTCS = qltv.ThongTinCuonSaches.Where(p => p.MaSach == txbMaCuonSach.Text).SingleOrDefault();
////////////////thông tin độc giả
var listSoLuotViPham = from kq in qltv.XuLyViPhams where kq.MaDocGia == txbMaDG.Text select kq.LyDo;
ThongTinDocGia TTDG = qltv.ThongTinDocGias.Where(p => p.MaDocGia == txbMaDG.Text).SingleOrDefault();
//////////////////////////////////
if (TTCS == null || TTDG == null)
{
MessageBox.Show("Yêu cầu bạn nhập đúng thông tin mã độc giả và mã cuốn sách");
}
else
{
txtTenDG.Text = TTDG.TenDocGia.ToString();
txtTenCuonSach.Text = TTCS.TenDauSach.ToString();
cboTinhTrang.Text = TTCS.TinhTrang.ToString();
load_TTmuon();
muonsach();
}
}
catch (Exception)
{
MessageBox.Show("");
}
}
}
}
private void load_TTmuon()
{
Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien();
SqlParameter idParam = new SqlParameter {
ParameterName = "NoiDung", Value = txbMaDG.Text
};
//var lstSoSachMuon = qltv.ThongTinMuons.SqlQuery("TimKiemMaDG @NoiDung", idParam).ToList();
var lstSoSachMuon = from kq in qltv.ThongTinMuons where kq.MaDocGia == txbMaDG.Text select kq.MaSach;
txtSachMuon.Text = lstSoSachMuon.ToList().Count.ToString();
var listSoLuotViPham = from kq in qltv.XuLyViPhams where kq.MaDocGia == txbMaDG.Text select kq.LyDo;
txtViPham.Text = listSoLuotViPham.ToList().Count.ToString();
var lstMuonTra = qltv.ThongTinMuons.SqlQuery("select * from ThongTinMuon where MaDocGia = @NoiDung ", idParam).ToList();
dtgrdView_Muon.DataSource = lstMuonTra;
ThongTinCuonSach TTCS = qltv.ThongTinCuonSaches.Where(p => p.MaSach == txbMaCuonSach.Text).SingleOrDefault();
txtTenCuonSach.Text = TTCS.TenDauSach.ToString();
cboTinhTrang.Text = TTCS.TinhTrang.ToString();
}
