public static void Main(string[] args)
{
var db = new RealEstateDbContext();
using (db)
{
db.Database.Migrate();
IPropertiesService propertiesService = new PropertiesService(db);
//propertiesService.Create("Dianabad", "5-Rooms", "Brick", 2019, 210000, 100, 5, 12);
//propertiesService.UpdateTags(2);
//propertiesService.UpdateTags(3);
IDistrictsService districtsService = new DistrictsService(db);
var districts = districtsService.GetTopDistrictsByAveragePrice();
foreach (var district in districts)
{
Console.WriteLine($"{district.Name} => {district.AveragePrice:f2} ({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);
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}");
}
Console.WriteLine(new string('-', 60));
IDistrictsService districtsService = new DistrictsService(db);
var districts = districtsService.GetTopDistrictsByAveragePrice(100);
foreach (var district in districts)
{
Console.WriteLine($"{district.Name} => Price:{district.AveragePrice:0.00} ({district.MinPrice}-{district.MinPrice}) => {district.PropertiesCount} properties");
}
}