public ActionResult SearchPlayer(string text)
        {
            PlayerDbHandler pdb = new PlayerDbHandler();
            int             id  = pdb.SearchPlayer(text);

            return(RedirectToAction("ViewPlayer", "Player", new { id }));
        }
        public ActionResult DeletePlayerFromTeam(int playerid, int teamid)
        {
            PlayerDbHandler pdb = new PlayerDbHandler();

            pdb.DeletePlayerFromTeam(playerid, teamid);
            return(RedirectToAction("ViewTeam", "Team", new { id = teamid }));
        }
        public ActionResult DeleteLocation(int id)
        {
            PlayerDbHandler pdb = new PlayerDbHandler();

            if (pdb.DeletePlayer(id))
            {
                return(RedirectToAction("Index", "Home", null));
            }
            return(RedirectToAction("Index", "Home", null));
        }
 public ActionResult EditPlayer(Player P)
 {
     if (ModelState.IsValid)
     {
         PlayerDbHandler pdb = new PlayerDbHandler();
         pdb.UpdatePlayer(P);
         return(RedirectToAction("Index"));
     }
     return(View(P));
 }
 public ActionResult CreatePlayer(Player P)
 {
     try
     {
         if (ModelState.IsValid)
         {
             PlayerDbHandler pdb = new PlayerDbHandler();
             if (pdb.AddPlayer(P))
             {
                 ViewBag.Message = "Player Created Correctly";
                 ModelState.Clear();
             }
         }
         return(RedirectToAction("Index", "Home", null));
     }
     catch
     {
         return(View());
     }
 }
        public ActionResult ViewAllPlayers()
        {
            PlayerDbHandler pdb = new PlayerDbHandler();

            return(View(pdb.GetPlayers()));
        }
        public ActionResult EditPlayer(int id)
        {
            PlayerDbHandler pdb = new PlayerDbHandler();

            return(View(pdb.GetPlayers().Find(m => m.PlayerID == id)));
        }
        public ActionResult ViewPlayer(int id)
        {
            PlayerDbHandler pdb = new PlayerDbHandler();

            return(View(pdb.ViewPlayer(id)));
        }