public List<SanPham> GetAllSP()
{
try
{
using (ShopttEntities data = new ShopttEntities())
{
var my_data = (data.SanPhams.Select(p => p)).ToList();
return my_data;
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return null;
}
}
public bool AddSP(string TenSP)
{
SanPham sp = new SanPham();
sp.TenSP = TenSP;
try
{
using (ShopttEntities data = new ShopttEntities())
{
data.SanPhams.Add(sp);
data.SaveChanges();
return true;
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return false;
}
}
public List<SanPham> GetSanPhamID(int id)
{
try
{
using (ShopttEntities db = new ShopttEntities())
{
var Sp = (from p in db.SanPhams where p.MaNSX == id select p).ToList() ;
if (Sp!= null)
return Sp;
else
throw new Exception("Invalid product id");
}
}
catch (Exception e)
{
Debug.WriteLine(e);
return null;
}
}
