public async Task <OdissUser> FindByNameAsync(string userName) { using (var db = new MainDatabase().Get) { return(await db.QueryFirstOrDefaultAsync <OdissUser>("SELECT * FROM [dbo].[Users] WHERE UserName = @userName", new { userName })); } }
public async Task <OdissUser> FindByIdAsync(Guid userId) { using (var db = new MainDatabase().Get) { return(await db.QueryFirstOrDefaultAsync <OdissUser>("SELECT * FROM [dbo].[Users] WHERE ID = @userId", new { userId })); } }
public async Task <OdissUser> FindByEmailAsync(string email) { using (var db = new MainDatabase().Get) { return(await db.QueryFirstOrDefaultAsync <OdissUser>("SELECT * FROM [dbo].[Users] WHERE Email = @email", new { email })); } }
public async Task <UserSession <Guid, Guid> > GetByUserIdAsync(Guid userId) { using (var db = new MainDatabase().Get) { return(await db.QueryFirstOrDefaultAsync <UserSession <Guid, Guid> >(@" SELECT TOP 1 ID AS SessionId, IDUser AS UserId, Expire AS ExpiryDate, Data, Created AS CreatedAt, LastAction AS LastActionAt FROM [dbo].[Sessions] WHERE IDUser = @userId ORDER BY LastAction DESC", new { userId })); } }
public async Task <bool> RemoveByUserIdAsync(Guid userId) { using (var db = new MainDatabase().Get) { var deletedId = await db.QueryFirstOrDefaultAsync <Guid>(@" DELETE FROM [dbo].[Sessions] OUTPUT DELETED.IDUser WHERE IDUser = @userId", new { userId }); return(deletedId == userId); } }
public async Task <bool> UpdateAsync(UserSession <Guid, Guid> session) { using (var db = new MainDatabase().Get) { var updatedId = await db.QueryFirstOrDefaultAsync <Guid>(@" UPDATE [dbo].[Sessions] SET Expire = @ExpiryDate, Data = @Data, LastAction = @LastActionAt OUTPUT INSERTED.ID WHERE ID = @SessionId", session); return(updatedId == session.SessionId); } }