private void FromBox_TextChanged(AutoSuggestBox sender, AutoSuggestBoxTextChangedEventArgs args)
{
if (args.CheckCurrent())
{
using (var context = new parusaContext())
{
List <string> result = new List <string>();
string term = fromBox.Text.ToLower();
if (term == "")
{
return;
}
var cities = context.Cities.Where(i => i.Name.StartsWith(term)).ToList();
if (cities.Count != 0)
{
List <Airports> ports = new List <Airports>();
foreach (var city in cities)
{
ports.AddRange(context.Airports.Where(i => i.City == city));
}
foreach (var air in ports)
{
string country = context.Countries.FirstOrDefault(q => q.Id == air.City.IdCountry).Name;
string item = string.Format("{0}, {1}, {2}", air.City.Name, country, air.Iatacode);
result.Add(item);
}
}
// var airports = context.Airports.Where(i => i.Name.ToLower().Contains(term)).ToList();
fromBox.ItemsSource = result;
fromBox.IsSuggestionListOpen = true;
}
}
}
public void FillActions()
{
using (var context = new parusaContext())
{
var actions = context.Bonus.ToList();
itemsActions.ItemsSource = actions;
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
using (var context = new parusaContext())
{
var qwer = context.Cities.Where(q => q.IdCountryNavigation.Name == "Россия");
this.Frame.Navigate(typeof(flights));
}
}
