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; }