public void UploadDocumentNotes(DocumentNoteRequest documentNoteRequest) { try { using (dbConn = ConnectionFactory.GetOpenDefaultConnection()) { string query = @"Insert into Travel_Uploads (TRAVELREQUESTID, FILENAME, UPLOADEDDATETIME,Notes ) values (:tarId, :fileName, :uploadedDateTime, :notes)"; OracleCommand command = new OracleCommand(query, (OracleConnection)dbConn); command.CommandText = query; command.Parameters.Add(new OracleParameter("tarId", OracleDbType.Int32, documentNoteRequest.TravelRequestId, ParameterDirection.Input)); command.Parameters.Add(new OracleParameter("fileName", OracleDbType.Varchar2, documentNoteRequest.NotesOption, ParameterDirection.Input)); command.Parameters.Add(new OracleParameter("uploadedDateTime", OracleDbType.Date, System.DateTime.Now, ParameterDirection.Input)); command.Parameters.Add(new OracleParameter("Notes", OracleDbType.Clob, documentNoteRequest.Notes, ParameterDirection.Input)); command.ExecuteNonQuery(); command.Dispose(); dbConn.Close(); dbConn.Dispose(); } } catch (Exception ex) { LogMessage.Log("DocumentRepository : UploadFileInfo" + ex.Message); throw new Exception("Couldn't save file name to database"); } }
public void UploadNotes(DocumentNoteRequest documentNoteRequest) { try { documentsRepository.UploadNotes(documentNoteRequest); } catch (Exception ex) { throw new Exception("Unable to upload the document" + ex.Message); } }
public void UploadDocumentNotes(DocumentNoteRequest documentNoteRequest) { try { documentsRepository.UploadDocumentNotes(documentNoteRequest); } catch (Exception ex) { LogMessage.Log("Unable to upload justifaction memos" + ex.Message); throw new Exception("Unable to upload justifaction memos" + ex.Message); } }