public IHttpActionResult GetEventsSortByPoint() { List <Event> EventFollowPoint = null; var basicEventList = new List <EventBasicInfo>(); try { using (var db = new EventDAL()) { EventFollowPoint = db.GetEventSortByPoint(); foreach (Event events in EventFollowPoint) { var eventMainImage = db.GetMainImageEventById(events.EventID); //get name of organizationt which is owner of this event. string organizationName; string eventType; using (var dbOrg = new OrganizationDAL()) { var orgOwner = dbOrg.GetOrganizationById(events.CreatorID); organizationName = orgOwner.OrganizationName; } //get type of this event. using (var dbWscontext = new Ws_DataContext()) { var eventTypes = dbWscontext.EventTypes.Find(events.EventType); eventType = eventTypes.EventTypeName; } basicEventList.Add(new EventBasicInfo { EventID = events.EventID, CreatorID = events.CreatorID, CreatorName = organizationName, EventName = events.EventName, MainImageUrl = eventMainImage.ImageUrl, Content = events.Description, ShortDescription = events.ShortDescription, Status = true, EventType = eventType, CreatedDate = events.Created_Date.ToString("H:mm:ss dd/MM/yy") }); } } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Data = basicEventList })); } catch (Exception) { //ViewBag.ErrorMessage = ex; return(Redirect("/#/Error")); } }