public ActionResult DatabaseTables(string node, string database)
{
var vd = new DatabasesModel
{
Instance = SQLInstance.Get(node),
Database = database
};
return(View("Databases.Modal.Tables", vd));
}
public ActionResult DatabaseDetail(string node, string database, string view, string objectName)
{
var i = SQLInstance.Get(node);
var vd = new DatabasesModel
{
Instance = i,
Database = database,
ObjectName = objectName
};
switch (view)
{
case "backups":
vd.View = DatabasesModel.Views.Backups;
return(View("Databases.Modal.Backups", vd));
case "restores":
vd.View = DatabasesModel.Views.Restores;
return(View("Databases.Modal.Restores", vd));
case "storage":
vd.View = DatabasesModel.Views.Storage;
return(View("Databases.Modal.Storage", vd));
case "tables":
vd.View = DatabasesModel.Views.Tables;
return(View("Databases.Modal.Tables", vd));
case "views":
vd.View = DatabasesModel.Views.Views;
return(View("Databases.Modal.Views", vd));
case "unusedindexes":
vd.View = DatabasesModel.Views.UnusedIndexes;
return(View("Databases.Modal.UnusedIndexes", vd));
case "missingindexes":
vd.View = DatabasesModel.Views.MissingIndexes;
return(View("Databases.Modal.MissingIndexes", vd));
case "storedprocedures":
vd.View = DatabasesModel.Views.StoredProcedures;
return(View("Databases.Modal.StoredProcedures", vd));
}
return(View("Databases.Modal.Tables", vd));
}
public ActionResult DatabaseDetail(string node, string database, string view)
{
var vd = new DatabasesModel
{
Instance = SQLInstance.Get(node),
Database = database
};
switch (view)
{
case "tables":
vd.View = DatabasesModel.Views.Tables;
return(View("Databases.Modal.Tables", vd));
case "views":
vd.View = DatabasesModel.Views.Views;
return(View("Databases.Modal.Views", vd));
}
return(View("Databases.Modal.Tables", vd));
}
