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 <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,
// });
//}
}
}
public bool DeleteCharacter(Guid key)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@Key", key)
};
using (CustomDataAdapter adapter = new CustomDataAdapter("DeleteCharacter5eByKey", CommandType.StoredProcedure, parameters))
{
adapter.ExecuteNonQuery();
}
return(true);
}
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);
}
