public virtual void Insert(FittingPreset preset)
{
preset.Id = Db.Query().CommandText("insert into robotfittingpresets (ownerEid,preset) values (@ownerEid,@preset);select cast(scope_identity() as int)")
.SetParameter("@ownerEid", preset.Owner)
.SetParameter("@preset", (string)preset.ToGenxyString())
.ExecuteScalar <int>().ThrowIfEqual(0, ErrorCodes.SQLInsertError);
}
public void Update(FittingPreset preset)
{
Db.Query().CommandText("update robotfittingpresets set preset = @preset where id = @id")
.SetParameter("@id", preset.Id)
.SetParameter("@preset", preset.ToGenxyString())
.ExecuteNonQuery().ThrowIfEqual(0, ErrorCodes.SQLUpdateError);
}
private static FittingPreset CreateRobotFittingPresetFromRecord(IDataRecord record)
{
var presetString = record.GetValue <string>("preset");
var preset = FittingPreset.CreateFrom(presetString);
preset.Id = record.GetValue <int>("id");
preset.Owner = record.GetValue <long>("ownerEid");
return(preset);
}
public void Delete(FittingPreset preset)
{
DeleteById(preset.Id);
}
public override void Insert(FittingPreset preset)
{
preset.Owner = _character.Eid;
base.Insert(preset);
}
