public static async Task RunAsync([TimerTrigger("0 0 */6 * * *")] TimerInfo myTimer, ILogger log)

        {
            log.LogInformation($"C# Timer trigger function executed at: {DateTime.Now}");

            UtilsQuerys uq   = new UtilsQuerys();
            int         vent = uq.getVentilators();

            //Missing get ventilators here
            if (vent <= 5)
            {
                UserAdmin user = uq.getUserAdmin();

                var adminEmail = user.email;
                var adminName  = user.fullName;

                string sendgridApi = Environment.GetEnvironmentVariable("SENDGRID_API_KEY");
                string fromEmail   = Environment.GetEnvironmentVariable("FROMEMAIL");
                string fromUser    = Environment.GetEnvironmentVariable("FROMUSER");

                var           client  = new SendGridClient(sendgridApi);
                var           from    = new EmailAddress(fromEmail, fromUser);
                var           subject = "Ventilators are running out!";
                var           to      = new EmailAddress(adminEmail, adminName);
                StringBuilder strHtml = uq.getTemplateEmail("low_ventilators");
                //var plainTextContent = "";
                var htmlContent = strHtml.ToString(); //MISSING TEMPLATE
                var msg         = MailHelper.CreateSingleEmail(from, to, subject, "", htmlContent);
                var response    = await client.SendEmailAsync(msg);
            }
            else
            {
                log.LogInformation($"there are enough ventilator");
            }
        }
        public static void Run([TimerTrigger("0 0 0 * * *")] TimerInfo myTimer, ILogger log)
        {
            log.LogInformation($"C# Timer trigger function executed at: {DateTime.Now}");
            List <InventoryAvaible> lowInventor = ReadLowInventoryDB();

            if (lowInventor.Count > 0)
            {
                // send Email
                string json_lowInventor = JsonConvert.SerializeObject(lowInventor);

                UtilsQuerys uq   = new UtilsQuerys();
                UserAdmin   user = uq.getUserAdmin();

                string sendgridApi = Environment.GetEnvironmentVariable("SENDGRID_API_KEY");
                string fromEmail   = Environment.GetEnvironmentVariable("FROMEMAIL");
                string fromUser    = Environment.GetEnvironmentVariable("FROMUSER");

                var adminEmail = user.email;
                var adminName  = user.fullName;

                var client  = new SendGridClient(sendgridApi);
                var from    = new EmailAddress(fromEmail, fromUser);
                var subject = "Alarm we need more supplies";
                var to      = new EmailAddress(adminEmail, adminName);
                //var plainTextContent = json_lowInventor;
                StringBuilder   strHtml     = uq.getTemplateEmail("low_supplies", json_lowInventor);
                string          htmlContent = strHtml.ToString();
                var             msg         = MailHelper.CreateSingleEmail(from, to, subject, " ", htmlContent);
                Task <Response> response    = client.SendEmailAsync(msg);
                response.Wait();
                var rep = response.Result;
            }
            else
            {
                log.LogInformation($"We have enough supplies!! ");
            }
        }