INSERT INTO evaluationhdr
(ID, AgentID, TeamID,
EvaluationCode, EvaluationName,
DateCreated, HowPaid, Amount,
DateReceived, CheckNumber, PaymentReceived
)
VALUES('#Client.EvalOrder.EvalHdrID#', '#Client.AgentID#', '#Client.TeamID#',
'#Client.EvalOrder.EvaluationCode#', '#Client.EvalOrder.EvaluationName#',
#CreateODBCDate(Now())#, 'P', #EvaluationCost#,
#CreateODBCDate(Now())#, 'PayPal', 1
)
SELECT ID, FirstName, LastName, ParticipantID
FROM teammembers
WHERE TeamID = '#Client.TeamID#'
INSERT INTO evaluations
(ID, AgentID, TeamID,
MemberID, EvaluationCode, DateCreated,
FirstName, LastName
)
VALUES ('#CreateUUID()#', '#Client.AgentID#', '#Client.TeamID#',
'#GetCurrTeam.ParticipantID#', '#Client.EvalOrder.EvaluationCode#', #CreateODBCDate(Now())#,
'#GetCurrTeam.FirstName#', '#GetCurrTeam.LastName#')
COMPANY: #Client.AgentCompanyName#
">
Order Date: #DateFormat(Now(), 'mm/dd/yyyy')#
">
The system has already credited it to their account.
">
The ICS-CONNECT ADMINISTRATION System
">
#Tmp#
PayPal Complete
PayPal is done.
#Tmp#
#Client.StatMsg#