public void addPhieuNhapCT(PhieuNhapCT s) { PBL3 db = new PBL3(); db.PhieuNhapCT.Add(s); db.SaveChanges(); }
public void AddSach(Sach s) { PBL3 db = new PBL3(); db.Sach.Add(s); db.SaveChanges(); }
public HoaDonCT getHDCTByMHDCT(int x) { PBL3 db = new PBL3(); HoaDonCT s = db.HoaDonCT.Find(x); return(s); }
public Login GetLoginByID(int id) { PBL3 db = new PBL3(); Login l = db.Login.Find(id); return(l); }
public List <PhieuNhapCT> GetPNCTByDate(DateTime t1, DateTime t2) { PBL3 db = new PBL3(); var l = from p in db.PhieuNhapCT where p.PhieuNhap.Ngay >= t1 where p.PhieuNhap.Ngay <= t2 select p; return(l.ToList()); }
public KhuyenMai GetKMByKMCT(KhuyenMaiCT k) { PBL3 db = new PBL3(); KhuyenMai km = db.KhuyenMai.Find(k.MaKM); return(km); }
public void AddMH(MatHang m) { PBL3 db = new PBL3(); db.MatHang.Add(m); db.SaveChanges(); }
public Sach GetSachByMS(int x) { PBL3 db = new PBL3(); Sach s = db.Sach.Find(x); return(s); }
public HoaDon GetHDByMaHD(int x) { PBL3 db = new PBL3(); HoaDon hd = db.HoaDon.Find(x); return(hd); }
public void AddHD(HoaDon hd) { PBL3 db = new PBL3(); db.HoaDon.Add(hd); db.SaveChanges(); }
public void ExecuteDB(KhuyenMaiCT s) { PBL3 db = new PBL3(); bool check = false; foreach (KhuyenMaiCT i in db.KhuyenMaiCT) { if (i.MaKMCT == s.MaKMCT) { check = true; } } if (check) { // EditDB(s); KhuyenMaiCT edit = db.KhuyenMaiCT.Find(s.MaKMCT); edit.MaSach = s.MaSach; edit.DonGiaKM = s.DonGiaKM; edit.MaKM = s.MaKM; db.SaveChanges(); } else { //AddDB(s); { db.KhuyenMaiCT.Add(s); db.SaveChanges(); } } }
public void AddNSX(NhaSX n) { PBL3 db = new PBL3(); db.NhaSX.Add(n); db.SaveChanges(); }
public List <int> GetListMaSachByDate(DateTime t1, DateTime t2, int x) { PBL3 db = new PBL3(); if (x == 1) { //var l = from p in db.HoaDonCT where p.HoaDon.Ngay >= t1 where p.HoaDon.Ngay <= t2 select new { p.MaSach }; List <HoaDonCT> l = new List <HoaDonCT>(); l = db.HoaDonCT.Where(p => p.HoaDon.Ngay >= t1).Where(p => p.HoaDon.Ngay <= t2).Select(p => p).ToList(); List <int> l1 = new List <int>(); //List<int> l2 = new List<int>(); foreach (HoaDonCT i in l) { l1.Add(i.MaSach); } var l2 = l1.Distinct(); return(l2.ToList()); } else { List <PhieuNhapCT> l = new List <PhieuNhapCT>(); l = db.PhieuNhapCT.Where(p => p.PhieuNhap.Ngay >= t1).Where(p => p.PhieuNhap.Ngay <= t2).Select(p => p).ToList(); List <int> l1 = new List <int>(); //List<int> l2 = new List<int>(); foreach (PhieuNhapCT i in l) { l1.Add(i.MaSach); } var l2 = l1.Distinct(); return(l2.ToList()); } }
public List <HoaDonCT> GetHDCTByDate(DateTime t1, DateTime t2) { PBL3 db = new PBL3(); var l = from p in db.HoaDonCT where p.HoaDon.Ngay >= t1 where p.HoaDon.Ngay <= t2 select p; return(l.ToList()); }
public void AddLogin(Login l) { PBL3 db = new PBL3(); db.Login.Add(l); db.SaveChanges(); }
public List <SachKM> GetKhuyenMaiCTByMaKM(int MaKM, int MaSach) { PBL3 db = new PBL3(); if (MaKM == 0 && MaSach == 0) { var l = from p in db.KhuyenMaiCT select new SachKM { MaKMCT = p.MaKMCT, TenSach = p.Sach.TenSach, DonGiaKM = p.DonGiaKM, TenKM = p.KhuyenMai.TenKM }; return(l.ToList()); } else if (MaKM == 0 && MaSach != 0) { var l = from p in db.KhuyenMaiCT where p.MaSach == MaSach select new SachKM { MaKMCT = p.MaKMCT, TenSach = p.Sach.TenSach, DonGiaKM = p.DonGiaKM, TenKM = p.KhuyenMai.TenKM }; return(l.ToList()); } else if (MaKM != 0 && MaSach == 0) { var l = from p in db.KhuyenMaiCT where p.MaKM == MaKM select new SachKM { MaKMCT = p.MaKMCT, TenSach = p.Sach.TenSach, DonGiaKM = p.DonGiaKM, TenKM = p.KhuyenMai.TenKM }; return(l.ToList()); } else { var l = from p in db.KhuyenMaiCT where p.MaSach == MaSach where p.MaKM == MaKM select new SachKM { MaKMCT = p.MaKMCT, TenSach = p.Sach.TenSach, DonGiaKM = p.DonGiaKM, TenKM = p.KhuyenMai.TenKM }; return(l.ToList()); } }
public void AddHDCT(HoaDonCT hdct) { PBL3 db = new PBL3(); db.HoaDonCT.Add(hdct); db.SaveChanges(); }
public List <KhuyenMaiCT> GetListKhuyenMaiCTVyByMaKM(int MaKM) { PBL3 db = new PBL3(); // List<KhuyenMaiCT> data = new List<KhuyenMaiCT>(); return(db.KhuyenMaiCT.Where(p => p.MaKMCT == MaKM).ToList()); }
public void DeleteLogin(int id) { PBL3 db = new PBL3(); Login l = db.Login.Find(id); db.Login.Remove(l); db.SaveChanges(); }
public void UpSLT(int x, int sl) { PBL3 db = new PBL3(); Sach s = db.Sach.Find(x); s.SoLuongTon += sl; db.SaveChanges(); }
public void DeletePNCT(int MaPNCT) { PBL3 db = new PBL3(); PhieuNhapCT delS = db.PhieuNhapCT.Find(MaPNCT); // tim theo thuoc tinh khoa chinh db.PhieuNhapCT.Remove(delS); db.SaveChanges(); }
public void DeleteKMCT(int MaKMCT) { PBL3 db = new PBL3(); KhuyenMaiCT delS = db.KhuyenMaiCT.Find(MaKMCT); // tim theo thuoc tinh khoa chinh db.KhuyenMaiCT.Remove(delS); db.SaveChanges(); }
public void DeleteKM(int makm) { PBL3 db = new PBL3(); KhuyenMai k = db.KhuyenMai.Find(makm); db.KhuyenMai.Remove(k); db.SaveChanges(); }
public void DeleteSach(int MaSach) { PBL3 db = new PBL3(); Sach s = db.Sach.Find(MaSach); db.Sach.Remove(s); db.SaveChanges(); }
public void DeleteHDCT(int x) { PBL3 db = new PBL3(); HoaDonCT s = db.HoaDonCT.Find(x); db.HoaDonCT.Remove(s); db.SaveChanges(); }
public void UpdateSoLuongSachGiam(int soluong, int MaSach) { PBL3 db = new PBL3(); Sach edit = db.Sach.Find(MaSach); edit.SoLuongTon -= soluong; db.SaveChanges(); }
public List <SachPN> GetSachPNByMaPN(int x) { PBL3 db = new PBL3(); var l = from p in db.PhieuNhapCT where p.MaPN == x select new SachPN { MaPNCT = p.MaPNCT, TenSach = p.Sach.TenSach, SoLuong = p.SoLuong, GiaNhap = p.GiaNhap }; return(l.ToList()); }
public List <SachHDCT> GetSachByMaHD(int x) { PBL3 db = new PBL3(); var l = from p in db.HoaDonCT where p.MaHD == x select new SachHDCT { MaHDCT = p.MaHDCT, TenSach = p.Sach.TenSach, SoLuong = p.SoLuong, DonGia = p.DonGia, GiaKM = p.GiaKM }; return(l.ToList()); }
public List <SachKM> GetKhuyenMaiCT() { PBL3 db = new PBL3(); var l = from p in db.KhuyenMaiCT select new SachKM { MaKMCT = p.MaKMCT, TenSach = p.Sach.TenSach, DonGiaKM = p.DonGiaKM, TenKM = p.KhuyenMai.TenKM }; return(l.ToList()); }
public List <SachPN> GetSachPNByDate(DateTime t1, DateTime t2) { PBL3 db = new PBL3(); var l = from p in db.PhieuNhapCT where p.PhieuNhap.Ngay >= t1 where p.PhieuNhap.Ngay <= t2 select new SachPN { MaPNCT = p.MaPNCT, TenSach = p.Sach.TenSach, SoLuong = p.SoLuong, GiaNhap = p.GiaNhap }; return(l.ToList()); }