public void UpdateAddressesData()
{
List <TerritoryAddress> addresses = new List <TerritoryAddress>();
if (allAddresses != null)
{
foreach (DataRow row in allAddresses.Rows)
{
string logement = row["Logement"].ToString();
string type = row["Type de territoire"].ToString();
if (logement != null && logement.Length > 0 && !type.Equals("P") && !type.Equals("C"))
//if (logement != null && logement.Length > 0)
{
TerritoryAddress add = new TerritoryAddress();
add.TerritoryNumber = row["Numéro de territoire"].ToString();
add.Address = row["Adresse"].ToString();
add.Details = row["Logement"].ToString();
string status = row["Statut"].ToString();
add.Language = row["Langue"].ToString();
add.Remark = row["Notes"].ToString();
add.Status = status; // "Ne voulant Plus être Visité"
addresses.Add(add);
}
}
}
allAddressesData.FilteredItemsSource = addresses;
}
private void TerritoriesData_SelectedCellsChanged(object sender, SelectionChangedEventArgs e)
{
DataGrid dataGrid = sender as DataGrid;
if (e.AddedItems != null && e.AddedItems.Count > 0)
{
// find row for the first selected item
DataGridRow row = (DataGridRow)dataGrid.ItemContainerGenerator.ContainerFromItem(e.AddedItems[0]);
if (row != null)
{
DataGridCellsPresenter presenter = GetVisualChild <DataGridCellsPresenter>(row);
// find grid cell object for the cell with index 0
DataGridCell cellTerritoryNumber = presenter.ItemContainerGenerator.ContainerFromIndex(1) as DataGridCell;
// Trying to get the mail (third column)
string territoryNumber = ((TextBlock)cellTerritoryNumber.Content).Text;
List <TerritoryAddress> addresses = new List <TerritoryAddress>();
if (allAddresses != null)
{
foreach (DataRow row2 in allAddresses.Rows)
{
string currentRowTerritoryNumber = row2["Numéro de territoire"].ToString();
string logement = row2["Logement"].ToString();
if (currentRowTerritoryNumber == territoryNumber && logement != null && logement.Length > 0)
{
TerritoryAddress add = new TerritoryAddress();
add.TerritoryNumber = territoryNumber;
add.Address = row2["Adresse"].ToString();
add.Details = row2["Logement"].ToString();
add.Status = row2["Statut"].ToString();
add.Language = row2["Langue"].ToString();
add.Remark = row2["Notes"].ToString();
addresses.Add(add);
}
}
}
territoryAddressesData.FilteredItemsSource = addresses;
}
}
}