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