public async Task <IEnumerable <PropertyDetail> > getAllPropertyDetails() { using (var context = new PropertyManagementContext(_dbContextOptions)) { return(await context.PropertyDetail.Include(x => x.PropertyImage).Include(x => x.OwnerHistory).ToListAsync()); } }
public async Task <PropertyDetail> getPropertyDetails(int propertyDetailId) { using (var context = new PropertyManagementContext(_dbContextOptions)) { return(await context.PropertyDetail.Include(x => x.PropertyImage).Include(y => y.OwnerHistory).Where(x => x.Id == propertyDetailId).FirstOrDefaultAsync()); } }
public async Task <IEnumerable <OwnerHistory> > getOwnerHistory(int propertyDetailId) { using (var context = new PropertyManagementContext(_dbContextOptions)) { return(await context.OwnerHistory.Where(x => x.PropertyDetailId == propertyDetailId)?.ToListAsync()); } }
public async Task <IEnumerable <PropertyDetail> > searchPropertyDetails(PropertySearchModel searchModel) { using (var context = new PropertyManagementContext(_dbContextOptions)) { var result = context.PropertyDetail.Include(x => x.PropertyImage).Include(x => x.OwnerHistory).AsQueryable(); if (searchModel != null) { if (!string.IsNullOrEmpty(searchModel.OwnerName)) { bool containsOwner = false; foreach (var item in result) { var owners = item.OwnerHistory.Select(x => x.OwnerName); foreach (var owner in owners) { if (owner.Contains(searchModel.OwnerName)) { containsOwner = true; } } result = (!containsOwner) ? result.Where(y => y.Id != item.Id): result; } } if (!string.IsNullOrEmpty(searchModel.Address)) { result = result.Where(x => x.PropertyAddress.Contains(searchModel.Address)); } if (searchModel.NumOfBedrooms.HasValue && searchModel.NumOfBedrooms.Value != 0) { result = result.Where(x => x.NumOfBedrooms == searchModel.NumOfBedrooms); } if (searchModel.NumOfBathrooms.HasValue && searchModel.NumOfBathrooms.Value != 0) { result = result.Where(x => x.NumOfbathrooms == searchModel.NumOfBathrooms); } } return(await result?.ToListAsync()); } }
public PropertyLeasersController(PropertyManagementContext context) { _context = context; }
public MaintenanceRequestsController(PropertyManagementContext context) { _context = context; }
public UnitRepository() { _context = new PropertyManagementContext(); }
public BuildingRepository() { _context = new PropertyManagementContext(); }
public PaymentHistoriesController(PropertyManagementContext context) { _context = context; }