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