public void ServiceInstanceCreate(int officeID, int applicantCIN, out long serviceInstanceID)
{
var parameters = new OracleDynamicParameters();
parameters.Add("p_Office_Id", OracleDbType.Int32, officeID);
parameters.Add("p_Applicant_CIN", OracleDbType.Int32, applicantCIN);
parameters.Add("p_ServiceInstance_Id_Out", OracleDbType.Int32, null, System.Data.ParameterDirection.Output);
DbConnection.SPExecute("pkg_services.p_ServiceInstance_Create", parameters);
serviceInstanceID = parameters.GetLongNumber("p_ServiceInstance_Id_Out");
}
public void ApplicationDocumentCreate(long applicationID, int documentTypeID, long documentID, out long appDocumentID)
{
var parameters = new OracleDynamicParameters();
parameters.Add("p_Application_Id", OracleDbType.Int64, applicationID);
parameters.Add("p_Document_Type", OracleDbType.Int32, documentTypeID);
parameters.Add("p_Document_Id", OracleDbType.Int64, documentID);
parameters.Add("p_App_Document_Id_Out", OracleDbType.Int64, null, System.Data.ParameterDirection.Output);
DbConnection.SPExecute("pkg_services.p_App_Documents_Create", parameters);
appDocumentID = parameters.GetLongNumber("p_App_Document_Id_Out");
}
public void ServiceActionCreate(long operationID, long serviceInstanceID, long applicationID, int applicationStatus, int actionTypeID, out long serviceActionID)
{
var parameters = new OracleDynamicParameters();
parameters.Add("p_OperationID", OracleDbType.Int64, operationID);
parameters.Add("p_ServiceInstID", OracleDbType.Int64, serviceInstanceID);
parameters.Add("p_ApplicationID", OracleDbType.Int64, applicationID);
parameters.Add("p_ApplicationStatus", OracleDbType.Int32, applicationStatus);
parameters.Add("p_ActionTypeID", OracleDbType.Int32, actionTypeID);
parameters.Add("p_ServiceActionID_out", OracleDbType.Int64, null, System.Data.ParameterDirection.Output);
DbConnection.SPExecute("pkg_velin.p_Service_Action_Create", parameters);
serviceActionID = parameters.GetLongNumber("p_ServiceActionID_out");
}
public void DocumentDataCreate(string docIdentifier, string contentType, string filename, bool isTemporal, OracleBlob content, out long documentId)
{
var parameters = new OracleDynamicParameters();
parameters.Add("p_Guid", OracleDbType.Varchar2, docIdentifier);
parameters.Add("p_ContentType", OracleDbType.Varchar2, contentType);
parameters.Add("p_Filename", OracleDbType.Varchar2, filename);
parameters.Add("p_IsTemp", OracleDbType.Int32, isTemporal);
parameters.Add("p_Content", OracleDbType.Blob, content);
parameters.Add("p_DocumentId_out", OracleDbType.Int32, null, System.Data.ParameterDirection.Output);
DbConnection.SPExecute("pkg_velin.p_Document_Data_Create", parameters);
documentId = parameters.GetLongNumber("p_DocumentId_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");
}
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");
}