// GET api/Games public HttpResponseMessage Get() { using (WebAPI_FP_TournamentGamesEntities entities = new WebAPI_FP_TournamentGamesEntities()) { return(Request.CreateResponse(HttpStatusCode.OK, entities.GamesResoluts.ToList())); } }
// PUT api/Games/5 public HttpResponseMessage Put(int id, [FromBody] GamesResolut value) { using (WebAPI_FP_TournamentGamesEntities entities = new WebAPI_FP_TournamentGamesEntities()) { GamesResolut wanted = entities.GamesResoluts.FirstOrDefault(t => t.ID == id); if (wanted != null) { wanted.Game_Name = value.Game_Name; wanted.Player1 = value.Player1; wanted.Player2 = value.Player2; wanted.Who_Won_ = value.Who_Won_; //entities.SaveChanges(); try { //db.SaveChanges(); entities.SaveChanges(); } catch (DbEntityValidationException ex) { Console.WriteLine(ex); } return(Request.CreateResponse(HttpStatusCode.Accepted, wanted)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format("The game with id: {0} not found", id))); } } }
// POST api/Games public HttpResponseMessage Post([FromBody] GamesResolut value) { using (WebAPI_FP_TournamentGamesEntities entities = new WebAPI_FP_TournamentGamesEntities()) { entities.GamesResoluts.Add(value); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, new Uri(Request.RequestUri + value.ID.ToString()))); } }
// GET api/Games/5 public HttpResponseMessage Get(int id) { using (WebAPI_FP_TournamentGamesEntities entities = new WebAPI_FP_TournamentGamesEntities()) { GamesResolut wanted = entities.GamesResoluts.FirstOrDefault(t => t.ID == id); if (wanted != null) { return(Request.CreateResponse(HttpStatusCode.OK, wanted)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format("The game with id: {0} not found", id))); } } }
public HttpResponseMessage GetByName(string name) { using (WebAPI_FP_TournamentGamesEntities entities = new WebAPI_FP_TournamentGamesEntities()) { List <GamesResolut> wanted = entities.GamesResoluts.Where(t => (t.Player1.ToUpper() == name.ToUpper()) || (t.Player2.ToUpper() == name.ToUpper())).ToList(); if (wanted.Count > 0) { return(Request.CreateResponse(HttpStatusCode.OK, wanted)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format("The game with Player: {0} not found", name))); } } }
// GET api/GamesResults/5 public HttpResponseMessage Get(int id) { using (WebAPI_FP_TournamentGamesEntities entities = new WebAPI_FP_TournamentGamesEntities()) { GamesResult game = entities.GamesResults.FirstOrDefault(t => t.ID == id); if (game != null) { return(Request.CreateResponse(HttpStatusCode.OK, game)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format("Game with id : {0} , NOT FOUND!!!", id))); } } }
public HttpResponseMessage GetByPlayerName(string playerName) { using (WebAPI_FP_TournamentGamesEntities entities = new WebAPI_FP_TournamentGamesEntities()) { List <GamesResult> gameList = (entities.GamesResults.Where(t => ((t.Player1.ToUpper() == playerName.ToUpper()) || (t.Player2.ToUpper() == playerName.ToUpper())))).ToList(); if (gameList.Count > 0) { return(Request.CreateResponse(HttpStatusCode.OK, gameList)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format("Game with id : {0} , NOT FOUND!!!", playerName))); } } }
// DELETE api/GamesResults/5 public HttpResponseMessage Delete(int id) { using (WebAPI_FP_TournamentGamesEntities entities = new WebAPI_FP_TournamentGamesEntities()) { GamesResult game = entities.GamesResults.FirstOrDefault(t => t.ID == id); if (game != null) { entities.GamesResults.Remove(game); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Accepted, string.Format("Game with id: {0} , was deleted.", id))); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format("Game with id : {0} , NOT FOUND!!!", id))); } } }
public HttpResponseMessage GetBySearch(string gameName = null, string player1Name = null, string player2Name = null, string whoWon = null) { using (WebAPI_FP_TournamentGamesEntities entities = new WebAPI_FP_TournamentGamesEntities()) { List <GamesResult> gameList = entities.GamesResults.Where(t => gameName != null ? t.Game_Name.ToUpper().Contains(gameName.ToUpper()) : true) .Where(t => player1Name != null ? t.Player1.ToUpper().Contains(player1Name.ToUpper()) : true) .Where(t => player2Name != null ? t.Player2.ToUpper().Contains(player2Name.ToUpper()) : true) .Where(t => whoWon != null ? t.Who_Won_.ToUpper().Contains(whoWon.ToUpper()) : true).ToList(); if (gameList.Count > 0) { return(Request.CreateResponse(HttpStatusCode.OK, gameList)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format("Game with wished fields NOT FOUND!!!"))); } } }
public HttpResponseMessage Get(int id = -1, string gameName = null, string player1 = null, string player2 = null, string whoWon = null) { using (WebAPI_FP_TournamentGamesEntities entities = new WebAPI_FP_TournamentGamesEntities()) { List <GamesResolut> wanted = entities.GamesResoluts.Where(t => id != -1 ? t.ID == id : true) .Where(t => gameName != null ? t.Game_Name.ToUpper() == gameName.ToUpper() : true) .Where(t => player1 != null ? t.Player1.ToUpper() == player1.ToUpper() : true) .Where(t => player2 != null ? t.Player2.ToUpper() == player2.ToUpper() : true) .Where(t => whoWon != null ? t.Who_Won_.ToUpper() == whoWon.ToUpper() : true).ToList(); if (wanted != null) { return(Request.CreateResponse(HttpStatusCode.OK, wanted)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "The game not found")); } } }
// PUT api/GamesResults/5 public HttpResponseMessage Put(int id, [FromBody] GamesResult game) { using (WebAPI_FP_TournamentGamesEntities entities = new WebAPI_FP_TournamentGamesEntities()) { GamesResult gameUpdate = entities.GamesResults.FirstOrDefault(t => t.ID == id); if (gameUpdate != null) { gameUpdate.Game_Name = game.Game_Name; gameUpdate.Player1 = game.Player1; gameUpdate.Player2 = game.Player2; gameUpdate.Who_Won_ = game.Who_Won_; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Accepted, gameUpdate)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format("Game with id : {0} , NOT FOUND!!!", id))); } } }