public void SetGridToLocations()
{
ShowAllFilterBoxes();
Column0Label.Content = "City: ";
Column1Label.Content = "State: ";
Column2Label.Content = "Rating: ";
SQLConnections sql = new SQLConnections();
List <Location> locations = sql.GetAllLocations();
List <ColumnData> columnDataLocations = new List <ColumnData>();
foreach (var item in locations)
{
ColumnData data = new ColumnData
{
Column1 = item.City,
Column2 = item.State,
Column3 = item.RatingConverted,
Column4 = item.Notes,
Column5 = "Update",
Column6 = "Delete"
};
columnDataLocations.Add(data);
}
ResultBox.ItemsSource = columnDataLocations;
}
private void SetGridToAll()
{
Column0Label.Content = "Keyword: ";
Column1Label.Visibility = Visibility.Hidden;
Column2Label.Visibility = Visibility.Hidden;
Column1TextBox.Visibility = Visibility.Hidden;
Column2TextBox.Visibility = Visibility.Hidden;
SQLConnections sql = new SQLConnections();
List <Jobs> jobsAll = sql.GetAllJobs();
List <Location> locationsAll = sql.GetAllLocations();
List <Position> positionsAll = sql.GetAllPositions();
List <ColumnData> columnDataAll = new List <ColumnData>();
foreach (var item in jobsAll)
{
ColumnData data = new ColumnData
{
Column1 = "Job",
Column2 = item.CompanyName,
Column3 = item.CEOName,
Column4 = item.Rating,
Column5 = "Update",
Column6 = "Delete"
};
columnDataAll.Add(data);
}
foreach (var item in locationsAll)
{
ColumnData data = new ColumnData
{
Column1 = "Location",
Column2 = item.City,
Column3 = item.State,
Column4 = item.RatingConverted,
Column5 = "Update",
Column6 = "Delete"
};
columnDataAll.Add(data);
}
foreach (var item in positionsAll)
{
ColumnData data = new ColumnData
{
Column1 = "Position",
Column2 = item.JobTitle,
Column3 = null,
Column4 = null,
Column5 = "Update",
Column6 = "Delete"
};
columnDataAll.Add(data);
}
ResultBox.ItemsSource = columnDataAll;
}
private void FillAllLocations()
{
SQLConnections sql = new SQLConnections();
AllLocations = sql.GetAllLocations();
}
