Beispiel #1
0
        public ActionResult Change(int id)
        {
            Context ctx = new Context();

            var matchTeams = (from mt in ctx.MatchesTeam
                              where mt.matchId == id
                              select mt).FirstOrDefault();

            var teams = (from t in ctx.Teams
                         select t).ToList();

            var results = new List<SelectListItem>();

            foreach (Teams t in teams)
            {
                results.Add(new SelectListItem() { Text = t.teamName, Value = t.teamId.ToString() });
            }

            ViewBag.HomeTeam = results;
            ViewBag.AwayTeam = results;

            if (matchTeams == null)
            {
                matchTeams = new MatchesTeam();
                matchTeams.matchId = id;
                matchTeams.teamId = 0;
                matchTeams.teamIsLocal = true;
            }

            return View(matchTeams);
        }
Beispiel #2
0
        public ActionResult Change(MatchesTeam mt, FormCollection form)
        {
            MatchesTeam teamLocal = new MatchesTeam() { matchId = int.Parse(form["matchId"].ToString()), teamId = int.Parse(form["dropHome"].ToString()), teamIsLocal = true };
            MatchesTeam teamAway = new MatchesTeam() { matchId = int.Parse(form["matchId"].ToString()), teamId = int.Parse(form["dropAway"].ToString()), teamIsLocal = false };

            Context ctx = new Context();

            int matchId = int.Parse(form["matchId"].ToString());

            var exists = (from ma in ctx.MatchesTeam
                          where ma.matchId == matchId
                          select ma).ToList();

            if (exists.Count == 0)
            {
                ctx.MatchesTeam.Add(teamLocal);
                ctx.MatchesTeam.Add(teamAway);
            }
            else
            {
                if (exists[0].teamIsLocal == true)
                {
                    exists[0].teamId = int.Parse(form["dropHome"].ToString());
                    exists[1].teamId = int.Parse(form["dropAway"].ToString());
                }
                else
                {
                    exists[1].teamId = int.Parse(form["dropHome"].ToString());
                    exists[0].teamId = int.Parse(form["dropAway"].ToString());
                }

            }
            ctx.SaveChanges();
            return RedirectToAction("List", "Match");
        }
Beispiel #3
0
        public ActionResult Finalist()
        {
            Context ctx = new Context();

            var users = (from u in ctx.UserProfiles
                         where u.UserName == User.Identity.Name
                         select u).SingleOrDefault();

            var result = (from f in ctx.UserFinalist
                          from t in ctx.Teams
                          where f.UserId == users.UserId &&
                              t.teamId == f.teamId
                          select new ModelTemp() { teamName = t.teamName, teamFlag = t.teamImage, position = f.position, positionName = f.position == 1 ? "Campeón" : f.position == 2 ? "Sub Campeón" : f.position == 3 ? "Tercer Lugar" : "Cuarto Lugar" }).OrderBy(o => o.position).ToList();

            ViewBag.Finalist = result;
            return View();
        }
Beispiel #4
0
        public ActionResult Index()
        {
            Context ctx = new Context();

            var user = (from u in ctx.UserProfiles
                        where u.UserName == User.Identity.Name
                        select u).SingleOrDefault();

            var userFinalist = (from f in ctx.UserFinalist
                                where f.UserId == user.UserId
                                select f).Count();

            if (userFinalist != 4 && !User.Identity.Name.Equals("admin"))
            {
                return RedirectToAction("Champions", "Account");
            }

            //ViewBag.Message = "Modify this template to jump-start your ASP.NET MVC application.";

            return View();
        }
            public SimpleMembershipInitializer()
            {
                Database.SetInitializer<Context>(null);

                try
                {
                    using (var context = new Context())
                    {
                        if (!context.Database.Exists())
                        {
                            // Create the SimpleMembership database without Entity Framework migration schema
                            ((IObjectContextAdapter)context).ObjectContext.CreateDatabase();
                        }
                    }

                    WebSecurity.InitializeDatabaseConnection("Context", "UserProfile", "UserId", "UserName", autoCreateTables: true);
                }
                catch (Exception ex)
                {
                    throw new InvalidOperationException("The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588", ex);
                }
            }
Beispiel #6
0
        public ActionResult List(string date)
        {
            Context ctx = new Context();

            DateTime fecha = DateTime.Now;
            if (date == null)
            {
                fecha = new DateTime(Util.LocalDate.Now.Year, Util.LocalDate.Now.Month, Util.LocalDate.Now.Day);
            }
            else
            {
                fecha = DateTime.Parse(date);
            }

            var userId = (from u in ctx.UserProfiles
                          where u.UserName == User.Identity.Name
                          select u.UserId).SingleOrDefault();

            var userFinalist = (from f in ctx.UserFinalist
                                where f.UserId == userId
                                select f).Count();

            if (userFinalist != 4 && !User.Identity.Name.Equals("admin"))
            {
                return RedirectToAction("Champions", "Account");
            }

            var result = (from p in ctx.Predictions
                          from m in ctx.Matches
                          where p.matchId == m.matchId && p.UserId == userId &&
                          m.matchDate == fecha
                          //&& (Util.LocalDate.Now - m.matchDate).Hours > 2
                          select new { p.predictionId, p.matchId, p.homeResult, p.homePenaltyResult, p.awayResult, p.awayPenaltyResult, m.matchDate, m.stadiumName }).OrderBy(o => o.matchId).ToList();

            List<PredictionMatches> temp = new List<PredictionMatches>();

            foreach (var o in result)
            {
                PredictionMatches p = new PredictionMatches() { matchId = o.matchId, predictionId = o.predictionId,  awayPenaltyResult = o.awayPenaltyResult, matchDate = o.matchDate, awayResult = o.awayResult, stadiumName = o.stadiumName, homeResult = o.homeResult, homePenaltyResult = o.homePenaltyResult  };
                var teamsMatches = (from mt in ctx.MatchesTeam
                                    from te in ctx.Teams
                                    where mt.matchId == o.matchId
                                    && te.teamId == mt.teamId
                                    select new { te.teamImage, te.teamName, mt.teamIsLocal });

                foreach (var i in teamsMatches)
                {
                    if (i.teamIsLocal)
                    {
                        p.HomeTeam = i.teamName;
                        p.HomeFlag = i.teamImage;
                    }
                    else
                    {
                        p.AwayTeam = i.teamName;
                        p.AwayFlag = i.teamImage;
                    }
                }

                temp.Add(p);
            }
            ViewBag.Predictions = temp;
            return View();
        }
