// GET api/<controller> public IEnumerable<Player> GetAllPlayers() { try { List<Player> players = new List<Player>(); string connectionString = ConfigurationManager.ConnectionStrings["FreeFootieConnectionString"].ConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { var results = (from c in myData.players orderby c.id ascending select c).ToList(); foreach (var temp in results) { Player player = new Player(); player.id = temp.id; player.name = temp.name; player.dob = temp.dob.ToString("yyyy-MM-dd"); player.number = temp.number; players.Add(player); } } return players; } catch (Exception ex) { Common.ErrorCatch(ex, "PlayerController.GetAllPlayers"); return null; } }
// GET api/<controller> public IEnumerable<Location> GetAllLocations() { try { List<Location> locations = new List<Location>(); string connectionString = ConfigurationManager.ConnectionStrings["FreeFootieConnectionString"].ConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { var results = (from c in myData.locations orderby c.id ascending select c).ToList(); foreach (var temp in results) { Location location = new Location(); location.id = temp.id; location.name = temp.name; location.latitude = temp.latitude; location.longitude = temp.longitude; locations.Add(location); } } return locations; } catch (Exception ex) { Common.ErrorCatch(ex, "LocationController.GetAllLocations"); return null; } }
// GET api/<controller> public IEnumerable<Pool> GetAllPools() { try { List<Pool> pools = new List<Pool>(); string connectionString = ConfigurationManager.ConnectionStrings["FreeFootieConnectionString"].ConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { var results = (from c in myData.pools orderby c.id ascending select c).ToList(); foreach (var temp in results) { Pool pool = new Pool(); pool.id = temp.id; pool.name = temp.name; pools.Add(pool); } } return pools; } catch (Exception ex) { Common.ErrorCatch(ex, "PoolController.GetAllPools"); return null; } }
// GET api/<controller> public IEnumerable<Team> GetAllPools() { try { List<Team> teams = new List<Team>(); string connectionString = ConfigurationManager.ConnectionStrings["FreeFootieConnectionString"].ConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { var results = (from c in myData.teams orderby c.id ascending select c).ToList(); foreach (var temp in results) { Team team = new Team(); team.id = temp.id; team.name = temp.name; team.coach = temp.coach; team.loses = temp.losses; team.wins = temp.wins; team.ties = temp.ties; team.phone = temp.phone; team.school = temp.schoolID; var playerIDs = (from c in myData.teamPlayers where c.teamID == temp.id select c.playerID).ToList().ToArray(); team.palyers = playerIDs; teams.Add(team); } } return teams; } catch (Exception ex) { Common.ErrorCatch(ex, "TeamController.GetAllPools"); return null; } }
//// PUT api/<controller>/5 //public void Put(int id, [FromBody]string value) //{ //} // DELETE api/<controller>/5 public void DeleteLocation(int id) { try { string connectionString = Properties.Settings.Default.FreeFootieConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { using (TransactionScope myScope = new TransactionScope()) { myData.locations.DeleteOnSubmit(myData.locations.Single(c => c.id == id)); myData.SubmitChanges(); myScope.Complete(); } } } catch (Exception ex) { Common.ErrorCatch(ex, "LocationController.DeleteLocation"); } }
// GET api/<controller> public IEnumerable<Game> GetAllGames() { try { List<Game> games = new List<Game>(); string connectionString = ConfigurationManager.ConnectionStrings["FreeFootieConnectionString"].ConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { var results = (from c in myData.games join d in myData.locations on c.locationID equals d.id orderby c.id ascending select new { game = c, locationName = d.name }).ToList(); foreach (var temp in results) { Game game = new Game(); game.id = temp.game.id; game.away = temp.game.awayTeamID; game.duration = temp.game.duration; game.home = temp.game.homeTeamID; game.location = temp.game.locationID; game.locationName = temp.locationName; game.date = "<<" + temp.game.startTime.ToString("yyyy-MM-dd HH:mm:ss") + "~"+ temp.game.duration +"h>>"; game.state = temp.game.state; game.homeTeamScore = temp.game.homeTeamScore; game.awayTeamScore = temp.game.awayTeamScore; games.Add(game); } } return games; } catch (Exception ex) { Common.ErrorCatch(ex, "GameController.GetAllGames"); return null; } }
// POST api/<controller> public void PostLocation(Location location) { try { string connectionString = Properties.Settings.Default.FreeFootieConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { using (TransactionScope myScope = new TransactionScope()) { location newLocation = new location(); var newID = (from c in myData.locations select c.id).Max(); newLocation.id = newID + 1; newLocation.name = location.name; newLocation.latitude = location.latitude; newLocation.longitude = location.longitude; myData.locations.InsertOnSubmit(newLocation); myData.SubmitChanges(); myScope.Complete(); } } } catch (Exception ex) { Common.ErrorCatch(ex, "LocationController.PostLocation"); } }
// GET api/<controller>/5 public Team GetTeamById(int id) { try { string connectionString = Properties.Settings.Default.FreeFootieConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { var temp = (from c in myData.teams where c.id == id orderby c.id ascending select c).SingleOrDefault(); Team team = new Team(); team.id = temp.id; team.name = temp.name; team.coach = temp.coach; team.loses = temp.losses; team.wins = temp.wins; team.ties = temp.ties; team.phone = temp.phone; team.school = temp.schoolID; var playerIDs = (from c in myData.teamPlayers where c.teamID == temp.id select c.playerID).ToList().ToArray(); team.palyers = playerIDs; return team; } } catch (Exception ex) { Common.ErrorCatch(ex, "TeamController.GetTeamById"); return null; } }
// POST api/<controller> public void PostTeam(Team team) { try { string connectionString = Properties.Settings.Default.FreeFootieConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { using (TransactionScope myScope = new TransactionScope()) { team newTeam = new team(); var newID = (from c in myData.teams select c.id).Max(); newTeam.id = newID + 1; newTeam.name = team.name; newTeam.coach = team.coach; newTeam.losses = team.loses; newTeam.wins = team.wins; newTeam.ties = team.ties; newTeam.phone = team.phone; newTeam.schoolID = team.school; myData.teams.InsertOnSubmit(newTeam); foreach (int playerID in team.palyers) { teamPlayer newTeamPlayer = new teamPlayer(); newTeamPlayer.teamID = newTeam.id; newTeamPlayer.playerID = playerID; myData.teamPlayers.InsertOnSubmit(newTeamPlayer); } myData.SubmitChanges(); myScope.Complete(); } } } catch (Exception ex) { Common.ErrorCatch(ex, "TeamController.PostTeam"); } }
// GET api/<controller>/5 public Pool GetPoolById(int id) { try { string connectionString = Properties.Settings.Default.FreeFootieConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { var temp = (from c in myData.pools where c.id == id orderby c.id ascending select c).SingleOrDefault(); Pool pool = new Pool(); pool.id = temp.id; pool.name = temp.name; return pool; } } catch (Exception ex) { Common.ErrorCatch(ex, "PoolController.GetPoolById"); return null; } }
public void SetScore(int id, int homeTeamScore, int awayTeamScore) { try { string connectionString = Properties.Settings.Default.FreeFootieConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { using (TransactionScope myScope = new TransactionScope()) { game newGame = new game(); var theGame = (from c in myData.games where c.id == id select c).SingleOrDefault(); theGame.homeTeamScore = homeTeamScore; theGame.awayTeamScore = awayTeamScore; myData.SubmitChanges(); myScope.Complete(); } } } catch (Exception ex) { Common.ErrorCatch(ex, "GameController.PostGame"); } }
// POST api/<controller> public void PostPool(Pool pool) { try { string connectionString = Properties.Settings.Default.FreeFootieConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { using (TransactionScope myScope = new TransactionScope()) { pool newPool = new pool(); var newID = (from c in myData.pools select c.id).Max(); newPool.id = newID + 1; newPool.name = pool.name; myData.pools.InsertOnSubmit(newPool); myData.SubmitChanges(); myScope.Complete(); } } } catch (Exception ex) { Common.ErrorCatch(ex, "PoolController.PostPool"); } }
// GET api/<controller>/5 public Player GetPlayerById(int id) { try { string connectionString = Properties.Settings.Default.FreeFootieConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { var temp = (from c in myData.players where c.id == id select c).SingleOrDefault(); Player player = new Player(); player.id = temp.id; player.name = temp.name; player.dob = temp.dob.ToString("yyyy-MM-dd"); player.number = temp.number; return player; } } catch (Exception ex) { Common.ErrorCatch(ex, "PlayerController.GetPlayerById"); return null; } }
// POST api/<controller> public void PostPlayer(Player player) { try { string connectionString = Properties.Settings.Default.FreeFootieConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { using (TransactionScope myScope = new TransactionScope()) { player newPalyer = new player(); var newID = (from c in myData.players select c.id).Max(); newPalyer.id = newID + 1; newPalyer.name = player.name; newPalyer.dob = Convert.ToDateTime(player.dob); newPalyer.number = player.number; myData.players.InsertOnSubmit(newPalyer); myData.SubmitChanges(); myScope.Complete(); } } } catch (Exception ex) { Common.ErrorCatch(ex, "PlayerController.PostPlayer"); } }
// GET api/<controller>/5 public Game GetGameById(int id) { try { string connectionString = Properties.Settings.Default.FreeFootieConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { var temp = (from c in myData.games join d in myData.locations on c.locationID equals d.id where c.id == id select new { game = c, locationName = d.name }).SingleOrDefault(); Game game = new Game(); game.id = id; game.away = temp.game.awayTeamID; game.duration = temp.game.duration; game.home = temp.game.homeTeamID; game.location = temp.game.locationID; game.locationName = temp.locationName; game.date = "<<" + temp.game.startTime.ToString("yyyy-MM-dd HH:mm:ss") + "~" + temp.game.duration + "h>>"; game.state = temp.game.state; game.homeTeamScore = temp.game.homeTeamScore; game.awayTeamScore = temp.game.awayTeamScore; return game; } } catch (Exception ex) { Common.ErrorCatch(ex, "GameController.GetGameById"); return null; } }
// GET api/<controller>/5 public Location GetLocationById(int id) { try { string connectionString = Properties.Settings.Default.FreeFootieConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { var temp = (from c in myData.locations where c.id == id orderby c.id ascending select c).SingleOrDefault(); Location location = new Location(); location.id = temp.id; location.name = temp.name; location.latitude = temp.latitude; location.longitude = temp.longitude; return location; } } catch (Exception ex) { Common.ErrorCatch(ex, "LocationController.GetLocationById"); return null; } }
// POST api/<controller> public void PostGame(Game game) { try { string connectionString = Properties.Settings.Default.FreeFootieConnectionString; using (FreeFootieDataContext myData = new FreeFootieDataContext(connectionString)) { using (TransactionScope myScope = new TransactionScope()) { game newGame = new game(); var newID = (from c in myData.games select c.id).Max(); newGame.id = newID + 1; newGame.awayTeamID = game.away; newGame.duration = game.duration; newGame.homeTeamID = game.home; newGame.locationID = game.location; string[] date_duration = game.date.Replace("<", string.Empty).Replace(">", string.Empty).Replace("h", string.Empty).Split('~'); if (date_duration.Count() > 0) { newGame.startTime = Convert.ToDateTime(date_duration[0]); } if (date_duration.Count() > 1) { newGame.duration = Convert.ToInt32(date_duration[1]); } newGame.state = game.state; newGame.homeTeamScore = game.homeTeamScore; newGame.awayTeamScore = game.awayTeamScore; myData.games.InsertOnSubmit(newGame); myData.SubmitChanges(); myScope.Complete(); } } } catch (Exception ex) { Common.ErrorCatch(ex, "GameController.PostGame"); } }