private void GenerateResultsDataTable() { _serviceAthleteResult = new AthletesService(); _tableResult = new DataTable(); _tableResult = _serviceAthleteResult.SelectParticipatedByDni(Dni.Text.ToUpper()); _tableResult.Columns[0].ColumnName = Properties.Resources.Competition_Id; _tableResult.Columns[1].ColumnName = Properties.Resources.FinishTime; _tableResult.Columns[2].ColumnName = Properties.Resources.Competition; _tableResult.Columns[3].ColumnName = Properties.Resources.AthleteGender; _tableResult.Columns.Add(Properties.Resources.Time + "(s)", typeof(string)); _tableResult.Columns.RemoveAt(3); foreach (DataRow row in _tableResult.Rows) { row[3] = PartialTimeString(row[1] is long?(long)row[1] : 0); } _tableResult.Columns.RemoveAt(1); DataGridResults.ItemsSource = _tableResult.DefaultView; if (DataGridResults.Columns.Count >= 1) { DataGridResults.Columns.ElementAt(0).Visibility = Visibility.Collapsed; } GenerateCategoriasDataTable(); }
private void GenerateCategoriasDataTable() { _serviceAthleteResult = new AthletesService(); _tableCat = new DataTable(); _tableCat = _serviceAthleteResult.SelectParticipatedByDni(Dni.Text.ToUpper()); _tableCat.Columns[0].ColumnName = Properties.Resources.Competition_Id; _tableCat.Columns[1].ColumnName = Properties.Resources.FinishTime; _tableCat.Columns[2].ColumnName = Properties.Resources.Competition; _tableCat.Columns[3].ColumnName = Properties.Resources.AthleteGender; _tableCat.Columns.RemoveAt(3); _tableCat.Columns.RemoveAt(1); DataGridPosiciones.ItemsSource = _tableCat.DefaultView; if (DataGridPosiciones.Columns.Count >= 1) { DataGridPosiciones.Columns.ElementAt(0).Visibility = Visibility.Collapsed; } }