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