public void UpdateDisplayRace(string id, Model.Race race)
{
var cmd = dbConnection.CreateCommand();
cmd.Parameters.Add("@id", DbType.String);
cmd.Parameters["@id"].Value = id;
cmd.Parameters.Add("@race", DbType.Int32);
cmd.Parameters["@race"].Value = (int)race;
cmd.CommandText = "insert or replace into player values (@id, (select name from player where id=@id), @race);";
cmd.ExecuteNonQuery();
}
public void CreateRace(Model.Race race)
{
if (race == null)
{
Logger.Error("Can't save race as race is null");
throw new ArgumentNullException(nameof(race));
}
try
{
using (var db = new LiteDatabase(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "MyData.db")))
{
var col = db.GetCollection <Model.Race>("Race");
col.Insert(race);
col.EnsureIndex(x => x.Name);
}
}
catch (Exception ex)
{
Logger.Error("Error Saving race " + ex.Message);
}
}
public static Task <Model.Miscellaneous.Race> Races(Model.Race ID)
{
return(Builder.AddDirective("races")
.AddDirective(ID.ToString())
.RequestAsync <Model.Miscellaneous.Race>());
}
