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(); }