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