Beispiel #7
0
        public ActionResult Modify(Predictions pred)
        {
            Context ctx = new Context();

            var userId = (from u in ctx.UserProfiles
                          where u.UserName == User.Identity.Name
                          select u.UserId).SingleOrDefault();

            var prediction = (from p in ctx.Predictions
                              where p.predictionId == pred.predictionId
                              select p).SingleOrDefault();

            var match = (from m in ctx.Matches
                         where m.matchId == prediction.matchId
                         select m).SingleOrDefault();

            if (DateTime.Compare(Util.LocalDate.Now, match.matchDate)>= 0)
            {
                ModelState.AddModelError("", "No puede modificar las predicciones el mismo día del juego.");
                return RedirectToAction("Modify", "Prediction", new {@id = pred.predictionId});
            }

            if (!userId.Equals(prediction.UserId))
            {
                return RedirectToAction("List", "Prediction");
            }
            //look for a register
            //prediction.matchPenaltyResult = pred.matchPenaltyResult;
            prediction.homeResult = pred.homeResult;
            prediction.homePenaltyResult = pred.homePenaltyResult == null ? 0 : pred.homePenaltyResult;
            prediction.awayResult = pred.awayResult;
            prediction.awayPenaltyResult = pred.awayPenaltyResult == null ? 0 : pred.awayPenaltyResult;
            prediction.matchPredictionModify = Util.LocalDate.Now;
            //prediction.matchResult = pred.matchResult;

            ctx.SaveChanges();
            return RedirectToAction("List", "Prediction");
        }
Beispiel #8
0
        public ActionResult ResetPassword(string userName, string token)
        {
            Context ctx = new Context();
            var userid = (from i in ctx.UserProfiles
                          where i.UserName == userName
                          select i.UserId).FirstOrDefault();

            bool any = (from j in ctx.webpages_Memberships
                        where (j.UserId == userid)
                        && (j.PasswordVerificationToken == token)
                        //&& (j.PasswordVerificationTokenExpirationDate < DateTime.Now)
                        select j).Any();

            if (any == true)
            {
                //generate random password
                string newpassword = Membership.GeneratePassword(10, 4);
                //reset password
                bool response = WebSecurity.ResetPassword(token, newpassword);
                if (response == true)
                {
                    //get user emailid to send password
                    var emailid = (from i in ctx.UserProfiles
                                   where i.UserName == userName
                                   select i.emailAddress).FirstOrDefault();
                    try
                    {
                        //SendEMail(emailid, subject, body);
                        MailMessage mailMsg = new MailMessage();

                        mailMsg.Subject = "Recuperar Contraseña";
                        mailMsg.Body = "La contraseña es " + newpassword;
                        mailMsg.To.Add(new MailAddress(emailid));

                        //mailMsg.AlternateViews.Add(AlternateView.CreateAlternateViewFromString(builder.ToString(), null, MediaTypeNames.Text.Html));
                        mailMsg.IsBodyHtml = false;
                        mailMsg.From = new MailAddress("*****@*****.**");

                        SmtpClient smtpClient = null;
                        smtpClient = new SmtpClient();
                        //smtpClient.Send(new MailMessage("*****@*****.**", user.emailAddress, "Predicciones hechas por los usuarios para el Mundial 2014", string.Empty));
                        smtpClient.Send(mailMsg);

                        TempData["Message"] = "Correo Enviado.";
                    }
                    catch (Exception ex)
                    {
                        TempData["Message"] = "Error enviando el correo. " + ex.Message;
                    }

                    //display message
                    //TempData["Message"] = "Success! Check email we sent. Your New Password Is " + newpassword;
                }
                else
                {
                    //TempData["Message"] = "Hey, avoid random request on this page.";
                }
            }
            else
            {
                TempData["Message"] = "Usuario y token no concuerdan.";
            }

            return RedirectToAction("ForgotPassword", "Account");
        }
Beispiel #9
0
        public ActionResult Modify(int id)
        {
            Context ctx = new Context();

            var user = (from u in ctx.UserProfiles
                        where u.UserName == User.Identity.Name
                        select u).SingleOrDefault();

            var userFinalist = (from f in ctx.UserFinalist
                                where f.UserId == user.UserId
                                select f).Count();

            if (userFinalist != 4 && !User.Identity.Name.Equals("admin"))
            {
                return RedirectToAction("Champions", "Account");
            }

            var model = (from p in ctx.Predictions
                         where p.predictionId == id
                         select p).SingleOrDefault();
            var matchInfo = (from m in ctx.Matches
                             where m.matchId == model.matchId
                             select m).SingleOrDefault();
            ViewBag.MatchInfo = matchInfo.stadiumName + " " + matchInfo.matchDate.ToString("dd/MM/yyyy hh:mm:ss");

            var matchTeams = (from mt in ctx.MatchesTeam
                              from t in ctx.Teams
                              where t.teamId == mt.teamId
                              && mt.matchId == matchInfo.matchId
                              select new { t.teamName, mt.teamIsLocal }).ToList();

            ViewBag.HomeTeam = (from o in matchTeams
                                    where o.teamIsLocal
                                select o.teamName).SingleOrDefault();
            ViewBag.AwayTeam = (from o in matchTeams
                                where !o.teamIsLocal
                                select o.teamName).SingleOrDefault();

            return View(model);
        }
