// Get All basic tables
// DEFAULT CRUD
public IEnumerable <HousingUnitMapper> GetHousingUnits()
{
var content = db.HousingUnits.ToList();
if (content.Count() == 0)
{
return(null);
}
else
{
List <HousingUnitMapper> housingUnits = new List <HousingUnitMapper>();
foreach (var item in content)
{
HousingUnitMapper housingUnit = new HousingUnitMapper()
{
HousingUnitId = item.housingUnitId,
ProviderId = item.providerId ?? 0,
AddressId = item.addressId ?? 0,
HousingSignature = item.housingSignature,
Capacity = item.capacity
};
housingUnits.Add(housingUnit);
}
return(housingUnits);
}
}
// Get One basic table
// DEFAULT CRUD
public HousingUnitMapper GetHousingUnit(int housingUnitId)
{
var content = db.HousingUnits.FirstOrDefault(j => j.housingUnitId == housingUnitId);
if (content == null)
{
return(null);
}
else
{
HousingUnitMapper housingUnit = new HousingUnitMapper()
{
HousingUnitId = content.housingUnitId,
ProviderId = content.providerId ?? 0,
AddressId = content.addressId ?? 0,
HousingSignature = content.housingSignature,
Capacity = content.capacity
};
return(housingUnit);
}
}
