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