Beispiel #10
0
        public ActionResult Edit(Matches matches, FormCollection form)
        {
            Context ctx = new Context();
            try
            {
                int matchId = int.Parse(form["matchId"].ToString());

                var match = (from m in ctx.Matches
                             where m.matchId == matchId
                             select m).SingleOrDefault();

                match.homeResult = matches.homeResult;
                match.awayResult = matches.awayResult;
                match.Played = true;

                string[] result = null;
                string[] resultPenalty = null;

                if (!match.IsFormula)
                {
                    var teamLocal = (from mt in ctx.MatchesTeam
                                     from t in ctx.Teams
                                     where mt.matchId == matchId &&
                                     t.teamId == mt.teamId &&
                                     mt.teamIsLocal == true
                                     select t).SingleOrDefault();

                    var teamAway = (from mt in ctx.MatchesTeam
                                    from t in ctx.Teams
                                    where mt.matchId == matchId &&
                                     t.teamId == mt.teamId &&
                                     mt.teamIsLocal == false
                                    select t).SingleOrDefault();

                    teamLocal.matchesPlayed += 1;
                    teamAway.matchesPlayed += 1;

                    //result = matches.matchResult.Split(new char[] { '-' });

                    if (match.homeResult > match.awayResult)
                    {
                        teamLocal.matchesWin += 1;
                        teamAway.matchesLoses += 1;

                        teamLocal.goalsFavor += match.homeResult;
                        teamAway.goalsFavor += match.awayResult;

                        teamLocal.goalsAgainst += match.awayResult;
                        teamAway.goalsAgainst += match.homeResult;

                        teamLocal.points += 3;
                        teamAway.points += 0;

                        teamLocal.goalsDifference = teamLocal.goalsFavor - teamLocal.goalsAgainst;
                        teamAway.goalsDifference = teamAway.goalsFavor - teamAway.goalsAgainst;
                    }
                    else if (match.awayResult > match.homeResult)
                    {
                        teamAway.matchesWin += 1;
                        teamLocal.matchesLoses += 1;

                        teamLocal.goalsFavor += match.homeResult;
                        teamAway.goalsFavor += match.awayResult;

                        teamLocal.goalsAgainst += match.awayResult;
                        teamAway.goalsAgainst += match.homeResult;

                        teamAway.points += 3;
                        teamLocal.points += 0;

                        teamLocal.goalsDifference = teamLocal.goalsFavor - teamLocal.goalsAgainst;
                        teamAway.goalsDifference = teamAway.goalsFavor - teamAway.goalsAgainst;

                    }
                    else if (match.awayResult == match.homeResult)
                    {
                        teamAway.matchesDraw += 1;
                        teamLocal.matchesDraw += 1;

                        teamLocal.goalsFavor += match.homeResult;
                        teamAway.goalsFavor += match.awayResult;

                        teamLocal.goalsAgainst += match.awayResult;
                        teamAway.goalsAgainst += match.homeResult;

                        teamAway.points += 1;
                        teamLocal.points += 1;

                        teamLocal.goalsDifference = teamLocal.goalsFavor - teamLocal.goalsAgainst;
                        teamAway.goalsDifference = teamAway.goalsFavor - teamAway.goalsAgainst;
                    }

                }
                else
                {
                    match.homePenaltyResult = matches.homePenaltyResult;
                    match.awayPenaltyResult = matches.awayPenaltyResult;
                }

                var matchProcessed = (from mp in ctx.MatchProcessed
                                      where mp.matchId == matchId
                                      select mp).FirstOrDefault();

                if (matchProcessed == null)
                {
                    ctx.MatchProcessed.Add(new MatchProcessed() { matchId = matchId, matchProcessed = false });
                }
                else
                {
                    if (!matchProcessed.matchProcessed)
                    {
                        matchProcessed.matchProcessed = false;
                    }
                }

            }
            catch (Exception ex)
            {
                var changedEntities = ctx.ChangeTracker.Entries().Where(x => x.State != System.Data.EntityState.Unchanged);

                foreach (var entry in changedEntities.Where(x => x.State == System.Data.EntityState.Modified))
                {
                    entry.CurrentValues.SetValues(entry.OriginalValues);
                    entry.State = System.Data.EntityState.Unchanged;
                }

                foreach (var entry in changedEntities.Where(x => x.State == System.Data.EntityState.Added))
                {
                    entry.State = System.Data.EntityState.Detached;
                }

                foreach (var entry in changedEntities.Where(x => x.State == System.Data.EntityState.Deleted))
                {
                    entry.State = System.Data.EntityState.Unchanged;
                }
            }

            ctx.SaveChanges();

            return RedirectToAction("List", "Match");
        }
Beispiel #11
0
        public ActionResult AuthorizeUser(int id)
        {
            Context ctx = new Context();

            var users = (from u in ctx.UserProfiles
                         where u.UserId == id
                         select u).SingleOrDefault();

            users.isActive = true;

            ctx.SaveChanges();

            return RedirectToAction("Authorize", "Account");
        }
Beispiel #12
0
        public ActionResult List()
        {
            Context ctx = new Context();

            var user = (from u in ctx.UserProfiles
                        where u.UserName == User.Identity.Name
                        select u).SingleOrDefault();

            var userFinalist = (from f in ctx.UserFinalist
                                where f.UserId == user.UserId
                                select f).Count();

            if (userFinalist != 4 && !User.Identity.Name.Equals("admin"))
            {
                return RedirectToAction("Champions", "Account");
            }

            ViewBag.List = (from u in ctx.UserProfiles
                            where u.UserName != "admin"
                            select u).OrderByDescending(o => o.pointsEarned).ToList();
            return View();
        }
