// 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); } }