public List <DanhMuc> LayToanBoDanhMuc()
{
CSDLTestDataContext context = new CSDLTestDataContext();
List <DanhMuc> dsDM = context.DanhMucs.ToList();
foreach (DanhMuc dm in dsDM)
{
dm.SanPhams.Clear();
}
return(dsDM);
}
public DanhMuc DoanhMucTheoMa(int id)
{
CSDLTestDataContext context = new CSDLTestDataContext();
DanhMuc dm = context.DanhMucs.FirstOrDefault(x => x.MaDM == id);
if (dm != null)
{
dm.SanPhams.Clear();
}
return(dm);
}
public List <SanPham> TimSanPhamTrongKhoangDonGia(int bd, int kt)
{
CSDLTestDataContext context = new CSDLTestDataContext();
List <SanPham> dsSP = context.SanPhams.Where(x => x.DonGia >= bd && x.DonGia <= kt).ToList();
foreach (SanPham sp in dsSP)
{
sp.DanhMuc = null;
}
return(dsSP);
}
public List <SanPham> DanhSachSanPhamTheoDanhMuc(int maDM)
{
CSDLTestDataContext context = new CSDLTestDataContext();
List <SanPham> dsSP = context.SanPhams.Where(x => x.DanhMuc == maDM).ToList();
foreach (SanPham sp in dsSP)
{
sp.DanhMuc = null;
}
return(dsSP);
}
public SanPham SanPhamTheoMa(int id)
{
CSDLTestDataContext context = new CSDLTestDataContext();
SanPham sp = context.SanPhams.FirstOrDefault(x => x.MaSP == id);
if (sp != null)
{
sp.DanhMuc = null;
}
//khử đệ quy
return(sp);
}
public List <SanPham> LayToanBoSanPham()
{
CSDLTestDataContext context = new CSDLTestDataContext();
List <SanPham> dsSP = context.SanPhams.ToList();
//khử đệ quy
foreach (SanPham sp in dsSP)
{
sp.DanhMuc = null;
}
return(dsSP);
}
public bool SuaDanhMuc(int maDM, string tenDM)
{
try
{
CSDLTestDataContext context = new CSDLTestDataContext();
DanhMuc dm = context.DanhMucs.FirstOrDefault(x => x.MaDM == maDM);
if (dm != null)
{
dm.TenDM = tenDM;
context.SubmitChanges();
return(true);
}
}
catch
{
}
return(false);
}
public bool LuuDanhMuc(int maDM, string tenDM)
{
try
{
CSDLTestDataContext context = new CSDLTestDataContext();
DanhMuc dm = new DanhMuc();
dm.MaDM = maDM;
dm.TenDM = tenDM;
context.DanhMucs.InsertOnSubmit(dm);
context.SubmitChanges();
return(true);
}
catch
{
}
return(false);
}
public bool XoaSanPham(int maSP)
{
try
{
CSDLTestDataContext context = new CSDLTestDataContext();
SanPham sp = context.SanPhams.FirstOrDefault(x => x.MaSP == maSP);
if (sp != null)
{
context.SanPhams.DeleteOnSubmit(sp);
context.SubmitChanges();
return(true);
}
}
catch
{
}
return(false);
}
public bool SuaSanPham(int maSP, string tenSP, int donGia, int danhMuc)
{
try
{
CSDLTestDataContext context = new CSDLTestDataContext();
SanPham sp = context.SanPhams.FirstOrDefault(x => x.MaSP == maSP);
if (sp != null)
{
sp.TenSP = tenSP;
sp.DonGia = donGia;
sp.DanhMuc = danhMuc;
context.SubmitChanges();
return(true);
}
}
catch
{
}
return(false);
}
public bool LuuSanPham(int maSP, string tenSP, int donGia, int danhMuc)
{
try
{
CSDLTestDataContext context = new CSDLTestDataContext();
SanPham sp = new SanPham();
sp.MaSP = maSP;
sp.TenSP = tenSP;
sp.DonGia = donGia;
sp.DanhMuc = danhMuc;
context.SanPhams.InsertOnSubmit(sp);
context.SubmitChanges();
return(true);
}
catch
{
}
return(false);
}
public bool XoaDanhMuc(int maDM)
{
try
{
CSDLTestDataContext context = new CSDLTestDataContext();
DanhMuc dm = context.DanhMucs.FirstOrDefault(x => x.MaDM == maDM);
if (dm != null)
{
if (dm.SanPhams.Count > 0)
{
return(false);
}
context.DanhMucs.DeleteOnSubmit(dm);
context.SubmitChanges();
return(true);
}
}
catch
{
}
return(false);
}