Beispiel #13
0
        public ActionResult SendEmails()
        {
            Context ctx = new Context();
            var users = (from u in ctx.UserProfiles
                         where u.UserName != "admin"
                         select u).ToList();

            MailMessage mailMsg = new MailMessage();
            StringBuilder builder = new StringBuilder();
            List<string> adresses = new List<string>();
            foreach (var user in users)
            {
                mailMsg.To.Add(new MailAddress(user.emailAddress, user.userCompleteName));
            }

            foreach (var user in users)
            {
                builder.Append("<h2>"+ user.userCompleteName + "</h2><br>");
                HtmlTable table = new HtmlTable();
                var predictions = (from p in ctx.Predictions
                                   from m in ctx.Matches
                           where p.UserId == user.UserId &&
                           p.matchPredictionModify != null &&
                           p.matchId == m.matchId &&
                           m.matchDate.Year == Util.LocalDate.Now.Year &&
                           m.matchDate.Month == Util.LocalDate.Now.Month &&
                           m.matchDate.Day == Util.LocalDate.Now.Day
                           select p).ToList();
                HtmlTableRow row = new HtmlTableRow();
                GenerateColumns(row);
                table.Rows.Add(row);

                foreach (var prediction in predictions)
                {
                    row = new HtmlTableRow();
                    HtmlTableCell cell = new HtmlTableCell();
                    cell.InnerText = prediction.predictionId.ToString();
                    row.Cells.Add(cell);

                    cell = new HtmlTableCell();
                    cell.InnerText = prediction.matchId.ToString();
                    row.Cells.Add(cell);

                    var matchInfo = (from m in ctx.Matches
                                     where m.matchId == prediction.matchId
                                     select m).SingleOrDefault();

                    cell = new HtmlTableCell();
                    cell.InnerText = matchInfo.stadiumName;
                    row.Cells.Add(cell);

                    cell = new HtmlTableCell();
                    cell.InnerText = matchInfo.matchDate.ToString("dd/MM/yyyy");
                    row.Cells.Add(cell);

                    var local = (from mt in ctx.MatchesTeam
                                 from t in ctx.Teams
                                 where mt.matchId == matchInfo.matchId
                                 && mt.teamId == t.teamId
                                 && mt.teamIsLocal == true
                                 select t).SingleOrDefault();

                    cell = new HtmlTableCell();
                    cell.InnerText = local.teamName;
                    row.Cells.Add(cell);

                    cell = new HtmlTableCell();
                    cell.InnerText = prediction.homeResult.ToString();
                    row.Cells.Add(cell);

                    cell = new HtmlTableCell();
                    cell.InnerText = prediction.homePenaltyResult.ToString();
                    row.Cells.Add(cell);

                    var visitor = (from mt in ctx.MatchesTeam
                                 from t in ctx.Teams
                                 where mt.matchId == matchInfo.matchId
                                 && mt.teamId == t.teamId
                                 && mt.teamIsLocal == false
                                 select t).SingleOrDefault();

                    cell = new HtmlTableCell();
                    cell.InnerText = visitor.teamName;
                    row.Cells.Add(cell);

                    cell = new HtmlTableCell();
                    cell.InnerText = prediction.awayResult.ToString();
                    row.Cells.Add(cell);

                    cell = new HtmlTableCell();
                    cell.InnerText = prediction.awayPenaltyResult.ToString();
                    row.Cells.Add(cell);

                    cell = new HtmlTableCell();
                    cell.InnerText = prediction.matchPredictionModify.ToString();
                    row.Cells.Add(cell);

                    table.Rows.Add(row);
                }
                StringBuilder sb = new StringBuilder();
                StringWriter tw = new StringWriter(sb);
                HtmlTextWriter hw = new HtmlTextWriter(tw);
                table.RenderControl(hw);

                builder.Append(sb.ToString());
                builder.Append("<br>");
            }

            mailMsg.AlternateViews.Add(AlternateView.CreateAlternateViewFromString(builder.ToString(), null, MediaTypeNames.Text.Html));
            mailMsg.IsBodyHtml = true;
            mailMsg.From = new MailAddress("*****@*****.**");
            //mailMsg.To.Add(new MailAddress(user.emailAddress));
            mailMsg.Subject = "Predicciones hechas por los usuarios para el Mundial 2014";

            SmtpClient smtpClient = null;
            smtpClient = new SmtpClient();
            //smtpClient.Send(new MailMessage("*****@*****.**", user.emailAddress, "Predicciones hechas por los usuarios para el Mundial 2014", string.Empty));
            smtpClient.Send(mailMsg);

            return RedirectToAction("Index", "Home");
        }
Beispiel #14
0
        public ActionResult ApplyFormulaMatch(int id)
        {
            Context ctx = new Context();

            var match = (from m in ctx.Matches
                         where m.matchId == id
                         select m).FirstOrDefault();
            string formula = string.Empty;
            if (match.IsFormula)
            {
                if (match.formulaByGroups)
                {
                    formula = match.formula;
                    string[] groups = formula.Split(new char[] { '-' });

                    var firstLeg = (from g in ctx.Groups
                               from t in ctx.Teams
                               where g.groupName.Contains(" " + groups[0].Substring(0, 1))
                               && t.groupId == g.groupId
                               select t).OrderByDescending(o => o.points).ThenByDescending(o => o.goalsDifference).ThenByDescending(o => o.goalsFavor).ThenByDescending(o => o.goalsAgainst).ToList();

                    var secondLeg = (from g in ctx.Groups
                                     from t in ctx.Teams
                                     where g.groupName.Contains(" " + groups[1].Substring(0, 1))
                                     && t.groupId == g.groupId
                                     select t).OrderByDescending(o => o.points).ThenByDescending(o => o.goalsDifference).ThenByDescending(o => o.goalsFavor).ThenByDescending(o => o.goalsAgainst).ToList();

                    Teams teamId1 = null;
                    Teams teamId2 = null;

                    if (groups[0].Substring(1, 1).ToString().Equals("1"))
                        teamId1 = firstLeg.FirstOrDefault();
                    else
                        teamId1 = firstLeg.Skip(1).Take(1).SingleOrDefault();

                    if(groups[1].Substring(1, 1).ToString().Equals("1"))
                         teamId2 = secondLeg.FirstOrDefault();
                    else
                        teamId2 = secondLeg.Skip(1).Take(1).SingleOrDefault();

                    MatchesTeam mt = new MatchesTeam();
                    mt.matchId = match.matchId;
                    mt.teamId = teamId1.teamId;
                    mt.teamIsLocal = true;
                    ctx.MatchesTeam.Add(mt);

                    mt = new MatchesTeam();
                    mt.matchId = match.matchId;
                    mt.teamId = teamId2.teamId;
                    mt.teamIsLocal = false;
                    ctx.MatchesTeam.Add(mt);

                }
                else
                {
                    formula = match.formula;
                    string[] games = formula.Split(new char[] { '-' });

                    int matchFormula = 0;

                    if (games[0].Substring(0, 1).ToString().Equals("W"))
                    {
                        matchFormula = int.Parse(games[0].Substring(1, 2).ToString());

                        var matchResult = (from m in ctx.Matches
                                           where m.matchId == matchFormula
                                           select m).FirstOrDefault();

                    }
                    else
                    { }
                }

                ctx.SaveChanges();

                return View();
            }
            else
            {
                return RedirectToAction("Index", "Home");
            }
        }
