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