//// 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");
}
}
// 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");
}
}
// 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");
}
}
// 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");
}
}
// 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");
}
}
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 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");
}
}
