public void Delete(SpeiseArt sA)
{
delete = gameObject.AddComponent <Delete>();
delete.DeleteSpeiseArt(sA);
controllerScript.LoadButton();
controllerScript.LoadEditSpeiseArt();
}
public void Create(SpeiseArt sA)
{
insert = gameObject.AddComponent <Insert>();
insert.InsertSpeiseArtInDataBase(sA);
controllerScript.LoadButton();
controllerScript.LoadEditSpeiseArt();
}
public void Rename(SpeiseArt sA)
{
insert = gameObject.AddComponent <Insert>();
insert.UpdateSpeiseArtInDatebase(sA);
controllerScript.LoadButton();
controllerScript.LoadEditSpeiseArt();
}
public void DeleteSpeiseArt(SpeiseArt speiseArt)
{
string sqlText = "DELETE from speisenart where id=" + speiseArt.ID;
conn.Open();
cmd.CommandText = sqlText;
cmd.ExecuteNonQuery();
conn.Close();
}
public void SetUp(SpeiseArt sA, int aS, EditSpeiseArtControll eSC)
{
speiseArt = sA;
anzahlSpeisen = aS;
editSpeiseArtControll = eSC;
speiseArtName.text = speiseArt.SpeisenArt;
text.text = "Anzahl Speisen: " + anzahlSpeisen;
if (anzahlSpeisen > 0)
{
delete.interactable = false;
}
SetUpButton();
}
private void ExecuteSpeisenArtSqlText(string sqlText, SpeiseArt speiseArt)
{
conn.Open();
cmd.CommandText = sqlText;
MySqlParameter paramSpeisenArtName = new MySqlParameter("@speisenartname", MySqlDbType.Text);
paramSpeisenArtName.Value = speiseArt.SpeisenArt;
cmd.Parameters.Add(paramSpeisenArtName);
cmd.ExecuteNonQuery();
conn.Close();
}
public SpeiseArt[] ReadSpeisenArtTable(string sqlText)
{
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlText;
MySqlDataReader reader = cmd.ExecuteReader();
int k = 0;
while (reader.Read())
{
k++;
}
reader.Close();
cmd.CommandText = sqlText;
reader = cmd.ExecuteReader();
SpeiseArt[] table = new SpeiseArt[k];
int i = 0;
while (reader.Read())
{
SpeiseArt speisenArtTable = new SpeiseArt();
speisenArtTable.ID = (int)reader[0];
speisenArtTable.SpeisenArt = (string)reader[1];
table[i] = speisenArtTable;
i++;
}
reader.Close();
conn.Close();
return(table);
}
public void UpdateSpeiseArtInDatebase(SpeiseArt speiseArt)
{
string sqlText = "UPDATE speisenart SET speisenartname=@speisenartname WHERE id=" + speiseArt.ID;
ExecuteSpeisenArtSqlText(sqlText, speiseArt);
}
public void InsertSpeiseArtInDataBase(SpeiseArt speiseArt)
{
string sqlText = "INSERT INTO speisenart(speisenartname) VALUES(@speisenartname)";
ExecuteSpeisenArtSqlText(sqlText, speiseArt);
}
private void Awake()
{
speiseArt = new SpeiseArt();
create.interactable = false;
}
