public ShelterDetailsModel Query(Guid guid)
{
var model = new ShelterDetailsModel();
var Clients = new List <Client>();
model.Shelter = _context.Shelters.FirstOrDefault(x => x.Id == guid);
//var bedsInShelter = _context.Beds.Where(x => x.Shelter.Id == guid).ToList();
var clientIdsFromBB = _context.BedBookings.Where(x => x.Bed.Shelter.Id == guid).Select(b => b.ClientId).ToList();
Clients.AddRange(_context.Clients.Where(c => clientIdsFromBB.Contains(c.Id)).ToList());
// bedsInShelter.ForEach(x =>
// {
// var clientIds = _context.BedBookings.Where(b => b.Bed.Id == x.Id).Select(y => y.ClientId).ToList();
//
// Clients.AddRange(_context.Clients.Where(c => clientIds.Contains(c.Id)).ToList());
// });
model.Clients = Clients;
return(model);
}
private ShelterDetailsModel GetClientsByShelterId(Guid guid)
{
var model = new ShelterDetailsModel();
model.Shelter = _dbContext.Shelters.FirstOrDefault(x => x.Id == guid);
//var guid = new Guid("4D1D68F4-D8CB-427C-986B-0DCC995F7964");
var bedsInShelter = _dbContext.Beds.Where(x => x.Shelter.Id == guid).ToList();
var aaa = _dbContext.BedBookings.Where(x => x.Bed.Shelter.Id == guid).ToList();
var Clients = new List <Client>();
bedsInShelter.ForEach(x =>
{
var clientIds = _dbContext.BedBookings.Where(b => b.Bed.Id == x.Id).Select(y => y.ClientId).ToList();
Clients.AddRange(_dbContext.Clients.Where(c => clientIds.Contains(c.Id)).ToList());
});
model.Clients = Clients;
return(model);
}
