private void FillAllPositions() { SQLConnections sql = new SQLConnections(); var x = sql.GetAllPositions(); AllPositions = x; }
public void SetGridToPositions() { ShowAllFilterBoxes(); Column0Label.Content = "Position: "; Column1Label.Visibility = Visibility.Hidden; Column2Label.Visibility = Visibility.Hidden; Column1TextBox.Visibility = Visibility.Hidden; Column2TextBox.Visibility = Visibility.Hidden; Column0Label.Content = "Position: "; SQLConnections sql = new SQLConnections(); List <Position> positions = sql.GetAllPositions(); List <ColumnData> columnDataPositions = new List <ColumnData>(); foreach (var item in positions) { ColumnData data = new ColumnData { Column1 = item.JobTitle, Column2 = null, Column3 = null, Column4 = null, Column5 = "Update", Column6 = "Delete" }; columnDataPositions.Add(data); } ResultBox.ItemsSource = columnDataPositions; }
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; }