public ActionResult CreateGame()
 {
     UsersContext ctx = new UsersContext();
     var q = from users in ctx.UserProfiles
             select users;
     List<string> UserList = q.Select(u => u.UserName).ToList();
     if (!WebSecurity.IsAuthenticated) return RedirectToAction("ErrorPage", new { ErrorMessage = "You are not logged in. Only registered users can create a new game"});
     ViewBag.testList = UserList;
     return View();
 }
 public ActionResult CreateGame(List<String> ListBox, String player0, String player1, String player2, String player3, String player4, String player5, String player6)
 {
     if (!WebSecurity.IsAuthenticated) return RedirectToAction("ErrorPage", new { ErrorMessage = "You must be logged in to create a game" });
     string CurrentUserMail = GetUserEmail(WebSecurity.CurrentUserName);
     RequestHandler rh = new RequestHandler();
     rh.RegisterUserAsync(CurrentUserMail, false);
     List<string> listOfUsers = new List<string>();
     listOfUsers.Add(CurrentUserMail);
     if (ListBox != null)
     {
         foreach (var item in ListBox)
         {
             string uMail = GetUserEmail(item);
             rh.RegisterUserAsync(uMail, false);
             if (!listOfUsers.Contains(uMail)) listOfUsers.Add(uMail);
         }
     }
     String[] paramHolder = new String[7] { player0, player1, player2, player3, player4, player5, player6 };
     foreach (var item in paramHolder)
     {
         if (item != "")
         {
             if (IsEmailRegistered(item))
             {
                 rh.RegisterUserAsync(item, false);
             }
             else
             {
                 rh.RegisterUserAsync(item, true);
             }
             if (!listOfUsers.Contains(item)) listOfUsers.Add(item);
         }
     }
     UsersContext ctxu = new UsersContext();
     var qu = from users in ctxu.UserProfiles
              select users;
     List<string> UserList = qu.Select(u => u.UserName).ToList();
     ViewBag.testList = UserList;
     if (listOfUsers.Count > 8 || listOfUsers.Count == 0)
     {
         ViewBag.Error = true;
         ViewBag.ErrorMessage = "You can not add more than 7 players";
         return View();
     }
     //If we get here we can create the game
     rh.CreateGameAsync(listOfUsers);
     return RedirectToAction("Index");
 }
            public SimpleMembershipInitializer()
            {
                Database.SetInitializer<UsersContext>(null);

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

                    WebSecurity.InitializeDatabaseConnection("DefaultConnection", "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);
                }
            }
 public bool IsEmailRegistered(string userEmail)
 {
     using (UsersContext ctx = new UsersContext())
     {
         var q = from users in ctx.UserProfiles
                 where users.UserEMail == userEmail
                 select users;
         if (q.Count() > 0) return true;
         else return false;
     }
 }
 public string GetUserName(string userEmail)
 {
     string userName = "";
     using (UsersContext ctx = new UsersContext())
     {
         var q = from users in ctx.UserProfiles
                 where users.UserEMail == userEmail
                 select users.UserName;
         if (q.Count() > 0) userName = q.Single();
     }
     return userName;
 }
        public ActionResult Register(RegisterModel model)
        {
            if (ModelState.IsValid)
            {
                // Attempt to register the user
                try
                {
                    WebSecurity.CreateUserAndAccount(model.UserName, model.Password);
                    WebSecurity.Login(model.UserName, model.Password);
                    using (UsersContext ctx = new UsersContext())
                    {
                        ctx.UserProfiles.First(x => x.UserName == model.UserName).UserEMail = model.EMail;
                        ctx.SaveChanges();
                    }
                    RequestHandler rh = new RequestHandler();
                    rh.RegisterUserAsync(model.EMail, false);
                    return RedirectToAction("Index", "Home");
                }
                catch (MembershipCreateUserException e)
                {
                    ModelState.AddModelError("", ErrorCodeToString(e.StatusCode));
                }
            }

            // If we got this far, something failed, redisplay form
            return View(model);
        }
        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 (UsersContext db = new UsersContext())
                {
                    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);
        }