public virtual IActionResult GetGroupsItems(DataSourceRequest command, GroupsItemsListModel model, int groupId)
        {
            if (!_permissionService.Authorize(StandardPermissionProvider.ManageProducts))
            {
                return(AccessDeniedKendoGridJson());
            }

            var query = _gpiRepository.TableNoTracking.Where(x => x.Deleted == false && x.GroupId == groupId);

            query = query.OrderBy(x => x.ItemId);

            var groups = new PagedList <GroupsItems>(query, command.Page - 1, command.PageSize);

            var gridModel = new DataSourceResult
            {
                Data = groups.Select(x =>
                {
                    var pn      = "";
                    var product = _productService.GetProductById(x.ItemId);
                    if (product != null)
                    {
                        pn = product.Name;
                    }
                    var groupsModel = new GroupsItemsListModel {
                        GroupItemId = x.Id, ItemId = x.ItemId, GroupId = x.GroupId, ItemName = pn, Relationship = x.Relationship
                    };
                    //categoryModel.Breadcrumb = x.GetFormattedBreadCrumb(_categoryService);
                    return(groupsModel);
                }),
                Total = groups.TotalCount
            };

            return(Json(gridModel));
        }
        public virtual IActionResult CreateItem(GroupsItemsListModel model)
        {
            if (!_permissionService.Authorize(StandardPermissionProvider.ManageProducts))
            {
                return(AccessDeniedView());
            }

            var item = new GroupsItems
            {
                Id = 1
            };

            if (!string.IsNullOrEmpty(model.ItemName) && !string.IsNullOrWhiteSpace(model.ItemName))
            {
                model.ItemName = WebUtility.UrlDecode(model.ItemName);

                model.ItemId = _productService.SearchProducts(keywords: model.ItemName, orderBy: ProductSortingEnum.NameAsc).FirstOrDefault().Id;

                item = new GroupsItems {
                    GroupId = model.GroupId, ItemId = model.ItemId, Relationship = model.Relationship
                };

                _gpiRepository.Insert(item);

                var groupsModel = new GroupsItemsListModel {
                    GroupItemId = item.Id, ItemId = item.ItemId, GroupId = item.GroupId, ItemName = model.ItemName, Relationship = item.Relationship
                };

                var groupsModels = new List <GroupsItemsListModel>();
                groupsModels.Add(groupsModel);

                model.GroupItemId  = item.Id;
                model.GroupId      = item.GroupId;
                model.ItemId       = item.ItemId;
                model.Relationship = item.Relationship;



                var gridModel = new DataSourceResult
                {
                    Data = groupsModels,

                    //Data = groups.Select(x =>
                    //{
                    //    var pn = "";
                    //    var product = _productService.GetProductById(x.ItemId);
                    //    if (product != null) { pn = product.Name; }
                    //    var groupsModel = new GroupsItemsListModel { GroupItemId = x.Id, ItemId = x.ItemId, GroupId = x.GroupId, ItemName = pn, Relationship = x.Relationship };
                    //    //categoryModel.Breadcrumb = x.GetFormattedBreadCrumb(_categoryService);
                    //    return groupsModel;
                    //}),
                    Total = 0 //groups.TotalCount
                };



                return(Json(gridModel));
            }
            return(Json(model));

            //return new NullJsonResult();
        }