public ActionResult DeleteConfirmed(int id) { using (PlayersEntities players = new PlayersEntities()) { Player player = players.Players.Find(id); var games = player.Games.ToList(); var roles = player.PlayerRoles.ToList(); foreach (var game in games) { player.Games.Remove(game); } var role = player.PlayerRoles.FirstOrDefault(r1 => r1.PlayerId == player.Id); if (role.Role.Id == 2) { players.PlayerRoles.Remove(role); } players.Players.Remove(player); players.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Index() { using (PlayersEntities players = new PlayersEntities()) { return(View()); } }
public ActionResult Login([Bind(Include = "Email,Password")] Player player) { if (ModelState.IsValid) { using (PlayersEntities players = new PlayersEntities()) { Player user = players.Players.FirstOrDefault(r => r.Password == player.Password && r.Email == player.Email); if (user != null) { var role = user.PlayerRoles.FirstOrDefault(r => r.Role.Name == "Admin"); var roleUser = user.PlayerRoles.FirstOrDefault(r => r.Role.Name == "Player"); if (role != null) { FormsAuthentication.SetAuthCookie(user.Username, false); return(RedirectToAction("index", "Home")); } else if (roleUser != null) { FormsAuthentication.SetAuthCookie(user.Username, false); return(RedirectToAction("about", "Home")); } } } } return(View(player)); }
public ActionResult Index() { using (PlayersEntities players = new PlayersEntities()) { var p = players.Players.ToList(); return(View(p)); } }
public ActionResult Edit() { using (PlayersEntities players = new PlayersEntities()) { Player p = players.Players.FirstOrDefault(r => r.Username == User.Identity.Name); return(View(p)); } }
public ActionResult Edit(int?id) { if (id == 0) { return(new HttpStatusCodeResult(System.Net.HttpStatusCode.BadRequest)); } using (PlayersEntities players = new PlayersEntities()) { Player player = players.Players.FirstOrDefault(r => r.Id == id); return(View(player)); } }
public ActionResult Edit([Bind(Include = "Id,Username,Password,Email,Win_Rate,IpAddress,Status")] Player player) { using (PlayersEntities players = new PlayersEntities()) { if (ModelState.IsValid) { players.Entry(player).State = EntityState.Modified; players.SaveChanges(); return(RedirectToAction("Index")); } return(View(player)); } }
public ActionResult List() { using (PlayersEntities players = new PlayersEntities()) { Player player = players.Players.FirstOrDefault(r => r.Username == User.Identity.Name); var games = player.Games.ToList(); ViewBag.played = games.Count; return(View(games)); } }
public ActionResult Create([Bind(Include = "Id,Username,Password,Email,Win,Lose,IpAddress,Status")] Player player) { using (PlayersEntities players = new PlayersEntities()) { if (ModelState.IsValid) { players.Players.Add(player); players.SaveChanges(); return(RedirectToAction("Index")); } return(View(player)); } }
public ActionResult Edit([Bind(Include = "Id,Username,Password,Email,Win_Rate,IpAddress,Status")] Player player) { using (PlayersEntities players = new PlayersEntities()) { if (ModelState.IsValid) { players.Entry(player).State = EntityState.Modified; players.SaveChanges(); } FormsAuthentication.SignOut(); return(RedirectToAction("Login", "Account")); } }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (PlayersEntities players = new PlayersEntities()) { Player player = players.Players.FirstOrDefault(r => r.Id == id); if (player == null) { return(HttpNotFound()); } return(View(player)); } }
public ActionResult MyStats() { int won = 0; int lost = 0; int total_games = 0; decimal percentage; using (PlayersEntities players = new PlayersEntities()) { Player p = players.Players.FirstOrDefault(r => r.Username == User.Identity.Name); var games = p.Games.ToList(); foreach (var g in games) { if (g.WinnerId == p.Id) { won++; } else { lost++; } } if (won > 0) { percentage = (decimal)won / games.Count * 100; } else { percentage = 0; } p.Win_Rate = percentage; ViewBag.ratio = percentage; ViewBag.won = won; ViewBag.lost = lost; ViewBag.total = games.Count; players.SaveChanges(); return(View(games)); } }
public ActionResult Register([Bind(Include = "Username,Password,Email")] Player player) { if (ModelState.IsValid) { using (PlayersEntities players = new PlayersEntities()) { Player p = players.Players.FirstOrDefault(r => r.Username == player.Username || r.Email == player.Email); if (p != null) { ViewBag.Error = "Player with that username or mail already exist"; return(View(player)); } else { if (player.Password.Length < 6) { ViewBag.Pass = "******"; return(View(player)); } else { var role = new PlayerRole { PlayerId = player.Id, RoleId = 2 }; player.PlayerRoles.Add(role); player.Win_Rate = (decimal)0.0; player.Status = "Offline"; players.Players.Add(player); players.SaveChanges(); return(RedirectToAction("Login", "Account")); } } } } return(View(player)); }
public ActionResult TopPlayers() { int wins = 0; using (PlayersEntities players = new PlayersEntities()) { var player = players.Players.ToList(); var game = players.Games.ToList(); foreach (var pl in player) { foreach (var g in game) { if (pl.Id == g.WinnerId) { wins++; } } if (pl.Games.Count > 0) { pl.Win_Rate = (decimal)wins / pl.Games.Count * 100; wins = 0; } else { pl.Win_Rate = (decimal)0.0; wins = 0; } players.SaveChanges(); } var p = players.Players.OrderBy(r => r.Games.Count).OrderByDescending(r => r.Win_Rate).Take(3).ToList(); return(View(p)); } }
public CountriesClient(string serviceUri) { _ctx = new PlayersEntities(new Uri(serviceUri)); }
public CountriesClient(string serviceUri) { _ctx = new PlayersEntities(new Uri(serviceUri)); _ctx.IgnoreMissingProperties = true; }