/// <summary> /// Sets the reader to object. /// </summary> /// <param name="objPrestigeRequirement">The object prestige requirement.</param> /// <param name="result">The result.</param> private void SetReaderToObject(ref PrestigeRequirement objPrestigeRequirement, ref SqlDataReader result) { if (result.HasRows) { objPrestigeRequirement.PrestigeRequirementID = (int)result.GetValue(result.GetOrdinal("PrestigeRequirementID")); objPrestigeRequirement.PrestigeRequirementDescription = result.GetValue(result.GetOrdinal("PrestigeRequirementDescription")).ToString(); objPrestigeRequirement._objComboBoxData.Add(objPrestigeRequirement.PrestigeRequirementID, objPrestigeRequirement.PrestigeRequirementDescription); } }
/// <summary> /// Clones the specified LST PrestigeRequirement. /// </summary> /// <param name="lstPrestigeRequirement">The LST PrestigeRequirement.</param> /// <returns>List<PrestigeRequirement></returns> static public List <PrestigeRequirement> Clone(List <PrestigeRequirement> lstPrestigeRequirement) { List <PrestigeRequirement> lstCPrestigeRequirement = new List <PrestigeRequirement>(); foreach (PrestigeRequirement objPrestigeRequirement in lstPrestigeRequirement) { lstCPrestigeRequirement.Add(PrestigeRequirement.Clone(objPrestigeRequirement)); } return(lstCPrestigeRequirement); }
/// <summary> /// Saves a List of Feats to a Character. /// </summary> /// <param name="lstCharFeat">A <List> of Feats .</param> /// <param name="intCharacterID">The Character identifier.</param> /// <returns></returns> public void SaveCharacterPrestigeRequirements(List <PrestigeRequirement> lstCharactePrestigeRequirement, int intCharacterID) { //Once a PrestigeRequirement is added it can be removed, added or updated, so reset the list PrestigeRequirement objDelPrestigeRequirement = new PrestigeRequirement(); objDelPrestigeRequirement.DeleteCharacterPrestigeRequirement(0, intCharacterID); foreach (PrestigeRequirement objCharPrestigeRequirement in lstCharactePrestigeRequirement) { objCharPrestigeRequirement.SaveCharacterPrestigeRequirement(objCharPrestigeRequirement.PrestigeRequirementID, intCharacterID); } }
/// <summary> /// Gets the prestige requirement 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 PrestigeRequirement objects</returns> private List <PrestigeRequirement> GetPrestigeRequirementList(string strSprocName, string strWhere, string strOrderBy) { List <PrestigeRequirement> PrestigeRequirements = new List <PrestigeRequirement>(); 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()) { PrestigeRequirement objPrestigeRequirement = new PrestigeRequirement(); SetReaderToObject(ref objPrestigeRequirement, ref result); PrestigeRequirements.Add(objPrestigeRequirement); } } catch { Exception e = new Exception(); throw e; } finally { command.Dispose(); connection.Close(); } return(PrestigeRequirements); }
/// <summary> /// Clones the specified object PrestigeRequirement. /// </summary> /// <param name="objPrestigeRequirement">The object PrestigeRequirement.</param> /// <returns>PrestigeRequirement</returns> static public PrestigeRequirement Clone(PrestigeRequirement objPrestigeRequirement) { PrestigeRequirement objCPrestigeRequirement = new PrestigeRequirement(objPrestigeRequirement.PrestigeRequirementID); return(objCPrestigeRequirement); }
/// <summary> /// Sets the reader to object. /// </summary> /// <param name="objClass">The object class.</param> /// <param name="result">The result.</param> private void SetReaderToObject(ref Class objClass, ref SqlDataReader result) { if (result.HasRows) { objClass.ClassID = (int)result.GetValue(result.GetOrdinal("ClassID")); objClass.IsPrestige = (bool)result.GetValue(result.GetOrdinal("IsPrestige")); objClass.ClassName = result.GetValue(result.GetOrdinal("ClassName")).ToString(); objClass.HitDieType = (int)result.GetValue(result.GetOrdinal("HitDieType")); objClass.StartingSkillNumber = (int)result.GetValue(result.GetOrdinal("StartingSkillNumber")); if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("StartingSkills")).ToString())) { objClass.StartingSkills = (int)result.GetValue(result.GetOrdinal("StartingSkills")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("StartCreditDie")).ToString())) { objClass.StartCreditDie = (int)result.GetValue(result.GetOrdinal("StartCreditDie")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("StartCreditDieNumber")).ToString())) { objClass.StartCreditDieNumber = (int)result.GetValue(result.GetOrdinal("StartCreditDieNumber")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("StartCreditDieModifier")).ToString())) { objClass.StartCreditDieModifier = (int)result.GetValue(result.GetOrdinal("StartCreditDieModifier")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("PrestigeRequiredTalents")).ToString())) { objClass.PrestigeRequiredTalents = (int)result.GetValue(result.GetOrdinal("PrestigeRequiredTalents")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("PrestigeRequiredForceTech")).ToString())) { objClass.PrestigeRequiredForceTech = (bool)result.GetValue(result.GetOrdinal("PrestigeRequiredForceTech")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("PrestigeRequiredDarkside")).ToString())) { objClass.PrestigeRequiredDarkside = (bool)result.GetValue(result.GetOrdinal("PrestigeRequiredDarkside")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("PrestigeRequiredFeats")).ToString())) { objClass.PrestigeRequiredFeats = (int)result.GetValue(result.GetOrdinal("PrestigeRequiredFeats")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("PrestigeRequiredBaseAttack")).ToString())) { objClass.PrestigeRequiredBaseAttack = (int)result.GetValue(result.GetOrdinal("PrestigeRequiredBaseAttack")); } if (!string.IsNullOrEmpty(result.GetValue(result.GetOrdinal("PrestigeRequiredLevel")).ToString())) { objClass.PrestigeRequiredLevel = (int)result.GetValue(result.GetOrdinal("PrestigeRequiredLevel")); } objClass._objComboBoxData.Clear(); objClass._objComboBoxData.Add(objClass.ClassID, objClass.ClassName); } if (objClass.IsPrestige) { Feat objFeat = new Feat();; ClassDefenseType objClassDefenseTypes = new ClassDefenseType(); PrestigeRequirement objPrestigeRequirement = new PrestigeRequirement(); TalentTree objTalentTree = new TalentTree(); Talent objTalent = new Talent(); ForcePower objForcePower = new ForcePower(); Skill objSkill = new Skill(); Race objRace = new Race(); objClass.StartingFeats = objFeat.GetStartingFeats(" ClassID=" + objClass.ClassID.ToString(), "FeatName"); objClass.objClassDefenseTypes = objClassDefenseTypes.GetClassDefenseTypes(" ClassID=" + objClass.ClassID.ToString(), ""); objClass.objPrestigeRequirement = objPrestigeRequirement.GetPrestigeRequirementPrestigeClass(" ClassID=" + objClass.ClassID.ToString(), "PrestigeRequirementDescription"); objClass.objPrestigeRequiredTalentTree = objTalentTree.GetTalentTreesPrestigeClass("ClassID=" + objClass.ClassID.ToString(), "TalentTreeName"); objClass.objPrestigeRequiredTalents = objTalent.GetPrestigeRequiredTalents("ClassID=" + objClass.ClassID.ToString(), "TalentName"); objClass.objPrestigeRequiredFeats = objFeat.GetPrestigeRequiredFeats(" ClassID=" + objClass.ClassID.ToString(), "FeatName"); objClass.objPrestigeRequiredFeatGroup = objFeat.GetPrestigeRequiredFeatGroups(" ClassID=" + objClass.ClassID.ToString(), "FeatName"); objClass.objPrestigeRequiredForcePowers = objForcePower.GetPrestigeRequiredForcePowers(" ClassID=" + objClass.ClassID.ToString(), "ForcePowerName"); objClass.objPrestigeRequiredSkills = objSkill.GetPrestigeRequiredSkills(" ClassID=" + objClass.ClassID.ToString(), "SkillName"); objClass.objPrestigeRequiredRaces = objRace.GetRaceRequirementForClass(" mtmPrestigeRequirementClassRace.ClassID=" + objClass.ClassID.ToString(), "RaceName"); } }