/// <summary> /// Save a Game to the Database /// </summary> /// <param name="game">Gameobject to Save</param> /// <returns>1 if successfull, otherwise 0</returns> public int SaveGame(FluffTailRanking.BusinessLayer.BusinessObjects.Game game) { try { using (KickerEntities context = new KickerEntities()) { FluffTailRanking.BusinessLayer.Persistence.Game current = new FluffTailRanking.BusinessLayer.Persistence.Game() { date = DateTime.Now, teamone = game.Team1.ID, teamtwo = game.Team2.ID, winner = game.Winner.ID }; //TODO: Update Player wins / losts on save context.Game.Add(current); context.SaveChanges(); } return(1); } catch (Exception ex) { return(0); } }
/// <summary> /// Get all Games out of the Database /// </summary> /// <returns>List with all Games</returns> public List <FluffTailRanking.BusinessLayer.BusinessObjects.Game> GetAllGames() { List <FluffTailRanking.BusinessLayer.BusinessObjects.Game> games = new List <FluffTailRanking.BusinessLayer.BusinessObjects.Game>(); using (KickerEntities contex = new KickerEntities()) { var query = from game in contex.Game select new { id = game.id, date = game.date, winner = game.winner, t1 = game.teamone, t2 = game.teamtwo }; foreach (var matches in query) { FluffTailRanking.BusinessLayer.BusinessObjects.Game game = new FluffTailRanking.BusinessLayer.BusinessObjects.Game() { ID = matches.id, Team1 = GetTeamById(matches.t1), Team2 = GetTeamById(matches.t2), Date = matches.date, Winner = GetTeamById(matches.winner) }; games.Add(game); } }; return(games); }
/// <summary> /// Get all Games out of the Database /// </summary> /// <returns>List with all Games</returns> public List<FluffTailRanking.BusinessLayer.BusinessObjects.Game> GetAllGames() { List<FluffTailRanking.BusinessLayer.BusinessObjects.Game> games = new List<FluffTailRanking.BusinessLayer.BusinessObjects.Game>(); using (KickerEntities contex = new KickerEntities()) { var query = from game in contex.Game select new { id = game.id, date = game.date, winner = game.winner, t1 = game.teamone, t2 = game.teamtwo }; foreach (var matches in query) { FluffTailRanking.BusinessLayer.BusinessObjects.Game game = new FluffTailRanking.BusinessLayer.BusinessObjects.Game() { ID = matches.id, Team1 = GetTeamById(matches.t1), Team2 = GetTeamById(matches.t2), Date = matches.date, Winner = GetTeamById(matches.winner) }; games.Add(game); } }; return games; }
public int AddGame(Game newgame) { try { return persistentManager.SaveGame(newgame); } catch (Exception ex) { return 0; } }
public int SaveGame(Game game) { throw new NotImplementedException(); }