public IEnumerable <BLListing> GetSearchListings(
string suburb, int bedrooms,
decimal minprice, decimal maxprice)
{
return(AddModelToList(
DALListings.SearchListings(suburb, bedrooms,
minprice, maxprice)));
}
public IEnumerable <string> GetSuburbs()
{
var suburbsDT = DALListings.GetListingsSuburbs();
return((
from DataRow drow in suburbsDT.Rows
select drow["Suburb"].ToString()).ToList());
}
public IEnumerable <int> GetBedrooms()
{
var bedroomsDT =
DALListings.GetListingsBedrooms();
return((
from DataRow drow in bedroomsDT.Rows
select(int) drow["Bedrooms"]).ToList());
}
public IEnumerable <string> GetPriceRanges()
{
var rangesDT =
DALListings.GetListingsPrices();
var priceList = new List <string>();
var range = new StringBuilder();
var priceStr = "";
for (var i = 0; i < rangesDT.Rows.Count; i++)
{
var price =
Convert.ToDecimal(rangesDT.Rows[i]["Price"]);
var roundedPrice =
Math.Round(price / 50) * 50;
if (i == 0)
{
var firstStrRange =
"0 - " + roundedPrice;
range.Append(firstStrRange);
priceList.Add(firstStrRange);
}
else
{
if (range.Length > 0)
{
var firstRange =
range.ToString().Split('-').Length == 3 ?
range.ToString().Split('-')[2].Trim() :
range.ToString().Split('-')[1].Trim();
priceStr =
firstRange +
" - " + Math.Round(price / 50) * 50;
if (Convert.ToDecimal(firstRange) !=
Math.Round(price / 50) * 50)
{
priceList.Add(priceStr);
}
}
else
{
var priceR =
priceStr.Split('-').Length == 3
? priceStr.Split('-')[2].Trim()
: priceStr.Split('-')[1].Trim();
if (Convert.ToDecimal(priceR) < roundedPrice)
{
priceStr =
priceR + " - " + roundedPrice;
}
if (price > roundedPrice)
{
priceStr =
roundedPrice + " - " +
(roundedPrice + 50m);
}
priceList.Add(priceStr);
}
range.Clear();
}
}
return(priceList);
}
public IEnumerable <BLListing> GetFeaturedListing()
{
return(AddModelToList(
DALListings.GetFeaturedListings()));
}
