public void LoadDatabase()
{
Customers.Clear();
Cities.Clear();
Places.Clear();
CustomersPlaces.Clear();
var requestCities = new RestRequest("api/city", Method.GET);
var queryResultCities = _restClient.Execute <List <City> >(requestCities).Data;
if (queryResultCities != null)
{
foreach (City c in queryResultCities)
{
Cities.Add(new CityVM(c));
}
}
var requestPlaces = new RestRequest("api/place", Method.GET);
var queryResultPlaces = _restClient.Execute <List <Place> >(requestPlaces).Data;
if (queryResultPlaces != null)
{
foreach (Place p in queryResultPlaces)
{
Places.Add(new PlaceVM(p));
}
}
var requestCustomersPlaces = new RestRequest("api/customerPlace", Method.GET);
var queryResultCustomersPlaces = _restClient.Execute <List <CustomerPlace> >(requestCustomersPlaces).Data;
if (queryResultCustomersPlaces != null)
{
foreach (CustomerPlace p in queryResultCustomersPlaces)
{
CustomersPlaces.Add(p);
}
}
var requestCustomers = new RestRequest("api/customer", Method.GET);
var queryResultCustomers = _restClient.Execute <List <Customer> >(requestCustomers).Data;
if (queryResultCustomers != null)
{
foreach (Customer c in queryResultCustomers)
{
Customers.Add(new CustomerVM(c, GetPlaceByCustomerId(c)));
}
}
ClearText();
}
public PlaceVM GetPlaceByCustomerId(Customer c)
{
return(Places.First(x => x.Id == CustomersPlaces.Where(y => y.CustomerId == c.Id).OrderByDescending(z => z.UpdateTime).First().PlaceId));
}
