private void LoadTreeView()
{
List <Skill> lstSkills = new List <Skill>();
Skill objSkill = new Skill();
lstSkills = objSkill.GetCharacterSelectableSkillList(objCALC.objCharacter, objCALC.objSelectedClass);
foreach (Skill objClassSkill in lstSkills)
{
List <SubSkill> lstSubSkills = new List <SubSkill>();
SubSkill objSubSkill = new SubSkill();
lstSubSkills = objSubSkill.GetSubSkills("SkillID=" + objClassSkill.SkillID.ToString(), "SubSkillName");
List <TreeNode> SubSkillListForSkill = new List <TreeNode>();
foreach (SubSkill objSSList in lstSubSkills)
{
TreeNode objTN = new TreeNode();
objTN.Text = objSSList.SubSkillName;
objTN.Tag = "SS" + objSSList.SubSkillID;
SubSkillListForSkill.Add(objTN);
}
if (SubSkillListForSkill.Count > 0)
{
TreeNode[] SkillNodes = new TreeNode[SubSkillListForSkill.Count];
SkillNodes = SubSkillListForSkill.ToArray();
TreeNode objSkillTN = new TreeNode(objClassSkill.SkillName, SkillNodes);
objSkillTN.Tag = "SK" + objClassSkill.SkillID;
tvSkillList.Nodes.Add(objSkillTN);
}
}
}
public void Test_GetSubSkills_WithOrderBy_GoodResult()
{
string strWhere = "SubSkillName Like '%Feint%'";
string strOrderBy = "SubSkillName";
SubSkill objSubSkill = new SubSkill();
List <SubSkill> lstSubSkills = new List <SubSkill>();
lstSubSkills = objSubSkill.GetSubSkills(strWhere, strOrderBy);
Assert.IsTrue(lstSubSkills.Count > 0);
}
public void Test_GetSubSkills_WithOutOrderBy_NoResult()
{
string strWhere = "SubSkillName Like '%Toad%'";
string strOrderBy = "";
SubSkill objSubSkill = new SubSkill();
List <SubSkill> lstSubSkills = new List <SubSkill>();
lstSubSkills = objSubSkill.GetSubSkills(strWhere, strOrderBy);
Assert.IsTrue(lstSubSkills.Count == 0);
}
private void LoadClbSubSkill(string strWhere)
{
SubSkill subSkill = new SubSkill();
//List<SubSkill> subSkills = new List<SubSkill>();
List <SubSkill> activeSubSkills = new List <SubSkill>();
//subSkills = subSkill.GetSubSkills("", " SubSkillName ");
activeSubSkills = subSkill.GetSubSkills(strWhere, " SubSkillName ");
this.lvSubSkills.Columns.Add("ID");
this.lvSubSkills.Columns.Add("Skill Name");
this.lvSubSkills.Columns.Add("Skill Description");
foreach (SubSkill objSubSkill in activeSubSkills)
{
//frmMain.gameNameSearchId = objGuideBook.EquipmentID;
ListViewItem lvItem = Common.CreateListViewItem(objSubSkill.SkillID, objSubSkill.SubSkillName, objSubSkill.SubSkillDescription, true);
this.lvSubSkills.Items.Add(lvItem);
}
Common.FormatListViewControlColumns(lvSubSkills);
//foreach (SubSkill objSubSkill in subSkills)
//{
// clbSubSkills.Items.Add(objSubSkill.SubSkillName );
//}
//CheckedListBox.CheckedItemCollection cilsubSkills; // = CheckedListBox.CheckedItemCollection();
//foreach (SubSkill objActiveSubSkills in activeSubSkills)
//{
// //for (int i = 0; i < lvSearchResults.Columns.Count; i++)
// for (int i = 0; i < clbSubSkills.Items.Count ; i++)
// {
// if (clbSubSkills.Items[i].ToString() == objActiveSubSkills.SubSkillName )
// {
// clbSubSkills.SelectedValue = objActiveSubSkills.SubSkillName;
// //clbSubSkills. = clbSubSkills.Items[i].ToString();
// }
// }
//}
if (dbconn.Open)
{
dbconn.CloseDatabaseConnection();
}
}
