public Place[] GetPlaces()
{
/*
var parameters = new TableCommunicationParameters("dbo.Places", ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString, new List<string>());
IReadCommunicator communicator = new ReadCommunicator(parameters, typeof(Place));
return (IEnumerable<Place>)communicator.GetRecords(new SelectFilter(), GetValues());
*/
ITableCrudMethods<Place> crud = new PlacesTableCrud();
return crud.Read(null);
}
public int PostPlace(Place place)
{
// var id = GetPlace(place);
// if (id == -1)
// {
// return InsertPlace(place);
// }
// return id;
ITableCrudMethods<Place> crud = new PlacesTableCrud();
return crud.Insert(place);
}
public Place GetPlace(int id)
{
/*
var parameters = new TableCommunicationParameters("dbo.Places", ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString, new List<string>());
IReadCommunicator communicator = new ReadCommunicator(parameters, typeof(Place));
return (Place)communicator.GetRecords(new SelectFilter(), GetValues(),
new JoinFilter(FilterJoin.Types.InnerJoin,
new ComparisonFilter("dbo.Users.Id","dbo.Places.OwnerId",FilterComparer.Types.Equals), new ValueFilter("dbo.Users") )
,new WhereFilter(new ComparisonFilter("dbo.Places.Id",""+id,FilterComparer.Types.Equals))).FirstOrDefault();
*/
ITableCrudMethods<Place> crud = new PlacesTableCrud();
return crud.Read(id);
}
