//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ // Manage Category list //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ public bool setCategory( int catalogueNum, int cateID) { //Check if the category is already set var result = from cl in db.CategoryLists select new { ID = cl.CategoryID, CatNum = cl.CatalogueNumber }; foreach (var cl in result) { if (cl.ID == cateID && cl.CatNum == catalogueNum) return false; } //Set category CategoryList cateList = new CategoryList { CatalogueNumber = catalogueNum, CategoryID = cateID }; db.CategoryLists.InsertOnSubmit(cateList); db.SubmitChanges(); //submit the action to customer table return true; }
partial void UpdateCategoryList(CategoryList instance);
partial void DeleteCategoryList(CategoryList instance);
partial void InsertCategoryList(CategoryList instance);