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"); }