public BaseRepository(KtmDbContext context)
{
this.context = context;
entities = context.Set <T>();
}
/// <summary>
/// Get kudos for report
/// </summary>
/// <returns>Returns a collection of kudos</returns>
public async Task <IEnumerable <KudoDetailDto> > GetKudosForReport(
DateTime?dateFrom,
DateTime?dateTo,
List <int> teamIds,
List <int> kudoTypeIds,
bool hasDateRange)
{
return(await(from k in kudo
join es in context.Set <Employee>() on k.SenderId equals es.Id
join ets in context.Set <EmployeeTeam>() on es.Id equals ets.EmployeeID
join ts in context.Set <Team>() on ets.TeamID equals ts.Id
join er in context.Set <Employee>() on k.ReceiverId equals er.Id
join etr in context.Set <EmployeeTeam>() on er.Id equals etr.EmployeeID
join tr in context.Set <Team>() on etr.TeamID equals tr.Id
join kd in context.Set <KudoDetail>() on k.KudoDetailId equals kd.Id
join ty in context.Set <KudoType>() on kd.KudoTypeId equals ty.Id
where (!hasDateRange || (k.Created >= dateFrom && k.Created <= dateTo)) &&
(teamIds.Count() == 0 || teamIds.Contains(ts.Id)) &&
k.Created >= ets.JoinedDate &&
(ets.ReleseadDate == null || k.Created <= ets.ReleseadDate) &&
k.Created >= etr.JoinedDate &&
(etr.ReleseadDate == null || k.Created <= etr.ReleseadDate)
select new KudoDetailDto
{
Id = k.Id,
Created = k.Created,
Modified = k.Modified,
Content = kd.Content,
TypeName = ty.TypeName,
SenderBadgeId = es.EmployeeBadgeId,
SenderFirstMidName = es.FirstMidName,
SenderLastName = es.LastName,
SenderTeam = ts.TeamName,
ReceiverBadgeId = er.EmployeeBadgeId,
ReceiverFirstMidName = er.FirstMidName,
ReceiverLastName = er.LastName,
ReceiverTeam = tr.TeamName,
SenderEmployeeNumber = es.EmployeeNumber,
ReceiverEmployeeNumber = er.EmployeeNumber
}
).ToListAsync());
}
public TeamRepository(KtmDbContext context, ILogger <Team> logger) : base(context, logger)
{
this.context = context;
team = context.Set <Team>();
}
public KudoRepository(KtmDbContext context, IMapper mapper, ILogger <Kudo> logger) : base(context, logger)
{
this.context = context;
kudo = context.Set <Kudo>();
_mapper = mapper;
}
public KudosDetailRepository(KtmDbContext context, IMapper mapper, ILogger <KudoDetail> logger) : base(context, logger)
{
this.context = context;
KudosDetail = context.Set <KudoDetail>();
this.mapper = mapper;
}
public EmployeeTeamRepository(KtmDbContext context, ILogger <EmployeeTeam> logger) : base(context, logger)
{
employeeTeam = context.Set <EmployeeTeam>();
}
public EmployeeRepository(KtmDbContext context, ILogger <Employee> logger) : base(context, logger)
{
this.context = context;
employee = context.Set <Employee>();
}
public BaseRepository(KtmDbContext context, ILogger <T> logger)
{
this.context = context;
entities = context.Set <T>();
_logger = logger;
}
