public string[] LoadPlayers(bool AllPlayers = true) { CoreDiploScore.DipDbDataSet DataSet = new CoreDiploScore.DipDbDataSet(); CoreDiploScore.DipDbDataSet.PlayersDataTable Dt1 = DataSet.Players; CoreDiploScore.DipDbDataSetTableAdapters.PlayersTableAdapter DTA = new DipDbDataSetTableAdapters.PlayersTableAdapter(); if (AllPlayers) { DTA.Fill(Dt1); } else { DTA.FillPlayersByTournamentID(Dt1, Class_ActiveTournament); } 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 = Dt1.Rows[i].ItemArray[3].ToString() + PublicClass.Separator + outVal; outVal = Dt1.Rows[i].ItemArray[2].ToString() + PublicClass.Separator + outVal; outVal = Dt1.Rows[i].ItemArray[1].ToString() + PublicClass.Separator + outVal; Lista[i] = outVal; } return(Lista); }
public bool InsertPlayer(string name, string surname, string email) { bool returnVal = false; try { DipDbDataSet D1 = new DipDbDataSet(); DipDbDataSet.PlayersDataTable Dt1 = D1.Players; DipDbDataSetTableAdapters.PlayersTableAdapter DTA = new DipDbDataSetTableAdapters.PlayersTableAdapter(); DTA.Fill(Dt1); DataRow MyDR = Dt1.NewRow(); MyDR["Cognome"] = surname; MyDR["Nome"] = name; MyDR["Email"] = email; Dt1.Rows.Add(MyDR); DTA.Update(Dt1); D1.AcceptChanges(); returnVal = true; } catch (Exception e) { MyLogger.Error("Errore in insert player", e); } return(returnVal); }