public async Task <IEnumerable <Character> > GetAllAsync() => await Characters.AsQueryable().ToListAsync();
public async Task <Character> GetCharacterAsync(Guid id) => await Characters.AsQueryable().FirstOrDefaultAsync(x => x.UserId == id);
private void OnCharCreate(WorldSession session, PCCharCreate packet) { byte[] playerBytes = { packet.Skin, packet.Face, packet.HairStyle, packet.HairColor }; byte[] playerBytes2 = { packet.Accessory }; playercreateinfo info = CreateInfo.SingleOrDefault(ci => ci.race == packet.Race && ci.@class == packet.Class); var charGuid = Characters.AsQueryable().Any() ? Characters.AsQueryable().Max(c => c.guid) + 1 : 1; character character = new character() { guid = charGuid, account = session.Account.id, name = Utils.NormalizeText(packet.Name), race = packet.Race, @class = packet.Class, gender = packet.Gender, level = 1, xp = 0, money = 100000, playerBytes = BitConverter.ToInt32(playerBytes, 0), playerBytes2 = 0, playerFlags = 0, position_x = info.position_x, position_y = info.position_y, position_z = info.position_z, map = info.map, orientation = info.orientation, taximask = "", online = 0, cinematic = 0, totaltime = 0, leveltime = 0, logout_time = 0, is_logout_resting = 0, rest_bonus = 0, resettalents_cost = 0, resettalents_time = 0, trans_x = 0, trans_y = 0, trans_z = 0, trans_o = 0, transguid = 0, extra_flags = 0, at_login = 0, zone = info.zone, death_expire_time = 0, taxi_path = "", honor_highest_rank = 0, honor_standing = 0, stored_honor_rating = 0, stored_dishonorable_kills = 0, stored_honorable_kills = 0, watchedFaction = 0, drunk = 0, health = 100, power1 = 0, power2 = 0, power3 = 0, power4 = 0, power5 = 0, exploredZones = "", equipmentCache = GetStartingEquipment(packet.Race, packet.Class, packet.Gender), ammoId = 0, actionBars = 0, deleteInfos_Account = session.Account.id, deleteInfos_Name = Utils.NormalizeText(packet.Name), deleteDate = 0 }; Characters.Add(character); Core.CharacterDatabase.SaveChanges(); session.SendPacket(new PSCharCreate(LoginErrorCode.CHAR_CREATE_SUCCESS)); }