Beispiel #15
0
        public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl)
        {
            string provider = null;
            string providerUserId = null;

            if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId))
            {
                return RedirectToAction("Manage");
            }

            if (ModelState.IsValid)
            {
                // Insert a new user into the database
                using (Context db = new Context())
                {
                    UserProfile user = db.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == model.UserName.ToLower());
                    //Check if user already exists
                    if (user == null)
                    {
                        // Insert name into the profile table
                        db.UserProfiles.Add(new UserProfile { UserName = model.UserName });
                        db.SaveChanges();

                        OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName);
                        OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false);

                        return RedirectToLocal(returnUrl);
                    }
                    else
                    {
                        ModelState.AddModelError("UserName", "User name already exists. Please enter a different user name.");
                    }
                }
            }

            ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName;
            ViewBag.ReturnUrl = returnUrl;
            return View(model);
        }
Beispiel #16
0
        public ActionResult Champions()
        {
            Context ctx = new Context();
            var user = (from u in ctx.UserProfiles
                        where u.UserName == User.Identity.Name
                        select u).SingleOrDefault();

            var teams = (from t in ctx.Teams
                         select t).OrderBy(o => o.teamId).FirstOrDefault();
            List<UserFinalist> userFinalist = new List<UserFinalist>();
            for (int i = 1; i <= 4; i++)
            {
                UserFinalist f = new UserFinalist();
                f.position = i;
                f.teamId = teams.teamId;
                f.UserId = user.UserId;
                userFinalist.Add(f);
            }
            ViewBag.UserFinalist = userFinalist;

            var teamsList = ( from t in ctx.Teams
                          select t).OrderBy(o => o.teamId).ToList();
            List<SelectListItem> list = new List<SelectListItem>();
            foreach(Teams t in teamsList)
            {
                list.Add(new SelectListItem() { Value = t.teamId.ToString(), Text = t.teamName });
            }

            ViewBag.Teams = list;

            return View();
            //return View();
        }
Beispiel #17
0
        public ActionResult Champions(FormCollection form)
        {
            Context ctx = new Context();

            var users = (from u in ctx.UserProfiles
                         where u.UserName == User.Identity.Name
                         select u).SingleOrDefault();

            int team1 = int.Parse(form[form.Keys.Get(1)].ToString());
            int team2 = int.Parse(form[form.Keys.Get(2)].ToString());
            int team3 = int.Parse(form[form.Keys.Get(3)].ToString());
            int team4 = int.Parse(form[form.Keys.Get(4)].ToString());

            List<Int32> teams = new List<int>();
            teams.Add(team1);

            if (teams.Contains(team2))
            {
                ModelState.AddModelError("", "Revise los finalistas no puede haber repetidos.");
                return RedirectToAction("Champions", "Account");
            }

            if (teams.Contains(team3))
            {
                ModelState.AddModelError("", "Revise los finalistas no puede haber repetidos.");
                return RedirectToAction("Champions", "Account");
            }

            if (teams.Contains(team4))
            {
                ModelState.AddModelError("", "Revise los finalistas no puede haber repetidos.");
                return RedirectToAction("Champions", "Account");
            }

            ctx.UserFinalist.Add(new UserFinalist() { position = 1, teamId = team1, UserId = users.UserId });
            ctx.UserFinalist.Add(new UserFinalist() { position = 2, teamId = team2, UserId = users.UserId });
            ctx.UserFinalist.Add(new UserFinalist() { position = 3, teamId = team3, UserId = users.UserId });
            ctx.UserFinalist.Add(new UserFinalist() { position = 4, teamId = team4, UserId = users.UserId });

            ctx.SaveChanges();

            return RedirectToAction("Index", "Home");
        }
