public async Task <IActionResult> GetStockItemsAsync(int pageSize       = 10, int pageNumber   = 1,
                                                             int?lastEditedBy   = null, int?colorID    = null,
                                                             int?outerPackageID = null, int?supplierID = null, int?unitPackageID = null)
        {
            var response = new PagedResponse <StockItem>();

            try
            {
                // Get the "proposed" query from repository
                var query = webAPIContext.GetStockItems();

                // Set paging values
                response.PageSize   = pageSize;
                response.PageNumber = pageNumber;

                // Get the total rows
                response.ItemsCount = await query.CountAsync();

                // Get the specific page from database
                response.Model = await query.Paging(pageSize, pageNumber).ToListAsync();

                response.Message = string.Format("Page {0} of {1}, Total of products: {2}.", pageNumber, response.PageCount, response.ItemsCount);

                Logger?.LogInformation("The stock items have been retrieved successfully.");
            }
            catch (Exception ex)
            {
                response.DidError     = true;
                response.ErrorMessage = "There was an internal error, please contact to technical support.";

                Logger?.LogCritical("There was an error on '{0}' invocation: {1}", nameof(GetStockItemsAsync), ex);
            }

            return(response.toHttpResponse());
        }