public IHttpActionResult GetAll()
        {
            try
            {
                var music = _repository.GetAll("SELECT * FROM MUSICS");

                _repository.Close();

                music = _repository.GetAll("SELECT * FROM MUSICS");

                return(Ok(music));
            }
            catch (System.Exception)
            {
                throw;
            }
            finally {
                _repository.Close();
            }
        }