public SkillSetElementSql AddElement()
{
SkillSetElementSql newElement = new SkillSetElementSql();
newElement.SkillSetId = Id;
Elements.Add(newElement);
return(newElement);
}
private void UpdateSkillElementInTree()
{
SkillSetElementSql curElement = GetCurrentSkillElement();
if (curElement == null)
{
return;
}
treeStr.SelectedNode.Text = curElement.ToString();
}
public void SaveData()
{
string q;
if (Id == 0)
{
q = $@"INSERT INTO skill_sets(name) VALUES ('')
SELECT @@IDENTITY AS Result";
Id = DataConnection.GetResultInt(q);
}
q = $@"UPDATE skill_sets SET
parent_id = {ParentId},
name = @str1,
description = @str2,
owner_type = {(int)OwnerType},
open_cost = {OpenCost},
available_for_player = {AvailableForPlayer},
experience_type = {(int)ExpType},
experience_multiplier = {ExperienceMultiplier}
WHERE
id = {Id}
";
List <string> names = new List <string> {
Name, Description
};
DataConnection.Execute(q, names);
string idsDoNotDelete = "";
if (Elements.Count > 0)
{
foreach (var element in Elements)
{
SkillSetElementSql curElement = (SkillSetElementSql)element;
curElement.SaveData(Id);
if (idsDoNotDelete != "")
{
idsDoNotDelete += ",";
}
idsDoNotDelete += curElement.Id.ToString();
}
}
q = $@"DELETE FROM skill_sets_structure WHERE skill_set_id = {Id}";
if (idsDoNotDelete != "")
{
q += $@" AND id NOT IN({idsDoNotDelete})";
}
DataConnection.Execute(q);
}
private void buttonAddSkillStructure_Click(object sender, EventArgs e)
{
if (NoEvents)
{
return;
}
SkillSetSql curSet = GetCurrentSkillSet();
if (curSet == null)
{
return;
}
SkillSetElementSql newElement = curSet.AddElement();
TreeNode n = treeStr.Nodes.Add(newElement.ToString());
n.Tag = newElement;
}
private void textReplaceSkillId_TextChanged(object sender, EventArgs e)
{
if (NoEvents)
{
return;
}
SkillSetElementSql curElement = GetCurrentSkillElement();
if (curElement == null)
{
return;
}
int value = 0;
Int32.TryParse(textReplaceSkillId.Text, out value);
curElement.ReplacesSkill = value;
SetPredecessorName(textReplaceSkillName, value);
}
private void textStrPredecessorId1_TextChanged(object sender, EventArgs e)
{
if (NoEvents)
{
return;
}
SkillSetElementSql curElement = GetCurrentSkillElement();
if (curElement == null)
{
return;
}
int value = 0;
Int32.TryParse(textStrPredecessorId1.Text, out value);
curElement.Predecessor1 = value;
SetPredecessorName(textStrPredecessorName1, value);
}
private void textStrColumn_TextChanged(object sender, EventArgs e)
{
if (NoEvents)
{
return;
}
SkillSetElementSql curElement = GetCurrentSkillElement();
if (curElement == null)
{
return;
}
int value = 0;
Int32.TryParse(textStrColumn.Text, out value);
curElement.SkillColumn = value;
UpdateSkillElementInTree();
}
private void checkAvailableAtStart_CheckedChanged(object sender, EventArgs e)
{
if (NoEvents)
{
return;
}
SkillSetElementSql curElement = GetCurrentSkillElement();
if (curElement == null)
{
return;
}
if (checkAvailableAtStart.Checked)
{
curElement.AvailableAtStart = 1;
}
else
{
curElement.AvailableAtStart = 0;
}
}
private void treeStr_AfterSelect(object sender, TreeViewEventArgs e)
{
ClearSkillStructureElement();
SkillSetElementSql curElement = GetCurrentSkillElement();
if (curElement == null)
{
return;
}
textStrId.Text = curElement.Id.ToString();
textStrSkillId.Text = curElement.SkillTypeId.ToString();
SetSkillName(textStrSkillName, curElement.SkillTypeId);
textStrLevel.Text = curElement.SkillLevel.ToString();
textStrColumn.Text = curElement.SkillColumn.ToString();
checkAvailableAtStart.Checked = curElement.AvailableAtStart == 1;
textStrPredecessorId1.Text = curElement.Predecessor1.ToString();
SetPredecessorName(textStrPredecessorName1, curElement.Predecessor1);
textStrPredecessorId2.Text = curElement.Predecessor2.ToString();
SetPredecessorName(textStrPredecessorName2, curElement.Predecessor2);
textReplaceSkillId.Text = curElement.ReplacesSkill.ToString();
SetPredecessorName(textReplaceSkillName, curElement.ReplacesSkill);
}
