private void GetCustomer(Customer customer, MediaServicesSetConfig mediaServicesSet)
{
var dataAccess = new AzureDataAccess(mediaServicesSet.DataStorageConnections);
customer.Accounts = mediaServicesSet.MediaServicesAccounts.Select((mediaServicesAccount, index) =>
{
var account = GetMediaAccountFromCache(customer, mediaServicesAccount);
if (account == null)
{
if (index == 0)
{
FillCustomerDetails(customer, mediaServicesAccount);
}
// TODO: this logic is wrong and needs to be replaced.
var globalAerts = dataAccess.GetAccountGlobalAlerts(mediaServicesAccount.AccountName);
return(new MediaService
{
Id = mediaServicesAccount.Id,
Name = mediaServicesAccount.AccountName,
Datacenter = mediaServicesAccount.MetaData.Location,
Health = GetMaxLevel(globalAerts),
});
}
return(account);
}).ToList();
customer.Health = customer.Accounts.Max(m => m.Health);
}
private IEnumerable <MetricAlert> Get(MediaServicesSetConfig config, string channelId, AlertsQuery query)
{
var chid = channelId.NimbusIdToGuid();
var channelAlerts = GetAlertsFromCache <ChannelAlert>(chid.ToString());
if (channelAlerts == null)
{
var dataAccess = new AzureDataAccess(config.DataStorageConnections);
channelAlerts = dataAccess.GetChannelAlerts(chid.ToString(), query.StatusLevels, query.MetricTypes);
}
IEnumerable <MetricAlert> alerts = null;
if (channelAlerts != null)
{
alerts = channelAlerts.Select(chAlt => new MetricAlert
{
AlertID = chAlt.AlertID,
Name = chAlt.ChannelName,
Date = chAlt.AlertDate.AddTicks(chAlt.AlertTime.Ticks),
Description = chAlt.Details,
Status = chAlt.ErrorLevel
});
}
return(alerts);
}
internal IEnumerable <MetricAlert> Get(MediaServicesSetConfig config, string originId, AlertsQuery query)
{
var endTime = DateTime.UtcNow;
var startTime = endTime.AddHours(-1);
HealthStatus[] healthLevels = null;
if (query != null)
{
if (query.StartTime != default(DateTime))
{
startTime = query.StartTime.ToUniversalTime();
}
if (query.EndTime != default(DateTime))
{
endTime = query.EndTime.ToUniversalTime();
}
if (endTime <= startTime)
{
throw new HttpResponseException(System.Net.HttpStatusCode.BadRequest);
}
healthLevels = query.StatusLevels;
}
var origId = originId.GuidToOriginId();
var alertstring = CloudCache.Get(origId + "Alerts");
List <OriginAlert> alerts;
if (alertstring != null)
{
alerts = JsonConvert.DeserializeObject <List <OriginAlert> >(alertstring);
}
else
{
var dataAccess = new AzureDataAccess(config.DataStorageConnections);
alerts = dataAccess.ExecuteReadQuery(context =>
{
var dbAlerts = context.OriginAlerts.Where(alert =>
alert.OriginId == originId &&
alert.Timestamp >= startTime &&
alert.Timestamp <= endTime);
if (healthLevels != null)
{
var predicate = CreatePredicate(healthLevels, "ErrorLevel");
dbAlerts = dbAlerts.Where(predicate);
}
return(dbAlerts.ToList());
});
}
return(alerts.Select(alert => new MetricAlert
{
Name = alert.OriginId,
Date = alert.Timestamp,
Description = alert.Details,
Status = alert.ErrorLevel
}).OrderByDescending(alt => alt.Date));
}
private static MediaPipeline MapMediaServicesSet(MediaServicesSetConfig configMediaServiceSet)
{
var mediaPipeline = new MediaPipeline();
mediaPipeline.Name = configMediaServiceSet.Name;
mediaPipeline.Deployments = configMediaServiceSet.MediaServicesAccounts
.Denull()
.Select(MapMediaServicesAccounts)
.Where(ad => null != ad)
.ToList();
return(mediaPipeline);
}
internal List <MetricAlert> Get(MediaServicesSetConfig config, string originId, AlertsQuery query)
{
//var origId = originId.GuidToOriginId();
var originAlerts = GetAlertsFromCache <OriginAlert>(originId);
if (originAlerts == null)
{
var dataAccess = new AzureDataAccess(config.DataStorageConnections);
if (query.StatusLevels == null)
{
originAlerts = dataAccess.GetOriginAlerts(originId);
}
else
{
originAlerts = dataAccess.GetOriginAlerts(originId, query.StatusLevels);
}
}
List <MetricAlert> alerts = new List <MetricAlert>();
if (originAlerts != null && originAlerts.Count > 0)
{
foreach (var orgAlt in originAlerts)
{
alerts.Add(new MetricAlert
{
AlertID = orgAlt.AlertID,
Name = orgAlt.OriginName,
Date = orgAlt.AlertDate.AddTicks(orgAlt.AlertTime.Ticks),
Description = orgAlt.Details,
Status = orgAlt.ErrorLevel
});
}
}
return(alerts);
}
private IEnumerable <MetricAlert> GetOriginAlerts(MediaServicesSetConfig config, string originId, AlertsQuery query)
{
var controller = new OriginAlertsController();
return(controller.Get(config, originId, query));
}
internal IEnumerable <MetricAlert> Get(MediaServicesSetConfig config, string originId, AlertsQuery query)
{
var endTime = DateTime.UtcNow;
var startTime = endTime.AddHours(-1);
HealthStatus[] healthLevels = null;
if (query != null)
{
if (query.StartTime != default(DateTime))
{
startTime = query.StartTime.ToUniversalTime();
}
if (query.EndTime != default(DateTime))
{
endTime = query.EndTime.ToUniversalTime();
}
if (endTime <= startTime)
{
throw new HttpResponseException(System.Net.HttpStatusCode.BadRequest);
}
healthLevels = query.StatusLevels;
}
//var origId = originId.GuidToOriginId();
string alertstring = CloudCache.Get(originId + "Alerts");
List <OriginAlert> originAlerts;
if (alertstring != null)
{
originAlerts = JsonConvert.DeserializeObject <List <OriginAlert> >(alertstring);
}
else
{
var dataAccess = new AzureDataAccess(config.DataStorageConnections);
if (healthLevels == null)
{
originAlerts = dataAccess.GetOriginAlerts(originId);
}
else
{
originAlerts = dataAccess.GetOriginAlerts(originId, healthLevels);
}
}
List <MetricAlert> alerts = new List <MetricAlert>();
if (originAlerts != null && originAlerts.Count > 0)
{
foreach (var orgAlt in originAlerts)
{
alerts.Add(new MetricAlert
{
AlertID = orgAlt.AlertID,
Name = orgAlt.OriginName,
Date = orgAlt.AlertDate.AddTicks(orgAlt.AlertTime.Ticks),
Description = orgAlt.Details,
Status = orgAlt.ErrorLevel
});
}
}
return(alerts);
}
private static void CleanupDatabase(MediaServicesSetConfig mediaServicesSet)
{
var rententionPeriod = TimeSpan.FromDays(SqlRetentionPeriod);
var earliestDate = DateTime.UtcNow - rententionPeriod;
Trace.TraceInformation("Earliest date before which the record will be removed: {0}", earliestDate);
foreach (var databaseConfig in mediaServicesSet.DataStorageConnections)
{
Trace.TraceInformation(
"Cleaning database account on Server:{0} Accont:{1} Catalog:{2}",
databaseConfig.AzureServer,
databaseConfig.AcctName,
databaseConfig.InitialCatalog);
}
// Clean channel and origin alerts older than 30 days.
var dataAccess = new AzureDataAccess(mediaServicesSet.DataStorageConnections);
int removed = dataAccess.CleanOutOldData(earliestDate);
Trace.TraceInformation("Total of {0} records removed on {1} ", removed, DateTime.UtcNow);
#region Not Used
//dataAccess.ExecuteWriteQuery( dataContext =>
//{
// foreach (AlertType at in dataContext.AlertTypes)
// {
// //start with GlobalAlerts
// var records = dataContext.Alerts.Where(alert => (alert.AlertDate < earliestDate.Date) &&
// alert.AlertTypeID == at.AlertTypeID).ToList();
// switch (at.AlertTypeID)
// {
// case 1:
// Trace.TraceInformation("Removing {0} records from Global Alerts...", records.Count);
// break;
// case 2:
// Trace.TraceInformation("Removing {0} records from Channel Alerts...", records.Count);
// break;
// case 3:
// Trace.TraceInformation("Removing {0} records from Origin Alerts...", records.Count);
// break;
// case 4:
// Trace.TraceInformation("Removing {0} records from Archive Alerts...", records.Count);
// break;
// }
// dataContext.Alerts.RemoveRange(records);
// dataContext.SaveChanges();
// }
//});
//dataAccess.ExecuteWriteQuery(dataContext =>
//{
// var records = dataContext.Alerts.Where(alert => (alert.AlertDate < earliestDate.Date) &&
// alert.AlertTypeID == 2).ToList();
// dataContext.Alerts.RemoveRange(records);
// dataContext.SaveChanges();
//});
//dataAccess.ExecuteWriteQuery(dataContext =>
//{
// var records = dataContext.Alerts.Where(alert => (alert.AlertDate < earliestDate.Date) &&
// alert.AlertTypeID == 3).ToList();
// dataContext.Alerts.RemoveRange(records);
// dataContext.SaveChanges();
//});
//dataAccess.ExecuteWriteQuery(dataContext =>
//{
// var records = dataContext.Alerts.Where(alert => (alert.AlertDate < earliestDate.Date) &&
// alert.AlertTypeID == 4).ToList();
// dataContext.Alerts.RemoveRange(records);
// dataContext.SaveChanges();
//});
#endregion
}
public static AzureDataAccess GetDataAccess(MediaServicesSetConfig config)
{
return(new AzureDataAccess(config.DataStorageConnections));
}
private IEnumerable <MetricAlert> Get(MediaServicesSetConfig config, string channelId, AlertsQuery query)
{
var endTime = DateTime.UtcNow;
var startTime = endTime.AddHours(-1);
HealthStatus[] healthLevels = null;
MetricType[] metricTypes = null;
if (query != null)
{
if (query.StartTime != default(DateTime))
{
startTime = query.StartTime.ToUniversalTime();
}
if (query.EndTime != default(DateTime))
{
endTime = query.EndTime.ToUniversalTime();
}
if (endTime <= startTime)
{
throw new HttpResponseException(System.Net.HttpStatusCode.BadRequest);
}
metricTypes = query.MetricTypes;
healthLevels = query.StatusLevels;
}
var chid = channelId.NimbusIdToGuid();
string alertstring = CloudCache.Get(chid + "Alerts");
List <ChannelAlert> channelAlerts;
if (alertstring != null)
{
channelAlerts = JsonConvert.DeserializeObject <List <ChannelAlert> >(alertstring);
}
else
{
var dataAccess = new AzureDataAccess(config.DataStorageConnections);
channelAlerts = dataAccess.GetChannelAlerts(chid.ToString(), healthLevels, metricTypes);
#region Not used
//channelAlerts = dataAccess.ExecuteReadQuery(context =>
//{
// var dbAlerts = context.ChannelAlerts.Where(alert =>
// alert.ChannelId == channelId &&
// alert.AlertDate >= startTime.AddTicks(alert.AlertTime.Ticks) &&
// alert.AlertDate <= endTime);
// if (healthLevels != null)
// {
// var predicate = CreatePredicate(healthLevels, "ErrorLevel");
// dbAlerts = dbAlerts.Where(predicate);
// }
// if (metricTypes != null)
// {
// var condition = CreatePredicate(metricTypes, "MetricType");
// dbAlerts = dbAlerts.Where(condition);
// }
// return dbAlerts.ToList();
//});
#endregion
}
List <MetricAlert> alerts = new List <MetricAlert>();
if (channelAlerts != null)
{
foreach (var chAlt in channelAlerts)
{
alerts.Add(new MetricAlert
{
AlertID = chAlt.AlertID,
Name = chAlt.ChannelName,
Date = chAlt.AlertDate.AddTicks(chAlt.AlertTime.Ticks),
Description = chAlt.Details,
Status = chAlt.ErrorLevel
});
}
}
return(alerts);
}
