public async Task <int> Count(SLAAlertFRTUserFilter filter)
{
IQueryable <SLAAlertFRTUserDAO> SLAAlertFRTUsers = DataContext.SLAAlertFRTUser.AsNoTracking();
SLAAlertFRTUsers = DynamicFilter(SLAAlertFRTUsers, filter);
return(await SLAAlertFRTUsers.CountAsync());
}
public async Task <bool> ValidateId(SLAAlertFRTUser SLAAlertFRTUser)
{
SLAAlertFRTUserFilter SLAAlertFRTUserFilter = new SLAAlertFRTUserFilter
{
Skip = 0,
Take = 10,
Id = new IdFilter {
Equal = SLAAlertFRTUser.Id
},
Selects = SLAAlertFRTUserSelect.Id
};
int count = await UOW.SLAAlertFRTUserRepository.Count(SLAAlertFRTUserFilter);
if (count == 0)
{
SLAAlertFRTUser.AddError(nameof(SLAAlertFRTUserValidator), nameof(SLAAlertFRTUser.Id), ErrorCode.IdNotExisted);
}
return(count == 1);
}
private async Task <List <SLAAlertFRTUser> > DynamicSelect(IQueryable <SLAAlertFRTUserDAO> query, SLAAlertFRTUserFilter filter)
{
List <SLAAlertFRTUser> SLAAlertFRTUsers = await query.Select(q => new SLAAlertFRTUser()
{
Id = filter.Selects.Contains(SLAAlertFRTUserSelect.Id) ? q.Id : default(long),
SLAAlertFRTId = filter.Selects.Contains(SLAAlertFRTUserSelect.SLAAlertFRT) ? q.SLAAlertFRTId : default(long?),
AppUserId = filter.Selects.Contains(SLAAlertFRTUserSelect.AppUser) ? q.AppUserId : default(long?),
AppUser = filter.Selects.Contains(SLAAlertFRTUserSelect.AppUser) && q.AppUser != null ? new AppUser
{
Id = q.AppUser.Id,
Username = q.AppUser.Username,
DisplayName = q.AppUser.DisplayName,
Address = q.AppUser.Address,
Email = q.AppUser.Email,
Phone = q.AppUser.Phone,
SexId = q.AppUser.SexId,
Birthday = q.AppUser.Birthday,
Avatar = q.AppUser.Avatar,
Department = q.AppUser.Department,
OrganizationId = q.AppUser.OrganizationId,
Longitude = q.AppUser.Longitude,
Latitude = q.AppUser.Latitude,
StatusId = q.AppUser.StatusId,
} : null,
SLAAlertFRT = filter.Selects.Contains(SLAAlertFRTUserSelect.SLAAlertFRT) && q.SLAAlertFRT != null ? new SLAAlertFRT
{
Id = q.SLAAlertFRT.Id,
TicketIssueLevelId = q.SLAAlertFRT.TicketIssueLevelId,
IsNotification = q.SLAAlertFRT.IsNotification,
IsMail = q.SLAAlertFRT.IsMail,
IsSMS = q.SLAAlertFRT.IsSMS,
Time = q.SLAAlertFRT.Time,
TimeUnitId = q.SLAAlertFRT.TimeUnitId,
IsAssignedToUser = q.SLAAlertFRT.IsAssignedToUser,
IsAssignedToGroup = q.SLAAlertFRT.IsAssignedToGroup,
SmsTemplateId = q.SLAAlertFRT.SmsTemplateId,
MailTemplateId = q.SLAAlertFRT.MailTemplateId,
} : null,
CreatedAt = q.CreatedAt,
UpdatedAt = q.UpdatedAt,
}).ToListAsync();
return(SLAAlertFRTUsers);
}