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));
}
