public async Task <IActionResult> GetAllCharactersByAccountId([FromBody] SelectAccountModel model)
{
var context = _contextService.GetCharacterContext(model.RealmType);
var characters = await(
from character in context.Characters
where character.Account == model.AccountId
join guildMembers in context.GuildMembers on character.Id equals guildMembers.CharacterId into joinTable1
from guildMembers in joinTable1.DefaultIfEmpty()
join guild in context.Guilds on guildMembers.GuildId equals guild.Id into joinTable2
from guild in joinTable2.DefaultIfEmpty()
select new Character(character)
{
Guild = guild,
CharacterBanned = character.CharacterBanned
}
).ToListAsync();
return(Ok(characters));
}
public async Task <IActionResult> GetAccountData([FromBody] SelectAccountModel model)
{
var account = await _authContext.Account.FirstOrDefaultAsync(x => x.Id == model.AccountId);
return(Ok(account));
}
