internal PlayerCommands(Function function) : base(function)
{
XP = new ClassXP(function);
Particle = new ClassParticle(function);
Item = new ClassItem(function);
Sound = new ClassSound(function);
Title = new ClassTitle(function);
Recipe = new ClassRecipe(function);
Advancement = new ClassAdvancement(function);
}
private ClassTitle GetTitleFromDB(string inID)
{
DataTable dt = DbReturnDataTable($"SELECT * FROM Titel WHERE id = {inID}");
ClassTitle CT = new ClassTitle();
foreach (DataRow row in dt.Rows)
{
CT.id = row["id"].ToString();
CT.title = row["titel"].ToString();
}
return(CT);
}
public ObservableCollection <ClassTitle> GetTitles()
{
ObservableCollection <ClassTitle> cTitles = new ObservableCollection <ClassTitle>();
string sqlQuery = "SELECT * FROM Titel";
DataTable dataTable = DbReturnDataTable(sqlQuery);
foreach (DataRow row in dataTable.Rows)
{
ClassTitle title = new ClassTitle();
title.title = row["titel"].ToString();
title.id = row["id"].ToString();
cTitles.Add(title);
}
return(cTitles);
}
public void UpdateTitleInDB(ClassTitle inTitle)
{
ExecuteNonQuery($"UPDATE Titel SET titel = '{inTitle.title}' WHERE id = {inTitle.id}");
}
public void InsertTitleIntoDB(ClassTitle inTitle)
{
ExecuteNonQuery($"INSERT INTO Titel (title) VALUES('{inTitle.title}')");
}
void CreateBook()
{
autor = new ClassAutor();
content = new ClassContent();
title = new ClassTitle();
}
void InitializeDocument()
{
body = new ClassBody();
footer = new ClassFooter();
title = new ClassTitle();
}
