public NotificationIndexFiltered GetFilteredAndSortedNotifications(NotificationIndexBody model)
{
int value = model.NotificationTypeIDs.Length + model.LevelOfImpactIDs.Length + model.StatusIDs.Length + model.PriorityIDs.Length;
IEnumerable <Thread> allThreads = value == 0 ? GetAllNotifications() : GetFilteredNotifications(model);
IPagedList <Thread> threads = allThreads != null?Sort(allThreads, model.CurrentSort, model.SearchString).ToPagedList(model.Page, model.ItemsPerPage ?? ConstantsRepo.PAGE_SIZE) : new List <Thread>().ToPagedList(1, 1);
NotificationIndexFiltered result = new NotificationIndexFiltered()
{
ItemStart = threads.TotalItemCount > 0 ? (threads.PageNumber - 1) * threads.PageSize + 1 : 0,
ItemEnd = threads.PageNumber * threads.PageSize < threads.TotalItemCount ? threads.PageNumber * threads.PageSize : threads.TotalItemCount,
PageCount = threads.PageCount,
PageNumber = threads.PageNumber,
TotalItemsCount = threads.TotalItemCount,
Threads = threads.ToList(),
IncidentNumberSort = model.CurrentSort == ConstantsRepo.SORT_INCIDENT_NUMBER_ASCE ? ConstantsRepo.SORT_INCIDENT_NUMBER_DESC : ConstantsRepo.SORT_INCIDENT_NUMBER_ASCE,
LevelOfImpactSort = model.CurrentSort == ConstantsRepo.SORT_LEVEL_OF_IMPACT_DESC ? ConstantsRepo.SORT_LEVEL_OF_IMPACT_ASCE : ConstantsRepo.SORT_LEVEL_OF_IMPACT_DESC,
NotificationHeadingSort = model.CurrentSort == ConstantsRepo.SORT_NOTIFICATION_BY_HEADING_ASCE ? ConstantsRepo.SORT_NOTIFICATION_BY_HEADING_DESC : ConstantsRepo.SORT_NOTIFICATION_BY_HEADING_ASCE,
NotificationTypeSort = model.CurrentSort == ConstantsRepo.SORT_NOTIFICATION_BY_TYPE_ASCE ? ConstantsRepo.SORT_NOTIFICATION_BY_TYPE_DESC : ConstantsRepo.SORT_NOTIFICATION_BY_TYPE_ASCE,
PrioritySort = model.CurrentSort == ConstantsRepo.SORT_NOTIFICATION_BY_PRIORITY_DESC ? ConstantsRepo.SORT_NOTIFICATION_BY_PRIORITY_ASCE : ConstantsRepo.SORT_NOTIFICATION_BY_PRIORITY_DESC,
StatusSort = model.CurrentSort == ConstantsRepo.SORT_STATUS_BY_NAME_DESC ? ConstantsRepo.SORT_STATUS_BY_NAME_ASCE : ConstantsRepo.SORT_STATUS_BY_NAME_DESC
};
return(result);
}
public IEnumerable <Thread> GetFilteredNotifications(NotificationIndexBody model)
{
try
{
model.NotificationTypeIDs = model.NotificationTypeIDs.Length == 0 ? _slRepo.GetTypeList().Select(o => int.Parse(o.Value)).ToArray() : model.NotificationTypeIDs;
model.LevelOfImpactIDs = model.LevelOfImpactIDs.Length == 0 ? _slRepo.GetImpactLevelList().Select(o => int.Parse(o.Value)).ToArray() : model.LevelOfImpactIDs;
model.PriorityIDs = model.PriorityIDs.Length == 0 ? _slRepo.GetPriorityList().Select(o => int.Parse(o.Value)).ToArray() : model.PriorityIDs;
model.StatusIDs = model.StatusIDs.Length == 0 ? _slRepo.GetStatusList(Key.STATUS_TYPE_NOTIFICATION).Select(o => int.Parse(o.Value)).ToArray() : model.StatusIDs;
IEnumerable <Notification> allNotifications;
if (String.IsNullOrEmpty(model.SearchString))
{
allNotifications = _context.Notification;
}
else
{
allNotifications = _context.Notification.Where(
n => n.IncidentNumber.ToLower().Contains(model.SearchString.ToLower()) ||
n.NotificationHeading.ToLower().Contains(model.SearchString.ToLower()) ||
n.NotificationDescription.ToLower().Contains(model.SearchString.ToLower())
// TODO: add more columns for large index search
);
}
if (HttpContext.Current.User.IsInRole(Key.ROLE_USER))
{
string userId = HttpContext.Current.User.Identity.GetUserId();
var userApps = _context.UserDetail
.Where(u => u.UserID == userId)
.FirstOrDefault().Applications;
allNotifications = userApps
.Select(x => new { Application = x, x.Servers })
.SelectMany(x => x.Servers
.SelectMany(n => n.Notifications
.Where(a => a.Applications.Contains(x.Application) || a.Applications.Count() == 0)));
}
else if (HttpContext.Current.User.IsInRole(Key.ROLE_CLIENT))
{
string userId = HttpContext.Current.User.Identity.GetUserId();
var userApps = _context.UserDetail
.Where(u => u.UserID == userId)
.FirstOrDefault().Client.Applications;
allNotifications = userApps
.Select(x => new { Application = x, x.Servers })
.SelectMany(x => x.Servers
.SelectMany(n => n.Notifications
.Where(a => a.Applications.Contains(x.Application) || a.Applications.Count() == 0)));
}
IEnumerable <Thread> allThreads = allNotifications
.GroupBy(n => n.IncidentNumber)
.Select(t => t.OrderBy(i => i.SentDateTime))
.Select(n => new { First = n.FirstOrDefault(), Last = n.LastOrDefault() })
.Where(t => model.NotificationTypeIDs.Contains(t.Last.NotificationTypeID) &&
model.LevelOfImpactIDs.Contains(t.Last.LevelOfImpactID) &&
model.StatusIDs.Contains(t.Last.StatusID) &&
model.PriorityIDs.Contains(t.Last.PriorityID))
.Select(
t => new Thread()
{
ReferenceID = t.First.ReferenceID,
IncidentNumber = t.First.IncidentNumber,
NotificationHeading = t.First.NotificationHeading,
SentDateTime = t.First.SentDateTime,
NotificationType = t.Last.NotificationType.NotificationTypeName,
LevelOfImpact = t.Last.LevelOfImpact.LevelName,
LevelOfImpactValue = t.Last.LevelOfImpact.LevelValue,
Priority = t.Last.Priority.PriorityName,
PriorityValue = t.Last.Priority.PriorityValue,
Status = t.Last.Status.StatusName
})
.GroupBy(n => n.IncidentNumber)
.Select(t => t.OrderByDescending(i => i.SentDateTime).FirstOrDefault());
return(allThreads);
}
catch (Exception)
{
return(null);
}
}
// POST: api/Notification
public NotificationIndexFiltered Post([FromBody] NotificationIndexBody model)
{
NotificationIndexFiltered result = _nApiRepo.GetFilteredAndSortedNotifications(model);
return(result);
}
