//
        // GET: /Scores/Details
        public ActionResult Details(string scoreId)
        {
            if (String.IsNullOrWhiteSpace(scoreId))
            {
                return(RedirectToAction("Missing", "Error", null));
            }

            FoireMusesConnection connection = GetConnection();
            Score  score        = null;
            Score  genericScore = null;
            Source sTextuelle   = null;
            Source sMusicale    = null;
            Play   assPlay      = null;
            IList <ScoreSearchItem> otherTitlesScore = null;
            IEnumerable <string>    attachedFiles    = null;
            IEnumerable <string>    documents        = null;

            try
            {
                score = connection.GetScore(scoreId, new Result <Score>()).Wait();
                if (score == null)
                {
                    return(RedirectToAction("Missing", "Error", null));
                }
                if (score.TextualSource != null && !String.IsNullOrWhiteSpace(score.TextualSource.SourceId))
                {
                    sTextuelle = connection.GetSource(score.TextualSource.SourceId, new Result <Source>()).Wait();
                    if (sTextuelle == null)
                    {
                        return(RedirectToAction("Problem", "Error", null));
                    }
                    if (!String.IsNullOrWhiteSpace(score.TextualSource.PieceId))
                    {
                        assPlay = connection.GetPlay(score.TextualSource.PieceId, new Result <Play>()).Wait();
                        if (assPlay == null)
                        {
                            return(RedirectToAction("Problem", "Error", null));
                        }
                    }
                }
                if (score.MusicalSource != null && !String.IsNullOrWhiteSpace(score.MusicalSource.SourceId))
                {
                    sMusicale = connection.GetSource(score.MusicalSource.SourceId, new Result <Source>()).Wait();
                    if (sMusicale == null)
                    {
                        return(RedirectToAction("Problem", "Error", null));
                    }
                }
                if (score.HasAttachement)
                {
                    attachedFiles = score.GetAttachmentNames().Where(x => !x.StartsWith("$"));
                    documents     = score.GetAttachmentNames().Where(x => x.StartsWith("$"));
                }
                if (score.IsMaster)
                {
                    SearchResult <ScoreSearchItem> results = connection.SearchScore(0, 0, new Dictionary <string, object>()
                    {
                        { "masterId", score.Id }
                    }, new Result <SearchResult <ScoreSearchItem> >()).Wait();
                    if (results == null)
                    {
                        return(RedirectToAction("Problem", "Error", null));
                    }
                    otherTitlesScore = results.Rows;
                }
                else if (score.MasterId != null)
                {
                    genericScore = connection.GetScore(score.MasterId, new Result <Score>()).Wait();
                    if (genericScore == null)
                    {
                        return(RedirectToAction("Problem", "Error", null));
                    }
                    SearchResult <ScoreSearchItem> results = connection.SearchScore(0, 0, new Dictionary <string, object>()
                    {
                        { "masterId", score.MasterId }
                    }, new Result <SearchResult <ScoreSearchItem> >()).Wait();
                    if (results == null)
                    {
                        return(RedirectToAction("Problem", "Error", null));
                    }
                    otherTitlesScore = results.Rows;
                }
            }
            catch (Exception e)
            {
                return(RedirectToAction("Problem", "Error", null));
            }
            ViewBag.TextualSource    = sTextuelle;
            ViewBag.AssociatedPlay   = assPlay;
            ViewBag.MusicalSource    = sMusicale;
            ViewBag.AttachedFiles    = attachedFiles;
            ViewBag.Documents        = documents;
            ViewBag.OtherTitlesScore = otherTitlesScore;
            ViewBag.GenericScore     = genericScore;
            return(View(score));
        }