public async Task<IHttpActionResult> AddCategory(CategoryModel model)
        {
            try
            {
                var category = new DrNajeeb.EF.Category();
                category.Name = model.Name;
                category.IsShowOnFrontPage = model.IsShowOnFrontPage ?? false;
                category.SEOName = Helpers.URLHelpers.URLFriendly(model.Name);
                category.CreatedOn = DateTime.UtcNow;
                category.Active = true;
                var maxValue = await _Uow._Categories.GetAll(x => x.Active == true).OrderByDescending(x => x.DisplayOrder).FirstOrDefaultAsync();
                category.DisplayOrder = (maxValue != null) ? maxValue.DisplayOrder + 1 : 1;

                //todo : add useid in createdby
                //todo : set seo name like QA site
                //todo : set and save category url
                //set display order of categories

                _Uow._Categories.Add(category);
                await _Uow.CommitAsync();
                return Ok();
            }
            catch (Exception ex)
            {
                return InternalServerError(ex);
            }
        }

        public JsonResult Delete(CategoryModel model)
        {
            if (ModelState.IsValid)
                return Json(_service.Delete(model));

            return Json(null);
        }

        public ActionResult SaveChanges(CategoryModel model)
        {
            if (!ModelState.IsValid)
                return null;

            T_Category entity = CategoryModel.ModelToEntity(model);

            // Save add action
            if (model.cat_id <= 0)
            {
                _context.Add(entity);
                _context.SaveChanges();
                Log.Info(string.Format("Edit category id={0} name={1}", entity.cat_id, entity.cat_name));

                return GenerateJson(entity, true, "Nouvelle catégorie ajoutée.");
            }
            // Save edit action
            else
            {
                _context.Edit(entity);
                _context.SaveChanges();
                Log.Info(string.Format("Create category id={0} name={1}", entity.cat_id, entity.cat_name));

                return GenerateJson(entity, false, "Catégorie modifiée.");
            }
        }

        public ActionResult Delete([DataSourceRequest]DataSourceRequest request, CategoryModel model)
        {
            this.Data.Categories.Delete(model.Id);
            this.Data.SaveChanges();

            return this.Json(new[] { model }.ToDataSourceResult(request, this.ModelState));
        }

 public Category CreateNewEntity(CategoryModel categoryModel)
 {
     Contract.Requires<ArgumentNullException>(categoryModel != null);
     Contract.Requires<ArgumentException>(categoryModel.Id == Guid.Empty, "Category should not have an id already.");
     Contract.Requires<ArgumentException>(!string.IsNullOrEmpty(categoryModel.Name), "Category requires a name.");
     Contract.Ensures(Contract.Result<Category>() != null);
     throw new NotImplementedException();
 }

 public void Should_not_have_error_when_pageSizeOptions_is_null_or_empty()
 {
     var model = new CategoryModel();
     model.PageSizeOptions = null;
     _validator.ShouldNotHaveValidationErrorFor(x => x.PageSizeOptions, model);
     model.PageSizeOptions = "";
     _validator.ShouldNotHaveValidationErrorFor(x => x.PageSizeOptions, model);
 }

    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        CategoryModel model = new CategoryModel();
        Category c = CreateCategory();

        lblResult.Text = model.InsertCategory(c);
        Response.Redirect("~/Pages/Management/ManageWebsite.aspx", false);
    }

 public CategoryViewModel(
             CategoryModel categoryModel, 
             string pageTitle, 
             INavigationServiceFacade navigationServiceFacade, 
             bool synchronizedWithSelection)
 {
     this._category = categoryModel;
     this._pageTitle = pageTitle;
     this._navigationServiceFacade = navigationServiceFacade;
 }

        public static CategoryModel ToCategoryModel(this Category global)
        {
            CategoryModel category = new CategoryModel
            {
                Id = global.Id,
                Name = global.Name
            };

            return category;
        }

        public ActionResult Edit(CategoryModel model)
        {
            if (model.Id == 0)
                ModelState.Remove("Id");

            if (ModelState.IsValid)
                return Json(model.Id == default(int) ? _service.Add(model) : _service.Edit(model));

            return PartialView("EditorTemplates/_Edit", model);
        }

 public static ProductModel CreateProduct(string brand, int width, int height, string type, CategoryModel category)
 {
     return new ProductModel()
     {
         Brand = brand,
         Width = width,
         Height = height,
         Type = type,
         ProductCategory = category
     };
 } 

 public CategoryModel GetByName(string name)
 {
     var categoryEntity = context.CategoryEntities.FirstOrDefault(m => m.Name.Equals(name, StringComparison.InvariantCultureIgnoreCase));
     if (categoryEntity == null)
         return null;
     var category = new CategoryModel()
     {
         Id = categoryEntity.Id,
         Name = categoryEntity.Name
     };
     return category;
 }

        public ActionResult Edit(int id, CategoryModel model)
        {
            var context = new ApplicationDbContext();
            var category = context.Categories.Single(x => x.CategoryId == id); //.FirstOrDefault(c => c.CategoryId == id);
            TryUpdateModel(category);
            return RedirectToAction("Index");


//
//            category.Title = model.Title;
            //context.SaveChanges();

        }

        public ActionResult Create([DataSourceRequest]DataSourceRequest request, CategoryModel model)
        {
            if (model != null && this.ModelState.IsValid)
            {
                var category = Mapper.Map<Category>(model);
                this.Data.Categories.Add(category);
                this.Data.SaveChanges();

                model.Id = category.Id;
            }

            return this.Json(new[] { model }.ToDataSourceResult(request, this.ModelState));
        }

        protected override void Because_of()
        {
            var categoryModel = new CategoryModel();
            categoryModel.Category = categoryModel;

            var userModel = new UserModel();
            var userGroupModel = new UserGroupModel();

            userModel.Category = categoryModel;
            userModel.Group = userGroupModel;
            userGroupModel.Users.Add(userModel);

            _destination = Mapper.Map<UserDto>(userModel);
        }

        public Category getCategory(CategoryModel model)
        {
            var cat = new Category();

            if (model != null)
            {
                cat.CategoryDescription = model.CategoryDescription;
                cat.CategoryId = model.CategoryId;
                cat.CategoryName = model.CategoryName;
                cat.CategoryPicture = model.CategoryPicture;
                cat.Products = getProduct(model.Products);
            }

            return cat;
        }

        public ActionResult Update([DataSourceRequest]DataSourceRequest request, CategoryModel model)
        {
            if (model != null && this.ModelState.IsValid)
            {
                var category = this.Data.Categories.All().FirstOrDefault(x => x.Id == model.Id);
                if (category != null)
                {
                    category.Name = model.Name;
                }

                this.Data.Categories.Update(category);
                this.Data.SaveChanges();
            }

            return this.Json(new[] { model }.ToDataSourceResult(request, this.ModelState));
        }

 /// <summary>
 /// 获取论坛板块信息 CategoryModel
 /// </summary>
 public BbsBoardModel GetBbsBoard(CategoryModel c)
 {
     cms_varticle lastpost = new cms_varticle();
     BbsBoardModel board = new BbsBoardModel();
     if (c != null)
     {
         board = GetBbsBoardStat(Utils.StrToInt(c.CateId));
         board.CateId = c.CateId;
         board.Path = c.Path;
         board.CateName = c.CateName;
         board.ReName = c.ReName;
         board.SubCount = c.SubCount;
         board.ReplyPermit = c.ReplyPermit;
         board.ParentId = c.ParentId;
     }
     return board;
 }

        async void MainCategories_Loaded(object sender, RoutedEventArgs e)
        {
            if (AppData.CheckNetworkConnection())
            {
                this.ViewModel.ShowOverlay();
                string categoriesResponse = await webServiceHandler.GetResponseThroughGet(AppData.AllCategoriesUrl, false);
                categories = JsonConvert.DeserializeObject<CategoryModel>(categoriesResponse);

                this.Background = new SolidColorBrush(Color.FromArgb(0, 255, 255, 255));
                this.ViewModel.HideOverlay();
                this.ViewModel.Categories = categories;
            }
            else
            {
                MessageDialog msg = new MessageDialog(AppData.NoInternetMessage);
                await msg.ShowAsync();
            }
           
        }

        public List<CategoryModel> AllCategories()
        {
            using (var db = new TankshopDbContext())
            {
                var dbCategories = db.Categories.ToList();
                var categoryModels = new List<CategoryModel>();
                foreach (var c in dbCategories)
                {
                    var categoryModel = new CategoryModel()
                    {
                        CategoryId = c.CategoryId,
                        CategoryName = c.Name,
                        Products = GetProductsByCategory(c.CategoryId)

                    };
                    categoryModels.Add(categoryModel);
                }
                return categoryModels;
            }
        }