public bool xoaCTPT(CT_PHIEUTRA ct)
{
CT_PHIEUTRA _ct = qltv.CT_PHIEUTRAs.Where(c => c.MaChiTietPhieuTra == ct.MaChiTietPhieuTra).FirstOrDefault();
if (_ct != null)
{
PHIEUTRA _pt = qltv.PHIEUTRAs.Where(t => t.MaPhieuTra == _ct.MaPhieuTra).FirstOrDefault();
try
{
_pt.SoLuongSachTra = _pt.SoLuongSachTra - 1;
qltv.CT_PHIEUTRAs.DeleteOnSubmit(_ct);
qltv.SubmitChanges();
PHIEUMUON _pm = qltv.PHIEUMUONs.Where(m => m.MaPhieuMuon == _ct.MaPhieuMuon).FirstOrDefault();
if (_pm != null)
{
CT_PHIEUMUON _ctpm = qltv.CT_PHIEUMUONs.Where(t => t.MaVach == _ct.MaVach && t.MaPhieuMuon == _pm.MaPhieuMuon).FirstOrDefault();
_ctpm.TinhTrangTraCT = false;
_pm.TinhTrangTra = false;
qltv.SubmitChanges();
}
return(true);
}
catch (Exception ex) { return(false); }
}
return(false);
}
public bool xoaPhieuTra(PHIEUTRA xpt)
{
PHIEUTRA pt = qltv.PHIEUTRAs.Where(t => t.MaPhieuTra == xpt.MaPhieuTra).FirstOrDefault();
if (pt != null)
{
try {
List <CT_PHIEUTRA> lstCTPT = qltv.CT_PHIEUTRAs.Where(t => t.MaPhieuTra == pt.MaPhieuTra).ToList();
foreach (CT_PHIEUTRA _ctpt in lstCTPT)
{
PHIEUMUON _pm = qltv.PHIEUMUONs.Where(m => m.MaPhieuMuon == _ctpt.MaPhieuMuon).FirstOrDefault();
List <CT_PHIEUMUON> lstCTPM = qltv.CT_PHIEUMUONs.Where(ct => ct.MaPhieuMuon == _pm.MaPhieuMuon && ct.MaVach == _ctpt.MaVach).ToList();
foreach (CT_PHIEUMUON _ctpm in lstCTPM)
{
if (_ctpm.TinhTrangTraCT == true)
{
_ctpm.TinhTrangTraCT = false;
}
}
_pm.TinhTrangTra = false;
qltv.CT_PHIEUTRAs.DeleteOnSubmit(_ctpt);
qltv.SubmitChanges();
}
qltv.PHIEUTRAs.DeleteOnSubmit(pt);
qltv.SubmitChanges();
return(true);
}
catch (Exception ex) {
return(false);
}
}
return(false);
}
public DOCGIA layDGtuPM(DOCGIA dg, ref string tiencoc)
{
DOCGIA dgs = qltv.DOCGIAs.Where(d => d.MaTheThuVien == dg.MaTheThuVien).FirstOrDefault();
PHIEUMUON pms = qltv.PHIEUMUONs.Where(m => m.MaTheThuVien == dg.MaTheThuVien).FirstOrDefault();
dg = dgs;
tiencoc = pms.PhiCoc.ToString();
return(dg);
}
public string layMaTVTheoPM(string mapm)
{
PHIEUMUON pm = qltv.PHIEUMUONs.Where(m => m.MaPhieuMuon == int.Parse(mapm)).FirstOrDefault();
if (pm != null)
{
return(pm.MaTheThuVien);
}
return("");
}
public PHIEUMUON tinhTienCoc(DOCGIA dg, float money)
{
PHIEUMUON d = qltv.PHIEUMUONs.Where(n => n.MaTheThuVien == dg.MaTheThuVien).FirstOrDefault();
if (d != null)
{
d.PhiCoc -= money;
qltv.SubmitChanges();
}
return(d);
}
public int ktraDGTrongPM(DOCGIA dg)
{
PHIEUMUON pms = qltv.PHIEUMUONs.Where(d => d.MaTheThuVien == dg.MaTheThuVien && d.TinhTrangTra == false).FirstOrDefault();
if (pms != null)
{
return(1);
}
else
{
return(-1);
}
}
public bool luuPhieuTra(int mapm, int manv, DateTime ngaytra, int sltra, bool tiencoc, string tiencocdg, List <CT_PHIEUTRA> lstCTPT)
{
PHIEUTRA pt = new PHIEUTRA();
try
{
//pt.MaPhieuMuon = mapm;
pt.MaNhanVien = manv;
pt.NgayLap = ngaytra;
pt.SoLuongSachTra = sltra;
pt.TinhTrangXoa = false;
qltv.PHIEUTRAs.InsertOnSubmit(pt);
qltv.SubmitChanges();
PHIEUTRA mapt = qltv.PHIEUTRAs.Where(n => n.TinhTrangXoa == false).OrderByDescending(x => x.MaPhieuTra).First();
foreach (CT_PHIEUTRA ctpt in lstCTPT)
{
CT_PHIEUTRA _ctpt = new CT_PHIEUTRA();
_ctpt.MaPhieuTra = mapt.MaPhieuTra;
_ctpt.MaPhieuMuon = ctpt.MaPhieuMuon;
_ctpt.MaVach = ctpt.MaVach;
_ctpt.TinhTrangXoa = false;
CT_PHIEUMUON _ctpm = qltv.CT_PHIEUMUONs.Where(m => m.MaPhieuMuon == ctpt.MaPhieuMuon && m.MaVach == ctpt.MaVach).FirstOrDefault();
if (_ctpm.TinhTrangTraCT == false)
{
_ctpm.TinhTrangTraCT = true;
}
if (updateTinhTrangPM(ctpt.MaPhieuMuon.ToString()))
{
if (tiencoc == true)
{
PHIEUMUON _pm = qltv.PHIEUMUONs.Where(m => m.MaPhieuMuon == ctpt.MaPhieuMuon).FirstOrDefault();
_pm.PhiCoc = 0;
tiencocdg = _pm.PhiCoc.ToString();
}
}
qltv.CT_PHIEUTRAs.InsertOnSubmit(_ctpt);
qltv.SubmitChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public DOCGIA layMaDG(DOCGIA dg, string mavach, ref string pmc)
{
DOCGIA dgs = new DOCGIA();
CT_PHIEUMUON ctpm = qltv.CT_PHIEUMUONs.Where(m => m.MaVach == mavach && m.TinhTrangTraCT == false).FirstOrDefault(); //mv
if (ctpm != null)
{
PHIEUMUON pm = qltv.PHIEUMUONs.Where(p => p.MaPhieuMuon == ctpm.MaPhieuMuon && p.TinhTrangTra == false).FirstOrDefault();
if (pm != null)
{
dgs = qltv.DOCGIAs.Where(d => d.MaTheThuVien == pm.MaTheThuVien).FirstOrDefault();
dg = dgs;
pmc = pm.PhiCoc.ToString();
}
}
return(dg);
}
public bool muonTaiLieu(List <TAILIEU> dsTaiLieuMuon, string mathethuvien, string phicoc, string manhanvien)
{
string maphieumuon = "";
PHIEUMUON newPM = new PHIEUMUON();
newPM.MaTheThuVien = mathethuvien;
newPM.NgayLap = DateTime.Now;
DateTime thoihanmuon = DateTime.Now.AddMonths(1);
newPM.ThoiHanMuon = thoihanmuon;
newPM.SoSachMuon = dsTaiLieuMuon.Count();
newPM.TinhTrangTra = false;
newPM.PhiCoc = double.Parse(phicoc);
newPM.MaNhanVien = int.Parse(manhanvien);
newPM.TinhTrangXoa = false;
try
{
db.PHIEUMUONs.InsertOnSubmit(newPM);
db.SubmitChanges();
PHIEUMUON pm = db.PHIEUMUONs.OrderByDescending(a => a.MaPhieuMuon).First();
maphieumuon = pm.MaPhieuMuon.ToString();
}
catch (Exception ex)
{
return(false);
}
foreach (TAILIEU item in dsTaiLieuMuon)
{
CT_PHIEUMUON newCTPM = new CT_PHIEUMUON();
//newCTPM.MaPhieuMuon = newPM.MaPhieuMuon;
newCTPM.MaPhieuMuon = int.Parse(maphieumuon);
newCTPM.MaVach = item.MaVach;
newCTPM.TinhTrangTraCT = false;
newCTPM.TinhTrangXoa = false;
try
{
db.CT_PHIEUMUONs.InsertOnSubmit(newCTPM);
db.SubmitChanges();
}
catch (Exception ex)
{
return(false);
}
}
return(true);
}
public void SuaPM(PHIEUMUON PM)
{
kn.MoKetNoi();
SqlCommand cmd = new SqlCommand("SuaPM", KetNoi.sqlCon); // gọi thủ tục trong csdl lên
cmd.CommandType = CommandType.StoredProcedure; //xác nhận kiểu store
cmd.Parameters.Add(new SqlParameter("@MaPM", PM.MaPM.Trim()));
cmd.Parameters.Add(new SqlParameter("@MaDG", PM.MaDG.Trim()));
cmd.Parameters.Add(new SqlParameter("@HoTenDG", PM.HoTenDG.Trim()));
cmd.Parameters.Add(new SqlParameter("@MaSach", PM.MaSach.Trim()));
cmd.Parameters.Add(new SqlParameter("@NgayMuon", PM.NgayMuon.ToString()));
cmd.Parameters.Add(new SqlParameter("@NgayTra", PM.NgayTra.ToString()));
cmd.Parameters.Add(new SqlParameter("@SoLuong", PM.SoLuong.ToString()));
cmd.Parameters.Add(new SqlParameter("@SLmuon", PM.SlMuon.ToString()));
cmd.Parameters.Add(new SqlParameter("@SLcon", PM.SlCon.ToString()));
cmd.ExecuteNonQuery(); //truy vấn
kn.DongKetNoi(); //đóng kn lại
}
public bool updateTinhTrangPM(string mapm)
{
PHIEUMUON pm = qltv.PHIEUMUONs.Where(m => m.MaPhieuMuon == int.Parse(mapm)).FirstOrDefault();
if (pm != null)
{
List <CT_PHIEUMUON> lstCTPM = qltv.CT_PHIEUMUONs.Where(m => m.MaPhieuMuon == pm.MaPhieuMuon).ToList();
if (lstCTPM == null)
{
return(false);
}
foreach (CT_PHIEUMUON _ct in lstCTPM)
{
if (_ct.TinhTrangTraCT == false)
{
return(false);
}
}
pm.TinhTrangTra = true;
return(true);
}
return(false);
}
public bool suaPhieuMuon(string maphieumuon, bool tinhtrangtra, string phicoc, string ngaymuon, string thoihanmuon)
{
if(string.IsNullOrEmpty(maphieumuon) || string.IsNullOrEmpty(tinhtrangtra.ToString()) || string.IsNullOrEmpty(phicoc) || string.IsNullOrEmpty(ngaymuon) || string.IsNullOrEmpty(thoihanmuon))
{
return false;
}
PHIEUMUON pm = db.PHIEUMUONs.Where(a => a.MaPhieuMuon == int.Parse(maphieumuon)).FirstOrDefault();
var cts = from ct in db.CT_PHIEUMUONs
where ct.MaPhieuMuon == pm.MaPhieuMuon
select ct;
if(pm != null)
{
if(tinhtrangtra)
{
pm.TinhTrangTra = true;
foreach(CT_PHIEUMUON ct in cts)
{
ct.TinhTrangTraCT = true;
}
}
else
{
pm.TinhTrangTra = false;
}
pm.PhiCoc = double.Parse(phicoc);
pm.NgayLap = DateTime.Parse(ngaymuon);
pm.ThoiHanMuon = DateTime.Parse(thoihanmuon);
db.SubmitChanges();
return true;
}
else
{
return false;
}
}
public bool xoaPhieuMuon(string maphieumuon)
{
PHIEUMUON delItem = db.PHIEUMUONs.Where(a => a.MaPhieuMuon == int.Parse(maphieumuon)).FirstOrDefault();
if(delItem != null)
{
delItem.TinhTrangXoa = true;
var cts = from ct in db.CT_PHIEUMUONs
where ct.MaPhieuMuon == int.Parse(maphieumuon)
select ct;
if(cts != null)
{
foreach(CT_PHIEUMUON item in cts)
{
db.CT_PHIEUMUONs.DeleteOnSubmit(item);
}
}
db.SubmitChanges();
return true;
}
else
{
return false;
}
}
public void SuaPM(PHIEUMUON PM)
{
dal.SuaPM(PM);
}
public void ThemPM(PHIEUMUON PM)
{
dal.ThemPM(PM);
}
