public Task <List <SocietyAsset> > List(SocietyAssetSearchParams searchParams)
        {
            var taskResult = Task.Run(() =>
            {
                using (var context = new DbContext())
                {
                    var ctx = context
                              .SocietyAssets
                              .Include(c => c.Complex)
                              .Include(c => c.Complex.City)
                              .Include(c => c.Complex.State)
                              .Include(s => s.Society)
                              .Include(f => f.Facility)
                              .Include(s => s.Floor);

                    if (searchParams.FacilityId.HasValue)
                    {
                        ctx = ctx.Where(c => c.FacilityId == searchParams.FacilityId.Value);
                    }

                    if (searchParams.SocietyId.HasValue)
                    {
                        ctx = ctx.Where(c => c.SocietyId == searchParams.SocietyId.Value);
                    }

                    return(ctx.ToList());
                }
            });

            return(taskResult);
        }
示例#2
0
 public Task <List <SocietyAsset> > List(SocietyAssetSearchParams searchParams)
 {
     return(_societyAssetRepository.List(searchParams));
 }