public static void InsertSpieltMit(Spiel s, Spieler sp, int setsGewonnen)
{
string query = "INSERT INTO spieltMit (`id_user`, `id_spiel`, `setsGewonnen`) VALUES ('" + sp.GetId() + "', '" + s.GetId() + "', '" + setsGewonnen + "')";
//open connection
if (OpenConnection() == true)
{
try
{
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
//Console.WriteLine(e.Message);
//Console.ReadLine();
}
//close connection
CloseConnection();
}
}
public static void InsertUser(Spieler s)
{
if (!CheckSpieler(s))
{
String firstNameData = "'" + s.GetFirstName() + "'";
String lastNameData = "'" + s.GetLastName() + "'";
String geburtstagData = "'" + s.GetGeburtstag().Year + "-" + s.GetGeburtstag().Month + "-" + s.GetGeburtstag().Day + "'";
String eMailData = "'" + s.GetEMail() + "'";
String passwdData = "'" + s.GetPasswd() + "'";
if (s.GetFirstName() == "")
{
firstNameData = "NULL";
}
if (s.GetLastName() == "")
{
lastNameData = "NULL";
}
if (s.GetEMail() == "")
{
eMailData = "NULL";
}
if (s.GetPasswd() == "")
{
passwdData = "NULL";
}
if (s.GetGeburtstag().Equals(new DateTime(1900, 1, 1)))
{
geburtstagData = "NULL";
}
string query = "INSERT INTO user (`id_user`, `username`, `firstName`, `lastName`, `geburtstag`, `eMail`, `password`) VALUES('" + s.GetId() + "', '" + s.GetUsername() + "', " + firstNameData + ", " + lastNameData + ", " + geburtstagData + ", " + eMailData + ", " + passwdData + ")";
//Console.WriteLine(query);
//Console.ReadKey();
//open connection
if (OpenConnection() == true)
{
try
{
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
Console.ReadLine();
}
//close connection
CloseConnection();
}
else
{
Console.WriteLine("HALLOI");
Console.ReadLine();
}
}
}
public static bool CheckSpieler(Spieler s)
{
return(CheckID(s.GetId()));
}