public bool DeleteMediaAssetLocation(MediaAssetLocation mediaAssetLocation)
        {
            try
            {
                MediaAssetLocationTable.DeleteOnSubmit(mediaAssetLocation);
                MediaAssetLocationTable.Context.SubmitChanges();

                return true;
            }
            catch (Exception)
            {
                return false;
            }
        }
        public bool SaveMediaAssetLocation(MediaAssetLocation mediaAssetLocation)
        {
            try
            {
                if (mediaAssetLocation.MediaAssetLocationId == 0)
                {
                    MediaAssetLocationTable.InsertOnSubmit(mediaAssetLocation);
                }
                else
                {
                    MediaAssetLocationTable.Context.Refresh(RefreshMode.KeepCurrentValues, mediaAssetLocation);
                }

                MediaAssetLocationTable.Context.SubmitChanges();

                return true;
            }
            catch (Exception ex)
            {
                return false;
            }
        }
        private bool SaveMediaAssetLocation(int mediaAssetId, string folderName)
        {
            bool isUploaded;

            // create the media asset location entry
            var mediaAssetLocation = new MediaAssetLocation()
            {
                MediaAssetId = mediaAssetId,
                Path = folderName + Path.GetFileName(DestinationFile),
                ProtocolId = (int)ProtocolList.S3
            };

            try
            {
                isUploaded = SqlMediaAssetLocationRepository.SaveMediaAssetLocation(mediaAssetLocation);
            }
            catch (Exception ex)
            {
                util.ErrorNotification(ex);
                isUploaded = false;
            }

            return isUploaded;
        }