public async Task <IActionResult> GetAllCharactersByUser([FromBody] RealmTypeModel model)
{
var user = await TokenHelper.GetUser(User, _userManager);
if (user == null)
{
return(RequestHandler.Unauthorized());
}
var context = _contextService.GetCharacterContext(model.RealmType);
var characters = await(
from character in context.Characters
where character.Account == user.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> GetOnlinePlayers([FromBody] RealmTypeModel model)
{
var context = _contextService.GetCharacterContext(model.RealmType);
var result = await context.Characters
.Where(x => x.IsOnline())
.Select(x =>
new PlayerModel
{
Name = x.Name,
Race = x.Race,
Class = x.Class,
Level = x.Level,
Zone = x.Zone,
Gender = x.Gender
}).ToListAsync();
return(Ok(result));
}
public async Task <IActionResult> GetUnstuckLocationsForRealm([FromBody] RealmTypeModel model)
{
var locations = await _websiteContext.UnstuckLocations.Where(x => x.RealmId == (int)model.RealmType).ToListAsync();
return(Ok(locations));
}