Beispiel #18
0
        public ActionResult Calculate()
        {
            Context ctx = new Context();
            int matchResult = 0;
            //int matchPenalty = 0;

            int matchPredictionResult = 0;
            //int matchPredictionPenalty = 0;

            bool isDraw = false;
            //get users
            var users = (from u in ctx.UserProfiles
                         where u.UserName != "admin" &&
                         u.isActive == true
                         select u).ToList();

            ////get list of matches processed
            //var matchesProcessed = (from mp in ctx.MatchProcessed
            //                        where mp.matchProcessed == false
            //                        select mp.matchId).ToList();

            //running users
            foreach (UserProfile up in users)
            {
                //get predictions form users
                var predictions = (from p in ctx.Predictions
                                   from m in ctx.Matches
                                   from mp in ctx.MatchProcessed
                                   where p.UserId == up.UserId
                                   && m.matchId == p.matchId
                                   && p.matchPredictionModify != null
                                   && mp.matchId == p.matchId
                                   && mp.matchProcessed == false
                                   select p).OrderBy(o => o.matchId).ToList();

                foreach (Predictions p in predictions)
                {
                    var match = (from m in ctx.Matches
                                 where m.matchId == p.matchId
                                 select m).FirstOrDefault();

                    matchResult = match.homeResult - match.awayResult;

                    matchPredictionResult = p.homeResult - p.awayResult;

                    //Draw
                    if (matchResult == 0 && matchPredictionResult == 0)
                    {
                        up.pointsEarned += 5;

                        if (match.homeResult == p.homeResult && match.awayResult == p.awayResult)
                        {
                            up.pointsEarned += 5;
                        }
                        isDraw = true;
                    }
                    //local win
                    if (matchResult > 0 && matchPredictionResult > 0)
                    {
                        up.pointsEarned += 5;
                        if (match.homeResult == p.homeResult && match.awayResult == p.awayResult)
                        {
                            up.pointsEarned += 5;
                        }
                        isDraw = false;
                    }
                    //away win
                    if (matchResult < 0 && matchPredictionResult < 0)
                    {
                        up.pointsEarned += 5;
                        if (match.homeResult == p.homeResult && match.awayResult == p.awayResult)
                        {
                            up.pointsEarned += 5;
                        }
                        isDraw = false;
                    }

                    if (match.IsFormula && isDraw)
                    {
                        //validate penalties
                        if (match.homePenaltyResult == p.homePenaltyResult && match.awayPenaltyResult == p.awayPenaltyResult)
                        {
                            up.pointsEarned += 5;
                        }
                    }

                    if (match.matchId >= 63)
                    {
                        //validate the finalist

                        var finalistThird = (from f in ctx.UserFinalist
                                        where f.UserId == up.UserId
                                        && f.position == (match.matchId == 63 ? 3 : 1)
                                        select f).FirstOrDefault();

                        var finalistFourth = (from f in ctx.UserFinalist
                                             where f.UserId == up.UserId
                                             && f.position == (match.matchId == 63 ? 4 : 2)
                                             select f).FirstOrDefault();

                        if (!isDraw)
                        {
                            matchResult = match.homeResult - match.awayResult;
                            if (matchResult < 0)
                            {
                                var teamWinner = (from mt in ctx.MatchesTeam
                                            where mt.matchId == match.matchId
                                            && !mt.teamIsLocal
                                            select mt).FirstOrDefault();

                                var teamLoser = (from mt in ctx.MatchesTeam
                                                  where mt.matchId == match.matchId
                                                  && mt.teamIsLocal
                                                  select mt).FirstOrDefault();

                                if (finalistThird.teamId == teamWinner.teamId)
                                {
                                    if (match.matchId == 63)
                                        up.pointsEarned += 50;
                                    else
                                        up.pointsEarned += 100;
                                }
                                else if (finalistFourth.teamId == teamLoser.teamId)
                                {
                                    if (match.matchId == 63)
                                        up.pointsEarned += 25;
                                    else
                                        up.pointsEarned += 75;
                                }
                            }
                            else
                            {
                                var teamWinner = (from mt in ctx.MatchesTeam
                                                  where mt.matchId == match.matchId
                                                  && mt.teamIsLocal
                                                  select mt).FirstOrDefault();

                                var teamLoser = (from mt in ctx.MatchesTeam
                                                 where mt.matchId == match.matchId
                                                 && !mt.teamIsLocal
                                                 select mt).FirstOrDefault();

                                if (finalistThird.teamId == teamWinner.teamId)
                                {
                                    if (match.matchId == 63)
                                        up.pointsEarned += 50;
                                    else
                                        up.pointsEarned += 100;
                                }
                                else if (finalistFourth.teamId == teamLoser.teamId)
                                {
                                    if (match.matchId == 63)
                                        up.pointsEarned += 25;
                                    else
                                        up.pointsEarned += 75;
                                }
                            }
                        }
                        else
                        {
                            matchResult = match.homePenaltyResult - match.awayPenaltyResult;
                            if (matchResult < 0)
                            {
                                var teamWinner = (from mt in ctx.MatchesTeam
                                                  where mt.matchId == match.matchId
                                                  && !mt.teamIsLocal
                                                  select mt).FirstOrDefault();

                                var teamLoser = (from mt in ctx.MatchesTeam
                                                 where mt.matchId == match.matchId
                                                 && mt.teamIsLocal
                                                 select mt).FirstOrDefault();

                                if (finalistThird.teamId == teamWinner.teamId)
                                {
                                    if (match.matchId == 63)
                                        up.pointsEarned += 50;
                                    else
                                        up.pointsEarned += 100;
                                }
                                else if (finalistFourth.teamId == teamLoser.teamId)
                                {
                                    if (match.matchId == 63)
                                        up.pointsEarned += 25;
                                    else
                                        up.pointsEarned += 75;
                                }
                            }
                            else
                            {
                                var teamWinner = (from mt in ctx.MatchesTeam
                                                  where mt.matchId == match.matchId
                                                  && mt.teamIsLocal
                                                  select mt).FirstOrDefault();

                                var teamLoser = (from mt in ctx.MatchesTeam
                                                 where mt.matchId == match.matchId
                                                 && !mt.teamIsLocal
                                                 select mt).FirstOrDefault();

                                if (finalistThird.teamId == teamWinner.teamId)
                                {
                                    if (match.matchId == 63)
                                        up.pointsEarned += 50;
                                    else
                                        up.pointsEarned += 100;
                                }
                                else if (finalistFourth.teamId == teamLoser.teamId)
                                {
                                    if (match.matchId == 63)
                                        up.pointsEarned += 25;
                                    else
                                        up.pointsEarned += 75;
                                }
                            }
                        }
                    }

                    var matchProcess = (from mp in ctx.MatchProcessed
                                        where mp.matchId == match.matchId
                                        && mp.matchProcessed == false
                                        select mp).FirstOrDefault();
                    matchProcess.matchProcessed = true;
                }

            }

            ctx.SaveChanges();
            return RedirectToAction("List", "Account");
        }
