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 i = SQLInstance.Get(node);
var vd = new DashboardModel
{
View = SQLViews.Active,
CurrentInstance = i,
ActiveSearchOptions = options
};
return(View("Operations.Active", vd));
}
private OperationsActiveModel GetOperationsActiveModel(string node, SQLInstance.ActiveSearchOptions options)
{
var i = Module.GetInstance(node);
return(new OperationsActiveModel
{
View = SQLViews.Active,
CurrentInstance = i,
ActiveSearchOptions = options
});
}
public ActionResult Kill(string node, string database, int sid)
{
var activeSearchOptions = new SQLInstance.ActiveSearchOptions();
var i = SQLInstance.Get(node);
var activeOps = i.GetActiveOperations(activeSearchOptions);
var model = activeOps.Data.FirstOrDefault(x => x.SessionId == sid);
ViewData["node"] = node;
ViewData["sid"] = sid;
return(View("Operations.Active.Kill", model));
}
public ActionResult ActiveFilters(string node, SQLInstance.ActiveSearchOptions options) =>
View("Operations.Active.Filters", GetOperationsActiveModel(node, options));
public ActionResult ActiveFilters(string node, SQLInstance.ActiveSearchOptions options)
{
var vd = GetOperationsActiveModel(node, options);
return(View("Operations.Active.Filters", vd));
}
