// Get All supply request by House Unit/tenat
// DEFAULT
// RETURNS ALL THE HOUSING UNITS WITH: Address, and Tenants with Supply Requests
public IEnumerable <HousingUnitProviderTenantSupplyMapper> GetHousingUnitsSupplyRequest(int housingUnitId)
{
var content = db.HousingUnits.Where(j => j.housingUnitId == housingUnitId).ToList();
if (content.Count() == 0)
{
return(null);
}
else
{
List <HousingUnitProviderTenantSupplyMapper> housingUnits = new List <HousingUnitProviderTenantSupplyMapper>();
AddressesHelper address = new AddressesHelper();
TenantsHelper tenants = new TenantsHelper();
foreach (var item in content)
{
HousingUnitProviderTenantSupplyMapper housingUnit = new HousingUnitProviderTenantSupplyMapper
{
HousingUnitId = item.housingUnitId,
ProviderId = item.providerId ?? 0,
AddressId = item.addressId ?? 0,
HousingSignature = item.housingSignature,
Capacity = item.capacity,
Address = address.GetAddress(item.addressId ?? 0),
Tenants = tenants.GetTenantsWithSupplies(item.housingUnitId)
};
housingUnits.Add(housingUnit);
}
return(housingUnits);
}
}
// Get All with Address
// DEFAULT
// RETURNS ALL THE HOUSING UNITS WITH: Address
public IEnumerable <HousingUnitAddressMapper> GetHousingUnitsWithAddress()
{
var content = db.HousingUnits.ToList();
if (content.Count() == 0)
{
return(null);
}
else
{
List <HousingUnitAddressMapper> housingUnits = new List <HousingUnitAddressMapper>();
AddressesHelper address = new AddressesHelper();
foreach (var item in content)
{
HousingUnitAddressMapper housingUnit = new HousingUnitAddressMapper()
{
HousingUnitId = item.housingUnitId,
ProviderId = item.providerId ?? 0,
AddressId = item.addressId ?? 0,
HousingSignature = item.housingSignature,
Capacity = item.capacity,
Address = address.GetAddress(item.addressId ?? 0)
};
housingUnits.Add(housingUnit);
}
return(housingUnits);
}
}
// Get One housing unit with Tenants
// DEFAULT
// RETURNS ONE HOUSING UNIT WITH: Tenants with Batch, Contact, Gender, and Car Relationship
public HousingUnitTenantInfoMapper GetHousingUnitWithTenants(int housingUnitId)
{
var content = db.HousingUnits.Where(j => j.housingUnitId == housingUnitId).FirstOrDefault();
if (content == null)
{
return(null);
}
else
{
AddressesHelper address = new AddressesHelper();
TenantsHelper tenants = new TenantsHelper();
HousingUnitTenantInfoMapper housingUnit = new HousingUnitTenantInfoMapper()
{
HousingUnitId = content.housingUnitId,
ProviderId = content.providerId ?? 0,
AddressId = content.addressId ?? 0,
HousingSignature = content.housingSignature,
Capacity = content.capacity,
Address = address.GetAddress(content.addressId ?? 0),
Tenants = tenants.GetTenantsWithInfoByHousing(content.housingUnitId)
};
return(housingUnit);
}
}
// 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 One with Address
// DEAFULT
// RETURNS ALL THE HOUSING UNITS BY ID WITH: Address
public HousingUnitAddressMapper GetHousingUnitWithAddress(int housingUnitId)
{
var content = db.HousingUnits.FirstOrDefault(j => j.housingUnitId == housingUnitId);
if (content == null)
{
return(null);
}
else
{
AddressesHelper address = new AddressesHelper();
HousingUnitAddressMapper housingUnit = new HousingUnitAddressMapper()
{
HousingUnitId = content.housingUnitId,
ProviderId = content.providerId ?? 0,
AddressId = content.addressId ?? 0,
HousingSignature = content.housingSignature,
Capacity = content.capacity,
Address = address.GetAddress(content.addressId ?? 0)
};
return(housingUnit);
}
}
// Get All housing units with Tenants
// DEFAULT
// RETURNS ALL THE HOUSING UNITS WITH: Tenants with Batch, Contact, Gender, and Car Relationship
public IEnumerable <HousingUnitAvailableMapper> GetHousingUnitsWithTenantsAvailable()
{
var content = db.HousingUnits.Where(j => j.housingUnitId != 0).ToList();
if (content.Count() == 0)
{
return(null);
}
else
{
List <HousingUnitAvailableMapper> housingUnits = new List <HousingUnitAvailableMapper>();
AddressesHelper address = new AddressesHelper();
TenantsHelper tenants = new TenantsHelper();
foreach (var item in content)
{
HousingUnitAvailableMapper housingUnit = new HousingUnitAvailableMapper()
{
HousingUnitId = item.housingUnitId,
ProviderId = item.providerId ?? 0,
AddressId = item.addressId ?? 0,
HousingSignature = item.housingSignature,
Capacity = item.capacity,
Address = address.GetAddress(item.addressId ?? 0),
Tenants = tenants.GetTenantsWithInfoByHousing(item.housingUnitId)
};
if (housingUnit.Tenants != null)
{
housingUnit.Occupied = housingUnit.Tenants.Count();
housingUnit.Available = housingUnit.Capacity - housingUnit.Tenants.Count();
}
else
{
housingUnit.Occupied = 0;
housingUnit.Available = housingUnit.Capacity;
}
housingUnits.Add(housingUnit);
}
return(housingUnits);
}
}
// Get One housing unit with Tenants
// DEFAULT
// RETURNS ONE HOUSING UNIT WITH: Tenants with Batch, Contact, Gender, and Car Relationship
public HousingUnitAvailableMapper GetHousingUnitsWithTenantsAvailable(int housingUnitId)
{
var content = db.HousingUnits.Where(j => j.housingUnitId == housingUnitId).FirstOrDefault();
if (content == null)
{
return(null);
}
else
{
AddressesHelper address = new AddressesHelper();
TenantsHelper tenants = new TenantsHelper();
HousingUnitAvailableMapper housingUnit = new HousingUnitAvailableMapper()
{
HousingUnitId = content.housingUnitId,
ProviderId = content.providerId ?? 0,
AddressId = content.addressId ?? 0,
HousingSignature = content.housingSignature,
Capacity = content.capacity,
Address = address.GetAddress(content.addressId ?? 0),
Tenants = tenants.GetTenantsWithInfoByHousing(content.housingUnitId)
};
if (housingUnit.Tenants != null)
{
housingUnit.Occupied = housingUnit.Tenants.Count();
housingUnit.Available = housingUnit.Capacity - housingUnit.Tenants.Count();
}
else
{
housingUnit.Occupied = 0;
housingUnit.Available = housingUnit.Capacity;
}
return(housingUnit);
}
}
