/// <summary>
/// Sets the reader to object.
/// </summary>
/// <param name="objRaceDefenseTypeModifier">The object race defense type modifier.</param>
/// <param name="result">The result.</param>
private void SetReaderToObject(ref RaceDefenseTypeModifier objRaceDefenseTypeModifier, ref SqlDataReader result)
{
if (result.HasRows)
{
objRaceDefenseTypeModifier.ModifierID = (int)result.GetValue(result.GetOrdinal("ModifierID"));
objRaceDefenseTypeModifier.DefenseTypeID = (int)result.GetValue(result.GetOrdinal("DefenseTypeID"));
objRaceDefenseTypeModifier.RaceID = (int)result.GetValue(result.GetOrdinal("RaceID"));
Modifier objModifier = new Modifier();
if (!(objRaceDefenseTypeModifier.ModifierID == 0))
{
objModifier.GetModifier(objRaceDefenseTypeModifier.ModifierID);
}
objRaceDefenseTypeModifier.objModifier = objModifier;
DefenseType objDefenseType = new DefenseType();
//List<DefenseType> DefenseTypes = new List<DefenseType>();
if (!(objRaceDefenseTypeModifier.RaceID == 0))
{
objDefenseType.GetRaceDefenseType(" RaceID=" + objRaceDefenseTypeModifier.RaceID.ToString() + " AND [otmRaceDefenseTypeModifier].DefenseTypeID=" + objRaceDefenseTypeModifier.DefenseTypeID.ToString(), "");
}
objRaceDefenseTypeModifier.objDefenseType = objDefenseType;
}
}
/// <summary>
/// Clones the specified LST RaceDefenseTypeModifier.
/// </summary>
/// <param name="lstRaceDefenseTypeModifier">The LST RaceDefenseTypeModifier.</param>
/// <returns>List<RaceDefenseTypeModifier></returns>
static public List <RaceDefenseTypeModifier> Clone(List <RaceDefenseTypeModifier> lstRaceDefenseTypeModifier)
{
List <RaceDefenseTypeModifier> lstCRaceDefenseTypeModifier = new List <RaceDefenseTypeModifier>();
foreach (RaceDefenseTypeModifier objRaceDefenseTypeModifier in lstRaceDefenseTypeModifier)
{
lstCRaceDefenseTypeModifier.Add(RaceDefenseTypeModifier.Clone(objRaceDefenseTypeModifier));
}
return(lstCRaceDefenseTypeModifier);
}
/// <summary>
/// Gets the race defense type modifiers by race.
/// </summary>
/// <param name="RaceID">The race identifier.</param>
/// <param name="strOrderBy">The string order by.</param>
/// <returns>List of RaceDefenseTypeModifier objects</returns>
public List <RaceDefenseTypeModifier> GetRaceDefenseTypeModifiersByRace(int RaceID, string strOrderBy)
{
//string strWhere = "";
//strWhere = " RaceID=" + RaceID.ToString() + " AND [otmRaceDefenseTypeModifier].DefenseTypeID=" + objDefenseType.DefenseTypeID.ToString();
//return GetRaceDefenseTypeModifierList("Select_RaceDefenseTypeModifier", strWhere, strOrderBy);
//This one is different!!!! Have to loop through each defense type individually to get the where clause.
List <DefenseType> objDefenseTypes = new List <DefenseType>();
DefenseType objDefType = new DefenseType();
objDefenseTypes = objDefType.GetRaceDefenseTypes("", "");
string strWhere = "";
List <RaceDefenseTypeModifier> raceDefenseTypeModifier = new List <RaceDefenseTypeModifier>();
try
{
foreach (DefenseType objDefenseType in objDefenseTypes)
{
SqlDataReader result;
DatabaseConnection dbconn = new DatabaseConnection();
SqlCommand command = new SqlCommand();
SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString);
strWhere = " RaceID=" + RaceID.ToString() + " AND [otmRaceDefenseTypeModifier].DefenseTypeID=" + objDefenseType.DefenseTypeID.ToString();
connection.Open();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "Select_RaceDefenseTypeModifier";
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())
{
RaceDefenseTypeModifier objRaceDefenseTypeModifier = new RaceDefenseTypeModifier();
SetReaderToObject(ref objRaceDefenseTypeModifier, ref result);
raceDefenseTypeModifier.Add(objRaceDefenseTypeModifier);
}
command.Dispose();
connection.Close();
}
}
catch
{
Exception e = new Exception();
throw e;
}
return(raceDefenseTypeModifier);
}
/// <summary>
/// Gets the race defense type modifier 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>List of RaceDefenseTypeModifier objects</returns>
private List <RaceDefenseTypeModifier> GetRaceDefenseTypeModifierList(string strSprocName, string strWhere, string strOrderBy)
{
List <RaceDefenseTypeModifier> raceDefenseTypeModifiers = new List <RaceDefenseTypeModifier>();
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())
{
RaceDefenseTypeModifier objRaceDefenseTypeModifier = new RaceDefenseTypeModifier();
SetReaderToObject(ref objRaceDefenseTypeModifier, ref result);
raceDefenseTypeModifiers.Add(objRaceDefenseTypeModifier);
}
}
catch
{
Exception e = new Exception();
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(raceDefenseTypeModifiers);
}
/// <summary>
/// Sets the reader to object.
/// </summary>
/// <param name="objRace">The object race.</param>
/// <param name="result">The result.</param>
private void SetReaderToObject(ref Race objRace, ref SqlDataReader result)
{
if (result.HasRows)
{
try
{
objRace.RaceID = (int)result.GetValue(result.GetOrdinal("RaceID"));
objRace.RaceName = result.GetValue(result.GetOrdinal("RaceName")).ToString();
objRace.RaceDescription = result.GetValue(result.GetOrdinal("RaceDescription")).ToString();
objRace.OtherDescription = result.GetValue(result.GetOrdinal("OtherDescription")).ToString();
objRace.Sex = result.GetValue(result.GetOrdinal("Sex")).ToString();
objRace.RageAbility = (bool)result.GetValue(result.GetOrdinal("RageAbility"));
objRace.ShapeShiftAbility = (bool)result.GetValue(result.GetOrdinal("ShapeShiftAbility"));
objRace.Primitive = (bool)result.GetValue(result.GetOrdinal("Primitive"));
objRace.BonusFeat = (bool)result.GetValue(result.GetOrdinal("BonusFeat"));
objRace.BonusSkill = (bool)result.GetValue(result.GetOrdinal("BonusSkill"));
objRace.AverageHeight = (decimal)result.GetValue(result.GetOrdinal("AverageHeight"));
objRace.AverageWeight = (decimal)result.GetValue(result.GetOrdinal("AverageWeight"));
objRace.SizeID = (int)result.GetValue(result.GetOrdinal("SizeID"));
objRace.SpeedID = (int)result.GetValue(result.GetOrdinal("SpeedID"));
List <RaceAbilityModifier> objRaceAbilityModifiers = new List <RaceAbilityModifier>();
RaceAbilityModifier objRaceAbilityModifier = new RaceAbilityModifier();
Speed objSpeed = new Speed();
if (!(objRace.RaceID == 0))
{
objRaceAbilityModifiers = objRaceAbilityModifier.GetRaceAbilityModifiers(" RaceID=" + objRace.RaceID.ToString(), "");
}
objRace.objRaceAbilityModifiers = objRaceAbilityModifiers;
List <Skill> objRaceSkills = new List <Skill>();
Skill objSkill = new Skill();
if (!(objRace.RaceID == 0))
{
objRaceSkills = objSkill.GetSkillsForRace(" RaceID=" + objRace.RaceID.ToString(), "");
}
objRace.lstRaceSkills = objRaceSkills;
List <Speed> objSpeeds = new List <Speed>();
if (!(objRace.SpeedID == 0))
{
objSpeeds = objSpeed.GetRaceSpeeds(objRace.RaceID);
}
objRace.objSpeeds = objSpeeds;
RaceDefenseTypeModifier objRaceDefenseTypeModifier = new RaceDefenseTypeModifier();
lstRaceDefenseTypeModifier = objRaceDefenseTypeModifier.GetRaceDefenseTypeModifiersByRace(objRace.RaceID, "");
RaceFeatConditionalFeat objRaceFeatConditionalFeat = new RaceFeatConditionalFeat();
lstConditionalFeatsByFeat = objRaceFeatConditionalFeat.GetRaceFeatConditionalFeatsByRaceID(objRace.RaceID);
RaceSkillConditionalFeat objRaceSkillConditionalFeat = new RaceSkillConditionalFeat();
lstConditionalFeatsBySkill = objRaceSkillConditionalFeat.GetRaceSkillConditionalFeatsByRaceID(objRace.RaceID);
Language objLanguage = new Language();
lstLanguages = objLanguage.GetRaceLanguages(objRace.RaceID, "");
RaceLanguage objRaceLang = new RaceLanguage();
lstRaceLanguages = objRaceLang.GetRaceLanguages("RaceID=" + objRace.RaceID.ToString(), "");
RaceSpecialAbility objRSA = new RaceSpecialAbility();
lstRaceSpecialAbilities = objRSA.GetRaceSpecialAbilitysByRace(objRace.RaceID);
objRace._objComboBoxData.Add(objRace.RaceID, objRace.RaceName);
}
catch
{
Exception e = new Exception();
throw e;
}
}
}
/// <summary>
/// Clones the specified object RaceDefenseTypeModifier.
/// </summary>
/// <param name="objRaceDefenseTypeModifier">The object RaceDefenseTypeModifier.</param>
/// <returns>RaceDefenseTypeModifier</returns>
static public RaceDefenseTypeModifier Clone(RaceDefenseTypeModifier objRaceDefenseTypeModifier)
{
RaceDefenseTypeModifier objCRaceDefenseTypeModifier = new RaceDefenseTypeModifier(objRaceDefenseTypeModifier.RaceID, objRaceDefenseTypeModifier.DefenseTypeID, objRaceDefenseTypeModifier.ModifierID);
return(objCRaceDefenseTypeModifier);
}
