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