public async Task Add(HttpCharacterModel model)
{
if (_testConnection != null)
{
await Add(model, _testConnection);
}
else
{
using (var conn = new SqliteConnection(_connectionString))
await Add(model, conn);
}
}
private static async Task Add(HttpCharacterModel model, SqliteConnection connection)
{
var command = connection.CreateCommand();
command.CommandText =
"INSERT INTO add2 (Name) " +
"VALUES ($name)";
command.Parameters.AddWithValue("$name", model.Name);
await connection.OpenAsync();
await command.ExecuteNonQueryAsync();
}
public async Task Update(int id, HttpCharacterModel model)
{
if (string.IsNullOrEmpty(await Get(id).Name()))
{
await Add(model);
}
else
{
if (_testConnection != null)
{
await Update(id, model, _testConnection);
}
else
{
using (var conn = new SqliteConnection(_connectionString))
await Update(id, model, conn);
}
}
}
private static async Task Update(int id, HttpCharacterModel model, SqliteConnection connection)
{
var command = connection.CreateCommand();
command.CommandText = "UPDATE add2 SET Name = $name, " +
"Str = $str, " +
"Dex = $dex, " +
"Con = $con, " +
"Int = $int, " +
"Wis = $wis, " +
"Chr = $chr, " +
"Race = $race, " +
"AvailableRaces = $availableRaces, " +
"Gender = $gender, " +
"Height = $height, " +
"Weight = $weight, " +
"Age = $age, " +
"Class = $className, " +
"AvailableClasses = $availableClasses, " +
"Alignment = $alignment, " +
"AvailableAlignments = $availableAlignments, " +
"HP = $hp, " +
"Paralyze = $paralyze, " +
"Rod = $rod, " +
"Petrification = $petrification, " +
"Breath = $breath, " +
"Spell = $spell, " +
"MoveRate = $moveRate, " +
"Funds = $funds, " +
"CompletionStep = $completionStep " +
"WHERE Id = $id";
command.Parameters.AddWithValue("$id", id);
command.Parameters.AddWithValue("$name", model.Name);
command.Parameters.AddWithValue("$str", model.Str);
command.Parameters.AddWithValue("$dex", model.Dex);
command.Parameters.AddWithValue("$con", model.Con);
command.Parameters.AddWithValue("$int", model.Int);
command.Parameters.AddWithValue("$wis", model.Wis);
command.Parameters.AddWithValue("$chr", model.Chr);
command.Parameters.AddWithValue("$race", model.Race ?? "none");
command.Parameters.AddWithValue("$availableRaces",
model.AvailableRaces == null ? "none" : string.Join(",", model.AvailableRaces));
command.Parameters.AddWithValue("$gender", model.Gender ?? "n");
command.Parameters.AddWithValue("$height", model.Height);
command.Parameters.AddWithValue("$weight", model.Weight);
command.Parameters.AddWithValue("$age", model.Age);
command.Parameters.AddWithValue("$className", model.ClassName ?? "none");
command.Parameters.AddWithValue("$availableClasses",
model.AvailableClasses == null ? "none" : string.Join(",", model.AvailableClasses));
command.Parameters.AddWithValue("$alignment", model.Alignment ?? "none");
command.Parameters.AddWithValue("$availableAlignments",
model.AvailableAlignments == null ? "none" : string.Join(",", model.AvailableAlignments));
command.Parameters.AddWithValue("$hp", model.HP);
command.Parameters.AddWithValue("$paralyze", model.Paralyze);
command.Parameters.AddWithValue("$rod", model.Rod);
command.Parameters.AddWithValue("$petrification", model.Petrification);
command.Parameters.AddWithValue("$breath", model.Breath);
command.Parameters.AddWithValue("$spell", model.Spell);
command.Parameters.AddWithValue("$moveRate", model.MoveRate);
command.Parameters.AddWithValue("$funds", model.Funds);
command.Parameters.AddWithValue("$completionStep", model.CompletionStep);
await connection.OpenAsync();
await command.ExecuteNonQueryAsync();
}
