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