public async Task <IActionResult> GetSearchMethodForSubCategory(ProductSubCategoryRequest request, string Name)
        {
            var result = new ProductSubCategoryResponse();

            var ProductSubCategory = await _context.ProductSubCategory.Take(request.Quantity).Where(c => c.Name.StartsWith(Name) || c.Name.Contains(Name) || c.Name.EndsWith(Name)).Select(p => new ProductSubCategory {
                ProductSubCategoryId = p.Id, ProductCategoryName = p.Name
            }).ToListAsync();

            if (ProductSubCategory.Count == 0)
            {
                result.Code    = -100;
                result.Message = "Can't get products with given parameters.";
                return(Ok(result));
            }

            result.Code    = 100;
            result.Message = "Success";
            result.productSubCategories = ProductSubCategory;
            return(Ok(result));
        }
        public async Task <IActionResult> GetProductSubCategory(ProductSubCategoryRequest request)
        {
            var result = new ProductSubCategoryResponse();

            var ProductSubCategory = await _context.ProductSubCategory.Skip(request.Skip).Take(request.Quantity).Select(p => new ProductSubCategory {
                ProductSubCategoryId = p.Id, ProductCategoryName = p.Name
            }).ToListAsync();

            if (ProductSubCategory.Count == 0)
            {
                result.Code    = -100;
                result.Message = "Can't get products with given parameters.";
                return(Ok(result));
            }

            result.Code    = 100;
            result.Message = "Success";
            result.productSubCategories = ProductSubCategory;
            return(Ok(result));
        }