public IEnumerable <GAPWebAPIUserToken> GetbyGuid(Guid userGuid)
{
using (var context = new GapContext())
{
return(context.GAPWebAPIUserToken
.AsNoTracking().Where(x => x.WebAPIUser_Guid == userGuid).ToList());
}
}
public bool ExpiredTokenKey(Guid?tokenId)
{
using (var context = new GapContext())
{
var token = context.GAPWebAPIUserToken.AsNoTracking().Where(x => x.TokenId == tokenId).FirstOrDefault();
return(token.TokenExpireDateTime < DateTime.Now);
}
}
public GAPWebApiUser GetByNamePassword(string UserName, string Password)
{
using (var context = new GapContext())
{
return(context.GAPWebAPIUsers
.AsNoTracking()
.FirstOrDefault(x => x.UserName == UserName && x.Password == Password));
}
}
public async Task <IEnumerable <GAPWebApiUser> > GetAll()
{
using (var context = new GapContext())
{
return(await context.GAPWebAPIUsers
.AsNoTracking()
.ToListAsync());
}
}
public async Task <IEnumerable <GAPWebApiUser> > Query(Expression <Func <GAPWebApiUser, bool> > predicate)
{
using (var context = new GapContext())
{
return(await context.GAPWebAPIUsers
.AsNoTracking()
.Where(predicate)
.ToListAsync());
}
}
public Guid InsertOrUpdate(Guid userGuid)
{
var userToken = CreateTokenKey(userGuid);
using (var context = new GapContext())
{
context.Entry(userToken).State = userToken.EntityState.ToEntityFrameworkState();
context.SaveChanges();
return(userToken.TokenId);
}
}
public bool Delete(Guid webUserTokenGuid)
{
using (var context = new GapContext())
{
bool flagReturn = false;
var userToken = context.GAPWebAPIUserToken.Where(y => y.TokenId == webUserTokenGuid).FirstOrDefault();
if (userToken == null)
{
return(flagReturn);
}
context.GAPWebAPIUserToken.Remove(userToken);
context.SaveChanges();
flagReturn = true;
return(flagReturn);
}
}