public string AddMusicDirector(string FirstName, string LastName)
        {
            if (ModelState.IsValid)
            {
                AdminAlbumDAL DalObj = new AdminAlbumDAL();
                AddAlbumMusicDirectorSongViewModel DirObject = new AddAlbumMusicDirectorSongViewModel();
                DirObject = DalObj.AddMusicDirectors(FirstName, LastName);
                if (DirObject.MusicDirctorID != -1)
                {
                    ViewBag.Message = "DirectorId" + DirObject.MusicDirctorID;

                }
                else
                {
                    ViewBag.Messgae = "-1";
                }
                return DirObject.MusicDirctorID.ToString();

            }
            return "false";
        }
        public string AddSong(string album, string Title, int Rating, int NoOfCopies, int Cost)
        {
            if (ModelState.IsValid)
            {
                AdminAlbumDAL DalObj = new AdminAlbumDAL();
                int check = 0;
                check = DalObj.AddSong(album, Title, Rating, NoOfCopies,Cost);
                if (check == 1)
                {
                    ViewBag.Message = "1";
                    return "one";

                }
                else if (check == 2)
                {
                    ViewBag.Messgae = "2";
                    return "two";
                }

            }
            return "false";
        }
        public string AddAlbums(string MusicDirector, string Language, string Name, int NoOfCopies, int Rating, int Cost)
        {
            if (ModelState.IsValid)
            {
                AdminAlbumDAL DalObj = new AdminAlbumDAL();
                int check = 0;
                check = DalObj.AddAlbum(MusicDirector, Language, Name, NoOfCopies, Rating, Cost);
                if (check == 1)
                {
                    ViewBag.Message ="1";
                    return "one";

                }
                else if (check == 2)
                {
                    ViewBag.Messgae = "2";
                    return "two";
                }

            }
            return "false";
        }
        //
        // GET: /AdminAddAlbumMusicDirectorSongs/
        public ActionResult Index()
        {
            if (Session["UserID"] != null)
            {
                if (Session["Role"].Equals("member"))
                {
                    return RedirectToAction("Index", "Member");
                }
            }
            else
            {
                return RedirectToAction("Login", "Account");
            }

            AdminAlbumDAL dalObj = new AdminAlbumDAL();
            List<string> musicDirectorList = new List<string>();
            List<string> albumList = new List<string>();

            musicDirectorList = dalObj.MusicDirectorList();
            albumList = dalObj.AlbumNameList();

            ViewBag.MusicDirectorList = musicDirectorList;
            ViewBag.AlbumList = albumList;
            return View();
        }