private FilterResult FilterData(BackupDbccService svc, BackupDbccViewModel viewModel, bool IsDownload)
{
var grid = svc.BackupDbccHistory(viewModel.GridConditions, viewModel.FilterConditions, viewModel.FilterOperands);
var aaData = grid.Data.Select(d => new string[] {
String.Format("{0} ({1})", d.Server, d.ServerId),
IsDownload
? d.Database
: String.Format(DatabaseInfoFormat, d.Workspace, d.Database),
d.FriendlyIsBackup,
d.FriendlyLastActivityDate,
d.FriendlyGapResolutionDate,
IsDownload
? d.GapSize.ToString()
: string.Format(@"<b class=""{0}"">{1}</b>",
d.GapSize <= 9
? "grid-item-healthy"
: d.GapResolutionDate.HasValue
? "grid-item-warning"
: "grid-item-critical",
d.GapSize.ToString())
}).ToArray();
return(new kCura.PDD.Web.Controllers.FilterResult()
{
Data = aaData, TotalRecordCount = grid.Count
});
}
private void Initialize(BackupDbccViewModel model)
{
var json = new JavaScriptSerializer().Serialize(model);
VarscatState.Value = json;
TimezoneOffset.Value = RequestService.GetTimezoneOffset(this.Request).ToString();
SampleStart.Value = base.GlassInfo.MinSampleDate.GetValueOrDefault(DateTime.UtcNow).ToString("s");
}
/// <summary>
/// Translates a Backup/DBCC view into grid data
/// </summary>
/// <param name="viewModel"></param>
/// <returns></returns>
private DataTableResponse FetchGapGridData(BackupDbccService svc, BackupDbccViewModel viewModel)
{
var data = FilterData(svc, viewModel, false);
var dtResponse = new DataTableResponse()
{
sEcho = string.IsNullOrEmpty(viewModel.GridConditions.sEcho)
? "1"
: viewModel.GridConditions.sEcho,
aaData = data.Data,
recordsTotal = data.Data.Count(),
recordsFiltered = data.TotalRecordCount
};
return(dtResponse);
}
private string FetchFileData(BackupDbccService svc, BackupDbccViewModel viewModel)
{
var filterResult = FilterData(svc, viewModel, true);
using (var sw = new System.IO.StringWriter())
{
var heaaderArr = new string[]
{
"Server", "Database", "Activity Type", "Last Activity",
"Resolution Date", "Gap Size"
};
sw.WriteLine(string.Join(",", heaaderArr));
foreach (var row in filterResult.Data)
{
sw.WriteCsvSafeLine(row);
}
return(sw.ToString());
}
}
