[HttpPost("newgame")] // lern to test this one propertly
public IEnumerable <Game> newgame([FromBody] Game auxGame) //receives a a formated json object, then adds it to the database
{
using (var context = new gameApiContext())
{
context.Add(auxGame);
context.SaveChanges();
return(context.Games.Where(Game => Game.GameName == auxGame.GameName).ToList()); //returns the new game in json format (in theory)
}
}
public IEnumerable <Game> deletegame(int id)
{
using (gameApiContext context = new gameApiContext())
{
context.Games.Remove(context.Games.FirstOrDefault(e => e.GameId == id));
context.SaveChanges();
return(context.Games.ToList());
}
}
public IEnumerable <Studio> deletestudio(string id) //somehow studio id ended up being a string instead of an int, im rolling with it
{
using (gameApiContext context = new gameApiContext())
{
context.Studios.Remove(context.Studios.FirstOrDefault(e => e.StudioId == id));
context.SaveChanges();
return(context.Studios.ToList());
}
}
[HttpPost("newstudio")] // lern to test this one propertly
public IEnumerable <Studio> newstudio([FromBody] Studio auxStudio) //receives a a formated json object, then adds it to the database
{
using (var context = new gameApiContext())
{
context.Add(auxStudio);
context.SaveChanges();
return(context.Studios.Where(Studio => Studio.StudioName == auxStudio.StudioName).ToList()); //returns the studio in json format (in theory)
}
}
[HttpPut("updatestudio")] //requires json formated data and a studio id to update
public IEnumerable <Studio> updateStudio(string id, [FromBody] Studio auxStudio)
{
using (gameApiContext context = new gameApiContext())
{
var Studio = context.Studios.FirstOrDefault(e => e.StudioId == id);
Studio.StudioName = auxStudio.StudioName;
Studio.StudioId = auxStudio.StudioId;
context.SaveChanges();
return(context.Studios.Where(Studio => Studio.StudioName == auxStudio.StudioName).ToList());
}
}
[HttpPut("updategame")] //requires json formated data and a game id to update
public IEnumerable <Game> updateGame(int id, [FromBody] Game auxGame)
{
using (gameApiContext context = new gameApiContext())
{
var game = context.Games.FirstOrDefault(e => e.GameId == id);
game.GameName = auxGame.GameName;
game.GameId = auxGame.GameId;
game.Genre = auxGame.Genre;
game.GamePlatform = auxGame.GamePlatform;
game.Studio = auxGame.Studio;
context.SaveChanges();
return(context.Games.Where(Game => Game.GameName == auxGame.GameName).ToList());
}
}