public static GameCharacter GetGameCharacterInformations(String characterName)
{
String name;
String klasse;
String level;
String leben;
String exp;
String atk;
String mana;
String def;
String spd;
List <String> gameCharacterList = TransactionQueries.GetGameCharacter(characterName);
name = gameCharacterList[0];
klasse = gameCharacterList[1];
level = gameCharacterList[2];
leben = gameCharacterList[3];
exp = gameCharacterList[4];
atk = gameCharacterList[5];
mana = gameCharacterList[6];
def = gameCharacterList[7];
spd = gameCharacterList[8];
return(new GameCharacter(name, klasse, level, leben, exp, atk, mana, def, spd));
}
public static bool CreateCharacterForAUser(String characterName, String classID, String userID)
{
bool responseSaveCharacter;
String characterID;
responseSaveCharacter = TransactionQueries.CreateCharacterForUser(characterName, classID, userID);
if (responseSaveCharacter)
{
characterID = TransactionQueries.GetCharID(Convert.ToInt32(userID));
if (characterID.Length != 0)
{
if (TransactionQueries.SaveCharacterDetailsAtCreate(characterID, userID, Convert.ToInt32(classID)))
{
return(TransactionQueries.SaveCharIDInUserManager(characterID, userID));
}
else
{
return(false);
}
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public static List <Tuple <String, String> > HasUserCharacters(String username)
{
String responseHasUserCharacter;
responseHasUserCharacter = TransactionQueries.HasUserCharacters(username);
if (responseHasUserCharacter.Length != 0)
{
return(TransactionQueries.GetCharacterInformations(responseHasUserCharacter));
}
else
{
return(null);
}
}
public static void CreateDatabase()
{
if (!System.IO.File.Exists(Queries.dbName))
{
SQLiteConnection.CreateFile(Queries.dbName);
}
try
{
TransactionQueries.InitProjectDatabase();
}
catch (Exception ex)
{
// TODO Fehler an das Frontend melden
throw new Exception("Fehler beim erstellen der Datenbank. Fehler: " + ex.Message);
}
}
public static List <Classes> GetAllClasses() => Classes.FillListWithClasses(TransactionQueries.GetAllClasses());
public static bool CreateUser(String vorname, String nachname, String email, String username, String password) => TransactionQueries.RegisterNewUser(vorname, nachname, email, username, password);
public static bool ExistsUser(String username) => TransactionQueries.CheckIfUserRegistered(username);
public static User CheckLogin(String username, String password)
{
User u = User.CreateUser(TransactionQueries.CheckIfLoginDataAreCorrect(username, password));;
return(u);
}
