public static List<VersenyEredmeny> Load( ) {
var value = new List<VersenyEredmeny>();
Database.Connection.Open( );
var command = Database.Connection.CreateCommand();
command.CommandText = "SELECT VEAZON, INNEVE, INSOSZ, ITAZON, INCSSZ, IN10TA, IN08TA, IN05TA, INMETA, " +
"INOSZP, INERSZ, INMEGJ, INKOMO, KOAZON, INBEEK FROM Eredmények ORDER BY VEAZON;";
var reader = command.ExecuteReader();
while( reader.Read( ) ) {
var index = -1;
var q = new Model.Eredmeny.Eredmeny {
Verseny = reader.GetString(++index),
Indulo = reader.GetString(++index),
Sorszam = reader.GetInt32(++index),
Ijtipus = reader.GetString(++index),
Csapat = reader.GetInt32(++index),
Talalat10 = reader.GetInt32(++index),
Talalat8 = reader.GetInt32(++index),
Talalat5 = reader.GetInt32(++index),
Melle = reader.GetInt32(++index),
OsszPont = reader.GetInt32(++index),
Szazalek = reader.GetInt32(++index),
Megjelent = reader.GetBoolean(++index),
KorosztalyModositott = reader.GetBoolean(++index),
KorosztalyAzonosito = reader.GetString(++index),
Kor = reader.GetInt32(++index)
};
var found = false;
foreach( var versenyEredmeny in value.Where( versenyEredmeny => versenyEredmeny.VersenyAzonosito.Equals( q.Verseny ) ) ) {
versenyEredmeny.Eredmenyek._eredmenyek.Add( q );
found = true;
break;
}
if( !found ) {
value.Add( new VersenyEredmeny {
VersenyAzonosito = q.Verseny,
Eredmenyek = new Eredmenyek {
_eredmenyek = new ObservableCollection<Model.Eredmeny.Eredmeny> {
q
}
}
} );
}
}
command.Dispose( );
Database.Connection.Close( );
return value;
}
public Eredmeny_Torles(Model.Eredmeny.Eredmeny eredmeny) {
InitializeComponent();
_eredmeny = eredmeny;
lblKerdes.Content += Environment.NewLine + "Név: " + _eredmeny.Indulo;
}
public Beirolap_Nyomtatas( Model.Eredmeny.Eredmeny eredmeny, bool duplaBeirolap ) {
InitializeComponent( );
_eredmeny = eredmeny;
_duplaBeirolap = duplaBeirolap;
}
public Eredmeny_Hozzaadas_Modositas( Model.Eredmeny.Eredmeny eredmeny ) {
_eredmeny = eredmeny;
InitializeComponent( );
InitializeContent( _eredmeny );
}
