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 layTTtra(int mactpm)
{
CT_PHIEUMUON _ct = qltv.CT_PHIEUMUONs.Where(t => t.MaChiTietPhieuMuon == mactpm && t.TinhTrangTraCT == true).FirstOrDefault();
if (_ct != null)
{
return(true);
}
return(false);
}
public bool suaCT_PhieuMuon(string mact, bool tinhtrangtra)
{
CT_PHIEUMUON ct = db.CT_PHIEUMUONs.Where(a => a.MaChiTietPhieuMuon == int.Parse(mact)).FirstOrDefault();
if(ct != null)
{
ct.TinhTrangTraCT = tinhtrangtra;
db.SubmitChanges();
return true;
}
return false;
}
public bool xoaCT_PhieuMuon(string mact)
{
CT_PHIEUMUON ct = db.CT_PHIEUMUONs.Where(a => a.MaChiTietPhieuMuon == int.Parse(mact)).FirstOrDefault();
if(ct != null)
{
ct.TinhTrangXoa = true;
db.SubmitChanges();
return true;
}
else
{
return false;
}
}
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);
}