public ActionResult Connections(string node)
{
var i = SQLInstance.Get(node);
var vd = new DashboardModel
{
View = SQLViews.Connections,
CurrentInstance = i
};
return View(vd);
}
public ActionResult Instance(string node)
{
var i = SQLInstance.Get(node);
var vd = new DashboardModel
{
View = SQLViews.Instance,
StandaloneInstances = SQLInstance.AllStandalone,
Refresh = node.HasValue() ? 10 : 5,
CurrentInstance = i
};
return View("Instance", vd);
}
public ActionResult Connections(string node, bool refresh = false)
{
var instance = SQLInstance.Get(node);
if (refresh && instance != null)
{
instance.Connections.Purge();
}
var vd = new DashboardModel
{
View = DashboardModel.Views.Connections,
CurrentInstance = instance
};
return View("Dashboard", vd);
}
public ActionResult Instance(string node, bool ajax = false)
{
var instance = SQLInstance.Get(node);
if (instance == null && ajax)
return ContentNotFound("Instance " + node + " was not found.");
var vd = new DashboardModel
{
StandaloneInstances = SQLInstance.AllStandalone,
Refresh = node.HasValue() ? 10 : 5,
View = DashboardModel.Views.Instance,
CurrentInstance = instance
};
return View(ajax ? "Instance" : "Dashboard", vd);
}
public ActionResult Active(string node, SQLInstance.ActiveSearchOptions options,
SQLInstance.ActiveSearchOptions.ShowSleepingSessionOptions? sleeping = null,
bool? system = false,
bool? details = false)
{
if (sleeping.HasValue) options.IncludeSleepingSessions = sleeping.Value;
if (system.HasValue) options.IncludeSystemSessions = system.Value;
if (details.HasValue) options.GetAdditionalInfo = details.Value;
var vd = new DashboardModel
{
View = DashboardModel.Views.Active,
CurrentInstance = SQLInstance.Get(node),
ActiveSearchOptions = options
};
return View("Dashboard", vd);
}
public ActionResult Servers(string cluster, string node, string ag, bool detailOnly = false)
{
var vd = new DashboardModel
{
StandaloneInstances = SQLInstance.AllStandalone,
Clusters = SQLCluster.AllClusters,
Refresh = node.HasValue() ? 10 : 5
};
if (cluster.HasValue())
vd.CurrentCluster = vd.Clusters.FirstOrDefault(c => string.Equals(c.Name, cluster, StringComparison.OrdinalIgnoreCase));
if (vd.CurrentCluster != null)
vd.AvailabilityGroups = vd.CurrentCluster.GetAvailabilityGroups(node, ag).ToList();
if (detailOnly && vd.CurrentCluster != null)
return View("Servers.ClusterDetail", vd);
return View("Servers", vd);
}
public ActionResult Databases(string node)
{
var i = SQLInstance.Get(node);
var vd = new DashboardModel
{
View = SQLViews.Databases,
CurrentInstance = i,
Refresh = 10*60
};
return View(vd);
}
public ActionResult Top(string node, SQLInstance.TopSearchOptions options, bool? detailed = false)
{
var i = SQLInstance.Get(node);
options.SetDefaults();
var vd = new DashboardModel
{
View = SQLViews.Top,
Detailed = detailed.GetValueOrDefault(),
CurrentInstance = i,
TopSearchOptions = options
};
return View("Operations.Top", vd);
}
public ActionResult Databases(string node)
{
var vd = new DashboardModel
{
View = DashboardModel.Views.Databases,
CurrentInstance = SQLInstance.Get(node)
};
return View("Dashboard", vd);
}