public GetHumanitarianEventResponse GetHumanitarianEvents(GetHumanitarianEventRequest request)
{
var response = new GetHumanitarianEventResponse();
using (var context = new HumanitarianEventContext())
{
response.Events = (from c in context.HumanitarianEvents
select c).ToList();
}
return response;
}
public AddHumanitarianEventResponse AddHumanitarianEvent(AddHumanitarianEventRequest request)
{
var response = new AddHumanitarianEventResponse();
using(var context = new HumanitarianEventContext())
{
request.EventToAdd.Id = Guid.NewGuid();
request.EventToAdd.LastModifiedDateTime = DateTime.Now;
request.EventToAdd.LastModifiedUser = "******";
context.HumanitarianEvents.Add(request.EventToAdd);
context.SaveChanges();
}
return response;
}
// POST: api/Event
public async Task<HttpResponseMessage> Post(HttpRequestMessage request)
{
// todo: Using a POST to retrieve data will make a REST purist cry. Better option?
// get the raw JSON from the request.
var jsonString = await request.Content.ReadAsStringAsync();
// todo: Process the string. Dates should be provided in "ISO 8601" format - 2009-02-15T00:00:00Z
// todo: Pass the data to the sprocs.
string tmp = "lat_deg:1,lon_deg:2,radius:10";
var CriteriaList = new SqlParameter("@CriteriaList", tmp);
var ctx = new HumanitarianEventContext();
//var x = ctx.Database.ExecuteSqlCommand("exec dbo.GetFilteredEvents @CriteriaList", CriteriaList);
var x = ctx.Database.ExecuteSqlCommand("exec dbo.TestProc @CriteriaList", CriteriaList);
// todo: implement logic to return proper status code and content, if any...
return new HttpResponseMessage(HttpStatusCode.Forbidden);
}
// GET: api/Event --- Return *ALL* humanitarian events
public IEnumerable<HumanitarianEvent> Get()
{
var ctx = new HumanitarianEventContext();
return ctx.HumanitarianEvents;
}
