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")); } }
public IHttpActionResult GetTop1ViewedEvent() { List <Event> topEvent = null; var basicEventList = new List <EventBasicInfo>(); try { using (var db = new EventDAL()) { //Get top event. topEvent = db.GetTopFourEventByPoint(1); foreach (Event e in topEvent) { //Lấy ra ảnh tương ứng với mỗi 1 event với Status = true //Note: ảnh có status bằng "true" là ảnh dùng để hiển thị trên trang Event var eventMainImage = db.GetMainImageEventById(e.EventID); basicEventList.Add(new EventBasicInfo { CreatedDate = e.Created_Date.ToString("H:mm:ss dd/MM/yy"), EventID = e.EventID, EventName = e.EventName, Content = e.Description, ShortDescription = e.ShortDescription, CreatorID = e.CreatorID, MainImageUrl = eventMainImage.ImageUrl, Status = e.Status }); } } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Data = basicEventList })); } catch (Exception) { return(Redirect("/#/Error")); } }
public IHttpActionResult GetTopFourEventByPoint() { List <Event> topEvent = null; var basicEventList = new List <EventBasicInfo>(); using (var db = new EventDAL()) { //Get top event. topEvent = db.GetTopFourEventByPoint(4); foreach (Event e in topEvent) { int Like = db.CountLikeInEvent(e.EventID); int Comment = db.CountCommentInEvent(e.EventID); //Lấy ra ảnh tương ứng với mỗi 1 event với Status = 1 //Note: ảnh có status bằng 1 là ảnh dùng để hiển thị trên trang Home var eventMainImage = db.GetMainImageEventById(e.EventID); basicEventList.Add(new EventBasicInfo { CreatedDate = e.Created_Date.ToString("H:mm:ss dd/MM/yy"), EventID = e.EventID, EventName = e.EventName, Content = e.Description, ShortDescription = e.ShortDescription, CreatorID = e.CreatorID, MainImageUrl = eventMainImage.ImageUrl, Status = e.Status, Likes = Like, NumberOfComments = Comment }); } } return(Ok(new HTTPMessageDTO { Status = WsConstant.HttpMessageType.SUCCESS, Data = basicEventList })); }