/// <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);
}
