private void ExportAssetExcel(IAsset asset, Excel.Worksheet xlWorkSheet, int row, bool detailed, bool localtime)
{
xlWorkSheet.Cells[row, 1] = asset.Name;
xlWorkSheet.Cells[row, 2] = asset.Id;
xlWorkSheet.Cells[row, 3] = localtime ? asset.LastModified.ToLocalTime() : asset.LastModified;
xlWorkSheet.Cells[row, 4] = AssetInfo.GetAssetType(asset);
xlWorkSheet.Cells[row, 5] = AssetInfo.GetSize(asset);
var url = AssetInfo.GetValidOnDemandURI(asset);
xlWorkSheet.Cells[row, 6] = url != null?url.ToString() : string.Empty;
if (localtime)
{
xlWorkSheet.Cells[row, 7] = asset.Locators.Any() ? (DateTime?)asset.Locators.Max(l => l.ExpirationDateTime).ToLocalTime() : null;
}
else
{
xlWorkSheet.Cells[row, 7] = asset.Locators.Any() ? (DateTime?)asset.Locators.Max(l => l.ExpirationDateTime) : null;
}
if (detailed)
{
xlWorkSheet.Cells[row, 8] = asset.AlternateId;
xlWorkSheet.Cells[row, 9] = asset.StorageAccount.Name;
var streamingloc = asset.Locators.Where(l => l.Type == LocatorType.OnDemandOrigin);
xlWorkSheet.Cells[row, 10] = streamingloc.Count();
if (localtime)
{
xlWorkSheet.Cells[row, 11] = streamingloc.Any() ? (DateTime?)streamingloc.Min(l => l.ExpirationDateTime).ToLocalTime() : null;
xlWorkSheet.Cells[row, 12] = streamingloc.Any() ? (DateTime?)streamingloc.Max(l => l.ExpirationDateTime).ToLocalTime() : null;
}
else
{
xlWorkSheet.Cells[row, 11] = streamingloc.Any() ? (DateTime?)streamingloc.Min(l => l.ExpirationDateTime) : null;
xlWorkSheet.Cells[row, 12] = streamingloc.Any() ? (DateTime?)streamingloc.Max(l => l.ExpirationDateTime) : null;
}
var sasloc = asset.Locators.Where(l => l.Type == LocatorType.Sas);
xlWorkSheet.Cells[row, 13] = sasloc.Count();
if (localtime)
{
xlWorkSheet.Cells[row, 14] = sasloc.Any() ? (DateTime?)sasloc.Min(l => l.ExpirationDateTime).ToLocalTime() : null;
xlWorkSheet.Cells[row, 15] = sasloc.Any() ? (DateTime?)sasloc.Max(l => l.ExpirationDateTime).ToLocalTime() : null;
}
else
{
xlWorkSheet.Cells[row, 14] = sasloc.Any() ? (DateTime?)sasloc.Min(l => l.ExpirationDateTime) : null;
xlWorkSheet.Cells[row, 15] = sasloc.Any() ? (DateTime?)sasloc.Max(l => l.ExpirationDateTime) : null;
}
xlWorkSheet.Cells[row, 16] = asset.GetEncryptionState(AssetDeliveryProtocol.SmoothStreaming | AssetDeliveryProtocol.HLS | AssetDeliveryProtocol.Dash).ToString();
}
}
private void ExportAssetExcel(IAsset asset, Excel.Worksheet xlWorkSheet, int row, bool detailed, bool localtime)
{
int index = 1;
xlWorkSheet.Cells[row, index++] = asset.Name;
xlWorkSheet.Cells[row, index++] = asset.Id;
xlWorkSheet.Cells[row, index++] = localtime ? asset.LastModified.ToLocalTime() : asset.LastModified;
xlWorkSheet.Cells[row, index++] = AssetInfo.GetAssetType(asset);
xlWorkSheet.Cells[row, index++] = AssetInfo.GetSize(asset);
int backindex = index;
var urls = AssetInfo.GetURIs(asset);
if (urls != null)
{
foreach (var url in urls)
{
xlWorkSheet.Cells[row, index++] = url != null?url.ToString() : string.Empty;
}
}
index = backindex + _context.StreamingEndpoints.Count();
var streamlocators = asset.Locators.Where(l => l.Type == LocatorType.OnDemandOrigin);
if (streamlocators.Any())
{
if (localtime)
{
xlWorkSheet.Cells[row, index++] = (DateTime?)streamlocators.Max(l => l.ExpirationDateTime).ToLocalTime();
}
else
{
xlWorkSheet.Cells[row, index++] = (DateTime?)streamlocators.Max(l => l.ExpirationDateTime);
}
}
else
{
xlWorkSheet.Cells[row, index++] = string.Empty;
}
// SAS locator
var saslocators = asset.Locators.Where(l => l.Type == LocatorType.Sas);
var saslocator = saslocators.ToList().OrderByDescending(l => l.ExpirationDateTime).FirstOrDefault();
if (saslocator != null && asset.AssetFiles.Count() > 0)
{
if (asset.AssetFiles.Count() == 1)
{
var ProgressiveDownloadUri = asset.AssetFiles.FirstOrDefault().GetSasUri(saslocator);
xlWorkSheet.Cells[row, index++] = ProgressiveDownloadUri.AbsoluteUri;
}
else
{
xlWorkSheet.Cells[row, index++] = saslocator.Path;
}
if (localtime)
{
xlWorkSheet.Cells[row, index++] = saslocator.ExpirationDateTime.ToLocalTime();
}
else
{
xlWorkSheet.Cells[row, index++] = saslocator.ExpirationDateTime;
}
}
else
{
xlWorkSheet.Cells[row, index++] = string.Empty;
xlWorkSheet.Cells[row, index++] = string.Empty;
}
if (detailed)
{
xlWorkSheet.Cells[row, index++] = asset.AlternateId;
xlWorkSheet.Cells[row, index++] = asset.StorageAccount.Name;
xlWorkSheet.Cells[row, index++] = asset.Uri == null ? string.Empty : asset.Uri.ToString();
var streamingloc = asset.Locators.Where(l => l.Type == LocatorType.OnDemandOrigin);
xlWorkSheet.Cells[row, index++] = streamingloc.Count();
if (localtime)
{
xlWorkSheet.Cells[row, index++] = streamingloc.Any() ? (DateTime?)streamingloc.Min(l => l.ExpirationDateTime).ToLocalTime() : null;
xlWorkSheet.Cells[row, index++] = streamingloc.Any() ? (DateTime?)streamingloc.Max(l => l.ExpirationDateTime).ToLocalTime() : null;
}
else
{
xlWorkSheet.Cells[row, index++] = streamingloc.Any() ? (DateTime?)streamingloc.Min(l => l.ExpirationDateTime) : null;
xlWorkSheet.Cells[row, index++] = streamingloc.Any() ? (DateTime?)streamingloc.Max(l => l.ExpirationDateTime) : null;
}
// SAS
xlWorkSheet.Cells[row, index++] = saslocators.Count();
if (localtime)
{
xlWorkSheet.Cells[row, index++] = saslocators.Any() ? (DateTime?)saslocators.Min(l => l.ExpirationDateTime).ToLocalTime() : null;
xlWorkSheet.Cells[row, index++] = saslocators.Any() ? (DateTime?)saslocators.Max(l => l.ExpirationDateTime).ToLocalTime() : null;
}
else
{
xlWorkSheet.Cells[row, index++] = saslocators.Any() ? (DateTime?)saslocators.Min(l => l.ExpirationDateTime) : null;
xlWorkSheet.Cells[row, index++] = saslocators.Any() ? (DateTime?)saslocators.Max(l => l.ExpirationDateTime) : null;
}
xlWorkSheet.Cells[row, index++] = asset.GetEncryptionState(AssetDeliveryProtocol.SmoothStreaming | AssetDeliveryProtocol.HLS | AssetDeliveryProtocol.Dash).ToString();
xlWorkSheet.Cells[row, index++] = asset.AssetFilters.Count().ToString();
}
}
private string ExportAssetCSVLine(IAsset asset, bool detailed, bool localtime)
{
List <string> linec = new List <string>();
linec.Add(asset.Name);
linec.Add(asset.Id);
linec.Add(localtime ? asset.LastModified.ToLocalTime().ToString() : asset.LastModified.ToString());
linec.Add(AssetInfo.GetAssetType(asset));
linec.Add(AssetInfo.GetSize(asset).ToString());
var urls = AssetInfo.GetURIs(asset);
if (urls != null && urls.Count() > 0)
{
foreach (var url in urls)
{
linec.Add(url != null ? url.ToString() : string.Empty);
}
}
else
{
for (int i = 0; i < _context.StreamingEndpoints.Count(); i++)
{
linec.Add(string.Empty);
}
}
var streamlocators = asset.Locators.Where(l => l.Type == LocatorType.OnDemandOrigin);
if (streamlocators.Any())
{
if (localtime)
{
linec.Add(streamlocators.Max(l => l.ExpirationDateTime).ToLocalTime().ToString());
}
else
{
linec.Add(streamlocators.Max(l => l.ExpirationDateTime).ToString());
}
}
else
{
linec.Add(string.Empty);
}
// SAS locator
var saslocators = asset.Locators.Where(l => l.Type == LocatorType.Sas);
var saslocator = saslocators.ToList().OrderByDescending(l => l.ExpirationDateTime).FirstOrDefault();
if (saslocator != null && asset.AssetFiles.Count() > 0)
{
if (asset.AssetFiles.Count() == 1)
{
var ProgressiveDownloadUri = asset.AssetFiles.FirstOrDefault().GetSasUri(saslocator);
linec.Add(ProgressiveDownloadUri.AbsoluteUri);
}
else
{
linec.Add(saslocator.Path);
}
if (localtime)
{
linec.Add(saslocator.ExpirationDateTime.ToLocalTime().ToString());
}
else
{
linec.Add(saslocator.ExpirationDateTime.ToString());
}
}
else
{
linec.Add(string.Empty);
linec.Add(string.Empty);
}
if (detailed)
{
linec.Add(asset.AlternateId);
linec.Add(asset.StorageAccount.Name);
linec.Add(asset.Uri == null ? string.Empty : asset.Uri.ToString());
var streamingloc = asset.Locators.Where(l => l.Type == LocatorType.OnDemandOrigin);
linec.Add(streamingloc.Count().ToString());
if (localtime)
{
linec.Add(streamingloc.Any() ? streamingloc.Min(l => l.ExpirationDateTime).ToLocalTime().ToString() : null);
linec.Add(streamingloc.Any() ? streamingloc.Max(l => l.ExpirationDateTime).ToLocalTime().ToString() : null);
}
else
{
linec.Add(streamingloc.Any() ? streamingloc.Min(l => l.ExpirationDateTime).ToString() : null);
linec.Add(streamingloc.Any() ? streamingloc.Max(l => l.ExpirationDateTime).ToString() : null);
}
// SAS
linec.Add(saslocators.Count().ToString());
if (localtime)
{
linec.Add(saslocators.Any() ? saslocators.Min(l => l.ExpirationDateTime).ToLocalTime().ToString() : null);
linec.Add(saslocators.Any() ? saslocators.Max(l => l.ExpirationDateTime).ToLocalTime().ToString() : null);
}
else
{
linec.Add(saslocators.Any() ? saslocators.Min(l => l.ExpirationDateTime).ToString() : null);
linec.Add(saslocators.Any() ? saslocators.Max(l => l.ExpirationDateTime).ToString() : null);
}
linec.Add(asset.GetEncryptionState(AssetDeliveryProtocol.SmoothStreaming | AssetDeliveryProtocol.HLS | AssetDeliveryProtocol.Dash).ToString());
linec.Add(asset.AssetFilters.Count().ToString());
}
return(convertCSVLine(linec));
}
private void WorkerAnalyzeAssets_DoWork(object sender, DoWorkEventArgs e)
{
Debug.WriteLine("WorkerAnalyzeAssets_DoWork");
BackgroundWorker worker = sender as BackgroundWorker;
IAsset asset = null;
PublishStatus SASLoc;
PublishStatus OrigLoc;
var listae = _MyObservAsset.OrderBy(a => cacheAssetentries.ContainsKey(a.Id)).ToList(); // as priority, assets not yet analyzed
foreach (AssetEntry AE in listae)
{
try
{
asset = _context.Assets.Where(a => a.Id == AE.Id).FirstOrDefault();
if (asset != null)
{
AssetInfo myAssetInfo = new AssetInfo(asset);
AE.Name = asset.Name;
AE.LastModified = asset.LastModified.ToLocalTime().ToString("G");
SASLoc = myAssetInfo.GetPublishedStatus(LocatorType.Sas);
OrigLoc = myAssetInfo.GetPublishedStatus(LocatorType.OnDemandOrigin);
AssetBitmapAndText assetBitmapAndText = ReturnStaticProtectedBitmap(asset);
AE.StaticEncryption = assetBitmapAndText.bitmap;
AE.StaticEncryptionMouseOver = assetBitmapAndText.MouseOverDesc;
assetBitmapAndText = BuildBitmapPublication(asset);
AE.Publication = assetBitmapAndText.bitmap;
AE.PublicationMouseOver = assetBitmapAndText.MouseOverDesc;
AE.Type = AssetInfo.GetAssetType(asset);
AE.SizeLong = myAssetInfo.GetSize();
AE.Size = AssetInfo.FormatByteSize(AE.SizeLong);
assetBitmapAndText = BuildBitmapDynEncryption(asset);
AE.DynamicEncryption = assetBitmapAndText.bitmap;
AE.DynamicEncryptionMouseOver = assetBitmapAndText.MouseOverDesc;
DateTime? LocDate = asset.Locators.Any() ? (DateTime?)asset.Locators.Min(l => l.ExpirationDateTime).ToLocalTime() : null;
AE.LocatorExpirationDate = LocDate.HasValue ? ((DateTime)LocDate).ToLocalTime().ToString() : null;
AE.LocatorExpirationDateWarning = LocDate.HasValue ? (LocDate < DateTime.Now.ToLocalTime()) : false;
assetBitmapAndText = BuildBitmapAssetFilters(asset);
AE.Filters = assetBitmapAndText.bitmap;
AE.FiltersMouseOver = assetBitmapAndText.MouseOverDesc;
cacheAssetentries[asset.Id] = AE; // let's put it in cache (or update the cache)
}
}
catch // in some case, we have a timeout on Assets.Where...
{
}
if (worker.CancellationPending == true)
{
e.Cancel = true;
return;
}
}
this.BeginInvoke(new Action(() => this.Refresh()), null);
}
private void WorkerAnalyzeAssets_DoWork(object sender, DoWorkEventArgs e)
{
Debug.WriteLine("WorkerAnalyzeAssets_DoWork");
BackgroundWorker worker = sender as BackgroundWorker;
IAsset asset;
PublishStatus SASLoc;
PublishStatus OrigLoc;
int i = 0;
foreach (AssetEntry AE in _MyObservAsset)
{
asset = null;
try
{
asset = _context.Assets.Where(a => a.Id == AE.Id).FirstOrDefault();
if (asset != null)
{
AssetInfo myAssetInfo = new AssetInfo(asset);
SASLoc = myAssetInfo.GetPublishedStatus(LocatorType.Sas);
OrigLoc = myAssetInfo.GetPublishedStatus(LocatorType.OnDemandOrigin);
AssetBitmapAndText assetBitmapAndText = ReturnStaticProtectedBitmap(asset);
AE.StaticEncryption = assetBitmapAndText.bitmap;
AE.StaticEncryptionMouseOver = assetBitmapAndText.MouseOverDesc;
assetBitmapAndText = BuildBitmapPublication(asset);
AE.Publication = assetBitmapAndText.bitmap;
AE.PublicationMouseOver = assetBitmapAndText.MouseOverDesc;
AE.Type = AssetInfo.GetAssetType(asset);
AE.SizeLong = myAssetInfo.GetSize();
AE.Size = AssetInfo.FormatByteSize(AE.SizeLong);
assetBitmapAndText = BuildBitmapDynEncryption(asset);
AE.DynamicEncryption = assetBitmapAndText.bitmap;
AE.DynamicEncryptionMouseOver = assetBitmapAndText.MouseOverDesc;
DateTime? LocDate = asset.Locators.Any() ? (DateTime?)asset.Locators.Min(l => l.ExpirationDateTime).ToLocalTime() : null;
AE.LocatorExpirationDate = LocDate;
AE.LocatorExpirationDateWarning = (LocDate < DateTime.Now);
assetBitmapAndText = BuildBitmapAssetFilters(asset);
AE.Filters = assetBitmapAndText.bitmap;
AE.FiltersMouseOver = assetBitmapAndText.MouseOverDesc;
i++;
if (i % 5 == 0)
{
this.BeginInvoke(new Action(() => this.Refresh()), null);
}
}
}
catch // in some case, we have a timeout on Assets.Where...
{
}
if (worker.CancellationPending == true)
{
e.Cancel = true;
return;
}
}
this.BeginInvoke(new Action(() => this.Refresh()), null);
}
private void ExportAssetExcel(IAsset asset, Excel.Worksheet xlWorkSheet, int row, bool detailed, bool localtime)
{
int index = 1;
xlWorkSheet.Cells[row, index++] = asset.Name;
xlWorkSheet.Cells[row, index++] = asset.Id;
xlWorkSheet.Cells[row, index++] = localtime ? asset.LastModified.ToLocalTime() : asset.LastModified;
xlWorkSheet.Cells[row, index++] = AssetInfo.GetAssetType(asset);
xlWorkSheet.Cells[row, index++] = AssetInfo.GetSize(asset);
int backindex = index;
var urls = AssetInfo.GetURIs(asset);
if (urls != null)
{
foreach (var url in urls)
{
xlWorkSheet.Cells[row, index++] = url != null?url.ToString() : string.Empty;
}
}
index = backindex + _context.StreamingEndpoints.Count();
if (localtime)
{
xlWorkSheet.Cells[row, index++] = asset.Locators.Any() ? (DateTime?)asset.Locators.Max(l => l.ExpirationDateTime).ToLocalTime() : null;
}
else
{
xlWorkSheet.Cells[row, index++] = asset.Locators.Any() ? (DateTime?)asset.Locators.Max(l => l.ExpirationDateTime) : null;
}
if (detailed)
{
xlWorkSheet.Cells[row, index++] = asset.AlternateId;
xlWorkSheet.Cells[row, index++] = asset.StorageAccount.Name;
xlWorkSheet.Cells[row, index++] = asset.Uri == null ? string.Empty : asset.Uri.ToString();
var streamingloc = asset.Locators.Where(l => l.Type == LocatorType.OnDemandOrigin);
xlWorkSheet.Cells[row, index++] = streamingloc.Count();
if (localtime)
{
xlWorkSheet.Cells[row, index++] = streamingloc.Any() ? (DateTime?)streamingloc.Min(l => l.ExpirationDateTime).ToLocalTime() : null;
xlWorkSheet.Cells[row, index++] = streamingloc.Any() ? (DateTime?)streamingloc.Max(l => l.ExpirationDateTime).ToLocalTime() : null;
}
else
{
xlWorkSheet.Cells[row, index++] = streamingloc.Any() ? (DateTime?)streamingloc.Min(l => l.ExpirationDateTime) : null;
xlWorkSheet.Cells[row, index++] = streamingloc.Any() ? (DateTime?)streamingloc.Max(l => l.ExpirationDateTime) : null;
}
var sasloc = asset.Locators.Where(l => l.Type == LocatorType.Sas);
xlWorkSheet.Cells[row, index++] = sasloc.Count();
if (localtime)
{
xlWorkSheet.Cells[row, index++] = sasloc.Any() ? (DateTime?)sasloc.Min(l => l.ExpirationDateTime).ToLocalTime() : null;
xlWorkSheet.Cells[row, index++] = sasloc.Any() ? (DateTime?)sasloc.Max(l => l.ExpirationDateTime).ToLocalTime() : null;
}
else
{
xlWorkSheet.Cells[row, index++] = sasloc.Any() ? (DateTime?)sasloc.Min(l => l.ExpirationDateTime) : null;
xlWorkSheet.Cells[row, index++] = sasloc.Any() ? (DateTime?)sasloc.Max(l => l.ExpirationDateTime) : null;
}
xlWorkSheet.Cells[row, index++] = asset.GetEncryptionState(AssetDeliveryProtocol.SmoothStreaming | AssetDeliveryProtocol.HLS | AssetDeliveryProtocol.Dash).ToString();
xlWorkSheet.Cells[row, index++] = asset.AssetFilters.Count().ToString();
}
}
