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