/// <summary> /// Clones the specified LST FeatPrerequisiteDarkSide. /// </summary> /// <param name="lstFeatPrerequisiteDarkSide">The LST FeatPrerequisiteDarkSide.</param> /// <returns>List<FeatPrerequisiteDarkSide></returns> static public List <FeatPrerequisiteDarkSide> Clone(List <FeatPrerequisiteDarkSide> lstFeatPrerequisiteDarkSide) { List <FeatPrerequisiteDarkSide> lstCFeatPrerequisiteDarkSide = new List <FeatPrerequisiteDarkSide>(); foreach (FeatPrerequisiteDarkSide objFeatPrerequisiteDarkSide in lstFeatPrerequisiteDarkSide) { lstCFeatPrerequisiteDarkSide.Add(FeatPrerequisiteDarkSide.Clone(objFeatPrerequisiteDarkSide)); } return(lstCFeatPrerequisiteDarkSide); }
/// <summary> /// Sets the reader to object. /// </summary> /// <param name="objFeatPrerequisiteDarkSide">The object feat prerequisite dark side.</param> /// <param name="result">The result.</param> private void SetReaderToObject(ref FeatPrerequisiteDarkSide objFeatPrerequisiteDarkSide, ref SqlDataReader result) { if (result.HasRows) { objFeatPrerequisiteDarkSide.FeatID = (int)result.GetValue(result.GetOrdinal("FeatID")); objFeatPrerequisiteDarkSide.DarkSideScore = (int)result.GetValue(result.GetOrdinal("DarkSideScore")); objFeatPrerequisiteDarkSide.TotalDarkSide = (bool)result.GetValue(result.GetOrdinal("TotalDarkSide")); //Ability objAbility = new Ability(); //objAbility.GetAbility(objFeatPrerequisiteDarkSide.AbilityID); //objFeatPrerequisiteDarkSide.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 dark side 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 <FeatPrerequisiteDarkSide> GetFeatPrerequisiteDarkSideList(string strSprocName, string strWhere, string strOrderBy) { List <FeatPrerequisiteDarkSide> featPrerequisiteAbilitys = new List <FeatPrerequisiteDarkSide>(); 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()) { FeatPrerequisiteDarkSide objFeatPrerequisiteDarkSide = new FeatPrerequisiteDarkSide(); SetReaderToObject(ref objFeatPrerequisiteDarkSide, ref result); featPrerequisiteAbilitys.Add(objFeatPrerequisiteDarkSide); } } catch { Exception e = new Exception(); throw e; } finally { command.Dispose(); connection.Close(); } return(featPrerequisiteAbilitys); }
/// <summary> /// Clones the specified object FeatPrerequisiteDarkSide. /// </summary> /// <param name="objFeatPrerequisiteDarkSide">The object FeatPrerequisiteDarkSide.</param> /// <returns>FeatPrerequisiteDarkSide</returns> static public FeatPrerequisiteDarkSide Clone(FeatPrerequisiteDarkSide objFeatPrerequisiteDarkSide) { FeatPrerequisiteDarkSide objCFeatPrerequisiteDarkSide = new FeatPrerequisiteDarkSide(objFeatPrerequisiteDarkSide.FeatID); return(objCFeatPrerequisiteDarkSide); }