public GetManufacturerResult GetManufacturer(Guid id)
        {
            var data = _context.Manufacturers
                       .Where(ManufacturerQueries.GetById(id))
                       .FirstOrDefault();


            if (data == null)
            {
                return(null);
            }

            return(new GetManufacturerResult
            {
                Id = data.Id.ToString(),
                Description = data.Description
            });
        }
        public IEnumerable <GetManufacturerResult> GetManufacturers()
        {
            var data = _context.Manufacturers
                       .Where(ManufacturerQueries.GetAll())
                       .OrderBy(x => x.Description)
                       .ToList();

            if (data == null)
            {
                return(null);
            }

            return(data.Select(reg => new GetManufacturerResult
            {
                Id = reg.Id.ToString(),
                Description = reg.Description
            }));
        }