/// <summary>
/// US:836 create a session record in the database
/// </summary>
/// <param name="strFXSessionID"></param>
/// <returns></returns>
public CStatus CreateFXSession(out string strFXSessionID)
{
strFXSessionID = String.Empty;
//create a status object and check for valid dbconnection
CStatus status = DBConnValid();
if (!status.Status)
{
return(status);
}
//load the paramaters list
CParameterList pList = new CParameterList(SessionID,
ClientIP,
UserID);
//add the rest of the parameters
pList.AddOutputParameter("po_vFXSessionID", strFXSessionID);
//execute the SP
status = DBConn.ExecuteOracleSP("PCK_USR.CreateFXSession", pList);
if (status.Status)
{
//get the TS_ID returned from the SP call
strFXSessionID = pList.GetParamStringValue("po_vFXSessionID");
}
return(status);
}