LED lighting fixtures for indoor and outdoor lighting applications; Lighting devices for showcases