public HttpResponseMessage GetAllGame() { using (db = new GamePlayerEntities()) { return(Request.CreateResponse(HttpStatusCode.OK, db.Game.ToList())); } }
public HttpResponseMessage Post([FromBody] Game game) { using (db = new GamePlayerEntities()) { db.Game.Add(game); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Accepted)); } }
public HttpResponseMessage GetWithId(int id) { using (db = new GamePlayerEntities()) { Game game = db.Game.FirstOrDefault(ID => ID.ID.Equals(id)); if (game != null) { return(Request.CreateResponse(HttpStatusCode.OK, game)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, game)); } } }
// DELET api/Game/5 public HttpResponseMessage Delete(int id) { using (db = new GamePlayerEntities()) { Game game = db.Game.FirstOrDefault(ID => ID.ID.Equals(id)); if (game != null) { db.Game.Remove(game); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, "The game" + game.ID + "remove")); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } }
// PUT api/Game/5 public HttpResponseMessage Put(int id, [FromBody] Game gameBody) { using (db = new GamePlayerEntities()) { Game game = db.Game.FirstOrDefault(ID => ID.ID.Equals(id)); if (game != null) { game.Player_one = gameBody.Player_one; game.Player_two = gameBody.Player_two; game.who_won = gameBody.who_won; game.Game_Name = gameBody.Game_Name; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Accepted)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } }
public HttpResponseMessage Get(int id = -1, string gameName = null, string playerOne = null, string playerTwo = null, string who_Won = null) { using (db = new GamePlayerEntities()) { List <Game> listGame = db.Game .Where(g => gameName != null ? g.Game_Name.ToLower().StartsWith(gameName.ToLower()) : true) .Where(p1 => playerOne != null ? p1.Player_one.ToLower().StartsWith(playerOne.ToLower()) : true) .Where(p2 => playerTwo != null ? p2.Player_two.ToLower().StartsWith(playerTwo.ToLower()) : true) .Where(ww => who_Won != null ? ww.who_won.ToLower().StartsWith(who_Won.ToLower()) : true) .Where(idGame => id > -1 ? idGame.ID.Equals(id) : true).ToList(); if (listGame.Count > 0) { return(Request.CreateResponse(HttpStatusCode.OK, listGame)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } }