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