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