private IList <CharacterAllyOrOrganization5e> GetAlliesAndOrganizations(int characterId) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@CharacterId", characterId) }; using (CustomDataAdapter adapter = new CustomDataAdapter("GetCharacterAlliesAndOrganizations5e", CommandType.StoredProcedure, parameters)) { DataTable table = new DataTable(); adapter.Fill(table); List <CharacterAllyOrOrganization5e> alliesAndOrganizations = new List <CharacterAllyOrOrganization5e>(); foreach (DataRow row in table.Rows) { CharacterAllyOrOrganization5e allyOrOrganization = DataRowHelper.CreateItemFromRow <CharacterAllyOrOrganization5e>(row); allyOrOrganization.ImageKey = row["ImageKey"].ToNullableGuid(); alliesAndOrganizations.Add(allyOrOrganization); } return(alliesAndOrganizations); } }
private Character5e CreateCharacterObject(DataRow row) { int characterId = Convert.ToInt32(row["Id"]); Character5e character = DataRowHelper.CreateItemFromRow <Character5e>(row); character.Key = (Guid)row["Key"]; character.SavingThrows = CreateSavingThrowsObject(row); character.Skills = DataRowHelper.CreateItemFromRow <CharacterSkills5e>(row); //CreateSkillsObject(row); character.TemporaryHitPoints = row["TemporaryHitPoints"].ToNullableInt(); character.AttacksAndSpellcasts = GetAttacksAndSpellcasts(characterId); character.Items = GetItems(characterId); character.Money = DataRowHelper.CreateItemFromRow <CharacterMoney5e>(row); //CreateMoneyObject(row); character.FeaturesAndTraits = GetFeaturesAndTraits(characterId); character.Proficiencies = GetProficiencies(characterId); character.AlliesAndOrganizations = GetAlliesAndOrganizations(characterId); character.SpellcastingAbility = row["SpellcastingAbility"].ToNullableInt(); character.SpellSaveDC = row["SpellSaveDC"].ToNullableInt(); character.SpellAttackBonus = row["SpellAttackBonus"].ToNullableInt(); character.Spells = GetSpells(characterId); character.SpellSlots = DataRowHelper.CreateItemFromRow <CharacterSpellSlots5e>(row); //CreateSpellSlotsObject(row); character.AppearanceKey = (Guid)row["AppearanceKey"]; return(character); //return new Character5e //{ // Key = (Guid)row["Key"], // Name = row["Name"] as String, // Class = row["Class"] as String, // Level = Convert.ToInt32(row["Name"]), // Background = row["Background"] as String, // PlayerName = row["PlayerName"] as String, // Race = row["Race"] as String, // Alignment = row["Alignment"] as String, // Experience = Convert.ToInt32(row["Experience"]), // Strength = Convert.ToInt32(row["Strength"]), // Dexterity = Convert.ToInt32(row["Dexterity"]), // Constitution = Convert.ToInt32(row["Constitution"]), // Intelligence = Convert.ToInt32(row["Intelligence"]), // Wisdom = Convert.ToInt32(row["Wisdom"]), // Charisma = Convert.ToInt32(row["Charisma"]), // Inspiration = Convert.ToInt32(row["Inspiration"]), // ProficiencyBonus = Convert.ToInt32(row["ProficiencyBonus"]), // SavingThrows = CreateSavingThrowsObject(row), // Skills = CreateSkillsObject(row), // ArmorClass = Convert.ToInt32(row["ArmorClass"]), // Initiative = Convert.ToInt32(row["Initiative"]), // Speed = Convert.ToInt32(row["Speed"]), // HitPointMaximum = Convert.ToInt32(row["HitPointMaximum"]), // CurrentHitPoints = Convert.ToInt32(row["CurrentHitPoints"]), // TemporaryHitPoints = row["TemporaryHitPoints"].ToNullableInt(), // TotalHitDice = row["TotalHitDice"] as String, // HitDice = row["HitDice"] as String, // SuccessDeathSaves = Convert.ToInt32(row["SuccessDeathSaves"]), // FailedDeathSaves = Convert.ToInt32(row["FailedDeathSaves"]), // AttacksAndSpellcasts = GetAttacksAndSpellcasts(characterId), // //Items = row["Items"] as String, // Money = CreateMoneyObject(row), // PersonalityTraits = row["PersonalityTraits"] as String, // Ideals = row["Ideals"] as String, // Bonds = row["Bonds"] as String, // Flaws = row["Flaws"] as String, // //FeaturesAndTraits = row["FeaturesAndTraits"] as String, // PassiveWisdom = Convert.ToInt32(row["PassiveWisdom"]), // //Proficiencies = row["Proficiencies"] as String, // //AlliesAndOrganizations = row["AlliesAndOrganizations"] as String, // Age = Convert.ToInt32(row["Age"]), // Height = row["Height"] as String, // Weight = row["Weight"] as String, // Eyes = row["Eyes"] as String, // Skin = row["Skin"] as String, // Hair = row["Hair"] as String, // SpellcastingClass = row["SpellcastingClass"] as String, // SpellcastingAbility = row["SpellcastingAbility"].ToNullableInt(), // SpellSaveDC = row["SpellSaveDC"].ToNullableInt(), // SpellAttackBonus = row["SpellAttackBonus"].ToNullableInt(), // //Spells = row["Spells"] as String, // SpellSlots = CreateSpellSlotsObject(row), // AppearanceKey = (Guid)row["AppearanceKey"], // Backstory = row["Backstory"] as String //}; }