public ActionResult JoinPrivateLeague(int leagueID, int useriD)
        {
            _Home model = new _Home();

            dbconAPP = GetConnection();
            try
            {
                dbconAPP.Open();
                model.list_cLeaguePrivate = new List <League>();
                model.cUser            = new User();
                model.cLeague          = new League();
                model.cUser.UserID     = useriD;
                model.cLeague.LeagueID = leagueID;
                model.GetNonLeagueMemberData(dbconAPP, model);
                List <League> tempPublic = new List <League>();
                tempPublic         = model.list_cLeaguePrivate.Where(n => n.LeagueID == leagueID).ToList <League>();
                model.cLeague      = tempPublic[0];
                ViewBag.LeagueType = "Private";
            }
            catch (Exception ex)
            {
                ViewBag.HomeError += "ERROR: " + ex.Message + " (Home.JoinPrivateLeague[GET]).";
                return(View("JoinLeague", model));
            }
            finally
            {
                if (dbconAPP != null && dbconAPP.State == System.Data.ConnectionState.Open)
                {
                    dbconAPP.Close();
                }
            }
            return(View("JoinLeague", model));
        }
        public ActionResult Teams()
        {
            _Home model = new _Home();

            dbconAPP = GetConnection();
            try
            {
                dbconAPP.Open();
                ApplicationUser user = System.Web.HttpContext.Current.GetOwinContext().GetUserManager <ApplicationUserManager>().FindById(System.Web.HttpContext.Current.User.Identity.GetUserId());
                if (user == null)
                {
                    model.GetNonLeagueMemberData(dbconAPP, model);
                    return(View("NonMember", model));
                }
                else
                {
                    model.cUser        = new User();
                    model.cUser.UserID = model.cUser.GetUserID(dbconAPP, user.Id);
                    model.GetLeagueMemberData(dbconAPP, model);
                    return(View("Member", model));
                }
            }
            catch (Exception ex)
            {
                ViewBag.HomeError += "ERROR: " + ex.Message + " (Home.League[GET]).";
                return(View("NonMember", model));
            }
            finally
            {
                if (dbconAPP != null && dbconAPP.State == System.Data.ConnectionState.Open)
                {
                    dbconAPP.Close();
                }
            }
        }
 public ActionResult JoinPrivateLeague(_Home model, string buttonAction, HttpPostedFileBase uploadfile)
 {
     //model = (_Home)TempData["model"];
     if (uploadfile != null && uploadfile.ContentLength > 0)
     {
         var fileName = Path.GetFileName(uploadfile.FileName);
         var path     = Path.Combine(Server.MapPath("~/Images/TeamLogos"), fileName);
         uploadfile.SaveAs(path);
         model.cFantasyTeam.Logo = fileName;
     }
     return(View(model));
 }
 public ActionResult GoToLeague(_Home model, string buttonAction, string LeagueID, string SeasonID, string FantasyTeamID)
 {
     //if (buttonAction == "public")
     //{
     //    TempData["LeagueList"] = model.list_cLeaguePublic;
     //}
     //else
     //{
     //    TempData["LeagueList"] = model.list_cLeaguePrivate;
     //}
     return(RedirectToAction("Index", "League", new { leagueType = buttonAction, leagueID = LeagueID, seasonID = SeasonID, fantasyTeamID = FantasyTeamID }));
 }
        public ActionResult JoinLeague(_Home model, string buttonAction, HttpPostedFileBase uploadfile)
        {
            dbconAPP = GetConnection();
            try
            {
                //save logo
                if (uploadfile != null && uploadfile.ContentLength > 0)
                {
                    var fileName = Path.GetFileName(uploadfile.FileName);
                    var path     = Path.Combine(Server.MapPath("~/Images/TeamLogos"), fileName);
                    uploadfile.SaveAs(path);
                    model.cFantasyTeam.Logo = fileName;
                }
                else
                {
                    model.cFantasyTeam.Logo = "defaultTeamLogo.png";
                }

                //Add fantasy team
                dbconAPP.Open();
                model.cFantasyTeam.UserID   = model.cUser.UserID;
                model.cFantasyTeam.LeagueID = model.cLeague.LeagueID;
                model.cFantasyTeam.CreateNewFantasyTeam(dbconAPP, model.cFantasyTeam);
            }
            catch (Exception ex)
            {
                ViewBag.HomeError += "ERROR: " + ex.Message + " (Home.JoinLeague[POST]).";
                return(RedirectToAction("Index", "Home", new { msg = ViewBag.HomeError }));
            }
            finally
            {
                if (dbconAPP != null && dbconAPP.State == System.Data.ConnectionState.Open)
                {
                    dbconAPP.Close();
                }
            }
            return(RedirectToAction("Index", "Home", new { msg = ViewBag.HomeError }));
        }
        public ActionResult Leagues()
        {
            _Home model = new _Home();

            dbconAPP = GetConnection();
            try
            {
                dbconAPP.Open();
                model.GetNonLeagueMemberData(dbconAPP, model);
                return(View("NonMember", model));
            }
            catch (Exception ex)
            {
                ViewBag.HomeError += "ERROR: " + ex.Message + " (Home.League[GET]).";
                return(View("NonMember", model));
            }
            finally
            {
                if (dbconAPP != null && dbconAPP.State == System.Data.ConnectionState.Open)
                {
                    dbconAPP.Close();
                }
            }
        }
        public ActionResult Index(_Home model, string buttonAction, string leagueID)
        {
            FantasyTeam modelFantasyTeam = new FantasyTeam();
            string      errType          = "League";
            string      errMsg           = "";

            try
            {
                //Get connection
                dbconAPP = GetConnection();
                dbconAPP.Open();

                //Verify user isn't already apart of the league
                ApplicationUser user = System.Web.HttpContext.Current.GetOwinContext().GetUserManager <ApplicationUserManager>().FindById(System.Web.HttpContext.Current.User.Identity.GetUserId());
                model.cLeague          = new League();
                model.cUser            = new User();
                model.cUser.UserID     = model.cUser.GetUserID(dbconAPP, user.Id);
                model.cLeague.LeagueID = Convert.ToInt32(leagueID);
                if (model.cLeague.VerifyLeagueUsers(dbconAPP, model.cLeague, model.cUser.UserID))
                {
                    return(Content("You cannot join this league because you are already a member."));
                }

                //Process request based on buttonAction value
                switch (buttonAction.ToUpper())
                {
                case "PUBLIC":
                    //TempData["model"] = model;
                    List <League> tempPublic = new List <League>();
                    tempPublic         = model.list_cLeaguePublic.Where(n => n.LeagueID == model.cLeague.LeagueID).ToList <League>();
                    model.cLeague      = tempPublic[0];
                    ViewBag.LeagueType = "Public";
                    //return View("JoinLeague", model);
                    //return RedirectToAction("JoinPublicLeague");
                    break;

                case "PRIVATE":
                    //TempData["model"] = model;
                    List <League> tempPrivate = new List <League>();
                    tempPrivate        = model.list_cLeaguePrivate.Where(n => n.LeagueID == model.cLeague.LeagueID).ToList <League>();
                    model.cLeague      = tempPrivate[0];
                    ViewBag.LeagueType = "Private";
                    //return View("JoinLeague", model);
                    //return RedirectToAction("JoinPrivateLeague");
                    break;
                }

                //Get Fantasy Team info
                errType = "FantasyTeam";
                modelFantasyTeam.UserID     = model.cUser.UserID;
                modelFantasyTeam.LeagueID   = model.cLeague.LeagueID;
                modelFantasyTeam.LeagueName = model.cLeague.LeagueName;
                return(PartialView("_JoinLeague", modelFantasyTeam));
            }
            catch (Exception ex)
            {
                if (errType == "League")
                {
                    errMsg += "ERROR: " + ex.Message + " (Home.Index[POST]).";
                    return(Content(errMsg));
                }
                else
                {
                    errMsg += "ERROR: " + ex.Message + " (Home.Index[POST]).";
                    ViewBag.JoinLeagueError = errMsg;
                    return(PartialView("_JoinLeague", modelFantasyTeam));
                }
            }
            finally
            {
                if (dbconAPP != null && dbconAPP.State == System.Data.ConnectionState.Open)
                {
                    dbconAPP.Close();
                }
            }
        }