private void SetReaderToObject(ref FeatPrereqORCondition objFeatPrereqORCondition, ref SqlDataReader result) { if (result.HasRows) { objFeatPrereqORCondition.FeatPrereqORConditionID = (int)result.GetValue(result.GetOrdinal("FeatPrereqORConditionID")); objFeatPrereqORCondition.FeatID = (int)result.GetValue(result.GetOrdinal("FeatID")); objFeatPrereqORCondition.TalentID = (int)result.GetValue(result.GetOrdinal("TalentID")); objFeatPrereqORCondition.FeatRequirementID = (int)result.GetValue(result.GetOrdinal("FeatRequirementID")); objFeatPrereqORCondition.RaceID = (int)result.GetValue(result.GetOrdinal("RaceID")); objFeatPrereqORCondition.TalentTreeID = (int)result.GetValue(result.GetOrdinal("TalentTreeID")); objFeatPrereqORCondition.TalentTreeTalentQuantity = (int)result.GetValue(result.GetOrdinal("TalentTreeTalentQuantity")); objFeatPrereqORCondition.AbilityID = (int)result.GetValue(result.GetOrdinal("AbilityID")); objFeatPrereqORCondition.AbilityMinimum = (int)result.GetValue(result.GetOrdinal("AbilityMinimum")); objFeatPrereqORCondition.SkillID = (int)result.GetValue(result.GetOrdinal("SkillID")); Talent objT = new Talent(objFeatPrereqORCondition.TalentID); objFeatPrereqORCondition.objTalent = objT; Feat objF = new Feat(objFeatPrereqORCondition.FeatRequirementID); objFeatPrereqORCondition.objFeatRequirement = objF; Race objR = new Race(objFeatPrereqORCondition.RaceID); objFeatPrereqORCondition.objRace = objR; TalentTree objTT = new TalentTree(objFeatPrereqORCondition.TalentTreeID); objFeatPrereqORCondition.objTalentTree = objTT; Ability objA = new Ability(objFeatPrereqORCondition.AbilityID); objFeatPrereqORCondition.objAbility = objA; Skill objS = new Skill(objFeatPrereqORCondition.SkillID); objFeatPrereqORCondition.objSkill = objS; } }
private void SetReaderToObject(ref TalentPrereqORCondition objTalentPrereqORCondition, ref SqlDataReader result) { if (result.HasRows) { objTalentPrereqORCondition.TalentPrereqORConditionID = (int)result.GetValue(result.GetOrdinal("TalentPrereqORConditionID")); objTalentPrereqORCondition.TalentID = (int)result.GetValue(result.GetOrdinal("TalentID")); objTalentPrereqORCondition.TalentRequirementID = (int)result.GetValue(result.GetOrdinal("TalentRequirementID")); objTalentPrereqORCondition.FeatID = (int)result.GetValue(result.GetOrdinal("FeatID")); objTalentPrereqORCondition.RaceID = (int)result.GetValue(result.GetOrdinal("RaceID")); objTalentPrereqORCondition.TalentTreeID = (int)result.GetValue(result.GetOrdinal("TalentTreeID")); objTalentPrereqORCondition.TalentTreeTalentQuantity = (int)result.GetValue(result.GetOrdinal("TalentTreeTalentQuantity")); objTalentPrereqORCondition.AbilityID = (int)result.GetValue(result.GetOrdinal("AbilityID")); objTalentPrereqORCondition.AbilityMinimum = (int)result.GetValue(result.GetOrdinal("AbilityMinimum")); objTalentPrereqORCondition.SkillID = (int)result.GetValue(result.GetOrdinal("SkillID")); if (objTalentPrereqORCondition.TalentID != 0) { Talent objTalent = new Talent(); objTalentPrereqORCondition.objTalent = objTalent.GetTalent(objTalentPrereqORCondition.TalentID); } if (objTalentPrereqORCondition.TalentRequirementID != 0) { Talent objTalentRequirement = new Talent(); objTalentPrereqORCondition.objTalentRequirement = objTalent.GetTalent(objTalentPrereqORCondition.TalentID); } if (objTalentPrereqORCondition.FeatID != 0) { Feat objFeat = new Feat(); objTalentPrereqORCondition.objFeat = objFeat.GetFeat(objTalentPrereqORCondition.FeatID); } if (objTalentPrereqORCondition.RaceID != 0) { Race objRace = new Race(); objTalentPrereqORCondition.objRace = objRace.GetRace(objTalentPrereqORCondition.FeatID); } if (objTalentPrereqORCondition.TalentTreeID != 0) { TalentTree objTalentTree = new TalentTree(); objTalentPrereqORCondition.objTalentTree = objTalentTree.GetTalentTree(objTalentPrereqORCondition.TalentTreeID); } if (objTalentPrereqORCondition.AbilityID != 0) { TalentPrerequisteAbility objTalentPrerequisteAbility = new TalentPrerequisteAbility(); objTalentPrereqORCondition.objTalentPrerequisteAbility = objTalentPrerequisteAbility.GetTalentPrerequisteAbility(this.TalentID, this.AbilityID); } if (objTalentPrereqORCondition.SkillID != 0) { Skill objSkill = new Skill(); objTalentPrereqORCondition.objSkill = objSkill.GetSkill(objTalentPrereqORCondition.SkillID); } } }
/// <summary> /// Clones the specified LST TalentTree. /// </summary> /// <param name="lstTalentTree">The LST TalentTree.</param> /// <returns>List<TalentTree></returns> static public List <TalentTree> Clone(List <TalentTree> lstTalentTree) { List <TalentTree> lstCTalentTree = new List <TalentTree>(); foreach (TalentTree objTalentTree in lstTalentTree) { lstCTalentTree.Add(TalentTree.Clone(objTalentTree)); } return(lstCTalentTree); }
/// <summary> /// Determines whether [is talent tree in list] [the specified object talent tree]. /// </summary> /// <param name="objTalentTree">The object talent tree.</param> /// <param name="lstTalentTree">The LST talent tree.</param> /// <returns>Boolean</returns> static public bool IsTalentTreeInList(TalentTree objTalentTree, List <TalentTree> lstTalentTree) { bool blnTalentTreeFound = false; foreach (TalentTree lstObjTalentTree in lstTalentTree) { if (objTalentTree.TalentTreeID == lstObjTalentTree.TalentTreeID) { blnTalentTreeFound = true; } } return(blnTalentTreeFound); }
/// <summary> /// Sets the reader to object. /// </summary> /// <param name="objTalentTree">The object talent tree.</param> /// <param name="result">The result.</param> private void SetReaderToObject(ref TalentTree objTalentTree, ref SqlDataReader result) { if (result.HasRows) { objTalentTree.TalentTreeID = (int)result.GetValue(result.GetOrdinal("TalentTreeID")); objTalentTree.ForceTalent = (bool)result.GetValue(result.GetOrdinal("ForceTalent")); objTalentTree.TalentTreeName = result.GetValue(result.GetOrdinal("TalentTreeName")).ToString(); Talent objTalent = new Talent(); Race objRace = new Race(); TalentTreeRequirement objTalentTreeRequirement = new TalentTreeRequirement(); objTalentTree.objTalentTreeTalents = objTalent.GetTreeTalents("otmTalentTreeTalent.TalentTreeID=" + objTalentTree.TalentTreeID.ToString(), ""); objTalentTree.objTalentTreeRaceRequirement = objRace.GetRaceRequirementForTalentTree("TalentTreeID=" + objTalentTree.TalentTreeID.ToString(), " RaceName"); objTalentTree.objTalentTreeRequirement = objTalentTreeRequirement.GetTalentTreeTalentTreeRequirements("TalentTreeID=" + objTalentTree.TalentTreeID.ToString(), " TalentTreeRequirementDescription "); objTalentTree._objComboBoxData.Add(objTalentTree.TalentTreeID, objTalentTree.TalentTreeName); } }
/// <summary> /// Gets the talent tree list. /// </summary> /// <param name="strSprocName">Name of the string sproc.</param> /// <param name="strWhere">The string where.</param> /// <param name="strOrderBy">The string order by.</param> /// <returns>List of TalentTree objects</returns> private List <TalentTree> GetTalentTreeList(string strSprocName, string strWhere, string strOrderBy) { List <TalentTree> talentTrees = new List <TalentTree>(); SqlDataReader result; DatabaseConnection dbconn = new DatabaseConnection(); SqlCommand command = new SqlCommand(); SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString); try { connection.Open(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = strSprocName; command.Parameters.Add(dbconn.GenerateParameterObj("@strWhere", SqlDbType.VarChar, strWhere, 1000)); command.Parameters.Add(dbconn.GenerateParameterObj("@strOrderBy", SqlDbType.VarChar, strOrderBy, 1000)); result = command.ExecuteReader(); while (result.Read()) { TalentTree objTalentTree = new TalentTree(); SetReaderToObject(ref objTalentTree, ref result); talentTrees.Add(objTalentTree); } } catch { Exception e = new Exception(); throw e; } finally { command.Dispose(); connection.Close(); } return(talentTrees); }
//TODO Unit Test public List <TalentTree> GetForceTalentTreesByCharacterTradtion(Character objChar) { List <TalentTree> talentTrees = new List <TalentTree>(); SqlDataReader result; DatabaseConnection dbconn = new DatabaseConnection(); SqlCommand command = new SqlCommand(); SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString); try { connection.Open(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "Select_CharacterTalentTreeForceTradtions"; command.Parameters.Add(dbconn.GenerateParameterObj("@CharacterID", SqlDbType.Int, objChar.CharacterID.ToString())); result = command.ExecuteReader(); while (result.Read()) { TalentTree objTalentTree = new TalentTree(); SetReaderToObject(ref objTalentTree, ref result); talentTrees.Add(objTalentTree); } } catch { Exception e = new Exception(); throw e; } finally { command.Dispose(); connection.Close(); } return(talentTrees); }
/// <summary> /// Clones the specified object TalentTree. /// </summary> /// <param name="objTalentTree">The object TalentTree.</param> /// <returns>TalentTree</returns> static public TalentTree Clone(TalentTree objTalentTree) { TalentTree objCTalentTree = new TalentTree(objTalentTree.TalentTreeID); return(objCTalentTree); }
/// <summary> /// Sets the reader to object. /// </summary> /// <param name="objClass">The object class.</param> /// <param name="result">The result.</param> private void SetReaderToObject(ref Class objClass, ref SqlDataReader result) { if (result.HasRows) { objClass.ClassID = (int)result.GetValue(result.GetOrdinal("ClassID")); objClass.IsPrestige = (bool)result.GetValue(result.GetOrdinal("IsPrestige")); objClass.ClassName = result.GetValue(result.GetOrdinal("ClassName")).ToString(); objClass.HitDieType = (int)result.GetValue(result.GetOrdinal("HitDieType")); objClass.StartingSkillNumber = (int)result.GetValue(result.GetOrdinal("StartingSkillNumber")); if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("StartingSkills")).ToString())) { objClass.StartingSkills = (int)result.GetValue(result.GetOrdinal("StartingSkills")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("StartCreditDie")).ToString())) { objClass.StartCreditDie = (int)result.GetValue(result.GetOrdinal("StartCreditDie")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("StartCreditDieNumber")).ToString())) { objClass.StartCreditDieNumber = (int)result.GetValue(result.GetOrdinal("StartCreditDieNumber")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("StartCreditDieModifier")).ToString())) { objClass.StartCreditDieModifier = (int)result.GetValue(result.GetOrdinal("StartCreditDieModifier")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("PrestigeRequiredTalents")).ToString())) { objClass.PrestigeRequiredTalents = (int)result.GetValue(result.GetOrdinal("PrestigeRequiredTalents")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("PrestigeRequiredForceTech")).ToString())) { objClass.PrestigeRequiredForceTech = (bool)result.GetValue(result.GetOrdinal("PrestigeRequiredForceTech")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("PrestigeRequiredDarkside")).ToString())) { objClass.PrestigeRequiredDarkside = (bool)result.GetValue(result.GetOrdinal("PrestigeRequiredDarkside")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("PrestigeRequiredFeats")).ToString())) { objClass.PrestigeRequiredFeats = (int)result.GetValue(result.GetOrdinal("PrestigeRequiredFeats")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("PrestigeRequiredBaseAttack")).ToString())) { objClass.PrestigeRequiredBaseAttack = (int)result.GetValue(result.GetOrdinal("PrestigeRequiredBaseAttack")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("PrestigeRequiredLevel")).ToString())) { objClass.PrestigeRequiredLevel = (int)result.GetValue(result.GetOrdinal("PrestigeRequiredLevel")); } objClass._objComboBoxData.Clear(); objClass._objComboBoxData.Add(objClass.ClassID, objClass.ClassName); } if (objClass.IsPrestige) { Feat objFeat = new Feat();; ClassDefenseType objClassDefenseTypes = new ClassDefenseType(); PrestigeRequirement objPrestigeRequirement = new PrestigeRequirement(); TalentTree objTalentTree = new TalentTree(); Talent objTalent = new Talent(); ForcePower objForcePower = new ForcePower(); Skill objSkill = new Skill(); Race objRace = new Race(); objClass.StartingFeats = objFeat.GetStartingFeats(" ClassID=" + objClass.ClassID.ToString(), "FeatName"); objClass.objClassDefenseTypes = objClassDefenseTypes.GetClassDefenseTypes(" ClassID=" + objClass.ClassID.ToString(), ""); objClass.objPrestigeRequirement = objPrestigeRequirement.GetPrestigeRequirementPrestigeClass(" ClassID=" + objClass.ClassID.ToString(), "PrestigeRequirementDescription"); objClass.objPrestigeRequiredTalentTree = objTalentTree.GetTalentTreesPrestigeClass("ClassID=" + objClass.ClassID.ToString(), "TalentTreeName"); objClass.objPrestigeRequiredTalents = objTalent.GetPrestigeRequiredTalents("ClassID=" + objClass.ClassID.ToString(), "TalentName"); objClass.objPrestigeRequiredFeats = objFeat.GetPrestigeRequiredFeats(" ClassID=" + objClass.ClassID.ToString(), "FeatName"); objClass.objPrestigeRequiredFeatGroup = objFeat.GetPrestigeRequiredFeatGroups(" ClassID=" + objClass.ClassID.ToString(), "FeatName"); objClass.objPrestigeRequiredForcePowers = objForcePower.GetPrestigeRequiredForcePowers(" ClassID=" + objClass.ClassID.ToString(), "ForcePowerName"); objClass.objPrestigeRequiredSkills = objSkill.GetPrestigeRequiredSkills(" ClassID=" + objClass.ClassID.ToString(), "SkillName"); objClass.objPrestigeRequiredRaces = objRace.GetRaceRequirementForClass(" mtmPrestigeRequirementClassRace.ClassID=" + objClass.ClassID.ToString(), "RaceName"); } }