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