public Category CreateCategory(Category category) { var dc = new DataClassesDataContext(_connectionString); dc.Categories.InsertOnSubmit(category); dc.SubmitChanges(); return category; }
partial void DeleteCategory(Category instance);
partial void UpdateCategory(Category instance);
partial void InsertCategory(Category instance);
public Category UpdateCategory(Category category) { var dc = new DataClassesDataContext(_connectionString); dc.Categories.Attach(category, ReadCategory(category.CategoryID)); dc.SubmitChanges(); return category; }
public Product[] SearchProduct(Category category, Supplier supplier) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Product> s = from e in dc.Products select e; IEnumerable<Product> ss = from e in s.ToList() where (category == null || e.Category.CategoryID == category.CategoryID) && (supplier == null || e.SupplierID == supplier.SupplierID) select e; try { return ss.ToArray(); } catch (Exception e) { Debug.WriteLine(e); } return new Product[0]; }
public void DeleteCategory(Category category) { var dc = new DataClassesDataContext(_connectionString); IQueryable<Category> s = from e in dc.Categories where e.CategoryID == category.CategoryID select e; dc.Categories.DeleteOnSubmit(s.First()); dc.SubmitChanges(); }