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