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 }));
}
