public void Save() { string q; if (Id == 0) { if (ModuleCode == Guid.Empty) { q = $@" INSERT INTO players_modules(player_id) VALUES(0) SELECT @@IDENTITY AS Result"; Id = DataConnection.GetResultInt(q); } else { Id = ShipModule.ModuleIdByGuid(ModuleCode); if (Id == 0) { return; } } } q = $@"UPDATE players_modules SET player_id = {PlayerId}, module_id = {ModuleTypeId}, experience = {Experience}, module_level = {ModuleLevel}, rig_id = {RigSlotId}, module_code = CAST('{ModuleCode.ToString()}' AS uniqueidentifier) WHERE id = {Id}"; DataConnection.Execute(q); }
public void SaveData(int rigId) { string q; if (Id == 0) { q = $@" INSERT INTO ss_rigs_slots(ss_rig_id) VALUES({rigId}) SELECT @@IDENTITY AS Result"; this.Id = DataConnection.GetResultInt(q); } int slotId = 0; if (Slot != null) { slotId = Slot.Id; } int moduleTypeId = 0; if (ModuleType != null) { moduleTypeId = ModuleType.Id; } int moduleId = 0; if (Module != null) { Module.Id = ShipModule.ModuleIdByGuid(Module.ModuleCode); moduleId = Module.Id; Module.RigSlotId = Id; Module.Save(); } q = $@" UPDATE ss_rigs_slots SET slot_id = {slotId}, module_type_id = {moduleTypeId}, module_id = {moduleId}, officer_ids = @str1 WHERE id = {Id}"; List <string> names = new List <string> { team.GetOfficerString() }; DataConnection.Execute(q, names); }