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