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 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 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(); } }