public string[] LoadTournaments()
{
DipDbDataSetTableAdapters.tournamentsTableAdapter DTA = GetTableAdapterForTournaments();
DipDbDataSet.tournamentsDataTable Dt1 = new DipDbDataSet.tournamentsDataTable();
DTA.Fill(Dt1);
int numeroRighe = Dt1.Rows.Count;
string[] Lista = new string[numeroRighe];
for (int i = 0; i < numeroRighe; i++)
{
string outVal = Dt1.Rows[i].ItemArray[0].ToString();
outVal = outVal + PublicClass.Separator + Dt1.Rows[i].ItemArray[1].ToString();
DateTime myDT = (DateTime)Dt1.Rows[i].ItemArray[2];
outVal = outVal + PublicClass.Separator + myDT.ToShortDateString();
outVal = outVal + PublicClass.Separator + Dt1.Rows[i].ItemArray[4].ToString();
Lista[i] = outVal;
if (Convert.ToBoolean(Dt1.Rows[i].ItemArray[3]) == true)
{ //update active tournament
Class_ActiveTournament = Convert.ToInt32(Dt1.Rows[i].ItemArray[0]);
String_ActiveTournament = outVal;
}
}
return(Lista);
}
private void WriteToDB(int idToSave = 0)
{
//TODO: spostare dentro databaseloader
DipDbDataSet D1 = new DipDbDataSet();
DipDbDataSet.tournamentsDataTable Dt1 = D1.tournaments;
CoreDiploScore.DipDbDataSetTableAdapters.tournamentsTableAdapter DTA = new CoreDiploScore.DipDbDataSetTableAdapters.tournamentsTableAdapter();
if (idToSave > 0)
{
DTA.UpdateTournamentByID(NameTournament_TB.Text, Convert.ToDateTime(DateTournament_DTP.Value.ToShortDateString()), idToSave);
return;
}
DTA.Fill(Dt1);
DipDbDataSet.tournamentsRow MyDR = Dt1.NewtournamentsRow();
MyDR["NameTournament"] = NameTournament_TB.Text;
MyDR["DateEvent"] = DateTournament_DTP.Value.ToShortDateString();
MyDR["Active"] = 1;
MyDR["Rounds"] = Rounds_numUD.Value;
Dt1.Rows.Add(MyDR);
DTA.Update(Dt1);
D1.AcceptChanges();
reload();
}
