private IList <CharacterAttackOrSpellcast5e> GetAttacksAndSpellcasts(int characterId) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@CharacterId", characterId) }; using (CustomDataAdapter adapter = new CustomDataAdapter("GetCharacterAttacksAndSpellcasts5e", CommandType.StoredProcedure, parameters)) { DataTable table = new DataTable(); adapter.Fill(table); return(DataRowHelper.CreateListFromTable <CharacterAttackOrSpellcast5e>(table)); //foreach(DataRow row in table.Rows) //{ // attacksAndSpellcasts.Add(new CharacterAttackOrSpellcast5e // { // Name = row["Name"] as String, // AttackBonus = Convert.ToInt32(row["AttackBonus"]), // Damage = row["Damage"] as String, // DamageType = row["DamageType"] as String, // Notes = row["Notes"] as String, // }); //} } }
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 IList <CharacterSpell5e> GetSpells(int characterId) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@CharacterId", characterId) }; using (CustomDataAdapter adapter = new CustomDataAdapter("GetCharacterSpells5e", CommandType.StoredProcedure, parameters)) { DataTable table = new DataTable(); adapter.Fill(table); return(DataRowHelper.CreateListFromTable <CharacterSpell5e>(table)); } }
public ICharacter GetCharacterByKey(Guid key) { Character5e character = null; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Key", key) }; using (CustomDataAdapter adapter = new CustomDataAdapter("GetCharacter5eByKey", CommandType.StoredProcedure, parameters)) { DataTable table = new DataTable(); adapter.Fill(table); if (table.Rows.Count > 0) { character = CreateCharacterObject(table.Rows[0]); } } return(character); }