Beispiel #1
0
        /// <summary>
        /// Creates a new media object.
        /// </summary>
        /// <param name="media">The memory stream containing the media.</param>
        /// <param name="type">The media type.</param>
        /// <param name="rpu">A delegate of type <see cref="StatusMessageReportProgress"/> used to send messages back to the calling object.</param>
        /// <param name="caller">The calling object.</param>
        /// <returns>The id for the new media object.</returns>
        /// <remarks>Documented by Dev03, 2008-08-05</remarks>
        /// <remarks>Documented by Dev03, 2009-01-13</remarks>
        public int CreateMedia(Stream media, EMedia type, StatusMessageReportProgress rpu, object caller)
        {
            using (NpgsqlConnection conn = PostgreSQLConn.CreateConnection(Parent.CurrentUser))
            {
                NpgsqlTransaction tran = conn.BeginTransaction();

                LargeObjectManager lbm  = new LargeObjectManager(conn);
                int         noid        = lbm.Create(LargeObjectManager.READWRITE);
                LargeObject largeObject = lbm.Open(noid, LargeObjectManager.READWRITE);
                byte[]      buffer      = new byte[media.Length];
                media.Read(buffer, 0, (int)media.Length);
                BufferToLargeObject(buffer, largeObject, rpu, caller);
                largeObject.Close();

                int newId = 0;
                using (NpgsqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "INSERT INTO \"MediaContent\" (data, media_type) VALUES (:data, :type) RETURNING id;";
                    cmd.Parameters.Add("data", noid);
                    cmd.Parameters.Add("type", type.ToString());
                    newId = Convert.ToInt32(PostgreSQLConn.ExecuteScalar(cmd, Parent.CurrentUser));
                }
                tran.Commit();

                return(newId);
            }
        }
Beispiel #2
0
        /// <summary>
        /// Writes the content of a buffer into a LargeObject.
        /// </summary>
        /// <param name="buffer">The buffer.</param>
        /// <param name="largeObject">The large object.</param>
        /// <param name="rpu">The rpu.</param>
        /// <param name="caller">The calling object.</param>
        /// <remarks>Documented by Dev02, 2008-08-08</remarks>
        private void BufferToLargeObject(byte[] buffer, LargeObject largeObject, StatusMessageReportProgress rpu, object caller)
        {
            largeObject.Seek(0);

            int offset = 0;
            int size   = buffer.Length;
            StatusMessageEventArgs args = new StatusMessageEventArgs(StatusMessageType.CreateMediaProgress, buffer.Length);

            while (offset < size)
            {
                largeObject.Write(buffer, offset, Math.Min(chunkSize, size - offset));
                offset       += chunkSize;
                args.Progress = offset;
                if (rpu != null)
                {
                    rpu(args, caller);
                }
            }
        }
        /// <summary>
        /// Writes the content of a buffer into a LargeObject.
        /// </summary>
        /// <param name="buffer">The buffer.</param>
        /// <param name="largeObject">The large object.</param>
        /// <param name="rpu">The rpu.</param>
        /// <param name="caller">The calling object.</param>
        /// <remarks>Documented by Dev02, 2008-08-08</remarks>
        private void BufferToLargeObject(byte[] buffer, LargeObject largeObject, StatusMessageReportProgress rpu, object caller)
        {
            largeObject.Seek(0);

            int offset = 0;
            int size = buffer.Length;
            StatusMessageEventArgs args = new StatusMessageEventArgs(StatusMessageType.CreateMediaProgress, buffer.Length);
            while (offset < size)
            {
                largeObject.Write(buffer, offset, Math.Min(chunkSize, size - offset));
                offset += chunkSize;
                args.Progress = offset;
                if (rpu != null)
                    rpu(args, caller);
            }
        }
        /// <summary>
        /// Creates a new media object.
        /// </summary>
        /// <param name="media">The memory stream containing the media.</param>
        /// <param name="type">The media type.</param>
        /// <param name="rpu">A delegate of type <see cref="StatusMessageReportProgress"/> used to send messages back to the calling object.</param>
        /// <param name="caller">The calling object.</param>
        /// <returns>The id for the new media object.</returns>
        /// <remarks>Documented by Dev03, 2008-08-05</remarks>
        /// <remarks>Documented by Dev03, 2009-01-13</remarks>
        public int CreateMedia(Stream media, EMedia type, StatusMessageReportProgress rpu, object caller)
        {
            using (NpgsqlConnection conn = PostgreSQLConn.CreateConnection(Parent.CurrentUser))
            {
                NpgsqlTransaction tran = conn.BeginTransaction();

                LargeObjectManager lbm = new LargeObjectManager(conn);
                int noid = lbm.Create(LargeObjectManager.READWRITE);
                LargeObject largeObject = lbm.Open(noid, LargeObjectManager.READWRITE);
                byte[] buffer = new byte[media.Length];
                media.Read(buffer, 0, (int)media.Length);
                BufferToLargeObject(buffer, largeObject, rpu, caller);
                largeObject.Close();

                int newId = 0;
                using (NpgsqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "INSERT INTO \"MediaContent\" (data, media_type) VALUES (:data, :type) RETURNING id;";
                    cmd.Parameters.Add("data", noid);
                    cmd.Parameters.Add("type", type.ToString());
                    newId = Convert.ToInt32(PostgreSQLConn.ExecuteScalar(cmd, Parent.CurrentUser));
                }
                tran.Commit();

                return newId;
            }
        }
