
/* DEPLOYED SWAGGER */
declare @username varchar(50) = 'test'
declare @password varchar(50) = '1234'
declare @refills varchar(250) = 'http://testapi.inform.jatesting.cfahome.com/api/refills' 
declare @comments varchar(250) = 'http://testapi.inform.jatesting.cfahome.com/api/comments'
declare @wageAccrual varchar(250) = 'http://testapi.inform.jatesting.cfahome.com/api/wageaccrual'
declare @unpaidInvoice varchar(250) = 'http://testapi.inform.jatesting.cfahome.com/api/unpaidinvoiceexpense'
declare @markMonthEnd varchar(250) = 'http://testapi.inform.jatesting.cfahome.com/api/mark-monthend'
declare @expenseTransfer varchar(250) = 'http://testapi.inform.jatesting.cfahome.com/api/expenseTransfer'
declare @rules varchar(250) = 'http://testapi.inform.jatesting.cfahome.com/api/rules'
declare @inventorySummary varchar(250) = 'http://testapi.inform.jatesting.cfahome.com/api/inventory-cost-summary'
declare @inventoryDetail varchar(250) = 'http://testapi.inform.jatesting.cfahome.com/api/inventory-cost-detail'
declare @supplierInvoice varchar(250) = 'http://testapi.inform.jatesting.cfahome.com/api/eom-supplier-invoice'
declare @utilityThreshold varchar(250) = 'http://testapi.inform.jatesting.cfahome.com/api/eom-utility-threshold'
declare @accrualReason varchar(250) = 'http://testapi.inform.jatesting.cfahome.com/api/no-payment-accrual-reason'

/* LOCAL SWAGGER 
declare @username varchar(50) = 'test'
declare @password varchar(50) = '1234'
declare @refills varchar(250) = 'http://localhost:9000/api/refills' 
declare @comments varchar(250) = 'http://localhost:9000/api/comments'
declare @wageAccrual varchar(250) = 'http://localhost:9000/api/wageaccrual'
declare @unpaidInvoice varchar(250) = 'http://localhost:9000/api/unpaidinvoiceexpense'
declare @markMonthEnd varchar(250) = 'http://localhost:9000/api/mark-monthend'
declare @expenseTransfer varchar(250) = 'http://localhost:9000/api/expenseTransfer'
declare @rules varchar(250) = 'http://localhost:9000/api/rules'
declare @inventorySummary varchar(250) = 'http://localhost:9000/api/inventory-cost-summary'
declare @inventoryDetail varchar(250) = 'http://localhost:9000/api/inventory-cost-detail'
declare @supplierInvoice varchar(250) = 'http://localhost:9000/api/eom-supplier-invoice'
declare @utilityThreshold varchar(250) = 'http://localhost:9000/api/eom-utility-threshold'
declare @accrualReason varchar(250) = 'http://localhost:9000/api/no-payment-accrual-reason'
*/

/* CFA DEV Endpoint 
declare @username varchar(50) = 'dev_wsc_inform'
declare @password varchar(50) = 'MDpm7nGMhcaZ2VD62exg'
declare @refills varchar(250) = 'https://dev.ext.services.cfahome.com/eom-api/v1/survey/refills' 
declare @comments varchar(250) = 'https://dev.ext.services.cfahome.com/eom-api/v1/survey/comments'
declare @wageAccrual varchar(250) = 'https://dev.ext.services.cfahome.com/eom-api/v1/survey/wage-accrual'
declare @unpaidInvoice varchar(250) = 'https://dev.ext.services.cfahome.com/eom-api/v1/survey/unpaid-expenses'
declare @markMonthEnd varchar(250) = 'https://dev.ext.services.cfahome.com/eom-api/v1/mark-month-end'
declare @expenseTransfer varchar(250) = 'https://dev.ext.services.cfahome.com/eom-api/v1/survey/expense-transfers'
declare @rules varchar(250) = 'https://dev.ext.services.cfahome.com/eom-api/v1/survey/rules'
declare @inventorySummary varchar(250) = 'https://dev.ext.services.cfahome.com/eom-api/v1/inventory-summary'
declare @inventoryDetail varchar(250) = 'https://dev.ext.services.cfahome.com/eom-api/v1/inventory-details'
declare @utilityThreshold varchar(250) = 'https://dev.ext.services.cfahome.com/eom-api/v1/utilities-above-thresholdd'
declare @supplierInvoice varchar(250) = 'https://dev.ext.services.cfahome.com/eom-api/v1/invoice-check'
declare @accrualReason varchar(250) = 'https://dev.ext.services.cfahome.com/eom-api/v1/survey/no-payment-accrual-reason'
*/

UPDATE tbExternalApi SET username = @username, password = @password,
	ApiUri = @refills
	WHERE Description like 'EndOfMonthRefill'

UPDATE tbExternalApi SET username = @username, password = @password,
	ApiUri = @comments
	WHERE Description like 'EndOfMonthComments'

UPDATE tbExternalApi SET username = @username, password = @password,
	ApiUri = @wageAccrual
	WHERE Description like 'EndOfMonthWageAccrual'

UPDATE tbExternalApi SET username = @username, password = @password,
	ApiUri = @unpaidInvoice
	WHERE Description like 'EndOfMonthExpenseUnpaid'

UPDATE tbExternalApi SET username = @username, password = @password,
	ApiUri = @markMonthEnd
	WHERE Description like 'EndOfMonthMarkMonthEnd'

UPDATE tbExternalApi SET username = @username, password = @password,
	ApiUri = @expenseTransfer
	WHERE Description like 'EndOfMonthExpenseTransfer'

UPDATE tbExternalApi SET username = @username, password = @password,
	ApiUri = @rules
	WHERE Description like 'EndOfMonthAccrualsAndReversals'

UPDATE tbExternalApi SET username = @username, password = @password,
	ApiUri = @inventorySummary
	WHERE Description like 'EndOfMonthInventoryCostSummary'

UPDATE tbExternalApi SET username = @username, password = @password,
	ApiUri = @inventoryDetail
	WHERE Description like 'EndOfMonthInventoryCostDetail'

UPDATE tbExternalApi SET username = @username, password = @password,
	ApiUri = @supplierInvoice
	WHERE Description like 'EndOfMonthSupplierInvoices'

UPDATE tbExternalApi SET username = @username, password = @password,
	ApiUri = @utilityThreshold
	WHERE Description like 'EndOfMonthUtilityThreshold'

UPDATE tbExternalApi SET username = @username, password = @password,
	ApiUri = @accrualReason
	WHERE Description like 'EndOfMonthNoPaymentAccrualReason'

