public Status <ListingCountModel> GetListingCounts()
{
var result = new ListingCountModel();
using (var context = new RentlerContext())
{
var counts = (from b in context.Buildings
where b.IsActive && !b.IsDeleted
group b by b.PropertyTypeCode into grouped
select new
{
PropertyTypeCode = grouped.Key,
Count = grouped.Count()
}).ToList();
foreach (var item in counts)
{
switch ((PropertyType)item.PropertyTypeCode)
{
case PropertyType.SingleFamilyHome:
result.SingleFamilyHome = item.Count;
break;
case PropertyType.Apartment:
result.Apartment = item.Count;
break;
case PropertyType.CondoTownhome:
result.CondoTownhome = item.Count;
break;
case PropertyType.MultiFamilyHome:
result.MultiFamilyHome = item.Count;
break;
case PropertyType.ManufacturedHome:
result.ManufacturedHome = item.Count;
break;
case PropertyType.HorseLivestock:
result.HorseLivestock = item.Count;
break;
case PropertyType.SingleRoom:
result.SingleRoom = item.Count;
break;
default:
break;
}
}
}
return(Status.OK(result));
}
public Status<ListingCountModel> GetListingCounts()
{
var result = new ListingCountModel();
using (var context = new RentlerContext())
{
var counts = (from b in context.Buildings
where b.IsActive && !b.IsDeleted
group b by b.PropertyTypeCode into grouped
select new
{
PropertyTypeCode = grouped.Key,
Count = grouped.Count()
}).ToList();
foreach (var item in counts)
switch ((PropertyType)item.PropertyTypeCode)
{
case PropertyType.SingleFamilyHome:
result.SingleFamilyHome = item.Count;
break;
case PropertyType.Apartment:
result.Apartment = item.Count;
break;
case PropertyType.CondoTownhome:
result.CondoTownhome = item.Count;
break;
case PropertyType.MultiFamilyHome:
result.MultiFamilyHome = item.Count;
break;
case PropertyType.ManufacturedHome:
result.ManufacturedHome = item.Count;
break;
case PropertyType.HorseLivestock:
result.HorseLivestock = item.Count;
break;
case PropertyType.SingleRoom:
result.SingleRoom = item.Count;
break;
default:
break;
}
}
return Status.OK(result);
}
