// POST: /DataManagement/ItemCategoryList
        public JsonResult ItemCategoryList()
        {
            try
            {
                JourListDMContainer dm = new JourListDMContainer();
                List<ItemCategoryModel> list = new List<ItemCategoryModel>();

                foreach (var a in dm.ItemCategories.Where(z => z.Active == true))
                {
                    ItemCategoryModel item = new ItemCategoryModel();
                    item.Id = a.Id;
                    item.Description = a.Description;
                    item.Active = a.Active;
                    list.Add(item);
                }

                return Json(new { Result = "OK", Records = list });
            }
            catch (Exception e)
            {
                return Json(new { Result = "ERROR", Message = e.Message });
            }
        }
        public JsonResult UpdateItemCategory(ItemCategoryModel model)
        {
            try
            {
                if (!ModelState.IsValid)
                {
                    return Json(new
                    {
                        Result = "ERROR",
                        Message = "Form is not valid! " +
                          "Please correct it and try again."
                    });
                }

                if (!User.IsInRole("Officer"))
                {
                    return Json(new
                    {
                        Result = "ERROR",
                        Message = "You do not have the authority to update this item category."
                    });
                }

                JourListDMContainer dm = new JourListDMContainer();

                ItemCategory item = dm.ItemCategories.Single(z => z.Id == model.Id);
                item.Description = model.Description;
                item.Active = model.Active;
                dm.SaveChanges();

                return Json(new { Result = "OK" });
            }
            catch (Exception e)
            {
                return Json(new { Result = "ERROR", Message = e.Message });
            }
        }
        public JsonResult CreateItemCategory(ItemCategoryModel model)
        {
            if (!ModelState.IsValid)
            {
                return Json(new
                {
                    Result = "ERROR",
                    Message = "Form is not valid! " +
                    "Please correct it and try again."
                });
            }

            if (!User.IsInRole("Officer"))
            {
                return Json(new
                {
                    Result = "ERROR",
                    Message = "You do not have the authority to create a new item category."
                });
            }

            try
            {
                JourListDMContainer dm = new JourListDMContainer();

                ItemCategory item = new ItemCategory();
                item.Description = model.Description;
                dm.AddToItemCategories(item);
                dm.SaveChanges();

                model.Id = item.Id;

                return Json(new { Result = "OK", Record = model });
            }
            catch (Exception e)
            {
                return Json(new { Result = "ERROR", Message = e.Message });
            }
        }