public uint Create(DbObject obj) { return((uint)Context.Connection.Query <int>("INSERT INTO fso_objects (shard_id, owner_id, lot_id, " + "dyn_obj_name, type, graphic, value, budget, upgrade_level) " + " VALUES (@shard_id, @owner_id, @lot_id, @dyn_obj_name, @type," + " @graphic, @value, @budget, @upgrade_level); SELECT LAST_INSERT_ID();" , obj).First()); }
public bool UpdatePersistState(uint id, DbObject obj) { return(Context.Connection.Execute("UPDATE fso_objects " + "SET lot_id = @lot_id, " + "owner_id = @owner_id, " + "dyn_obj_name = @dyn_obj_name, " + "graphic = @graphic, " + "value = @value, " + "dyn_flags_1 = @dyn_flags_1, " + "dyn_flags_2 = @dyn_flags_2 " + "WHERE object_id = @object_id AND (@lot_id IS NULL OR lot_id = @lot_id);", obj) > 0); }