public ActionResult EventListView()
{
if (!RightManager.Instance.HasUserRight(false,
RightEnum.EVENT___ACCESS_TO_PUBLIC,
RightEnum.EVENT___ACCESS_TO_PRIVATE,
RightEnum.EVENT___ACCESS_TO_CONFIDENTIAL))
throw new Exception("Uživatel nemá přístup ke stránce přehled událostí");
LinkCssFile("EventListView.css");
ManageEventFilter();
var dbFilter = new EventDbFilter()
{
IsFindNewer = FilterSession.IsFindNewer,
PilotTime = FilterSession.PilotTime,
ActionName = FilterSession.EventName,
AccessibilityId = FilterSession.SelectedAccessibility,
CreatorId = FilterSession.SelectedUser,
EventTypeId = FilterSession.SelectedEventType,
UserAccessibilitiesByRight = RightManager.Instance.GetLoggedUserEventAccessibilityTypesByRights(),
FileName = FilterSession.FileName
};
var dbEventDTO = Locator.GetDbEventManager().GetEventList(dbFilter, ManagePager());
PagingSession.SetPaging(dbEventDTO.TotalRecords);
var model = new EventListViewModel()
{
Events = dbEventDTO.Eventlist.Select(ModelConvertor.ConvertToEventModelNew).ToList(),
Paging = PagingSession,
Filter = FilterSession
};
// we need to show user if about forum items to each event.
if (model.Events.Any())
SetEventForumVisitedInfo(model.Events);
return View(model);
}
public EventListDTO GetEventList(EventDbFilter dbFilter, DatabasePager pager)
{
using (var context = new OpletalovaDbEntities())
{
var query = context.EVENT
.OrderByDescending(e => e.From)
.ThenBy(e => e.To)
.AsQueryable();
// file names are in different table with 1:N relation (not M:N!)
// I am sure it can be done another way but this is fast!
if (!String.IsNullOrEmpty(dbFilter.FileName))
{
var eventIds =
context.FILE_INFO.Where(f => f.FileName.Contains(dbFilter.FileName))
.Select(f => f.EventId)
.ToList();
query = query.Where(e => eventIds.Contains(e.Id));
}
if (!String.IsNullOrEmpty(dbFilter.ActionName))
query = query.Where(q => q.Name.Contains(dbFilter.ActionName));
if (dbFilter.EventTypeId.HasValue)
query = query.Where(q => q.Type == dbFilter.EventTypeId.Value);
query = dbFilter.AccessibilityId.HasValue
? query.Where(q => q.Accessibility == dbFilter.AccessibilityId.Value)
: query.Where(q => dbFilter.UserAccessibilitiesByRight.Contains(q.Accessibility));
if (dbFilter.CreatorId.HasValue)
query = query.Where(q => q.USER.Id == dbFilter.CreatorId.Value);
query = dbFilter.IsFindNewer
? query.Where(q => q.From >= dbFilter.PilotTime)
: query.Where(q => q.From <= dbFilter.PilotTime);
// we need to know how many records are ther in total (to be able set paging)
var totalRecords = query.Count();
// lets return only records which we want to show
var skipNum = pager.SelectedPageIndex * pager.PageSize;
if (skipNum < 0)
skipNum = 0;
query = query
.Include(e => e.USER)
.Include(e => e.EVENT_ACCESSIBILITY)
.Include(e => e.EVENT_TYPE)
.Include(e => e.FILE_INFO)
.Skip(skipNum) // how many records we should escape
.Take(pager.PageSize); // how many rows we should returned
return new EventListDTO()
{
Eventlist = query.ToList(),
TotalRecords = totalRecords
};
}
}