Beispiel #19
0
        public ActionResult UserData(int id)
        {
            Context ctx = new Context();

            var user = (from u in ctx.UserProfiles
                        where u.UserName == User.Identity.Name
                        select u).SingleOrDefault();

            var userFinalist = (from f in ctx.UserFinalist
                                where f.UserId == user.UserId
                                select f).Count();

            if (userFinalist != 4 && !User.Identity.Name.Equals("admin"))
            {
                return RedirectToAction("Champions", "Account");
            }

            var finalist = (from uf in ctx.UserFinalist
                            from t in ctx.Teams
                            where uf.UserId == id &&
                            t.teamId == uf.teamId
                            select new FinalistModel
                            {
                                position = uf.position,
                                teamName = t.teamName,
                                teamImage = t.teamImage
                            }).OrderBy(o => o.position).ToList();

            ViewData["FinalistasUsuario"] = finalist;

            var predictions = (from p in ctx.Predictions
                               from ma in ctx.Matches
                               where p.UserId == id &&
                               ma.matchId == p.matchId &&
                               p.matchPredictionModify != null
                               select new PredictionUser
                                {
                                   predictionId = p.predictionId,
                                            matchId = ma.matchId,
                                            Stadium = ma.stadiumName,
                                            matchDate = ma.matchDate,
                                            teamHome = string.Empty,
                                            teamHomeImage = string.Empty,
                                            teamHomeResult = p.homeResult,
                                            temaHomePResult = p.homePenaltyResult,
                                            teamAway = string.Empty,
                                            teamAwayImage = string.Empty,
                                            teamAwayResult = p.awayResult,
                                            temaAwayPResult = p.awayPenaltyResult,
                               }).OrderBy(o => o.predictionId).ToList();

            foreach (var obj in predictions)
            {
                obj.teamHome = (from mt in ctx.MatchesTeam
                                from t in ctx.Teams
                                where mt.matchId == obj.matchId
                                && t.teamId == mt.teamId
                                && mt.teamIsLocal == true
                                select t.teamName).FirstOrDefault();
                obj.teamHomeImage = (from mt in ctx.MatchesTeam
                                from t in ctx.Teams
                                where mt.matchId == obj.matchId
                                && t.teamId == mt.teamId
                                && mt.teamIsLocal == true
                                select t.teamImage).FirstOrDefault();

                obj.teamAway = (from mt in ctx.MatchesTeam
                                from t in ctx.Teams
                                where mt.matchId == obj.matchId
                                && t.teamId == mt.teamId
                                && mt.teamIsLocal == false
                                select t.teamName).FirstOrDefault();
                obj.teamAwayImage = (from mt in ctx.MatchesTeam
                                     from t in ctx.Teams
                                     where mt.matchId == obj.matchId
                                     && t.teamId == mt.teamId
                                     && mt.teamIsLocal == false
                                     select t.teamImage).FirstOrDefault();
            }

            var userData = (from u in ctx.UserProfiles
                            where u.UserId == id
                            select u.userCompleteName).FirstOrDefault();

            ViewBag.Title = "Finalistas y Predicciones del Usuario " + userData;
            ViewData["Predictions"] = predictions;

            return View();
        }
Beispiel #20
0
        public ActionResult Index()
        {
            Context ctx = new Context();

            var user = (from u in ctx.UserProfiles
                        where u.UserName == User.Identity.Name
                        select u).SingleOrDefault();

            var userFinalist = (from f in ctx.UserFinalist
                                where f.UserId == user.UserId
                                select f).Count();

            if (userFinalist != 4 && !User.Identity.Name.Equals("admin"))
            {
                return RedirectToAction("Champions", "Account");
            }

            var groups = (from g in ctx.Groups
                          select g).ToList();

            ViewBag.Groups = groups;

            foreach (Groups g in groups)
            {
                switch (g.groupId)
                {
                    case 1:

                        var GroupA = (from t in ctx.Teams
                                      where t.groupId == g.groupId
                                      select t).OrderByDescending(o => o.points).ThenByDescending(o => o.goalsDifference).ThenByDescending(o => o.goalsFavor).ThenByDescending(o => o.goalsAgainst).ToList();

                        ViewBag.GroupA = GroupA;
                        break;

                    case 2:

                        var GroupB = (from t in ctx.Teams
                                      where t.groupId == g.groupId
                                      select t).OrderByDescending(o => o.points).ThenByDescending(o => o.goalsDifference).ThenByDescending(o => o.goalsFavor).ThenByDescending(o => o.goalsAgainst).ToList();

                        ViewBag.GroupB = GroupB;
                        break;

                    case 3:

                        var GroupC = (from t in ctx.Teams
                                      where t.groupId == g.groupId
                                      select t).OrderByDescending(o => o.points).ThenByDescending(o => o.goalsDifference).ThenByDescending(o => o.goalsFavor).ThenByDescending(o => o.goalsAgainst).ToList();

                        ViewBag.GroupC = GroupC;
                        break;

                    case 4:

                        var GroupD = (from t in ctx.Teams
                                      where t.groupId == g.groupId
                                      select t).OrderByDescending(o => o.points).ThenByDescending(o => o.goalsDifference).ThenByDescending(o => o.goalsFavor).ThenByDescending(o => o.goalsAgainst).ToList();

                        ViewBag.GroupD = GroupD;
                        break;

                    case 5:

                        var GroupE = (from t in ctx.Teams
                                      where t.groupId == g.groupId
                                      select t).OrderByDescending(o => o.points).ThenByDescending(o => o.goalsDifference).ThenByDescending(o => o.goalsFavor).ThenByDescending(o => o.goalsAgainst).ToList();

                        ViewBag.GroupE = GroupE;
                        break;

                    case 6:

                        var GroupF = (from t in ctx.Teams
                                      where t.groupId == g.groupId
                                      select t).OrderByDescending(o => o.points).ThenByDescending(o => o.goalsDifference).ThenByDescending(o => o.goalsFavor).ThenByDescending(o => o.goalsAgainst).ToList();

                        ViewBag.GroupF = GroupF;
                        break;

                    case 7:

                        var GroupG = (from t in ctx.Teams
                                      where t.groupId == g.groupId
                                      select t).OrderByDescending(o => o.points).ThenByDescending(o => o.goalsDifference).ThenByDescending(o => o.goalsFavor).ThenByDescending(o => o.goalsAgainst).ToList();

                        ViewBag.GroupG = GroupG;
                        break;

                    case 8:

                        var GroupH = (from t in ctx.Teams
                                      where t.groupId == g.groupId
                                      select t).OrderByDescending(o => o.points).ThenByDescending(o => o.goalsDifference).ThenByDescending(o => o.goalsFavor).ThenByDescending(o => o.goalsAgainst).ToList();

                        ViewBag.GroupH = GroupH;
                        break;
                }
            }

            return View();
        }
