public ActionResult SearchAlbumsSongsTest()
 {
     ViewBag.Message = "Search Albums/ Songs";
     AlbumsSongsDAL albumSongsDAL = new AlbumsSongsDAL();
     try
     {
         //List<string> testLanguageLi= st = albumSongsDAL.GetLanguageList();
         //List<string> testMDList = GetLanguageList();
         ViewBag.LanguageList = albumSongsDAL.GetLanguageList();
         ViewBag.MusicDirectorList = albumSongsDAL.GetMusicDirectorList();
         ViewBag.TopFiveAlbums = albumSongsDAL.GetTopFiveAlbums();
         ViewBag.TopFiveSongs = albumSongsDAL.GetTopFiveSongs();
         ViewBag.SearchAlbums = albumSongsDAL.SearchAlbumsAndUpdateHits("Hindi","A.R. Rahman");
         ViewBag.SearchSongs = albumSongsDAL.SearchSongsAndUpdateHits("Tamil","Illeya Raja");
     }
     catch (Exception)
     {
     }
     return View();
 }
        //public ActionResult Index()
        //{
        //    return View("SearchAlbumsSongs");
        //}
        public ActionResult SearchAlbumsSongs()
        {
            ViewBag.Message = "Search Albums/ Songs";
             ViewBag.LanguageList = new List<string>();
             ViewBag.MusicDirectorList = new List<string>();
            AlbumsSongsDAL albumSongsDAL = new AlbumsSongsDAL();
            try
            {
                ViewBag.LanguageList = albumSongsDAL.GetLanguageList();

                //ViewBag.MusicDirectorList = albumSongsDAL.GetMusicDirectorList();
                ViewBag.MusicDirectorList = albumSongsDAL.GetMusicDirectorList();
                return View();
            }
            catch (Exception)
            {
                //ModelState.AddModelError("Error in rendering search page.", "Could not render search page.");
                ViewBag.Message ="Search Albums/ Songs. Connection Error. ";
                ViewBag.LanguageList = new List<Album>();
                ViewBag.MusicDirectorList = new List<MusicDirector>();
            }
            return View();
        }