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