public void SaveTournamentPlayers(string tournament, string[] Players)
{
DipDbDataSet DataSet = new DipDbDataSet();
DipDbDataSet.Tournament_playerDataTable Dt1 = DataSet.Tournament_player;
DipDbDataSetTableAdapters.Tournament_playerTableAdapter DTA = new DipDbDataSetTableAdapters.Tournament_playerTableAdapter();
string[] T_TEMP_passed = tournament.Split(PublicClass.SeparatorChar);
int tournamentID = Convert.ToInt32(T_TEMP_passed[0]);
DTA.DeleteByTournamentID(tournamentID);
int numeroRighe = Players.Count();
for (int i = 0; i < numeroRighe; i++)
{
string[] MyTemp = Players[i].Split(PublicClass.SeparatorChar);
int playerID = Convert.ToInt32(MyTemp[3]);
DipDbDataSet.Tournament_playerRow myDR = Dt1.NewTournament_playerRow();
myDR.PlayerID = playerID;
myDR.TournamentID = tournamentID;
Dt1.AddTournament_playerRow(myDR);
}
DTA.Update(Dt1);
}
private DipDbDataSetTableAdapters.tournamentsTableAdapter GetTableAdapterForTournaments()
{
DipDbDataSet DataSet = new DipDbDataSet();
DipDbDataSetTableAdapters.tournamentsTableAdapter DTA = new DipDbDataSetTableAdapters.tournamentsTableAdapter();
return(DTA);
}
public int GetRoundsForActiveTournament()
{
int NrOfRounds = 0;
DipDbDataSet D1 = new DipDbDataSet();
DipDbDataSetTableAdapters.tournamentsTableAdapter TTA = new DipDbDataSetTableAdapters.tournamentsTableAdapter();
NrOfRounds = (int)TTA.GetActiveTournamentRounds();
MyLogger.Debug("GetRoundsForActiveTournament NrOfRounds {0}", NrOfRounds.ToString());
return(NrOfRounds);
}
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();
}
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);
}
