/// <summary> /// Sets the reader to object. /// </summary> /// <param name="objForcePower">The object force power.</param> /// <param name="result">The result.</param> private void SetReaderToObject(ref ForcePower objForcePower, ref SqlDataReader result) { if (result.HasRows) { objForcePower.ForcePowerID = (int)result.GetValue(result.GetOrdinal("ForcePowerID")); objForcePower.ForcePowerName = result.GetValue(result.GetOrdinal("ForcePowerName")).ToString(); objForcePower.ForcePowerDescription = result.GetValue(result.GetOrdinal("ForcePowerDescription")).ToString(); //objForcePower.ForcePowerDescriptorID = (int)result.GetValue(result.GetOrdinal("ForcePowerDescriptorID")); objForcePower.TurnSegmentID = (int)result.GetValue(result.GetOrdinal("TurnSegmentID")); objForcePower.ForcePowerTarget = result.GetValue(result.GetOrdinal("ForcePowerTarget")).ToString(); objForcePower.ForcePowerSpecial = result.GetValue(result.GetOrdinal("ForcePowerSpecial")).ToString(); ForcePowerDescriptor FPD = new ForcePowerDescriptor(); objForcePower.objForcePowerDescriptors = FPD.GetForcePowerForcePowerDescriptors(" ForcePowerID=" + objForcePower.ForcePowerID.ToString(), " ForcePowerDescriptorName "); if (objForcePower.TurnSegmentID != 0) { TurnSegment TS = new TurnSegment(); objForcePower.objTurnSegment = TS.GetTurnSegment(objForcePower.TurnSegmentID); } objForcePower._objComboBoxData.Add(objForcePower.ForcePowerID, objForcePower.ForcePowerName); } }
/// <summary> /// Clones the specified LST ForcePower. /// </summary> /// <param name="lstForcePower">The LST ForcePower.</param> /// <returns>List<ForcePower></returns> static public List <ForcePower> Clone(List <ForcePower> lstForcePower) { List <ForcePower> lstCForcePower = new List <ForcePower>(); foreach (ForcePower objForcePower in lstForcePower) { lstCForcePower.Add(ForcePower.Clone(objForcePower)); } return(lstCForcePower); }
/// <summary> /// Saves a List of ForcePowers to a Character. /// </summary> /// <param name="lstCharForcePower">A <List> of ForcePowers .</param> /// <param name="intCharacterID">The Character identifier.</param> /// <returns></returns> public void SaveCharacterForcePowers(List <ForcePower> lstCharForcePower, int intCharacterID) { ForcePower objDelForcePower = new ForcePower(); objDelForcePower.DeleteCharacterForcePower(intCharacterID, 0); foreach (ForcePower objCharForcePower in lstCharForcePower) { objCharForcePower.SaveCharacterForcePower(intCharacterID, objCharForcePower.ForcePowerID); } }
/// <summary> /// Determines whether [is force power in list] [the specified object force power]. /// </summary> /// <param name="objForcePower">The object force power.</param> /// <param name="lstForcePower">The LST force power.</param> /// <returns></returns> static public bool IsForcePowerInList(ForcePower objForcePower, List <ForcePower> lstForcePower) { bool blnForcePowerFound = false; foreach (ForcePower lstObjForcePower in lstForcePower) { if (objForcePower.ForcePowerID == lstObjForcePower.ForcePowerID) { blnForcePowerFound = true; } } return(blnForcePowerFound); }
/// <summary> /// Sets the reader to object. /// </summary> /// <param name="result">The result.</param> private void SetReaderToObject(ref SqlDataReader result) { if (result.HasRows) { this.TalentID = (int)result.GetValue(result.GetOrdinal("TalentID")); this.TalentName = result.GetValue(result.GetOrdinal("TalentName")).ToString(); this.TalentDescription = result.GetValue(result.GetOrdinal("TalentDescription")).ToString(); this.TalentTreeID = (int)result.GetValue(result.GetOrdinal("TalentTreeID")); this.MultipleSelection = (int)result.GetValue(result.GetOrdinal("MultipleSelection")); this.BookID = (int)result.GetValue(result.GetOrdinal("BookID")); this.TalentSpecial = result.GetValue(result.GetOrdinal("TalentSpecial")).ToString(); this._objComboBoxData.Add(this.TalentID, this.TalentName); TurnSegment objTurnSegment = new TurnSegment(); if (!(this.TurnSegmentID == 0)) { objTurnSegment.GetTurnSegment(this.TurnSegmentID); } this.objTurnSegment = objTurnSegment; Talent objPreTalent = new Talent(); this.objPrerequsiteTalent = objPreTalent.GetPrerequisteTalents(" otmTalentPrerequisteTalent.TalentID=" + this.TalentID.ToString(), "TalentName"); //List<Ability> objPrerequisteAbility TalentPrerequisteAbility objTalentPrerequisteAbility = new TalentPrerequisteAbility(); this.objTalentPrerequisteAbility = objTalentPrerequisteAbility.GetTalentPrerequisteAbilities("TalentID=" + this.TalentID.ToString(), ""); Skill objSkill = new Skill(); this.objTalentPrerequsiteSkill = objSkill.GetTalentRequiredSkills("TalentID=" + this.TalentID.ToString(), ""); Feat objFeat = new Feat(); this.objTalentPrerequsiteFeat = objFeat.GetTalentPrerequisiteFeats("TalentID=" + this.TalentID.ToString(), ""); ForcePower objPreForcePower = new ForcePower(); this.objTalentPrerequisteForcePower = objPreForcePower.GetTalentPrequisteForcePowers("TalentID=" + this.TalentID.ToString(), ""); BaseAttack objBaseAttack = new BaseAttack(); this.objBaseAttackPrerequisite = objBaseAttack.GetFeatPrequisiteBaseAttackBonus(this.TalentID); } }
/// <summary> /// Gets the force power 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></returns> private List <ForcePower> GetForcePowerList(string strSprocName, string strWhere, string strOrderBy) { List <ForcePower> forcePowers = new List <ForcePower>(); 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()) { ForcePower objForcePower = new ForcePower(); SetReaderToObject(ref objForcePower, ref result); forcePowers.Add(objForcePower); } } catch { Exception e = new Exception(); throw e; } finally { command.Dispose(); connection.Close(); } return(forcePowers); }
/// <summary> /// Clones the specified object ForcePower. /// </summary> /// <param name="objForcePower">The object ForcePower.</param> /// <returns>ForcePower</returns> static public ForcePower Clone(ForcePower objForcePower) { ForcePower objCForcePower = new ForcePower(objForcePower.ForcePowerID); return(objCForcePower); }
/// <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"); } }