public async Task<BaseDto<NotifGet>> Handle(GetNotificationQuery request, CancellationToken cancellationToken)
{
var result = _context.notifications.Where(x => x.id == request.id);
if (result.Count() != 0)
{
var early = new DateTime(1970, 1, 1, 0, 0, 0, 0);
var notification_log = await _context.notificationLogs.Where(x => x.notification_id == request.id && x.read_at != 0)
.Select(s => new Logs
{
notification_id = s.notification_id,
from = s.from,
read_at = early.AddSeconds(s.read_at),
target = s.target
}).ToListAsync();
var nullRead = await _context.notificationLogs.Where(x => x.notification_id == request.id && x.read_at == 0)
.Select(s => new Logs
{
notification_id = s.notification_id,
from = s.from,
read_at = null,
target = s.target
}).ToListAsync();
notification_log.AddRange(nullRead);
return new BaseDto<NotifGet>
{
message = "Success Retrieve Notification Data",
success = true,
data = new NotifGet
{
total = notification_log.Count(),
read_count = notification_log.Where(x => x.read_at != null).Count(),
notifications = await result.Select(s => new notificationsGet
{
id = s.id,
title = s.title,
message = s.message
}).ToListAsync(),
notification_logs = (request.include.ToLower() == "logs") ? notification_log.OrderBy(x => x.notification_id).ToList() : null
}
};
}
else
{
return new BaseDto<NotifGet>
{
message = "Failed Retrieve Notification Data",
success = false,
data = null
};
}
}
public async Task <BaseDto <NotifGet> > Handle(GetNotificationQuery request, CancellationToken cancellationToken)
{
var result = _context.notifications.Where(x => x.id == request.id);
if (result.Count() != 0)
{
return(new BaseDto <NotifGet>
{
message = "Success Retrieve Notification Data",
success = true,
data = new NotifGet
{
notifications = await result.Select(s => new notificationsGet
{
id = s.id,
title = s.title,
message = s.message
}).ToListAsync(),
notification_logs = (request.include.ToLower() == "logs") ?
await _context.notificationLogs.Where(x => x.notification_id == request.id)
.Select(s => new Logs
{
notification_id = s.notification_id,
from = s.from,
read_at = s.read_at,
target = s.target
}).ToListAsync() :
null
}
});
}
else
{
return(new BaseDto <NotifGet>
{
message = "Failed Retrieve Notification Data",
success = false,
data = null
});
}
}