/// <summary> /// Stored Procedure Call to begin Api Session, passing the pkSystemUser obtained from ValidatePassword method /// </summary> /// <param name="context"></param> /// <param name="pkSystemUser"></param> /// <returns>ApiSession</returns> public static ApiSession Execute(ApiContext context, long?pkSystemUser) { try { var sp = new BeginApiSession(pkSystemUser); var reader = context.GetReader(sp); if (reader.Read()) { var user = new ApiSession(); user.PKSystemUser = reader.GetInt64(0); user.UserId = reader.GetString(1); user.UserName = reader.GetString(2); user.UserCode = reader.GetString(3); user.AccessGranted = reader.GetDateTime(4); user.AccessToken = reader.GetGuid(5); user.RefreshToken = reader.GetGuid(6); user.TokenExpiry = reader.GetDateTime(7); return(user); } } catch (Exception e) { return(null); } return(null); }
/// <summary> /// Get a new ApiSession by calling the stored procedure, with defined parameters /// </summary> /// <param name="context"></param> /// <param name="pkSystemUser"></param> /// <param name="accessToken"></param> /// <param name="refreshToken"></param> /// <returns></returns> public static ApiSession Execute(ApiContext context, long?pkSystemUser, string accessToken, string refreshToken) { try { var sp = new RefreshApiSession(pkSystemUser, accessToken, refreshToken); var reader = context.GetReader(sp); if (reader.Read()) { var user = new ApiSession(); user.PKSystemUser = reader.GetInt64(0); user.UserId = reader.GetString(1); user.UserName = reader.GetString(2); user.AccessGranted = reader.GetDateTime(3); user.AccessToken = reader.GetGuid(4); user.RefreshToken = reader.GetGuid(5); user.TokenExpiry = reader.GetDateTime(6); return(user); } } catch { throw; } return(null); }
/// <summary> /// Update ApiSession by calling the Stored Procedure with PKSystemUser in session /// This is called after a user successfully log in and begin ApiSession /// </summary> /// <param name="context"></param> /// <param name="session"></param> public static void Execute(ApiContext context, ApiSession session) { try { var sp = new GetTenant(session.PKSystemUser); var reader = context.GetReader(sp); while (reader.Read()) { var tu = new TenantUserInfo(); tu.PKTenant = reader.GetInt64(0); tu.TenantCode = reader.GetNullableString(1); tu.TenantName = reader.GetNullableString(2); tu.PKTenantUser = reader.GetInt64(3); tu.PKParty = reader.GetNullableInt64(4); tu.PartyCode = reader.GetNullableString(5); tu.PartyName = reader.GetNullableString(6); session.Tenants.Add(tu); } } catch { throw; } }