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