public void Test_RemoveFeatListFromList_GoodResult() { Feat objFeat = new Feat(); List <Feat> objRemoveFeats = new List <Feat>(); List <Feat> objFeats = new List <Feat>(); int intTotalFeatsCount = 0; objFeats = objFeat.GetFeats("FeatID IN (1,2)", ""); intTotalFeatsCount = objFeats.Count; objRemoveFeats = objFeat.GetFeats("FeatID IN (1)", ""); objFeats = Feat.RemoveFeatListFromList(objRemoveFeats, objFeats); Assert.AreEqual(intTotalFeatsCount, objFeats.Count + 1); }
public void Test_GetFeats_WithOrderBy_GoodResult() { string strWhere = "FeatName Like '%Force%'"; string strOrderBy = ""; Feat objFeat = new Feat(); List <Feat> lstFeats = new List <Feat>(); lstFeats = objFeat.GetFeats(strWhere, strOrderBy); Assert.IsTrue(lstFeats.Count > 0); }
public void Test_GetFeats_WithOutOrderBy_NoResult() { string strWhere = "FeatName Like '%Toad%'"; string strOrderBy = "FeatName"; Feat objFeat = new Feat(); List <Feat> lstFeats = new List <Feat>(); lstFeats = objFeat.GetFeats(strWhere, strOrderBy); Assert.IsTrue(lstFeats.Count == 0); }
/// <summary> /// Handles the Click event of the btnSearch control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param> private void btnSearch_Click(object sender, EventArgs e) { string searchOrderBy = ""; string searchFilter = ""; switch (searchType) { case Common.searchType.Armor: searchOrderBy = "ArmorName"; if (txtSearch.Text.Contains("%")) { searchFilter = "ArmorName LIKE '" + txtSearch.Text + "'"; } else { searchFilter = "ArmorName = '" + txtSearch.Text + "'"; } Armor Armor = new Armor(); List <Armor> Armors = new List <Armor>(); Armors = Armor.GetArmors(searchFilter, searchOrderBy); SetFormForArmor(Armors); break; case Common.searchType.Feat: searchOrderBy = "FeatName"; if (txtSearch.Text.Contains("%")) { searchFilter = "FeatName LIKE '" + txtSearch.Text + "'"; } else { searchFilter = "FeatName = '" + txtSearch.Text + "'"; } Feat objFeat = new Feat(); List <Feat> Feats = new List <Feat>(); Feats = objFeat.GetFeats(searchFilter, searchOrderBy); SetFormForFeat(Feats); break; case Common.searchType.ForcePower: searchOrderBy = "ForcePowerName"; if (txtSearch.Text.Contains("%")) { searchFilter = "ForcePowerName LIKE '" + txtSearch.Text + "'"; } else { searchFilter = "ForcePowerName = '" + txtSearch.Text + "'"; } ForcePower objForcePower = new ForcePower(); List <ForcePower> ForcePowers = new List <ForcePower>(); ForcePowers = objForcePower.GetForcePowers(searchFilter, searchOrderBy); SetFormForForcePower(ForcePowers); break; case Common.searchType.Character: searchOrderBy = "CharacterName"; if (txtSearch.Text.Contains("%")) { searchFilter = "CharacterName LIKE '" + txtSearch.Text + "'"; } else { searchFilter = "CharacterName = '" + txtSearch.Text + "'"; } Character objCharacter = new Character(); List <Character> Characters = new List <Character>(); Characters = objCharacter.GetCharacters(searchFilter, searchOrderBy); SetFormForCharacter(Characters); break; case Common.searchType.Equipment: searchOrderBy = "EquipmentName"; if (txtSearch.Text.Contains("%")) { searchFilter = "EquipmentName LIKE '" + txtSearch.Text + "'"; } else { searchFilter = "EquipmentName = '" + txtSearch.Text + "'"; } Equipment objEquipment = new Equipment(); List <Equipment> equipmentList = new List <Equipment>(); equipmentList = objEquipment.GetEquipment(searchFilter, searchOrderBy); SetFormForEquipment(equipmentList); break; case Common.searchType.Skill: searchOrderBy = "SkillName"; if (txtSearch.Text.Contains("%")) { searchFilter = "SkillName LIKE '" + txtSearch.Text + "'"; } else { searchFilter = "SkillName = '" + txtSearch.Text + "'"; } Skill objSkill = new Skill(); List <Skill> objSkills = new List <Skill>(); objSkills = objSkill.GetSkills(searchFilter, searchOrderBy); SetFormForSkill(objSkills); break; case Common.searchType.Talent: searchOrderBy = "TalentName"; if (txtSearch.Text.Contains("%")) { searchFilter = "TalentName LIKE '" + txtSearch.Text + "'"; } else { searchFilter = "TalentName = '" + txtSearch.Text + "'"; } Talent objTalent = new Talent(); List <Talent> Talents = new List <Talent>(); Talents = objTalent.GetTalents(searchFilter, searchOrderBy); SetFormForTalent(Talents); break; case Common.searchType.Weapon: searchOrderBy = "WeaponName"; if (txtSearch.Text.Contains("%")) { searchFilter = "WeaponName LIKE '" + txtSearch.Text + "'"; } else { searchFilter = "WeaponName = '" + txtSearch.Text + "'"; } Weapon objWeapon = new Weapon(); List <Weapon> Weapons = new List <Weapon>(); Weapons = objWeapon.GetWeapons(searchFilter, searchOrderBy); SetFormForWeapon(Weapons); break; default: break; } }