/// <summary> /// Clones the specified LST FeatPrerequisiteAbility. /// </summary> /// <param name="lstFeatPrerequisiteAbility">The LST FeatPrerequisiteAbility.</param> /// <returns>List<FeatPrerequisiteAbility></returns> static public List <FeatPrerequisiteAbility> Clone(List <FeatPrerequisiteAbility> lstFeatPrerequisiteAbility) { List <FeatPrerequisiteAbility> lstCFeatPrerequisiteAbility = new List <FeatPrerequisiteAbility>(); foreach (FeatPrerequisiteAbility objFeatPrerequisiteAbility in lstFeatPrerequisiteAbility) { lstCFeatPrerequisiteAbility.Add(FeatPrerequisiteAbility.Clone(objFeatPrerequisiteAbility)); } return(lstCFeatPrerequisiteAbility); }
/// <summary> /// Sets the reader to object. /// </summary> /// <param name="objFeatPrerequisiteAbility">The object feat prerequisite ability.</param> /// <param name="result">The result.</param> private void SetReaderToObject(ref FeatPrerequisiteAbility objFeatPrerequisiteAbility, ref SqlDataReader result) { if (result.HasRows) { objFeatPrerequisiteAbility.FeatID = (int)result.GetValue(result.GetOrdinal("FeatID")); objFeatPrerequisiteAbility.AbilityID = (int)result.GetValue(result.GetOrdinal("AbilityID")); objFeatPrerequisiteAbility.AbilityMinimum = (int)result.GetValue(result.GetOrdinal("AbilityMinimum")); Ability objAbility = new Ability(); objAbility.GetAbility(objFeatPrerequisiteAbility.AbilityID); objFeatPrerequisiteAbility.objAbility = objAbility; } }
/// <summary> /// Sets the reader to object. /// </summary> /// <param name="objFeat">The object feat.</param> /// <param name="result">The result.</param> private void SetReaderToObject(ref Feat objFeat, ref SqlDataReader result) { if (result.HasRows) { objFeat.FeatID = (int)result.GetValue(result.GetOrdinal("FeatID")); objFeat.FeatName = result.GetValue(result.GetOrdinal("FeatName")).ToString(); objFeat.FeatDescription = result.GetValue(result.GetOrdinal("FeatDescription")).ToString(); objFeat.FeatSpecial = result.GetValue(result.GetOrdinal("FeatSpecial")).ToString(); objFeat.RageRequired = (bool)result.GetValue(result.GetOrdinal("RageRequired")); objFeat.ShapeShiftRequired = (bool)result.GetValue(result.GetOrdinal("ShapeShiftRequired")); objFeat.MultipleSelection = (int)result.GetValue(result.GetOrdinal("MultipleSelection")); objFeat.BookID = (int)result.GetValue(result.GetOrdinal("BookID")); objFeat.SkillTrainingFeat = (bool)result.GetValue(result.GetOrdinal("SkillTrainingFeat")); objFeat.SkillFocusFeat = (bool)result.GetValue(result.GetOrdinal("SkillFocusFeat")); objFeat.WeaponProficiencyID = (bool)result.GetValue(result.GetOrdinal("WeaponProficiencyID")); objFeat.ArmorProficiencyID = (bool)result.GetValue(result.GetOrdinal("ArmorProficiencyID")); FeatPrerequisiteAbility objFeatPrerequisiteAbility = new FeatPrerequisiteAbility(); Feat objPreReqFeat = new Feat(); BaseAttack objBaseAttack = new BaseAttack(); Skill objSkill = new Skill(); Race objRace = new Race(); Class objClass = new Class(); Size objSize = new Size(); FeatPrerequisiteDarkSide objFeatPrerequisiteDarkSide = new FeatPrerequisiteDarkSide(); FeatPrereqORCondition objFeatPrereqORCondition = new FeatPrereqORCondition(); objFeat.objFeatPrerequisiteAbilities = objFeatPrerequisiteAbility.GetFeatPrerequisiteAbilites(" FeatID=" + objFeat.FeatID.ToString(), ""); objFeat.objFeatPrerequisiteFeats = objPreReqFeat.GetFeatPrerequisiteFeats(" [otmFeatPrequisiteFeat].FeatID=" + objFeat.FeatID.ToString(), " FeatName"); objFeat.objBaseAttackPrerequisite = objBaseAttack.GetFeatPrequisiteBaseAttackBonus(objFeat.FeatID); objFeat.objSkillPrerequisite = objSkill.GetFeatPrerequisiteSkill(objFeat.FeatID); objFeat.objFeatPrerequisiteClasses = objClass.GetFeatPrerequisiteClass(objFeat.FeatID); objFeat.objRacePrerequisite = objRace.GetFeatPrerequisiteRace(objFeat.FeatID); objFeat.objFeatPrerequisiteSize = objSize.GetFeatPrerequisiteSize(objFeat.FeatID); objFeat.objFeatPrerequisiteDarkSide = objFeatPrerequisiteDarkSide.GetFeatPrerequisiteDarkSide(objFeat.FeatID); objFeat.lstFeatPrereqORConditions = objFeatPrereqORCondition.GetFeatPrereqORConditions(objFeat.FeatID); objFeat._objComboBoxData.Add(objFeat.FeatID, objFeat.FeatName); } }
/// <summary> /// Gets the feat prerequisite ability 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 <FeatPrerequisiteAbility> GetFeatPrerequisiteAbilityList(string strSprocName, string strWhere, string strOrderBy) { List <FeatPrerequisiteAbility> featPrerequisiteAbilitys = new List <FeatPrerequisiteAbility>(); 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()) { FeatPrerequisiteAbility objFeatPrerequisiteAbility = new FeatPrerequisiteAbility(); SetReaderToObject(ref objFeatPrerequisiteAbility, ref result); featPrerequisiteAbilitys.Add(objFeatPrerequisiteAbility); } } catch { Exception e = new Exception(); throw e; } finally { command.Dispose(); connection.Close(); } return(featPrerequisiteAbilitys); }
/// <summary> /// Clones the specified object FeatPrerequisiteAbility. /// </summary> /// <param name="objFeatPrerequisiteAbility">The object FeatPrerequisiteAbility.</param> /// <returns>FeatPrerequisiteAbility</returns> static public FeatPrerequisiteAbility Clone(FeatPrerequisiteAbility objFeatPrerequisiteAbility) { FeatPrerequisiteAbility objCFeatPrerequisiteAbility = new FeatPrerequisiteAbility(objFeatPrerequisiteAbility.FeatID, objFeatPrerequisiteAbility.AbilityID); return(objCFeatPrerequisiteAbility); }