public static bool ThemPhieuNhap(PNsach pnsach) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); try { model.PNsach.Add(pnsach); model.SaveChanges(); return(true); } catch { return(false); } }
public static bool SuaPhieuNhap(PNsach pnsach) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); var _pnsach = (from p in model.PNsach where p.MaPN.Trim().Equals(pnsach.MaPN.Trim()) select p).FirstOrDefault(); if (_pnsach == null) return false; else { _pnsach.MaNXB = pnsach.MaNXB; _pnsach.Ngaynhap = pnsach.Ngaynhap; _pnsach.Nguoigiao = pnsach.Nguoigiao; _pnsach.TinhTrang = pnsach.TinhTrang; model.SaveChanges(); return true; } }
public static bool SuaPhieuNhap(PNsach pnsach) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); var _pnsach = (from p in model.PNsach where p.MaPN.Trim().Equals(pnsach.MaPN.Trim()) select p).FirstOrDefault(); if (_pnsach == null) { return(false); } else { _pnsach.MaNXB = pnsach.MaNXB; _pnsach.Ngaynhap = pnsach.Ngaynhap; _pnsach.Nguoigiao = pnsach.Nguoigiao; _pnsach.TinhTrang = pnsach.TinhTrang; model.SaveChanges(); return(true); } }
public static bool XoaPhieuNhap(PNsach pnsach) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); var _pnsach = (from p in model.PNsach where p.MaPN.Trim().Equals(pnsach.MaPN) select p).FirstOrDefault(); var _ctpn = from p in model.CTPNsach where p.MaPN.Trim().Equals(pnsach.MaPN) select p; try { foreach (var row in _ctpn) { model.CTPNsach.Remove(row); } model.PNsach.Remove(_pnsach); model.SaveChanges(); return(true); } catch { return(false); } }
public BUSNhapsach(PNsach phieunhap) { this.phieunhap = phieunhap; }
public static bool XoaPhieuNhap(PNsach pnsach) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); var _pnsach = (from p in model.PNsach where p.MaPN.Trim().Equals(pnsach.MaPN) select p).FirstOrDefault(); var _ctpn = from p in model.CTPNsach where p.MaPN.Trim().Equals(pnsach.MaPN) select p; try { foreach(var row in _ctpn) { model.CTPNsach.Remove(row); } model.PNsach.Remove(_pnsach); model.SaveChanges(); return true; } catch { return false; } }
public static bool ThemPhieuNhap(PNsach pnsach) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); try { model.PNsach.Add(pnsach); model.SaveChanges(); return true; } catch { return false; } }