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