static void Main(string[] args) { Console.OutputEncoding = Encoding.UTF8; var db = new RealEstateDbContext(); db.Database.Migrate(); IPropertiesService propertiesService = new PropertiesService(db); Console.Write("Min price: "); int minPrice = int.Parse(Console.ReadLine()); Console.Write("Max price: "); int maxPrice = int.Parse(Console.ReadLine()); var properties = propertiesService.SearchByPrice(minPrice, maxPrice); foreach (var property in properties) { Console.WriteLine($"{property.District}, fl. {property.Floor}, {property.Size} m², {property.Year}, {property.Price}€, {property.PropertyType}, {property.BuildingType}"); } //IDistrictsService districtService = new DistrictsService(db); //var districts = districtService.GetTopDistrictsByAveragePrice(); //foreach (var district in districts) //{ // Console.WriteLine($"{district.Name} => Price: {district.AveragePrice} ({district.MinPrice} - {district.MaxPrice}) => {district.PropertiesCount} properties"); //} }
static void Main(string[] args) { Console.OutputEncoding = Encoding.UTF8; var db = new RealEstateDbContext(); db.Database.Migrate(); IPropertiesService propertiesService = new PropertiesService(db); var properties = propertiesService.SearchByPrice(0, 200000); foreach (var property in properties.Take(3)) { Console.WriteLine($"District: {property.District}, Floor: {property.Floor},Size: {property.Size}, Year: {property.Year}, {property.BuildingType}, {property.PropertyType}"); } //propertiesService.Create(2000, 3, 10, "Manastirski livadi", "mesonet", "brich", 2020, 5000000); //propertiesService.UpdateTags(1); //IDistrictsService districtService = new DistrictService(db); //var districts = districtService.GetTopDistrictsByAveragePrice(); //foreach (var district in districts) //{ // Console.WriteLine($"{district.Name} - {district.AveragePrice} ,{district.MinPrice}, {district.MaxPrice}"); //} }
static void Main(string[] args) { Console.OutputEncoding = Encoding.UTF8; var db = new RealEstateDbContext(); //db.Database.Migrate(); IPropertiesService propertiesService = new PropertiesService(db); //propertiesService.Create("Dianabad", 100, 2019, 322000000, "4-Staen", "Panelka", 17, 21); IDistrictsService districtsService = new DistrictsService(db); //var districts = districtsService.GetTopDisctrictsByAveragePrice(); //foreach (var district in districts) //{ // Console.WriteLine($"{district.Name} => Price: {district.AveragePrice} ({district.MinPrice} - {district.MaxPrice}) => properties: {district.PropertiesCount}"); //} Console.Write("Min price: "); int minPrice = int.Parse(Console.ReadLine()); Console.Write("Max price: "); int maxPrice = int.Parse(Console.ReadLine()); var properties = propertiesService.SearchByPrice(minPrice, maxPrice); foreach (var property in properties) { Console.WriteLine($"{property.Price}"); } }
private static void SearchPropertiesInPriceRange(RealEstateDbContext db) { IPropertiesService propertiesService = new PropertiesService(db); Console.Write("Min price: "); int minPrice = int.Parse(Console.ReadLine()); Console.Write("Max price: "); int maxPrice = int.Parse(Console.ReadLine()); var properties = propertiesService.SearchByPrice(minPrice, maxPrice); foreach (var property in properties) { Console.WriteLine( $"{property.District}, fl. {property.Floor}, {property.Size} m², {property.Year}, {property.Price:f2}€, {property.PropertyType}, {property.BuildingType}"); } }
static void Main(string[] args) { Console.OutputEncoding = Encoding.UTF8; RealEstateDbContext db = new RealEstateDbContext(); db.Database.Migrate(); //Console.WriteLine("Created"); IPropertiesService propertiesService = new PropertiesService(db); Console.Write("Min price: "); int minPrice = int.Parse(Console.ReadLine()); Console.Write("Max price: "); int maxPrice = int.Parse(Console.ReadLine()); var properties = propertiesService.SearchByPrice(minPrice, maxPrice); foreach (var property in properties) { Console.WriteLine($"{property.District}, fl. {property.Floor}, {property.Size} m², {property.Year}, {property.Price}€, {property.PropertyType}, {property.BuildingType}"); } }