public static List<ResourceCategory> GetResourceCategories(GetResourceCategoriesRequest request)
{
var context = Exigo.ODataResources();
var query = context.ResourceManagerCategories.AsQueryable();
var model = new List<ResourceCategory>();
// Apply the filters
if (request.ResourceCategoryID != null)
{
query = query.Where(c => c.ResourceCategoryID == (int)request.ResourceCategoryID);
}
var categories = query.ToList();
foreach (var category in categories)
{
var cat = new ResourceCategory();
cat.ResourceCategoryDescription = category.ResourceCategoryDescription;
cat.ResourceCategoryID = category.ResourceCategoryID;
cat.ResourceCategoryOrder = category.ResourceCategoryOrder; //Added the field to the model
model.Add(cat);
}
return model;
}
public static List <ResourceCategory> GetResourceCategories(GetResourceCategoriesRequest request)
{
var context = Exigo.ODataResources();
var query = context.ResourceManagerCategories.AsQueryable();
var model = new List <ResourceCategory>();
// Apply the filters
if (request.ResourceCategoryID != null)
{
query = query.Where(c => c.ResourceCategoryID == (int)request.ResourceCategoryID);
}
var categories = query.ToList();
foreach (var category in categories)
{
var cat = new ResourceCategory();
cat.ResourceCategoryDescription = category.ResourceCategoryDescription;
cat.ResourceCategoryID = category.ResourceCategoryID;
cat.ResourceCategoryOrder = category.ResourceCategoryOrder;
model.Add(cat);
}
return(model);
}
public static void ModifyResourceCategoryOrder(ResourceCategory category)
{
using (var context = Exigo.Sql())
{
context.Execute(@"
UPDATE ExigoWebContext.ResourceCategories
SET CategoryOrder = @order, ParentID = @parentid
WHERE CategoryID = @id
", new { order = category.CategoryOrder, id = category.CategoryID, parentid = category.ParentID });
}
}
public static void ModifyResourceCategoryDescription(ResourceCategory category)
{
using (var context = Exigo.Sql())
{
context.Execute(@"
UPDATE ExigoWebContext.ResourceCategories
SET CategoryDescription = @description
WHERE CategoryID = @id
", new { description = category.CategoryDescription, id = category.CategoryID });
}
}
public static void DeleteResourceCategory(ResourceCategory category)
{
using (var context = Exigo.Sql())
{
context.Execute(@"
DELETE FROM
ExigoWebContext.ResourceCategories
WHERE
CategoryID = @category
", new { category = category.CategoryID });
}
}
public static void AddResourceCategory(ResourceCategory newCategory)
{
using (var context = Exigo.Sql())
{
context.Execute(@"
INSERT
ExigoWebContext.ResourceCategories
(CategoryID, CategoryDescription, CategoryOrder, ParentID)
VALUES
(@categoryid, @categorydescription, @categoryorder, @parentid)
", new { categoryid = newCategory.CategoryID, categorydescription = newCategory.CategoryDescription, categoryorder = newCategory.CategoryOrder, parentid = newCategory.ParentID });
}
}
