// GET api/Games public HttpResponseMessage Get() { using (GamesDBEntities entities = new GamesDBEntities()) { return(Request.CreateResponse(HttpStatusCode.OK, entities.tblGames.ToList())); } }
public void AddGame(GAME game) { using (var gameContext = new GamesDBEntities()) { gameContext.GAMES.Add(game); gameContext.SaveChanges(); } }
// POST api/Games public HttpResponseMessage Post([FromBody] tblGame game) { using (GamesDBEntities entities = new GamesDBEntities()) { entities.tblGames.Add(game); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, new Uri(Request.RequestUri + "/" + game.GameID.ToString()))); } }
public HttpResponseMessage GetByPlayer(string player) { using (GamesDBEntities entities = new GamesDBEntities()) { List <tblGame> gameList = entities.tblGames.Where(g => g.Player1.ToLower().StartsWith(player.ToLower()) || g.Player2.ToLower().StartsWith(player.ToLower())).ToList(); if (gameList.Count > 0) { return(Request.CreateResponse(HttpStatusCode.OK, player)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format($"Game with Name {player} was not Found"))); } } }
// GET api/Games/5 public HttpResponseMessage Get(int id) { using (GamesDBEntities entities = new GamesDBEntities()) { tblGame game = entities.tblGames.FirstOrDefault(g => g.GameID == id); if (game != null) { return(Request.CreateResponse(HttpStatusCode.OK, game)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format($"Game with ID {id} was not Found"))); } } }
// DELETE api/Games/5 public HttpResponseMessage Delete(int id) { using (GamesDBEntities entities = new GamesDBEntities()) { tblGame game = entities.tblGames.FirstOrDefault(g => g.GameID == id); if (game != null) { entities.tblGames.Remove(game); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Accepted, string.Format($"Game with ID {id} was Deleted"))); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format($"Game with ID {id} was not Found"))); } } }
public void EditGame(int gameId) { using (var gameContext = new GamesDBEntities()) { var query = from game in GDBEntities.GAMES where game.Id == gameId select game; foreach (GAME game in query) { game.Complete = true; game.DateOfCompletion = DateTime.Today; } gameContext.SaveChanges(); } }
// PUT api/Games/5 public HttpResponseMessage Put(int id, [FromBody] tblGame game) { using (GamesDBEntities entities = new GamesDBEntities()) { tblGame game_To_Update = entities.tblGames.FirstOrDefault(g => g.GameID == id); // LINQ - Check if Found ID First or Default if (game_To_Update != null) { game_To_Update.Game_Name = game.Game_Name; game_To_Update.Player1 = game.Player1; game_To_Update.Player2 = game.Player2; game_To_Update.Who_won = game.Who_won; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Accepted, string.Format($"game with ID {id} Updated"))); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format($"game wite ID {id} not Found"))); } } }
public HttpResponseMessage GetBySearch(int gameID = 0, string gameName = null, string player1 = null, string player2 = null, string whoWon = null) { using (GamesDBEntities entities = new GamesDBEntities()) { List <tblGame> gameList = entities.tblGames.Where(g => gameID > 0 ? g.GameID == gameID : true). Where(g => gameName != null ? g.Game_Name.ToLower().StartsWith(gameName.ToLower()): true). Where(g => player1 != null ? g.Player1.ToLower().StartsWith(player1.ToLower()): true). Where(g => player2 != null ? g.Player2.ToLower().StartsWith(player2.ToLower()): true). Where(g => whoWon != null ? g.Who_won.ToLower().StartsWith(whoWon.ToLower()): true) .ToList(); if (gameList.Count > 0) { return(Request.CreateResponse(HttpStatusCode.OK, gameList)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, string.Format("game whit this search fild is not found"))); } } }
public List <GAME> RetrieveGames(string console, bool complete) { using (var gameContext = new GamesDBEntities()) { var query = from game in GDBEntities.GAMES select game; if (complete) { switch (console) { case "NES": query = from game in GDBEntities.GAMES where game.Console == "NES" && game.Complete == true select game; return(query.ToList <GAME>()); case "SNES": query = from game in GDBEntities.GAMES where game.Console == "SNES" && game.Complete == true select game; return(query.ToList <GAME>()); case "N64": query = from game in GDBEntities.GAMES where game.Console == "N64" && game.Complete == true select game; return(query.ToList <GAME>()); case "GCN": query = from game in GDBEntities.GAMES where game.Console == "GCN" && game.Complete == true select game; return(query.ToList <GAME>()); case "Wii": query = from game in GDBEntities.GAMES where game.Console == "Wii" && game.Complete == true select game; return(query.ToList <GAME>()); default: return(query.ToList <GAME>()); } } else { switch (console) { case "NES": query = from game in GDBEntities.GAMES where game.Console == "NES" select game; return(query.ToList <GAME>()); case "SNES": query = from game in GDBEntities.GAMES where game.Console == "SNES" select game; return(query.ToList <GAME>()); case "N64": query = from game in GDBEntities.GAMES where game.Console == "N64" select game; return(query.ToList <GAME>()); case "GCN": query = from game in GDBEntities.GAMES where game.Console == "GCN" select game; return(query.ToList <GAME>()); case "Wii": query = from game in GDBEntities.GAMES where game.Console == "Wii" select game; return(query.ToList <GAME>()); default: return(query.ToList <GAME>()); } } } }
public BaseRepository(GamesDBEntities context) { Context = context; }