var _NotifyData = (from Notification in _dbContext.Notification
join MstStage in _dbContext.MstStage on Notification.Status equals MstStage.Id
where Notification.DeptId == (DeptId == 0 ? Notification.DeptId : DeptId) && Notification.Status == (Items.Status == 100 ? Notification.Status : Items.Status)
&& Notification.CreatedOn >= (Items.FromDate == string.Empty ? Notification.CreatedOn : ApplicationData.AppStringToDatetime(Items.FromDate)) && Notification.CreatedOn <= (Items.ToDate == string.Empty ? Notification.CreatedOn : ApplicationData.AppStringToDatetime(Items.ToDate))
orderby Notification.CreatedOn descending
select new NotifyData
{
RefNId = Notification.RefNid,
NType = Notification.Ntype,
NotificationH = Notification.NotificationH,
NotificationB = Notification.NotificationB,
Comment = Notification.Comment,
StatusId = (int)MstStage.Id,
Status = MstStage.Mode,
CreatedBy = (int)Notification.CreatedBy,
CreatedOn = ApplicationData.AppDateToString(Notification.CreatedOn),
ModifiedBy = (int)Notification.ModifiedBy,
ModifiedOn = ApplicationData.AppDateToString(Notification.ModifiedOn)
}).Distinct().AsEnumerable().Select((k, index) => new NotifyData()
{
SrlNo = index + 1,
RefNId = k.RefNId,
NType = k.NType,
NotificationH = k.NotificationH,
NotificationB = k.NotificationB,
Comment = k.Comment,
ApproveBy = k.ApproveBy,
StatusId = k.StatusId,
Status = k.Status,
CreatedBy = k.CreatedBy,
CreatedOn = k.CreatedOn,
ModifiedBy = k.ModifiedBy,
ModifiedOn = k.ModifiedOn,
Can_Approve = GetRegistationResult(_authenticationManager.GetAuthenticatedUser().Result.UserId, UserManageAccess.NotificationPage, UserManageAccess.NotificationApproveAction).Result,
}).ToList();