public Task <bool> CreatePlayerAsync(Gtaplayers objGTAPlayer) { _context.Gtaplayers.Add(objGTAPlayer); _context.SaveChanges(); return(Task.FromResult(true)); }
public Task <Gtaplayers> GetPlayerAsync(string strCurrentUser) { Gtaplayers colGTAPlayer = new Gtaplayers(); // Get player's DB entry colGTAPlayer = (from Gtaplayers in _context.Gtaplayers // only get entries for the current logged-in user where Gtaplayers.UserName == strCurrentUser select Gtaplayers).AsNoTracking().FirstOrDefault(); return(Task.FromResult(colGTAPlayer)); }
public Task <List <GtaplayerCharacters> > GetCharactersAsync(Gtaplayers player) { List <GtaplayerCharacters> colGTACharacters = new List <GtaplayerCharacters>(); // get GTA Player's Characters // only get character(s) for the current logged-in user colGTACharacters = (from gtacharacter in _context.GtaplayerCharacters .Include(GtaplayerGarage => GtaplayerGarage.GtaplayerGarages) where gtacharacter.PlayerId == player.Id select gtacharacter).AsNoTracking().ToList(); return(Task.FromResult(colGTACharacters)); }
public Task <List <GtaplayerGaragesDTO> > GetGaragesForPlayerAsync(Gtaplayers player) { List <GtaplayerGaragesDTO> colGTAGarages = new List <GtaplayerGaragesDTO>(); // get GTA Garages under a particular Player colGTAGarages = (from gtagarage in _context.GtaplayerGarages where gtagarage.Character.Player.Id == player.Id select new GtaplayerGaragesDTO { Id = gtagarage.Id.ToString(), CharacterId = gtagarage.CharacterId.ToString(), GarageId = (gtagarage.GarageId != null) ? gtagarage.GarageId.Value.ToString() : "", GarageName = gtagarage.GarageName }).AsNoTracking().ToList(); return(Task.FromResult(colGTAGarages)); }