Beispiel #21
0
        public ActionResult List(string date)
        {
            DateTime fecha = DateTime.Now;
            if (date == null)
            {
                fecha = new DateTime(Util.LocalDate.Now.Year, Util.LocalDate.Now.Month, Util.LocalDate.Now.Day);
            }
            else
            {
                fecha = DateTime.Parse(date);
            }

            Context ctx = new Context();
            var matches = (from m in ctx.Matches
                           where m.matchDate == fecha
                           select new ModifyMatches() { matchId = m.matchId, matchDate = m.matchDate, matchNumber = m.matchNumber, stadiumName = m.stadiumName, matchResult = string.Empty, matchPenaltyResult = string.Empty }).OrderBy(o => o.matchId).ToList();

            foreach (ModifyMatches m in matches)
            {
                var teams = (from mt in ctx.MatchesTeam
                             from t in ctx.Teams
                             where mt.matchId == m.matchId
                             && t.teamId == mt.teamId
                             select new { mt.teamIsLocal, t.teamName, t.teamImage });

                var results = (from ma in ctx.Matches
                                 where ma.matchId == m.matchId
                                 select ma).SingleOrDefault();
                m.matchResult = results.homeResult.ToString() + "-" + results.awayResult.ToString();

                m.matchPenaltyResult = results.homePenaltyResult.ToString() + "-" + results.awayPenaltyResult.ToString();

                foreach (var obj in teams)
                {
                    if (obj.teamIsLocal)
                    {
                        m.HomeFlag = obj.teamImage;
                        m.HomeTeam = obj.teamName;
                    }
                    else
                    {
                        m.AwayFlag = obj.teamImage;
                        m.AwayTeam = obj.teamName;
                    }
                }
            }

            ViewBag.Matches = matches;
            return View();
        }
Beispiel #22
0
        public ActionResult Register(RegisterModel model)
        {
            if (ModelState.IsValid)
            {
                // Attempt to register the user
                try
                {
                    Context ctx = new Context();
                    WebSecurity.CreateUserAndAccount(model.UserName, model.Password);

                    var userProfile = (from u in ctx.UserProfiles
                                       where u.UserName == model.UserName
                                       select u).SingleOrDefault();

                    userProfile.isActive = model.UserName.Equals("admin") ? true : false;
                    userProfile.pointsEarned = 0;
                    userProfile.userCompleteName = model.userCompleteName;
                    userProfile.emailAddress = model.emailAddress;

                    if (model.UserName != "admin")
                    {
                        var matches = (from m in ctx.Matches
                                       select m).OrderBy(o => o.matchNumber).ToList();

                        foreach (Matches m in matches)
                        {
                            var prediction = new Predictions();
                            prediction.matchId = m.matchId;
                            prediction.awayPenaltyResult = 0;
                            prediction.homePenaltyResult = 0;
                            prediction.homeResult = 0;
                            prediction.awayResult = 0;
                            prediction.matchPredictionCreateDate = Util.LocalDate.Now;
                            prediction.UserId = userProfile.UserId;
                            ctx.Predictions.Add(prediction);
                        }
                    }
                    ctx.SaveChanges();
                    //WebSecurity.Login(model.UserName, model.Password);
                    return RedirectToAction("Login", "Account");
                }
                catch (MembershipCreateUserException e)
                {
                    ModelState.AddModelError("", ErrorCodeToString(e.StatusCode));
                }
            }

            // If we got this far, something failed, redisplay form
            return View(model);
        }
Beispiel #23
0
 //
 // GET: /Match/
 public ActionResult Edit(int id)
 {
     Context ctx = new Context();
     return View((from m in ctx.Matches
                  where m.matchId == id
                  select m).SingleOrDefault());
 }
Beispiel #24
0
        public ActionResult ResetAll()
        {
            Context ctx = new Context();
            var matchesProcessed = (from mp in ctx.MatchProcessed
                                    select mp).ToList();

            foreach (var mp in matchesProcessed)
            {
                ctx.MatchProcessed.Remove(mp);
            }

            var users = (from u in ctx.UserProfiles
                         where u.UserName != "admin"
                         select u).ToList();

            foreach (var user in users)
            {
                user.pointsEarned = 0;
            }

            //Remove teams stadistics

            var teams = (from t in ctx.Teams
                         select t).ToList();

            foreach (var team in teams)
            {
                team.goalsAgainst = 0;
                team.goalsDifference = 0;
                team.goalsFavor = 0;
                team.matchesDraw = 0;
                team.matchesLoses = 0;
                team.matchesPlayed = 0;
                team.matchesWin = 0;
                team.points = 0;
            }

            ctx.SaveChanges();

            return RedirectToAction("Index", "Home");
        }
Beispiel #25
0
        public ActionResult Login(LoginModel model, string returnUrl)
        {
            Context ctx = new Context();

            if (ModelState.IsValid && WebSecurity.Login(model.UserName, model.Password, persistCookie: model.RememberMe))
            {
                var user = (from u in ctx.UserProfiles
                            where u.UserName == model.UserName
                            select u).SingleOrDefault();

                if (!user.isActive)
                {
                    WebSecurity.Logout();
                    ModelState.AddModelError("", "Usuario no activo");
                    return View(model);
                }

                return RedirectToLocal(returnUrl);
            }

            // If we got this far, something failed, redisplay form
            ModelState.AddModelError("", "El usuario y contraseña proporcionados no son correctos.");
            return View(model);
        }
Beispiel #26
0
        public ActionResult Authorize()
        {
            Context ctx = new Context();
            var users = (from u in ctx.UserProfiles
                         where !u.isActive
                         select u).ToList();

            ViewBag.Users = users;
            return View();
        }