//Insert statement to add a new user
 private static void CreateNewUser(RegisterModel model)
 {
     //Entity Framework classes generated by the database schema are used to insert into the database
     var db = new GameReviewWebsiteEntities();
     db.Gamers.Add(new Gamer()
                       {
                           Biography = model.Bio,
                           Name = model.UserName,
                           Password = model.Password
                       });
     db.SaveChanges();
 }
        public ActionResult Register(RegisterModel model)
        {
            if (ModelState.IsValid)
            {
                try
                {
                    CreateNewUser(model);
                    WebSecurity.Login(model.UserName, model.Password);
                    return RedirectToAction("Index", "GameReviews");
                }
                catch (MembershipCreateUserException e)
                {
                    ModelState.AddModelError("", ErrorCodeToString(e.StatusCode));
                }
            }

            return View(model);
        }