public ActionResult AddAzureSQLDatabaseStep2(CreateAzureSQLDatabaseCommand cmd, string sessionId)
{
if (!ModelState.IsValid)
{
return(View(cmd));
}
if (AzureSQLDatabases.AlreadyHasServer(cmd.Servername))
{
ModelState.AddModelError("servername", "This database is already configured");
return(View(cmd));
}
var testResult = AzureSQLDatabases.TestConnection(cmd);
if (testResult.Failed)
{
ModelState.AddModelError("test-connection", testResult.ToString());
return(View(cmd));
}
AzureSQLDatabases.StoreInSession(sessionId, cmd);
return(RedirectToAction("AddAzureSQLDatabaseStep3", new { sessionId = sessionId }));
}
public ActionResult Index()
{
var subscriptions = AzureSubscriptions.ListForOverview();
var databases = AzureSQLDatabases.ListForOverview();
return(View(new OverviewViewModel {
Services = subscriptions.Concat(databases).OrderBy(_ => _.Name).ToList()
}));
}
private ICollection <UsageObject> GetSQLDatabaseUsages()
{
var result = new List <UsageObject>();
foreach (var database in AzureSQLDatabases.ListAll())
{
try {
result.AddRange(GetDatabaseUsages(database));
}
catch (Exception e) {
_logger.ErrorException(string.Format("Failed fetch metrics for {0}", database.Servername), e);
}
}
return(result);
}
public async Task <ICollection <ChartInfo> > ListAllCharts()
{
var subscriptionCharts = AzureSubscriptions.ListAllCharts();
var sqlCharts = AzureSQLDatabases.ListAllCharts();
return((await subscriptionCharts).Concat(sqlCharts)
.Concat(new [] { new ChartInfo {
Name = "Dummy",
ResourceName = "DummyResourceName",
ResourceType = "DummyResourceType",
ServiceName = "Dummy Service",
ServiceType = "DummyService",
Uri = "wadgraphes://dummy"
} })
.ToList());
}
public ActionResult AddAzureSQLDatabaseStep3(string sessionId, string dummy)
{
AzureSQLDatabases.FinishSession(sessionId);
return(RedirectToRoute("Home"));
}
public ActionResult AddAzureSQLDatabaseStep3(string sessionId)
{
var finishCmd = AzureSQLDatabases.GetFinishCommandForSession(sessionId);
return(View(finishCmd));
}
