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); }