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