/// <summary>
/// displays search results button was clicked
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void b_showResults_Click(object sender, RoutedEventArgs e)
{
string type = interestArea[box_interest.SelectedItem.ToString()];
string city = box_location.SelectedItem.ToString();
DataTable dt = controller.getPartnershipsByCity(type, city);
DataRow[] rows = dt.Select();
List <advertisment> ads = new List <advertisment>();
//Get all the relevant data for an advertisment to display
foreach (DataRow r in rows)
{
if (r[3] != null && r[3].ToString() != string.Empty)
{
advertisment a = new advertisment()
{
Id = r[0].ToString(),
ManagerMail = r[1].ToString(),
City = r[2].ToString(),
Date = r[3].ToString(),
Type = interestArea[box_interest.SelectedItem.ToString()]
};
ads.Add(a);
}
}
listView.ItemsSource = ads;
listView.Visibility = Visibility.Visible;
}
private void b_showResults_Click(object sender, RoutedEventArgs e)
{
OleDbCommand command = new OleDbCommand("select * from Partnerships" + interestArea[box_interest.SelectedItem.ToString()] + " where City = '" + box_location.SelectedItem + "'", connection);
OleDbDataAdapter tableAdapter = new OleDbDataAdapter(command);
DataTable dt = new DataTable();
tableAdapter.Fill(dt);
DataRow[] rows = dt.Select();
List <advertisment> ads = new List <advertisment>();
//Get all the relevant data for an advertisment to display
foreach (DataRow r in rows)
{
advertisment a = new advertisment()
{
Id = r[0].ToString(),
ManagerMail = r[1].ToString(),
City = r[2].ToString(),
Date = r[3].ToString(),
Type = interestArea[box_interest.SelectedItem.ToString()]
};
ads.Add(a);
}
listView.ItemsSource = ads;
listView.Visibility = Visibility.Visible;
}
/// <summary>
/// display partnership details button in the ads list was clicked
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button_Click(object sender, RoutedEventArgs e)
{
Button button = sender as Button;
advertisment ad = button.DataContext as advertisment;
DataTable dt = controller.getAdvertisments(ad.Type, ad.Id);
DataRow[] rows = dt.Select();
ViewPartnership vp = new ViewPartnership(ref controller, rows[0], ad.Id, _userMail, ad.Type, ad.ManagerMail, true, "-1");
vp.Show();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Button button = sender as Button;
advertisment ad = button.DataContext as advertisment;
OleDbCommand command = new OleDbCommand("select * from Partnerships" + ad.Type + " where ID = " + ad.Id, connection);
OleDbDataAdapter tableAdapter = new OleDbDataAdapter(command);
DataTable dt = new DataTable();
tableAdapter.Fill(dt);
DataRow[] rows = dt.Select();
ViewPartnership vp = new ViewPartnership(rows[0]);
vp.Show();
}