// Get One housing unit with Provider
// DEFAULT
// RETURNS ONE HOUSING UNIT BY ID WITH: Address, and Provider with Contact
public HousingUnitProviderMapper GetHousingUnitWithProvider(int housingUnitId)
{
var content = db.HousingUnits.Where(j => j.housingUnitId == housingUnitId).FirstOrDefault();
if (content == null)
{
return(null);
}
else
{
AddressesHelper address = new AddressesHelper();
ProvidersHelper provider = new ProvidersHelper();
HousingUnitProviderMapper housingUnit = new HousingUnitProviderMapper()
{
HousingUnitId = content.housingUnitId,
ProviderId = content.providerId ?? 0,
AddressId = content.addressId ?? 0,
HousingSignature = content.housingSignature,
Capacity = content.capacity,
Address = address.GetAddress(content.addressId ?? 0),
Provider = provider.GetProviderWithContact(housingUnitId)
};
return(housingUnit);
}
}
// Get All housing units with Provider
// DEFAULT
// RETURNS ALL THE HOUSING UNITS WITH: Address, and Provider with Contact
public IEnumerable <HousingUnitProviderMapper> GetHousingUnitsWithProvider()
{
var content = db.HousingUnits.Where(j => j.housingUnitId != 0).ToList();
if (content.Count() == 0)
{
return(null);
}
else
{
List <HousingUnitProviderMapper> housingUnits = new List <HousingUnitProviderMapper>();
AddressesHelper address = new AddressesHelper();
ProvidersHelper provider = new ProvidersHelper();
foreach (var item in content)
{
HousingUnitProviderMapper housingUnit = new HousingUnitProviderMapper()
{
HousingUnitId = item.housingUnitId,
ProviderId = item.providerId ?? 0,
AddressId = item.addressId ?? 0,
HousingSignature = item.housingSignature,
Capacity = item.capacity,
Address = address.GetAddress(item.addressId ?? 0),
Provider = provider.GetProviderWithContact(item.providerId ?? 0)
};
housingUnits.Add(housingUnit);
}
return(housingUnits);
}
}