public GibeGTMCategory AddCategory(GibeGTMCategory category) { if (!string.IsNullOrEmpty(category.Name)) { //get the database var db = UmbracoContext.Application.DatabaseContext.Database; //build a query to select everything the people table var query = new Sql().Select("*").From("GibeGTMCategory"); //fetch data from DB with the query and map to Person object var categories = db.Fetch <GibeGTMCategory>(query); if (!categories.Any(c => c.Name == category.Name)) { // insert category in to database db.Insert(category); } } return(category); }
public GibeGTMCategory RemoveCategory(GibeGTMCategory category) { if (!string.IsNullOrEmpty(category.Name)) { //get the database var db = UmbracoContext.Application.DatabaseContext.Database; //build a query to select everything the people table var query = new Sql().Select("*").From("GibeGTMCategory"); //fetch data from DB with the query and map to Person object var categories = db.Fetch <GibeGTMCategory>(query); if (categories.Any(c => c.Name == category.Name)) { var categoryToDelete = categories.FirstOrDefault(c => c.Name == category.Name); // delete category from database db.Delete <GibeGTMCategory>(categoryToDelete); } } return(category); }