//private static int log_output(const void db, const char text)
        //{
        //    if (text)
        //    {
        //        //if (UPLogSettings.LogStatements())
        //        //{
        //        //    DDLogCSQL("%08lX: %s", (unsigned long)db, text);

        //        //    #ifdef DEBUG
        //        //        Console.WriteLine("%08lX: %s", (unsigned long)db, text);
        //        //    #endif

        //        //    return 1;
        //        //}

        //        return 0;
        //    }
        //    else
        //    {
        //        return UPLogSettings.LogStatements();
        //    }
        //}

        private static int InsertRecordLinks(UPCRMRecord record, UPRecordIdentificationMapper recordMapper, int requestNr, int recordnr, IDatabase database, int result)
        {
            var links = record.Links;

            if (result == 0 && links?.Count > 0)
            {
                var statement = new DatabaseStatement(database);
                if (statement.Prepare("INSERT INTO recordlinks (requestnr, recordnr, infoareaid, linkid, recordid) VALUES (?,?,?,?,?)"))
                {
                    foreach (var link in links)
                    {
                        statement.Reset();
                        statement.Bind(1, requestNr);
                        statement.Bind(2, recordnr);
                        var linkRecordIdentification = recordMapper.MappedRecordIdentification(link.RecordIdentification);
                        statement.Bind(3, link.InfoAreaId);
                        statement.Bind(4, link.LinkId);
                        statement.Bind(5, linkRecordIdentification.RecordId());
                        result = statement.Execute();
                        if (result != 0)
                        {
                            break;
                        }
                    }
                }
            }

            return(result);
        }
        public int SaveDocumentUpload(byte[] data, int requestNr, string fileName,
                                      string mimeType, string recordIdentification, int fieldId, IDatabase database)
        {
            DatabaseStatement            statement = new DatabaseStatement(database);
            UPRecordIdentificationMapper mapper    = ServerSession.CurrentSession.RecordIdentificationMapper;
            string origRecordIdentification        = recordIdentification;

            recordIdentification = mapper.MappedRecordIdentification(recordIdentification);
            if (recordIdentification == origRecordIdentification)
            {
                this.Logger.LogDebug(
                    $"UPSync-saveDocupload request={requestNr}, length={data.Length}, file={fileName}, recordId={recordIdentification}",
                    LogFlag.LogUpSync);
            }
            else
            {
                this.Logger.LogDebug(
                    $"UPSync-saveDocupload request={requestNr}, length={data.Length}, file={fileName}, recordId={recordIdentification}, original={origRecordIdentification}",
                    LogFlag.LogUpSync);
            }

            if (statement.Prepare("INSERT INTO documentuploads (requestnr, data, filename, mimetype, infoareaid, recordid, fieldid) VALUES (?,?,?,?,?,?,?)"))
            {
                string timepart         = DateTime.UtcNow.TimeIntervalSinceReferenceDate().ToString().Replace(":", string.Empty).Replace(".", string.Empty);
                string extendedFileName = $"{timepart}_{requestNr}_{fileName}";
                string localPath        = this.GetOfflineStoragePath(extendedFileName);
                string databaseValue    = $"file://{extendedFileName}";
                SimpleIoc.Default.GetInstance <IPlatformService>().StorageProvider.SaveFile(localPath, data);
                this.Logger.LogDebug($"Sync request {requestNr}: document {localPath} saved ({data.Length} bytes)", LogFlag.LogUpSync);
                statement.Bind(1, requestNr);
                statement.Bind(2, databaseValue);
                statement.Bind(3, fileName);
                statement.Bind(4, mimeType);
                statement.Bind(5, recordIdentification.InfoAreaId());
                statement.Bind(6, recordIdentification.RecordId());
                statement.Bind(7, fieldId);
                return(statement.Execute());
            }

            return(-1);
        }