// GET: Servers
public async Task <ActionResult> Index()
{
AzureSqlManagerRepository azureSqlManagerRepository = new AzureSqlManagerRepository();
var model = await azureSqlManagerRepository.GetServers(_subscriptionId, BuildPath());
return(View(model));
}
public async Task <ActionResult> Databases(string server)
{
ViewBag.Server = server;
AzureSqlManagerRepository azureSqlManagerRepository = new AzureSqlManagerRepository();
var model = await azureSqlManagerRepository.GetDatabases(_subscriptionId, BuildPath(), server);
return(View(model));
}
public async Task <ActionResult> FirewallRules(string server)
{
AzureSqlManagerRepository azureSqlManagerRepository = new AzureSqlManagerRepository();
var model = await azureSqlManagerRepository.GetFirewallRules(_subscriptionId, server, BuildPath());
ViewBag.IP = Request.UserHostAddress;
ViewBag.ServerName = server;
return(View(model));
}
public async Task <ActionResult> SQLAddFirewallRule(string server)
{
string user = string.Format("User-{0}", User.Identity.Name);
AzureSqlManagerRepository azureSqlManagerRepository = new AzureSqlManagerRepository();
var rules = await azureSqlManagerRepository.GetFirewallRules(_subscriptionId, server, BuildPath());
foreach (var r in rules)
{
if (r.Name.StartsWith(user))
{
await azureSqlManagerRepository.DeleteFirewallRule(_subscriptionId, server, r.Name, BuildPath());
}
}
string ip = Request.UserHostAddress;
string IP = Request.UserHostName;
var result = await azureSqlManagerRepository.AddFireWallRule(_subscriptionId, server, ip, user, BuildPath());
return(RedirectToAction("FirewallRules", new { serverName = server }));
}
