public ActionResult ListingFilters(ListingFiltersRequestModel model)
{
var client = new Client();
var listings =
client.RunAsync(new ListingAction(new ListingFilters(model.Type, model.PlaceName))).Result;
var flats = listings.Response.Listings.Select(x => new Flat
{
Price = x.Price.ToString(),
Title = x.Title,
ImgUrl = x.ImgUrl,
FlatLocation = x.Title,
BedNum = x.BedNum.ToString(),
BathNum = x.BathNum.ToString(),
Summary = x.Summary,
Latitude = x.Latitude,
Longitude = x.Longitude
});
using (var context = new FlatDbContext())
{
context.Flats.AddRange(flats);
context.SaveChanges();
}
return(View("~/Views/NestoriaClient/List.cshtml", flats));
}
static void Main()
{
try
{
var listingAction = new ListingAction(new ListingFilters(ListingTypes.Buy, "Chelsea"));
var result = RunAsync(listingAction).Result;
var flats = result.Response.Listings.Select(x => new Flat
{
Price = x.Price.ToString(),
FlatLocation = x.Title.ToString(),
BedNum = x.BedNum.ToString(),
BathNum = x.BathNum.ToString(),
Summary = x.Summary.ToString()
});
using (var context = new FlatDbContext())
{
context.Flats.AddRange(flats);
context.SaveChanges(); //context
}
}
catch (ArgumentException e)
{
Console.WriteLine($"Something is going wrong: {e.Message}");
}
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
public async Task <Database> Connect(FlatDbContext Context, string Token)
{
_Context = Context;
var item = await _Context.Item.SingleOrDefaultAsync(m => m.Database == TokenDatabase && m.ItemId == TokenToId(Token));
if (item != null)
{
Console.WriteLine("Database item found");
_DatabaseId = Int64.Parse(item.MasterId, NullDatabase);
_CanWrite = _DatabaseId != NullDatabase && item.StatusId == TokenWriteStatusId;
_CanRead = _CanWrite || (_DatabaseId != NullDatabase && item.StatusId == TokenReadStatusId);
}
else
{
Console.WriteLine("No data found");
_DatabaseId = NullDatabase;
_CanRead = false;
_CanWrite = false;
}
return(this);
}
public FlatDbController(FlatDbContext aContext) => _context = aContext;
public static async Task <Database> Access(FlatDbContext Context, string Token)
{
return(await new Database().Connect(Context, Token));
}
