public List <Product> GetAllProducts()
        {
            List <Product> products = null;

            using (_context)
            {
                try
                {
                    products = _context.SPGetProducts((int?)null).ToList();
                }
                catch (Exception ex)
                {
                    CustomLogging.LogMessage(TracingLevel.ERROR, new Exception("Error getting products", ex));
                }
            }
            return(products);
        }