jTable - Display item from Foreign Key table #3331

4 Answer(s)

• 

  0

  20summers created 7 years ago

  WIll I have to do something like below or is their an easier way?

  private IQueryable<AuditLogAndUser> CreateAuditLogAndUsersQuery(GetAuditLogsInput input)
          {
              var query = from auditLog in _auditLogRepository.GetAll()
                  join user in _userRepository.GetAll() on auditLog.UserId equals user.Id into userJoin
                  from joinedUser in userJoin.DefaultIfEmpty()
                  where auditLog.ExecutionTime >= input.StartDate && auditLog.ExecutionTime <= input.EndDate
                  select new AuditLogAndUser {AuditLog = auditLog, User = joinedUser};
  
              query = query
                  .WhereIf(!input.UserName.IsNullOrWhiteSpace(), item => item.User.UserName.Contains(input.UserName))
                  .WhereIf(!input.ServiceName.IsNullOrWhiteSpace(), item => item.AuditLog.ServiceName.Contains(input.ServiceName))
                  .WhereIf(!input.MethodName.IsNullOrWhiteSpace(), item => item.AuditLog.MethodName.Contains(input.MethodName))
                  .WhereIf(!input.BrowserInfo.IsNullOrWhiteSpace(), item => item.AuditLog.BrowserInfo.Contains(input.BrowserInfo))
                  .WhereIf(input.MinExecutionDuration.HasValue && input.MinExecutionDuration > 0, item => item.AuditLog.ExecutionDuration >= input.MinExecutionDuration.Value)
                  .WhereIf(input.MaxExecutionDuration.HasValue && input.MaxExecutionDuration < int.MaxValue, item => item.AuditLog.ExecutionDuration <= input.MaxExecutionDuration.Value)
                  .WhereIf(input.HasException == true, item => item.AuditLog.Exception != null && item.AuditLog.Exception != "")
                  .WhereIf(input.HasException == false, item => item.AuditLog.Exception == null || item.AuditLog.Exception == "");
              return query;
          }
  

  Save Cancel
• 

  0

  exlnt created 7 years ago

  In my table class I have setup a FK using the code below.

  [Required]
          [ForeignKey("ListValuesCF")]
          public int ContributionFrequency { get; set; }
          public virtual ListValues ListValuesCF { get; set; }
  

  In my ResidentFundingListDto I have the following two properties. public int ContributionFrequency { get; set; } public string ContributionFrequencyName { get; set; } The second one holds the "text" value for the frequency. This is what I display on my JTable grid.

  Then I used the code shown below to display the "text" value on my JTable grid.

  public async Task<PagedResultDto<ResidentFundingListDto>> GetResidentFundingSources(GetResidentFundingInput input)
          {
                 var query = from rf in _residentFundingRepository.GetAll()
                              select new ResidentFundingListDto
                              {
                                  ActiveYesNo = rf.ActiveYesNo,
                                  ContributionAmount = rf.ContributionAmount,
                                  ContributionFrequency = rf.ContributionFrequency,
                                  ContributionFrequencyName = rf.ListValuesCF.ListText, //This is a join to table named ListValues 
                                  CreationTime = rf.CreationTime,
                                  Id = rf.Id
                              };
                  query = query.WhereIf(!input.Filter.IsNullOrWhiteSpace(), R => R.ResidentName.Contains(input.Filter));
                  var resultCount = await query.CountAsync();
                  var results = await query.OrderBy(input.Sorting).PageBy(input).ToListAsync();
                  return new PagedResultDto<ResidentFundingListDto>(resultCount, results);
              }
          }
  

  Save Cancel
• 

  0

  20summers created 7 years ago

  Brilliant - thanks so much!

  Save Cancel
• 

  0

  ismcagdas created 7 years ago

  Support Team

  Thanks a lot @exlnt :)

  Save Cancel