public static async Task <IActionResult> Run( [HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)] HttpRequest req, ILogger log) { log.LogInformation("C# HTTP trigger function processed a request."); string requestBody = await new StreamReader(req.Body).ReadToEndAsync(); dynamic data = JsonConvert.DeserializeObject(requestBody); string[] targetsarr = data?.data.essentials.alertTargetIDs.ToObject <string[]>(); string[] targetsplit = targetsarr[0].ToString().Split(new string("/"), StringSplitOptions.RemoveEmptyEntries); string resourcegroup = targetsplit[3]; string sqlsrv = targetsplit[7]; string database = targetsplit[(targetsplit.Length - 1)]; log.LogInformation("Delete Database:"); log.LogInformation("ResourceGroup:" + resourcegroup); log.LogInformation("SQLServer:" + sqlsrv); log.LogInformation("Database:" + database); AzSQL sqlclass = new AzSQL(); bool deleteresult = await sqlclass.DeleteDatabase(sqlsrv, database); log.LogInformation("State:" + deleteresult); string state = "executed"; return((ActionResult) new OkObjectResult(state)); }
public static async void Run([TimerTrigger("0 */2 * * * *")] TimerInfo myTimer, ILogger log) { log.LogInformation($"C# Timer trigger function executed at: {DateTime.Now}"); log.LogInformation($"Execute function AddDB"); List <DatabaseModel> entriesfromazure = new List <DatabaseModel>(); AzureClass azurec = new AzureClass(); entriesfromazure = await azurec.getazressources(); List <DatabaseModel> entriesfromdb = new List <DatabaseModel>(); AzSQL sqlc = new AzSQL(); entriesfromdb = await sqlc.GetDatabase(); //Check database for old entries foreach (DatabaseModel item in entriesfromdb) { if (entriesfromazure.Contains(item)) { } else { } } }