public HttpResponseMessage Get([FromUri] EventsGetRequest GetEvents)
{
List <Events> eventsData = EventsService.Get(GetEvents);
ItemsResponse <Events> response = new ItemsResponse <Events>();
response.Items = eventsData;
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
public static List <Events> Get(EventsGetRequest model)
{
List <Events> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Events_SearchEpic"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@PageSize", model.PageSize);
paramCollection.AddWithValue("@PageNumber", model.PageNumber);
paramCollection.AddWithValue("@lat", model.Lat);
paramCollection.AddWithValue("@lon", model.Lon);
paramCollection.AddWithValue("@distance", model.Distance);
paramCollection.AddWithValue("@SearchString", model.SearchString);
}, map : delegate(IDataReader reader, short set) //executes after stored proc
{
Events p = new Events();
int startingIndex = 0; //startingOrdinal
p.Id = reader.GetSafeInt32(startingIndex++);
p.UserId = reader.GetSafeString(startingIndex++);
p.EventType = reader.GetSafeInt32(startingIndex++);
p.IsPublic = reader.GetSafeBool(startingIndex++);
p.Title = reader.GetString(startingIndex++);
p.Description = reader.GetSafeString(startingIndex++);
p.CountYes = reader.GetSafeInt32(startingIndex++);
p.CountNo = reader.GetSafeInt32(startingIndex++);
p.CountMaybe = reader.GetSafeInt32(startingIndex++);
p.CreateDate = reader.GetSafeDateTime(startingIndex++);
p.ModifiedDate = reader.GetSafeDateTime(startingIndex++);
p.Start = reader.GetSafeDateTime(startingIndex++);
p.End = reader.GetSafeDateTime(startingIndex++);
p.MediaId = reader.GetSafeInt32(startingIndex++);
Medias m = new Medias();
m.MediasTableId = reader.GetSafeInt32(startingIndex++);
m.CreatedDate = reader.GetSafeDateTime(startingIndex++);
m.ModifiedDate = reader.GetSafeDateTime(startingIndex++);
m.MediaType = reader.GetSafeEnum <MediaType>(startingIndex++);
m.ContentType = reader.GetSafeString(startingIndex++);
m.UserId = reader.GetSafeString(startingIndex++);
m.FilePath = reader.GetSafeString(startingIndex++);
if (m.MediasTableId > 0)
{
p.Media = m;
}
UserMini u = new UserMini();
u.profileName = reader.GetSafeString(startingIndex++);
u.profileLastName = reader.GetSafeString(startingIndex++);
u.UserId = reader.GetSafeString(startingIndex++);
Medias n = new Medias();
n.MediasTableId = reader.GetSafeInt32(startingIndex++);
n.CreatedDate = reader.GetSafeDateTime(startingIndex++);
n.ModifiedDate = reader.GetSafeDateTime(startingIndex++);
n.MediaType = reader.GetSafeEnum <MediaType>(startingIndex++);
n.ContentType = reader.GetSafeString(startingIndex++);
n.UserId = reader.GetSafeString(startingIndex++);
n.FilePath = reader.GetSafeString(startingIndex++);
if (n.MediasTableId > 0)
{
u.Avatar = n;
}
p.Organizer = u;
Location l = new Location();
l.Id = reader.GetSafeInt32(startingIndex++);
l.Latitude = reader.GetSafeDecimal(startingIndex++);
l.Longitude = reader.GetSafeDecimal(startingIndex++);
l.Address = reader.GetSafeString(startingIndex++);
l.City = reader.GetSafeString(startingIndex++);
l.State = reader.GetSafeString(startingIndex++);
l.ZipCode = reader.GetSafeString(startingIndex++);
p.Location = l;
if (list == null)
{
list = new List <Events>();
}
list.Add(p);
}
);
return(DecorateEvents(list));
}
