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