Beispiel #5
0
        /// <summary>
        /// Creates a new media object.
        /// </summary>
        /// <param name="caller">The calling object.</param>
        /// <param name="rpu">A delegate of the type StatusMessageReportProgress.</param>
        /// <param name="type">The type.</param>
        /// <param name="path">The path.</param>
        /// <param name="isActive">if set to <c>true</c> [is active].</param>
        /// <param name="isDefault">if set to <c>true</c> [is default].</param>
        /// <param name="isExample">if set to <c>true</c> [is example].</param>
        /// <returns></returns>
        /// <remarks>Documented by Dev02, 2008-08-11</remarks>
        internal IMedia CreateNewMediaObject(object caller, StatusMessageReportProgress rpu, EMedia type, string path, bool isActive, bool isDefault, bool isExample)
        {
            IMedia media = null;
            Uri    uri;

            if (!this.HasPermission(PermissionTypes.CanModifyMedia))
            {
                throw new PermissionException();
            }

            if (path == null)
            {
                throw new ArgumentNullException("Null value not allowed for media file path!");
            }

            try
            {
                if (File.Exists(Path.Combine(Environment.CurrentDirectory, path)))                 //to allow relative paths
                {
                    path = Path.Combine(Environment.CurrentDirectory, path);
                }

                uri = new Uri(path);
            }
            catch (UriFormatException exception)
            {
                throw new FileNotFoundException("Uri format is invalid.", exception);
            }

            if (uri.Scheme == Uri.UriSchemeFile && uri.IsFile)             //we got a new file
            {
                if (File.Exists(path))
                {
                    int newid;
                    using (FileStream stream = File.Open(path, FileMode.Open, FileAccess.Read, FileShare.Read))
                        newid = mediaconnector.CreateMedia(stream, type, rpu, caller);

                    media = DbMedia.CreateDisconnectedCardMedia(newid, type, isDefault, isExample, parent);

                    Helper.UpdateMediaProperties(path, newid, mediaconnector);
                }
                else
                {
                    throw new FileNotFoundException("Media file could not be found.", path);
                }
            }
            else if (uri.Scheme == "http" && uri.IsLoopback)             //we got a http reference => file is already in db
            {
                if (DbMediaServer.DbMediaServer.Instance(parent).IsYours(uri))
                {
                    int mediaId = DbMediaServer.DbMediaServer.GetMediaID(uri.AbsolutePath);
                    media = DbMedia.CreateDisconnectedCardMedia(mediaId, type, isDefault, isExample, parent);
                    rpu(new StatusMessageEventArgs(StatusMessageType.CreateMediaProgress, 100, 100), caller);
                }
                else
                {
                    DbMediaServer.DbMediaServer server = DbMediaServer.DbMediaServer.Instance(uri);

                    int newid = mediaconnector.CreateMedia(GetMediaConnector(server.Parent).GetMediaStream(DbMediaServer.DbMediaServer.GetMediaID(uri.AbsolutePath)), type, rpu, caller);

                    media = DbMedia.CreateDisconnectedCardMedia(newid, type, isDefault, isExample, parent);

                    Helper.UpdateMediaProperties(path, newid, mediaconnector);
                }
            }

            return(media);
        }
