Pcounter

Provide a minimum of three (3)  test accounts containing comprehensive and typical data, including the following:

• Valid log in credentials for campusM
• Active balance
• Transactions

The test accounts should allow testing the integration according to the Suggested Testing Guidelines i.e. should support authentication/ log into the app as the test account provided and run complete end-to-end testing of the integration functionality.

The list should include all the webpages the institution would like to allow the user to link out to. For example:

• Top-up credit
• View account
• Details on website

• Valid log in credentials for campusM
• Active balance
• Transactions

• Top-up credit
• View account
• Details on website

CREATE PROCEDURE getPrintBalance @username nvarchar(50)
AS
SELECT TOP 1 balance FROM (
SELECT TOP 1 p.DateTime AS dateTime, p.AccountBalance AS balance
FROM [XPREnterprise].[dbo].[tblPurchase] AS p
WHERE p.AccountName = @username
ORDER BY dateTime DESC
UNION ALL
SELECT TOP 1 f.DateTime AS dateTime, f.AccountBalance AS balance
FROM [XPREnterprise].[dbo].[tblFunding] AS f
WHERE f.AccountName = @username
ORDER BY dateTime DESC
UNION ALL
SELECT TOP 1 a.DateTime AS dateTime, a.AccountBalance AS balance
FROM [XPREnterprise].[dbo].[tblAdjustment] AS a
WHERE a.AccountName = @username
AND a.Type IN ('Charge', 'Set Balance')
ORDER BY dateTime DESC
) AS allBalance
ORDER BY dateTime DESC

CREATE PROCEDURE getPrintCreditLimit @username nvarchar(50)
AS
SELECT TOP 1 AccountCreditLimit
FROM [XPREnterprise].[dbo].[tblAdjustment]
WHERE AccountName = @username
AND Type = 'Set Credit Limit'
ORDER BY DateTime DESC

CREATE PROCEDURE getPrintTransactions @username nvarchar(50)
AS
SELECT TOP 5 * FROM (

SELECT TOP 5 p.DateTime AS dateTime, p.Type AS type, p.Quantity AS quantity, p.Multiplier AS multiplier, p.Amount AS amount,
p.DeviceCode AS deviceCode, p.DeviceName AS deviceName, p.DeviceDescription AS deviceDescription, p.AccountBalance AS balance,
NULL AS creditLimit, p.ItemGroupName AS itemGroupName, p.ItemName AS itemName, p.ItemPrice AS itemPrice,
p.ItemProperty1 AS itemProperty1, p.ItemProperty2 AS itemProperty2, p.ItemProperty3 AS itemProperty3,
p.ItemProperty4 AS itemProperty4, p.ItemProperty5 AS itemProperty5, p.ItemProperty6 AS itemProperty6
FROM [XPREnterprise].[dbo].[tblPurchase] AS p
WHERE p.AccountName = @username
ORDER BY dateTime DESC

UNION ALL
SELECT TOP 5 f.DateTime AS dateTime, f.Type AS type, NULL AS quantity, NULL AS multiplier, f.Amount AS amount,
f.DeviceCode AS deviceCode, f.DeviceName AS deviceName, f.DeviceDescription AS deviceDescription, f.AccountBalance AS balance,
NULL AS creditLimit, NULL AS itemGroupName, NULL AS itemName, NULL AS itemPrice,
NULL AS itemProperty1, NULL AS itemProperty2, NULL AS itemProperty3, NULL AS itemProperty4, NULL AS itemProperty5, NULL AS itemProperty6
FROM [XPREnterprise].[dbo].[tblFunding] AS f
WHERE f.AccountName = @username
ORDER BY dateTime DESC

UNION ALL
SELECT TOP 5 a.DateTime AS dateTime, a.Type AS type, NULL AS quantity, NULL AS multiplier,
CASE WHEN a.Type = 'Charge' THEN a.Amount ELSE NULL END AS amount,
a.DeviceCode AS deviceCode, a.DeviceName AS deviceName, a.DeviceDescription AS deviceDescription,
CASE WHEN a.Type = 'Set Balance' OR a.Type = 'Charge' THEN a.AccountBalance ELSE NULL END AS balance,
CASE WHEN a.Type = 'Set Credit Limit' THEN a.AccountCreditLimit ELSE NULL END AS creditLimit,
NULL AS itemGroupName, NULL AS itemName, NULL AS itemPrice,
NULL AS itemProperty1, NULL AS itemProperty2, NULL AS itemProperty3,
NULL AS itemProperty4, NULL AS itemProperty5, NULL AS itemProperty6
FROM [XPREnterprise].[dbo].[tblAdjustment] AS a
WHERE a.AccountName = @username
ORDER BY dateTime DESC

) AS allTransactions ORDER BY dateTime DESC