//+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
// 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);
