private void GeneratePersonalDataTable()
{
_serviceAthlete = new AthletesService();
_tablePersonal = _serviceAthlete.SelectAthleteByDni(Dni.Text.ToUpper());
_tablePersonal.Columns[0].ColumnName = Properties.Resources.AthleteDni;
_tablePersonal.Columns[1].ColumnName = Properties.Resources.AthleteName;
_tablePersonal.Columns[2].ColumnName = Properties.Resources.AthleteSurname;
_tablePersonal.Columns[3].ColumnName = Properties.Resources.Competition;
_tablePersonal.Columns[4].ColumnName = Properties.Resources.AthleteGender;
while (_tablePersonal.Rows.Count > 1)
{
_tablePersonal.Rows.RemoveAt(_tablePersonal.Rows.Count - 1);
}
_tablePersonal.Columns.RemoveAt(0);
_tablePersonal.Columns.RemoveAt(2);
_tablePersonal.Columns.RemoveAt(2);
DataGridDataPersonal.ItemsSource = _tablePersonal.DefaultView;
GenerateInscriptionsDataTable();
}
public CompetitionInscriptionTab()
{
_competitionService = new CompetitionService();
_athletesService = new AthletesService();
_enrollService = new EnrollService(null);
InitializeComponent();
}
private void LoadData(string dni)
{
if (dni != null)
{
try {
var atleList = new AthletesService().SelectAthleteTable();
Athlete = atleList.First(a => a.Dni.ToUpper().Equals(dni.ToUpper()));
LbNameSurname.Content = $"{Athlete.Name} {Athlete.Surname}";
var category = _competitionService.SelectCompetitionByAthleteAndCompetition(Competition, Athlete);
LbCategory.Content = $"{category.Name.Replace('_', ' ')} ({category.MinAge} - {category.MaxAge})";
var p = _service.SelectCompetitionHasParticipated(Competition, Athlete);
var time = PartialTimeString(p.FinishTime == 0 ? 0 : p.FinishTime - p.InitialTime);
LbTiempoTotal.Content = $"T. Final: {time}";
var partial = _service.SelectPartialTimesByAthlete(Competition, Athlete);
IEnumerable <PartialTimesDto> lista = new List <PartialTimesDto> {
partial
};
GenerateTable(lista);
}
catch (InvalidOperationException) { }
}
}
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();
}
public CancelInscriptionPage()
{
_enrollService = new EnrollService(null);
_athletesService = new AthletesService();
_competitionService = new CompetitionService();
InitializeComponent();
}
public ClubInscriptionFileTab()
{
InitializeComponent();
_athletesService = new AthletesService();
_competitionService = new CompetitionService();
_enrollService = new EnrollService(null);
_athletes = new List <AthleteDto>();
_validAthletes = new List <AthleteDto>();
_count = 0;
}
public ClubInscriptionFormTab()
{
InitializeComponent();
DPBirthDate.DisplayDateEnd = new DateTime(DateTime.Now.Year, 12, 31).AddYears(-18);
_athletesService = new AthletesService();
_competitionService = new CompetitionService();
_enrollService = new EnrollService(null);
_athletes = new List <AthleteDto>();
_count = 0;
_stringBuilder = new StringBuilder();
}
public void TestAddAthletes()
{
var athlete = new AthleteDto {
Dni = "55555554D",
Name = "Alejandro",
Surname = "Perez",
BirthDate = new DateTime(2010, 09, 11),
Gender = AthleteDto.MALE
};
var service = new AthletesService();
AthletesService.PrintAthletes(service.SelectAthleteTable());
}
private void DataGridTimes_OnMouseDoubleClick(object sender, MouseButtonEventArgs e)
{
PartialTimesAthletes.Competition = Competition;
var atleList = new AthletesService().SelectAthleteTable();
try {
var dni = _columnDNI[DataGridTimes.SelectedIndex];
PartialTimesAthletes.Athlete = atleList.First(a => a.Dni.ToUpper().Equals(dni.ToUpper()));
DataGridTimes.SelectedIndex = -1;
MainMenu.ChangeMenuSelected(Properties.Resources.TileTimes, Properties.Resources.SubMenuPartialTimes);
}
catch (IndexOutOfRangeException) { }
}
private void DataGridPosiciones_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
var id = _tableCat.Rows[DataGridPosiciones.SelectedIndex].ItemArray.ElementAt(0).ToString();
Competition.ID = long.Parse(id);
TimesAthletes.Competition = Competition;
var atleList = new AthletesService().SelectAthleteTable();
try {
TimesAthletes.Athlete = atleList.First(a => a.Dni.ToUpper().Equals(Dni.Text.ToUpper()));
MainMenu.ChangeMenuSelected(Properties.Resources.TileTimes, Properties.Resources.TitleTimesCompetition);
}
catch (IndexOutOfRangeException) { }
}
private void BtSearch_Click(object sender, RoutedEventArgs e)
{
if (!ComprobarDNI(Dni.Text))
{
MessageBox.Show(Properties.Resources.InvalidDNI);
return;
}
_serviceAthlete = new AthletesService();
var table = _serviceAthlete.SelectAthleteByDni(Dni.Text.ToUpper());
if (table.Rows.Count == 0)
{
MessageBox.Show(Properties.Resources.NoRegistered);
return;
}
GeneratePersonalDataTable();
}
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;
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (DataGridResults.SelectedItem != null)
{
const string message =
"¿Está segur@ que desea realizar el sorteo de adjudicación de plazas para esta competición? Esta opción no se puede deshacer";
const string caption = "Atención";
var result = MessageBox.Show(message, caption,
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (result == DialogResult.No)
{
}
else
{
if (Resultados.Items.IsEmpty)
{
competition.ID = _columnIds[DataGridResults.SelectedIndex];
Resultados.Items.Clear();
Resultados.Items.Add("ADMITIDOS");
_serviceA = new AthletesService();
var atletas = _serviceA.SelectAtheletesRaffle(_columnIds[DataGridResults.SelectedIndex]);
var contador = _service.SelectNumberRaffle(_columnIds[DataGridResults.SelectedIndex]);
foreach (var d in atletas)
{
if (contador > 0)
{
Resultados.Items.Add(d);
_serviceA.ChangeStatusAthlete(d, competition.ID);
contador--;
}
}
Resultados.Items.Add("RESERVA");
foreach (var d in atletas)
{
if (!Resultados.Items.Contains(d))
{
Resultados.Items.Add(d);
}
}
table.Rows[DataGridResults.SelectedIndex].Delete();
}
else
{
MessageBox.Show("Por favor, guarde los resultados del sorteo haciendo click en imprimir");
}
}
}
else
{
MessageBox.Show("Por favor, seleccione una competición");
}
}
public InscriptionPage()
{
InitializeComponent();
DPBirthDate.DisplayDateEnd = new DateTime(DateTime.Now.Year, 12, 31).AddYears(-18);
_athletesService = new AthletesService();
}
public LoadFilePartialTimes()
{
service = new AthletesService();
timesService = new TimesService();
InitializeComponent();
}
