public static bool CapNhatKhiSuachitiet(CTPNsach ctpn,long giatam,int soluongtam) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); var Phieunhap = (from p in model.PNsach where p.MaPN.Equals(ctpn.MaPN) select p).FirstOrDefault(); var CTphieunhap = (from p in model.CTPNsach where p.MaPN.Equals(ctpn.MaPN) && p.Masach.Equals(ctpn.Masach) select p).FirstOrDefault(); var _Sach = (from p in model.Sach where p.Masach.Equals(ctpn.Masach) select p).FirstOrDefault(); try { CTphieunhap.Soluong = ctpn.Soluong; CTphieunhap.Gia = ctpn.Gia; Phieunhap.Tongtien = giatam + CTphieunhap.Gia; _Sach.SoLuong = soluongtam + CTphieunhap.Soluong; model.SaveChanges(); return true; } catch { return false; } }
public static bool CapNhatKhiXoachitiet(CTPNsach ctpn) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); var Phieunhap = (from p in model.PNsach where p.MaPN.Equals(ctpn.MaPN) select p).FirstOrDefault(); var CTphieunhap = (from p in model.CTPNsach where p.MaPN.Equals(ctpn.MaPN) && p.Masach.Equals(ctpn.Masach) select p).FirstOrDefault(); var _Sach = (from p in model.Sach where p.Masach.Equals(ctpn.Masach) select p).FirstOrDefault(); try { Phieunhap.Tongtien = Phieunhap.Tongtien - CTphieunhap.Gia; _Sach.SoLuong = _Sach.SoLuong - CTphieunhap.Soluong; model.CTPNsach.Remove(CTphieunhap); model.SaveChanges(); return true; } catch { return false; } }
public static bool CapNhatKhiSuachitiet(CTPNsach ctpn, long giatam, int soluongtam) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); var Phieunhap = (from p in model.PNsach where p.MaPN.Equals(ctpn.MaPN) select p).FirstOrDefault(); var CTphieunhap = (from p in model.CTPNsach where p.MaPN.Equals(ctpn.MaPN) && p.Masach.Equals(ctpn.Masach) select p).FirstOrDefault(); var _Sach = (from p in model.Sach where p.Masach.Equals(ctpn.Masach) select p).FirstOrDefault(); try { CTphieunhap.Soluong = ctpn.Soluong; CTphieunhap.Gia = ctpn.Gia; Phieunhap.Tongtien = giatam + CTphieunhap.Gia; _Sach.SoLuong = soluongtam + CTphieunhap.Soluong; model.SaveChanges(); return(true); } catch { return(false); } }
public static bool CapNhatKhiXoachitiet(CTPNsach ctpn) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); var Phieunhap = (from p in model.PNsach where p.MaPN.Equals(ctpn.MaPN) select p).FirstOrDefault(); var CTphieunhap = (from p in model.CTPNsach where p.MaPN.Equals(ctpn.MaPN) && p.Masach.Equals(ctpn.Masach) select p).FirstOrDefault(); var _Sach = (from p in model.Sach where p.Masach.Equals(ctpn.Masach) select p).FirstOrDefault(); try { Phieunhap.Tongtien = Phieunhap.Tongtien - CTphieunhap.Gia; _Sach.SoLuong = _Sach.SoLuong - CTphieunhap.Soluong; model.CTPNsach.Remove(CTphieunhap); model.SaveChanges(); return(true); } catch { return(false); } }
public static CTPNsach layCTPN(CTPNsach ctpn) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); var CTphieunhap = (from p in model.CTPNsach where p.MaPN.Equals(ctpn.MaPN) && p.Masach.Equals(ctpn.Masach) select p).FirstOrDefault(); return(CTphieunhap); }
public static bool XoaCTPNSach(CTPNsach ctpn) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); var _CTPN = (from p in model.CTPNsach where p.MaPN.Trim().Equals(ctpn.MaPN) where p.Masach.Trim().Equals(ctpn.Masach) select p).FirstOrDefault(); try { model.CTPNsach.Remove(_CTPN); model.SaveChanges(); return(true); } catch { return(false); } }
public static bool ThemCTPNSach(CTPNsach ctpn) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); try { model.CTPNsach.Add(ctpn); model.SaveChanges(); return(true); } catch { return(false); } }
public static CTPNsach layCTPN(CTPNsach ctpn) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); var CTphieunhap = (from p in model.CTPNsach where p.MaPN.Equals(ctpn.MaPN) && p.Masach.Equals(ctpn.Masach) select p).FirstOrDefault(); return CTphieunhap; }
public static bool XoaCTPNSach(CTPNsach ctpn) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); var _CTPN = (from p in model.CTPNsach where p.MaPN.Trim().Equals(ctpn.MaPN) where p.Masach.Trim().Equals(ctpn.Masach) select p).FirstOrDefault(); try { model.CTPNsach.Remove(_CTPN); model.SaveChanges(); return true; } catch { return false; } }
public static bool ThemCTPNSach(CTPNsach ctpn) { DBQLPhatHanhSachEntities model = new DBQLPhatHanhSachEntities(); try { model.CTPNsach.Add(ctpn); model.SaveChanges(); return true; } catch { return false; } }