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);
}
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);
}
