public void RemoveHistoricalOcrData(NpgsqlConnection connection, HistoricalOcrData historicData) { try { _log.WriteLog(LogLevel.Info, $"Remove historicalData with path <'{historicData.FullFilePath}'> from (Postgres) database \n"); using (var command = GetCommand(connection, $"DELETE FROM historical_ocr_data WHERE fullfilepath = '{historicData.FullFilePath}'")) { command.ExecuteNonQuery(); } } catch (Exception ex) { _log.WriteLog(LogLevel.Error, "Error while removing historic data. Error details: \n" + ex.Message + "\n"); } }
public void InsertOcrData(NpgsqlConnection connection, HistoricalOcrData histoticData, VanguardDoc docs) { try { _log.WriteLog(LogLevel.Info, $"Insert ocrData with path <'{histoticData.FullFilePath}'> into (Postgres) database \n"); using (var command = GetCommand(connection, "INSERT INTO \"public\".\"ocr_data\" (\"DocId\", \"TenantId\", \"ErrorMessage\", \"StatusId\"," + $" \"Data\", \"createdAt\", \"updatedAt\") VALUES({docs.DocId}, {histoticData.TenantId}, '{null}', {histoticData.StatusId}, '{histoticData.Data}'," + $" '{histoticData.CreatedAt}', '{histoticData.UpdatedAt}') " + "ON CONFLICT ON CONSTRAINT ocr_data_pkey " + $"DO UPDATE SET \"ErrorMessage\" = '{null}', \"StatusId\" = {histoticData.StatusId}," + $"\"createdAt\" = '{histoticData.CreatedAt}', \"updatedAt\" = '{histoticData.UpdatedAt}'")) { command.ExecuteNonQuery(); } } catch (Exception ex) { _log.WriteLog(LogLevel.Error, "Error while inserting ocr data. Error details: \n" + ex.Message + "\n"); } }