public void ApplicationCreate(long?mainApplicationID, long serviceInstanceID, bool isReport,
int status, DateTime statusTime, int applicationTypeID, DateTime registrationTime,
out long applicationID, out string applIdentifier, out string reportIdentifier)
{
var parameters = new OracleDynamicParameters();
parameters.Add("p_ServiceInstance_Id", OracleDbType.Int64, serviceInstanceID);
parameters.Add("p_MainApplication_Id", OracleDbType.Int64, mainApplicationID);
parameters.Add("p_Is_Report", OracleDbType.Int32, isReport);
parameters.Add("p_Status", OracleDbType.Int16, status);
parameters.Add("p_StatusTime", OracleDbType.TimeStamp, statusTime);
parameters.Add("p_ApplicationType_Id", OracleDbType.Int16, applicationTypeID);
parameters.Add("p_RegistrationTime", OracleDbType.TimeStamp, registrationTime);
parameters.Add("p_Application_Id_Out", OracleDbType.Int64, null, System.Data.ParameterDirection.Output);
parameters.Add("p_Application_Identifier_Out", OracleDbType.Varchar2, null, System.Data.ParameterDirection.Output, 100);
parameters.Add("p_Report_Identifier_Out", OracleDbType.Varchar2, null, System.Data.ParameterDirection.Output, 100);
DbConnection.SPExecute("pkg_services.p_Applications_Create", parameters);
applicationID = parameters.GetLongNumber("p_Application_Id_Out");
applIdentifier = parameters.GetString("p_Application_Identifier_Out");
reportIdentifier = parameters.GetString("p_Report_Identifier_Out");
}
public void ServiceOperationCreate(string operationID, int serviceOperationTypeID,
out long serviceOperationID, out bool isCompleted, out string result)
{
var parameters = new OracleDynamicParameters();
parameters.Add("p_OperationID", OracleDbType.Varchar2, operationID);
parameters.Add("p_OperationTypeID", OracleDbType.Int32, serviceOperationTypeID);
parameters.Add("p_ServiceOperationID_out", OracleDbType.Int32, null, System.Data.ParameterDirection.Output);
parameters.Add("p_IsCompleted_out", OracleDbType.Int32, null, System.Data.ParameterDirection.Output);
parameters.Add("p_Result_out", OracleDbType.Varchar2, null, System.Data.ParameterDirection.Output, 2000);
DbConnection.SPExecute("pkg_velin.p_Service_Operation_Create", parameters);
serviceOperationID = parameters.GetLongNumber("p_ServiceOperationID_out");
isCompleted = parameters.GetBoolean("p_IsCompleted_out");
result = parameters.GetString("p_Result_out");
}