Beispiel #6
0
        /// <summary>
        /// Creates a new media object.
        /// </summary>
        /// <param name="type">The type.</param>
        /// <param name="path">The path.</param>
        /// <param name="isActive">if set to <c>true</c> [is active].</param>
        /// <param name="isDefault">if set to <c>true</c> [is default].</param>
        /// <param name="isExample">if set to <c>true</c> [is example].</param>
        /// <returns></returns>
        /// <remarks>Documented by Dev02, 2008-08-11</remarks>
        /// <remarks>Documented by Dev03, 2009-01-13</remarks>
        public IMedia CreateMedia(EMedia type, string path, bool isActive, bool isDefault, bool isExample)
        {
            StatusMessageReportProgress rpu = new StatusMessageReportProgress(ReportProgressUpdate);

            return(CreateNewMediaObject(this, rpu, type, path, isActive, isDefault, isExample));
        }
Beispiel #7
0
 /// <summary>
 /// Creates the media.
 /// </summary>
 /// <param name="type">The type of the media file.</param>
 /// <param name="path">The path to the media file.</param>
 /// <param name="isActive">if set to <c>true</c> [is active].</param>
 /// <param name="isDefault">if set to <c>true</c> [is default].</param>
 /// <param name="isExample">if set to <c>true</c> [is example].</param>
 /// <returns></returns>
 /// <remarks>Documented by Dev03, 2007-09-03</remarks>
 /// <remarks>Documented by Dev03, 2009-01-13</remarks>
 public IMedia CreateMedia(EMedia type, string path, bool isActive, bool isDefault, bool isExample)
 {
     StatusMessageReportProgress rpu = new StatusMessageReportProgress(ReportProgressUpdate);
     return (parent.GetParentDictionary() as DbDictionary).CreateNewMediaObject(this, rpu, type, path, isActive, isDefault, isExample);
 }
Beispiel #8
0
        /// <summary>
        /// Creates a new media object.
        /// </summary>
        /// <param name="caller">The calling object.</param>
        /// <param name="rpu">A delegate of the type StatusMessageReportProgress.</param>
        /// <param name="type">The type.</param>
        /// <param name="path">The path.</param>
        /// <param name="isActive">if set to <c>true</c> [is active].</param>
        /// <param name="isDefault">if set to <c>true</c> [is default].</param>
        /// <param name="isExample">if set to <c>true</c> [is example].</param>
        /// <returns></returns>
        /// <remarks>Documented by Dev02, 2008-08-11</remarks>
        internal IMedia CreateNewMediaObject(object caller, StatusMessageReportProgress rpu, EMedia type, string path, bool isActive, bool isDefault, bool isExample)
        {
            IMedia media = null;
            Uri uri;

            if (!this.HasPermission(PermissionTypes.CanModifyMedia))
                throw new PermissionException();

            if (path == null)
                throw new ArgumentNullException("Null value not allowed for media file path!");

            try
            {
                if (File.Exists(Path.Combine(Environment.CurrentDirectory, path))) //to allow relative paths
                    path = Path.Combine(Environment.CurrentDirectory, path);

                uri = new Uri(path);
            }
            catch (UriFormatException exception)
            {
                throw new FileNotFoundException("Uri format is invalid.", exception);
            }

            if (uri.Scheme == Uri.UriSchemeFile && uri.IsFile) //we got a new file
            {
                if (File.Exists(path))
                {
                    int newid;
                    using (FileStream stream = File.Open(path, FileMode.Open, FileAccess.Read, FileShare.Read))
                        newid = mediaconnector.CreateMedia(stream, type, rpu, caller);

                    media = DbMedia.CreateDisconnectedCardMedia(newid, type, isDefault, isExample, parent);

                    Helper.UpdateMediaProperties(path, newid, mediaconnector);
                }
                else
                    throw new FileNotFoundException("Media file could not be found.", path);
            }
            else if (uri.Scheme == "http" && uri.IsLoopback) //we got a http reference => file is already in db
            {
                if (DbMediaServer.DbMediaServer.Instance(parent).IsYours(uri))
                {
                    int mediaId = DbMediaServer.DbMediaServer.GetMediaID(uri.AbsolutePath);
                    media = DbMedia.CreateDisconnectedCardMedia(mediaId, type, isDefault, isExample, parent);
                    rpu(new StatusMessageEventArgs(StatusMessageType.CreateMediaProgress, 100, 100), caller);
                }
                else
                {
                    DbMediaServer.DbMediaServer server = DbMediaServer.DbMediaServer.Instance(uri);

                    int newid = mediaconnector.CreateMedia(GetMediaConnector(server.Parent).GetMediaStream(DbMediaServer.DbMediaServer.GetMediaID(uri.AbsolutePath)), type, rpu, caller);

                    media = DbMedia.CreateDisconnectedCardMedia(newid, type, isDefault, isExample, parent);

                    Helper.UpdateMediaProperties(path, newid, mediaconnector);
                }
            }

            return media;
        }