Esempio n. 1
0
        private void SendClaimApprovalNotification()
        {
            try
            {
                Log.ErrorFileWrite(moduleName, "2001", "IN - SPAR MAPPER Email Notification Start");

                List <EmailAlert> emailAlertList = EmailAlert.GetAccountClaimApprovalNotificationList();

                foreach (EmailAlert emailAlert in emailAlertList)
                {
                    MailMessage mailMessage = new MailMessage(ConfigurationManager.AppSettings["administrationEmailAddress"].ToString(), emailAlert.EmailAddress /*"*****@*****.**"*/);

                    mailMessage.Subject    = emailAlert.EmailSubject;
                    mailMessage.Body       = emailAlert.EmailBody;
                    mailMessage.IsBodyHtml = true;

                    SmtpClient smtpClient = new SmtpClient(ConfigurationManager.AppSettings["mailRelay"].ToString());
                    smtpClient.Port        = Convert.ToInt32(ConfigurationManager.AppSettings["port"]);
                    smtpClient.Credentials = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["administrationEmailAddress"].ToString(), ConfigurationManager.AppSettings["password"].ToString());
                    smtpClient.EnableSsl   = true;
                    smtpClient.Send(mailMessage);
                }

                //Utility.WriteLog(2001, 5, "IN - SPAR MAPPER Email Notification End", "Information", TraceEventType.Information, moduleName);
                Log.ErrorFileWrite(moduleName, "2002", "IN - SPAR MAPPER Email Notification End");
                Application.Exit();
            }
            catch (Exception ex)
            {
                //Utility.WriteLog(2002, 5, ex.Message, "Exception", TraceEventType.Error, moduleName);
                Log.ErrorFileWrite(moduleName, "2003", ex.Message, ex.StackTrace);
                Application.Exit();
            }
        }
Esempio n. 2
0
        public async Task <int> UpdateAsync(EmailAlert entity)
        {
            entity.DateCreated   = DateTime.Now;
            entity.DateProcessed = DateTime.Now;
            entity.CreatedBy     = "System";
            using (var connection = new SqlConnection(connString))
            {
                connection.Open();
                var result = await connection.ExecuteAsync("Sp_EmailAlert_Update",
                                                           new
                {
                    entity.Id,
                    entity.Email,
                    entity.Reeson,
                    entity.Status,
                    entity.Message,
                    entity.Subject,
                    entity.UserType,
                    entity.IsActive,
                    entity.Sendtries,
                    entity.CreatedBy,
                    entity.DateCreated,
                    entity.ReceiverName,
                    entity.DateProcessed,
                    entity.BackOfficeUser_SubscriberUser,
                }
                                                           , commandType : CommandType.StoredProcedure);

                return(result);
            }
        }
        public async static Task <string> SendEmailAlert(List <LastContactedDTO> companies)
        {
            var emailConfig = ConfigDictionary.EmailConfig();

            string alertCompanies = string.Empty;

            foreach (LastContactedDTO company in companies)
            {
                alertCompanies += $"<li><b>{ company.CompanyName }</b>: last contacted over <span style='color:red;font-weight:bold;'>{ Math.Floor(company.DaysSinceLastContact) }</span> days ago</li>";
            }

            string messageBody = "<html><body>" +
                                 $"<span style='display:inline-block;'><img src='https://cdn.shopify.com/s/files/applications/75204543d0fec5bbf9e7f1db609e8804_512x512.png?1594118407' style='width:50%;'/><h2>Client Communication Alert</h2></span>" +
                                 $"<p>It has been over 7 days since the following clients were last contacted:</p><br/>" +
                                 $"<ul>{ alertCompanies }</ul>" +
                                 "</body></html>";

            try
            {
                await EmailAlert.SendEmailAlert(new EmailAddress(emailConfig["LastContactedRecipientAddress"]),
                                                $"Client Communication Alert.",
                                                messageBody);

                return("Email sent!");
            }
            catch (Exception exception)
            {
                Console.WriteLine(exception.ToString());

                return("Email failed to send.");
            }
        }
Esempio n. 4
0
        protected void bnReturn_Click(object sender, System.EventArgs e)
        {
            try
            {
                int       code;
                MyContent content = new MyContent(appEnv.GetConnection());
                Account   account = new Account(appEnv.GetConnection());

                content.Insert(cid, Convert.ToInt32(dr["Version"]) + 1, 0,
                               dr["Headline"].ToString(), dr["Source"].ToString(),
                               Convert.ToInt32(dr["Byline"]),
                               dr["Teaser"].ToString(), dr["Body"].ToString(),
                               dr["TagLine"].ToString(),
                               Convert.ToInt32(dr["Editor"]), 0,
                               account.GetAccountID(User.Identity.Name),
                               (code = StatusCodes.RequiresEditing));

                new Distribution(appEnv.GetConnection()).Remove(cid, ver);

                EmailAlert ea = new EmailAlert(Context, code, Convert.ToInt32(dr["Editor"]));
                ea.Send();
            }
            catch (Exception err)
            {
                Page_Error("The following error occured: " + err.Message);
            }

            Response.Redirect("DeployList.aspx");
        }
Esempio n. 5
0
        private void SendEmployeeLeaveDeletionNotificationList()
        {
            try
            {
                List <EmailAlert> emailAlertList = EmailAlert.GetEmployeeLeaveDeletionNotificationList(Convert.ToDateTime(TextBoxStartDate.Text), Convert.ToDateTime(TextBoxEndDate.Text), this.employeeId, DropDownListLeaveType.SelectedItem.Text);

                foreach (EmailAlert emailAlert in emailAlertList)
                {
                    MailMessage mailMessage = new MailMessage(ConfigurationManager.AppSettings["administrationEmailAddress"].ToString(), emailAlert.EmailAddress /*"*****@*****.**"*/);

                    mailMessage.Subject    = emailAlert.EmailSubject;
                    mailMessage.Body       = emailAlert.EmailBody;
                    mailMessage.IsBodyHtml = true;

                    SmtpClient smtpClient = new SmtpClient(ConfigurationManager.AppSettings["mailRelay"].ToString());
                    smtpClient.Port        = Convert.ToInt32(ConfigurationManager.AppSettings["port"]);
                    smtpClient.Credentials = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["administrationEmailAddress"].ToString(), ConfigurationManager.AppSettings["password"].ToString());
                    smtpClient.EnableSsl   = true;
                    smtpClient.Send(mailMessage);
                }
            }
            catch (Exception ex)
            {
                LabelError.Text    = "";
                LabelError.Text   += ex.Message;
                PanelError.Visible = true;
            }
        }
        private void bnWithdraw_Click(object sender, System.EventArgs e)
        {
            try
            {
                int     code;
                Content content = new Content(appEnv.GetConnection());
                Account account = new Account(appEnv.GetConnection());

                DataRow dr = dt.Rows[0];

                content.Insert(cid, Convert.ToInt32(dr["Version"]) + 1, 0,
                               dr["Headline"].ToString(), dr["Source"].ToString(),
                               Convert.ToInt32(dr["Byline"]),
                               dr["Teaser"].ToString(), dr["Body"].ToString(),
                               dr["TagLine"].ToString(), 0,
                               Convert.ToInt32(dr["Approver"]),
                               account.GetAccountID(User.Identity.Name),
                               (code = StatusCodes.AwaitingEdit));

                EmailAlert ea = new EmailAlert(Context, code, 0);
                ea.Send();
            }
            catch (Exception err)
            {
                Page_Error("The following error occured: " + err.Message);
            }

            Response.Redirect("EdList.aspx");
        }
Esempio n. 7
0
        public Mainform()
        {
            InitializeComponent();

            emailalertclient           = new EmailAlert();
            notificationTimer.Tick    += new EventHandler(notificationTimer_Tick);
            notificationTimer.Interval = 2000;
        }
Esempio n. 8
0
    private void sendReceipt()
    {
        var message = new StringBuilder();
        email.RenderControl(new HtmlTextWriter(new StringWriter(message)));

        string s = message.ToString();

        EmailAlert alerter = new EmailAlert();

        alerter.sendEmail(GenericQuery.getUserEmail(User.Identity.Name), "Web Shop Receipt", s);
    }
Esempio n. 9
0
 public SettingsController()
 {
     this.pdata         = new ProfileData();
     this.ealert        = new EmailAlert();
     this.sellerData    = new SellerData();
     this.dashboardData = new DashboardData();
     _version           = ConfigurationManager.AppSettings["ApiVersion"];
     _api             = ConfigurationManager.AppSettings["Url"];
     _redirecturi     = ConfigurationManager.AppSettings["LwaRedirectUrl"];
     _clientkey       = ConfigurationManager.AppSettings["ClientKey"];
     _clientSecretkey = ConfigurationManager.AppSettings["ClientSecretKey"];
 }
Esempio n. 10
0
 protected void Page_Load(object sender, EventArgs e)
 {
     EmailAlert instance = new EmailAlert();
     bool test = instance.sendEmail("*****@*****.**", "Very Important thing", "DO IT NOW");
     if (test == true)
     {
         ShowPopUpMsg("True");
     }
     else
     {
         ShowPopUpMsg("False");
     }
 }
Esempio n. 11
0
 public void ClearLists()
 {
     Hunt.Clear();
     Caution.Clear();
     Danger.Clear();
     Alert.Clear();
     GlobalHunt.Clear();
     GlobalCaution.Clear();
     GlobalDanger.Clear();
     GlobalAlert.Clear();
     EmailAlert.Clear();
     WieldedItems.Clear();
 }
Esempio n. 12
0
        private void bnSubmit_Click(object sender, System.EventArgs e)
        {
            int code;

            content.SetStatus(Convert.ToInt32(dt.Rows[0]["ContentID"]),
                              Convert.ToInt32(dt.Rows[0]["Version"]),
                              (code = StatusCodes.AwaitingApproval));

            EmailAlert ea = new EmailAlert(Context, code, 0);

            ea.Send();

            Response.Redirect("EdList.aspx");
        }
Esempio n. 13
0
        // To protect from overposting attacks, see https://aka.ms/RazorPagesCRUD
        public async Task <IActionResult> OnPostAsync()
        {
            if (!ModelState.IsValid)
            {
                return(Page());
            }

            _context.Ticket.Add(Ticket);
            await _context.SaveChangesAsync();

            EmailAlert.Send("ticket created " + Ticket.TicketId, "ticket created " + Ticket.TicketId, "Chris Peck", "*****@*****.**");

            return(RedirectToPage("./Index"));
        }
Esempio n. 14
0
        protected void bnApprove_Click(object sender, System.EventArgs e)
        {
            Account account = new Account(appEnv.GetConnection());

            content.SetApproval(Convert.ToInt32(dt.Rows[0]["ContentID"]),
                                Convert.ToInt32(dt.Rows[0]["Version"]),
                                account.GetAccountID(User.Identity.Name));

            EmailAlert ea = new EmailAlert(Context, StatusCodes.Approved, 0);

            ea.Send();

            Response.Redirect("AppList.aspx");
        }
Esempio n. 15
0
        protected void bnReturn_Click(object sender, System.EventArgs e)
        {
            int code;

            content.SetStatus(Convert.ToInt32(dt.Rows[0]["ContentID"]),
                              Convert.ToInt32(dt.Rows[0]["Version"]),
                              (code = StatusCodes.RequiresEditing));

            EmailAlert ea = new EmailAlert(Context, code, Convert.ToInt32(dt.Rows[0]["Editor"]));

            ea.Send();

            Response.Redirect("AppList.aspx");
        }
Esempio n. 16
0
        protected void bnSubmit_Click(object sender, System.EventArgs e)
        {
            int code;

            content = new MyContent(appEnv.GetConnection());
            content.SetStatus(Convert.ToInt32(dt.Rows[0]["ContentID"]),
                              Convert.ToInt32(dt.Rows[0]["Version"]),
                              (code = StatusCodes.RequiresUpdate));

            EmailAlert ea = new EmailAlert(Context, code, Convert.ToInt32(dt.Rows[0]["ByLine"]));

            ea.Send();

            Response.Redirect("EdList.aspx");
        }
Esempio n. 17
0
        public void ClearArrays()
        {
            Hunt.Clear();
            Caution.Clear();
            Danger.Clear();
            Alert.Clear();
            GlobalHunt.Clear();
            GlobalCaution.Clear();
            GlobalDanger.Clear();
            GlobalAlert.Clear();
            EmailAlert.Clear();
            WieldedItems.Clear();

            //            OffhandItem.Clear();
        }
Esempio n. 18
0
        protected void bnSubmit_Click(object sender, System.EventArgs e)
        {
            int code;

            content.SetStatus(Convert.ToInt32(dt.Rows[0]["ContentID"]),
                              Convert.ToInt32(dt.Rows[0]["Version"]),
                              (code = (Convert.ToInt32(dt.Rows[0]["Editor"]) == 0)?
                                      StatusCodes.AwaitingEdit : StatusCodes.Editing));
            //  Any Editor              or Specific Editor

            EmailAlert ea = new EmailAlert(Context, code, Convert.ToInt32(dt.Rows[0]["Editor"]));

            ea.Send();

            Response.Redirect("AutList.aspx");
        }
Esempio n. 19
0
        private bool CreateJob(SPWebApplication site)
        {
            bool jobCreated = false;

            try
            {
                EmailAlert       job      = new EmailAlert(JobName, site);
                SPMinuteSchedule schedule = new SPMinuteSchedule();
                schedule.BeginSecond = 0;
                schedule.EndSecond   = 59;
                schedule.Interval    = 10;

                job.Schedule = schedule;
                job.Update();
            }
            catch (Exception)
            {
                return(jobCreated);
            }
            return(jobCreated);
        }
        public async Task <HttpStatusCode> Execute(object properties)
        {
            if (properties == null)
            {
                throw new ArgumentNullException(nameof(properties));
            }

            EmailAlert props = (EmailAlert)properties;

            var apiKey = Environment.GetEnvironmentVariable(this.config.EnvApiKey, EnvironmentVariableTarget.User);
            var client = new SendGridClient(apiKey);

            var from = new EmailAddress(this.config.SenderEmail, this.config.SenderName);
            var to   = new EmailAddress(props.ReceiverEmail, props.ReceiverName);

            var msg      = MailHelper.CreateSingleEmail(from, to, props.Subject, props.TextContent, props.HtmlContent);
            var response = await client.SendEmailAsync(msg);

            Console.WriteLine(response.Body.ReadAsStringAsync().Result);
            return(response.StatusCode);
        }
Esempio n. 21
0
        private void SendEmployeeLeaveApprovalNotificationList(string attachmentPath)
        {
            try
            {
                List <EmailAlert> emailAlertList = EmailAlert.GetEmployeeLeaveApprovalNotificationList(Convert.ToInt32(DropDownListFinancialPeriod.SelectedValue), Convert.ToDateTime(TextBoxStartDate.Text), Convert.ToDateTime(TextBoxEndDate.Text), this.employeeId, DropDownListLeaveType.SelectedItem.Text);

                Attachment attachment = null;
                if (attachmentPath.Length > 0)
                {
                    attachment = new Attachment(attachmentPath);
                }

                foreach (EmailAlert emailAlert in emailAlertList)
                {
                    MailMessage mailMessage = new MailMessage(ConfigurationManager.AppSettings["administrationEmailAddress"].ToString(), emailAlert.EmailAddress /*"*****@*****.**"*/);

                    mailMessage.Subject    = emailAlert.EmailSubject;
                    mailMessage.Body       = emailAlert.EmailBody;
                    mailMessage.IsBodyHtml = true;

                    if (attachmentPath.Length > 0)
                    {
                        mailMessage.Attachments.Add(attachment);
                    }

                    SmtpClient smtpClient = new SmtpClient(ConfigurationManager.AppSettings["mailRelay"].ToString());
                    smtpClient.Port        = Convert.ToInt32(ConfigurationManager.AppSettings["port"]);
                    smtpClient.Credentials = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["administrationEmailAddress"].ToString(), ConfigurationManager.AppSettings["password"].ToString());
                    smtpClient.EnableSsl   = true;
                    smtpClient.Send(mailMessage);
                }
            }
            catch (Exception ex)
            {
                LabelError.Text    = "";
                LabelError.Text   += ex.Message /* + " - " + ex.InnerException.ToString()*/;
                PanelError.Visible = true;
            }
        }
Esempio n. 22
0
        public async Task <int> AddAsync(EmailAlert entity)
        {
            int result = 0;

            try
            {
                using (var connection = new SqlConnection(connString))
                {
                    entity.DateCreated   = DateTime.Now;
                    entity.DateProcessed = DateTime.Now;
                    connection.Open();
                    result = await connection.ExecuteAsync("Sp_EmailAlert_Insert",
                                                           new
                    {
                        entity.Email,
                        entity.Reeson,
                        entity.Status,
                        entity.Message,
                        entity.Subject,
                        entity.UserType,
                        entity.IsActive,
                        entity.Sendtries,
                        entity.CreatedBy,
                        entity.DateCreated,
                        entity.ReceiverName,
                        entity.DateProcessed,
                        entity.BackOfficeUser_SubscriberUser,
                    },
                                                           commandType : CommandType.StoredProcedure);

                    return(result);
                }
            }
            catch (Exception ex)
            {
                ex.Message.ToString();
                return(result);
            }
        }
Esempio n. 23
0
        public async static Task <string> SendEmailAlert(DailyImpressionsDTO dailyImpressionsSummary)
        {
            Dictionary <string, string> emailConfig = ConfigDictionary.EmailConfig();

            string companies = string.Empty;

            foreach (CompanyDailyImpressionsSummary company in dailyImpressionsSummary.DailyImpressionsSummary)
            {
                string failingCampaigns = string.Empty;

                foreach (CampaignDailyImpressionsSummary campaign in company.Campaigns)
                {
                    failingCampaigns += $"<li>{ campaign.Name }: <span style='color:red;font-weight:bold;'>{ campaign.Impressions }</span> impressions</li>";
                }

                companies += $"<li><b>{ company.Name }</b>: <ul>{ failingCampaigns }</ul></li>";
            }

            string messageBody = "<html><body>" +
                                 $"<span style='display:inline-block;'><img src='https://cdn.shopify.com/s/files/applications/75204543d0fec5bbf9e7f1db609e8804_512x512.png?1594118407' style='width:50%;'/><h2>Google Ads Campaign Alert</h2></span>" +
                                 $"<p>The following campaigns achieved fewer than 100 impressions yesterday:</p><br/>" +
                                 $"<ul>{ companies }</ul>" +
                                 "</body></html>";

            try
            {
                await EmailAlert.SendEmailAlert(new EmailAddress(emailConfig["GoogleAdsRecipientAddress"]),
                                                $"Google Ads Campaign Alert",
                                                messageBody);

                return("Email sent!");
            }
            catch (Exception exception)
            {
                Console.WriteLine(exception.ToString());

                return("Email failed to send.");
            }
        }
Esempio n. 24
0
        private void bnReturn_Click(object sender, System.EventArgs e)
        {
            int     code;
            Account account = new Account(appEnv.GetConnection());

            content.SetApproval(Convert.ToInt32(dt.Rows[0]["ContentID"]),
                                Convert.ToInt32(dt.Rows[0]["Version"]),
                                account.GetAccountID(User.Identity.Name));
            content.SetStatus(Convert.ToInt32(dt.Rows[0]["ContentID"]),
                              Convert.ToInt32(dt.Rows[0]["Version"]),
                              (code = StatusCodes.Discontinued));

            EmailAlert ea = new EmailAlert(Context, code, Convert.ToInt32(dt.Rows[0]["Editor"]));

            ea.Body = tbEdReason.Text;
            ea.Send();

            ea      = new EmailAlert(Context, code, Convert.ToInt32(dt.Rows[0]["ByLine"]));
            ea.Body = tbAutReason.Text;
            ea.Send();

            Response.Redirect("AppList.aspx");
        }
Esempio n. 25
0
 public SellerController()
 {
     this.adata        = new AdminData();
     this.emailalert   = new EmailAlert();
     this.optimizeData = new OptimizeData();
 }
Esempio n. 26
0
        private IMonitor PopulateConfigurationDataFromServerInfo(AddServer addServerForm)
        {
            List<CAlert> alerts = new List<CAlert>(2);
            //Boolean alertsExist = addServerForm.GetAlerts(out alerts);
            //alerts =
            if (addServerForm.addServerAlertEmailOption.CheckState == CheckState.Checked)
            {
                EmailAlert ealert = new EmailAlert { Info = addServerForm.addServerAlertEmailTextBox.Text };
                if (!configurationData.Settings.IsDefaultAlert(ealert))
                    alerts.Add(ealert);
            }
            if (addServerForm.addServerAlertSmsOption.CheckState == CheckState.Checked)
            {
                SmsAlert salert = new SmsAlert { Info = addServerForm.addServerAlertSmsTextBox.Text };
                if (!configurationData.Settings.IsDefaultAlert(salert))
                    alerts.Add(salert);
            }

            Boolean alertsExist = alerts.Count > 0 && (addServerForm.addServerAlertEmailOption.Checked | addServerForm.addServerAlertSmsOption.Checked);
            try
            {
                switch (addServerForm.ReturnValue)
                {
                    case FullMonitorType.Basic:
                        #region Basic
                        BasicMonitor basicMonitor = addServerForm.GetBasicMonitor();
                        if (alertsExist)
                        {
                            foreach (CAlert alert in alerts)
                            {
                                //if (!configurationData.Settings.IsDefaultAlert(alert))
                                //{
                                    basicMonitor.AlertInfo.Add(alert);
                                //}
                            }
                        }
                        //else
                        //{
                        //    basicMonitor.AlertInfo.AddRange(configurationData.Settings.DefaultAlerts);
                        //}
                        if (addServerForm.Tag == null)
                            configurationData.BasicMonitors.Add(basicMonitor);
                        else
                        {
                            configurationData.BasicMonitors.Remove(addServerForm.Tag.ToString());
                            configurationData.BasicMonitors.Add(basicMonitor);
                        }
                        configurationData.ExportToXml(_configPath);
                        MonitorScheduler.Scheduler.SetMonitors(configurationData);
                        return basicMonitor;
                        #endregion
                    case FullMonitorType.Common:
                        #region Common

                        /*
                         * - Hard Drive Usage (dropdown list of C:\, D:\, etc)
                         * - Memory Usage
                         * - Swap/page file usage
                         * - CPU Usage
                         * - Process State (e.g. explorer.exe)
                         * - Service State (e.g. Intelligent Background Transfer Service)
                         */
                        List<CAlert> validAlerts = new List<CAlert>(2);
                        if (alertsExist)
                        {
                            foreach (CAlert alert in alerts)
                            {
                                //if (!configurationData.Settings.IsDefaultAlert(alert))
                                //{
                                    validAlerts.Add(alert);
                                //}
                            }
                        }

                        switch (addServerForm.CommonType)
                        {
                            case CommonMonitorType.HddUsage: //Pfc
                                PfcMonitor hddUsage = (PfcMonitor) addServerForm.GetCommonMonitor();
                                hddUsage.AlertInfo.AddRange(validAlerts);
                                if (addServerForm.Tag == null)
                                    configurationData.PfcMonitors.Add(hddUsage);
                                else
                                {
                                    configurationData.PfcMonitors.Remove(addServerForm.Tag.ToString());
                                    configurationData.PfcMonitors.Add(hddUsage);
                                }
                                //if (!alertsExist)
                                //{
                                //    hddUsage.AlertInfo.AddRange(configurationData.Settings.DefaultAlerts);
                                //}
                                configurationData.ExportToXml(_configPath);
                                MonitorScheduler.Scheduler.SetMonitors(configurationData);
                                return hddUsage;
                            case CommonMonitorType.CpuUsage: //Pfc
                                PfcMonitor cpuUsage = (PfcMonitor) addServerForm.GetCommonMonitor();
                                cpuUsage.AlertInfo.AddRange(validAlerts);
                                if (addServerForm.Tag == null)
                                    configurationData.PfcMonitors.Add(cpuUsage);
                                else
                                {
                                    configurationData.PfcMonitors.Remove(addServerForm.Tag.ToString());
                                    configurationData.PfcMonitors.Add(cpuUsage);
                                }
                                //if (!alertsExist)
                                //{
                                //    cpuUsage.AlertInfo.AddRange(configurationData.Settings.DefaultAlerts);
                                //}
                                configurationData.ExportToXml(_configPath);
                                MonitorScheduler.Scheduler.SetMonitors(configurationData);
                                return cpuUsage;
                            case CommonMonitorType.MemoryUsage: //Wmi
                                WmiMonitor memoryUsage = (WmiMonitor) addServerForm.GetCommonMonitor();
                                memoryUsage.AlertInfo.AddRange(validAlerts);
                                if (addServerForm.Tag == null)
                                    configurationData.WmiMonitors.Add(memoryUsage);
                                else
                                {
                                    configurationData.WmiMonitors.Remove(addServerForm.Tag.ToString());
                                    configurationData.WmiMonitors.Add(memoryUsage);
                                }
                                //if (!alertsExist)
                                //{
                                //    memoryUsage.AlertInfo.AddRange(configurationData.Settings.DefaultAlerts);
                                //}
                                configurationData.ExportToXml(_configPath);
                                MonitorScheduler.Scheduler.SetMonitors(configurationData);
                                return memoryUsage;
                            case CommonMonitorType.ProcessState: //Pfc
                                PfcMonitor processState = (PfcMonitor) addServerForm.GetCommonMonitor();
                                processState.AlertInfo.AddRange(validAlerts);
                                if (addServerForm.Tag == null)
                                    configurationData.PfcMonitors.Add(processState);
                                else
                                {
                                    configurationData.PfcMonitors.Remove(addServerForm.Tag.ToString());
                                    configurationData.PfcMonitors.Add(processState);
                                }
                                //if (!alertsExist)
                                //{
                                //    processState.AlertInfo.AddRange(configurationData.Settings.DefaultAlerts);
                                //}
                                configurationData.ExportToXml(_configPath);
                                MonitorScheduler.Scheduler.SetMonitors(configurationData);
                                return processState;
                            case CommonMonitorType.ServiceState: //Service
                                ServiceMonitor serviceState = (ServiceMonitor) addServerForm.GetCommonMonitor();
                                serviceState.AlertInfo.AddRange(validAlerts);
                                if (addServerForm.Tag == null)
                                    configurationData.ServiceMonitors.Add(serviceState);
                                else
                                {
                                    configurationData.ServiceMonitors.Remove(addServerForm.Tag.ToString());
                                    configurationData.ServiceMonitors.Add(serviceState);
                                }
                                //if (!alertsExist)
                                //{
                                //    serviceState.AlertInfo.AddRange(configurationData.Settings.DefaultAlerts);
                                //}
                                configurationData.ExportToXml(_configPath);
                                MonitorScheduler.Scheduler.SetMonitors(configurationData);
                                return serviceState;
                            case CommonMonitorType.SwapFileUsage: //Pfc
                                PfcMonitor swapFileUsage = (PfcMonitor) addServerForm.GetCommonMonitor();
                                swapFileUsage.AlertInfo.AddRange(validAlerts);
                                if (addServerForm.Tag == null)
                                    configurationData.PfcMonitors.Add(swapFileUsage);
                                else
                                {
                                    configurationData.PfcMonitors.Remove(addServerForm.Tag.ToString());
                                    configurationData.PfcMonitors.Add(swapFileUsage);
                                }
                                //if (!alertsExist)
                                //{
                                //    swapFileUsage.AlertInfo.AddRange(configurationData.Settings.DefaultAlerts);
                                //}
                                configurationData.ExportToXml(_configPath);
                                MonitorScheduler.Scheduler.SetMonitors(configurationData);
                                return swapFileUsage;
                            case CommonMonitorType.None:
                            default:
                                Logger.Instance.Log(this.GetType(), LogType.Info,
                                                    "CommonType had an invalid value: unable to populate a Monitor correctly");
                                break;
                        }
                        return null;

                        #endregion
                    case FullMonitorType.EventLog:
                        #region Events
                        EventMonitor eventMonitor = addServerForm.GetEventMonitor();
                        if (alertsExist)
                        {
                            foreach (CAlert alert in alerts)
                            {
                                //if (!configurationData.Settings.IsDefaultAlert(alert))
                                //{
                                    eventMonitor.AlertInfo.Add(alert);
                                //}
                            }
                        }
                        //else
                        //{
                        //    eventMonitor.AlertInfo.AddRange(configurationData.Settings.DefaultAlerts);
                        //}
                        if (addServerForm.Tag == null)
                            configurationData.EventMonitors.Add(eventMonitor);
                        else
                        {
                            configurationData.EventMonitors.Remove(addServerForm.Tag.ToString());
                            configurationData.EventMonitors.Add(eventMonitor);
                        }
                        configurationData.ExportToXml(_configPath);
                        MonitorScheduler.Scheduler.SetMonitors(configurationData);
                        return eventMonitor;
                        #endregion
                    case FullMonitorType.PerformanceCounter:
                        #region PerfCounters

                        PfcMonitor pfcMonitor = addServerForm.GetPfcMonitor();
                        if (alertsExist)
                        {
                            foreach (CAlert alert in alerts)
                            {
                                //if (!configurationData.Settings.IsDefaultAlert(alert))
                                //{
                                    pfcMonitor.AlertInfo.Add(alert);
                                //}
                            }
                        }
                        //else
                        //{
                        //    pfcMonitor.AlertInfo.AddRange(configurationData.Settings.DefaultAlerts);
                        //}
                        if (addServerForm.Tag == null)
                            configurationData.PfcMonitors.Add(pfcMonitor);
                        else
                        {
                            configurationData.PfcMonitors.Remove(addServerForm.Tag.ToString());
                            configurationData.PfcMonitors.Add(pfcMonitor);
                        }
                        configurationData.ExportToXml(_configPath);
                        MonitorScheduler.Scheduler.SetMonitors(configurationData);
                        return pfcMonitor;

                        #endregion
                    case FullMonitorType.Service:
                        #region Services

                        ServiceMonitor serviceMonitor = addServerForm.GetServiceMonitor();
                        if (alertsExist)
                        {
                            foreach (CAlert alert in alerts)
                            {
                                //if (!configurationData.Settings.IsDefaultAlert(alert))
                                //{
                                    serviceMonitor.AlertInfo.Add(alert);
                                //}
                            }
                        }
                        //else
                        //{
                        //    serviceMonitor.AlertInfo.AddRange(configurationData.Settings.DefaultAlerts);
                        //}
                        if (addServerForm.Tag == null)
                            configurationData.ServiceMonitors.Add(serviceMonitor);
                        else
                        {
                            configurationData.ServiceMonitors.Remove(addServerForm.Tag.ToString());
                            configurationData.ServiceMonitors.Add(serviceMonitor);
                        }
                        configurationData.ExportToXml(_configPath);
                        MonitorScheduler.Scheduler.SetMonitors(configurationData);
                        return serviceMonitor;

                        #endregion
                    case FullMonitorType.Wmi:
                        #region Wmi (For future use)

                        WmiMonitor wmiMonitor = (WmiMonitor)addServerForm.GetCommonMonitor();
                        //NOTE: need a GetWmiMonitor() later on, potentially
                        if (alertsExist)
                        {
                            foreach (CAlert alert in alerts)
                            {
                                //if (!configurationData.Settings.IsDefaultAlert(alert))
                                //{
                                    wmiMonitor.AlertInfo.Add(alert);
                                //}
                            }
                        }
                        //else
                        //{
                        //    wmiMonitor.AlertInfo.AddRange(configurationData.Settings.DefaultAlerts);
                        //}
                        if (addServerForm.Tag == null)
                            configurationData.WmiMonitors.Add(wmiMonitor);
                        else
                        {
                            configurationData.WmiMonitors.Remove(addServerForm.Tag.ToString());
                            configurationData.WmiMonitors.Add(wmiMonitor);
                        }
                        configurationData.ExportToXml(_configPath);
                        MonitorScheduler.Scheduler.SetMonitors(configurationData);
                        return wmiMonitor;

                        #endregion
                    case FullMonitorType.None:
                    default:
                        return null;
                }

            }
            catch (Exception ex)
            {
                Logger.Instance.LogException(this.GetType(), ex);
                MessageBox.Show(this, "Unable to save the Monitor, please check the log for details.",
                                "Error Saving Monitor", MessageBoxButtons.OK);
                return null;
            }
        }
Esempio n. 27
0
        /// <summary>
        /// Email����������Ϣ��ȡ��
        /// </summary>
        /// <param name="AccessInformation"></param>
        /// <param name="AlertIndex"></param>
        /// <returns></returns>
        public GetEmailAlertResult GetEmailAlert(AccessControl AccessInformation, string AlertIndex)
        {
            GetEmailAlertResult Result = new GetEmailAlertResult();
            EmailAlert email = new EmailAlert();
            string estr = "";
            bool ret = true;

            ret = GetAccessControlInformation(AccessInformation);
            if (!ret)
            {
                estr = keytext[ErrorInfo.AccessControlError.ToString()];
            }

            string strServer = "localhost";
            string strUser = "******";

            if (AccessInformation.LimitServer)
            {
                strServer = AccessInformation.SVDBServer;
            }

            if (AccessInformation.LimitUser)
            {
                strUser = AccessInformation.UserID;
            }

            while (ret)
            {
                if (this.iniFile == null)
                {
                    this.iniFile = new IniFileDaoImpl();
                }
                IDictionary<string, NameValueCollection> sectionlists = this.iniFile.GetIniFileBySection("alert.ini", AlertIndex);
                email.BaseInfo = GetIniBaseAlertInfo(AlertIndex, sectionlists);
                email.EmailAddresss = sectionlists[AlertIndex]["EmailAdress"];
                email.OtherAddress = sectionlists[AlertIndex]["OtherAdress"];
                email.EmailTemplate = sectionlists[AlertIndex]["EmailTemplate"];
                email.UpgradeTimes = sectionlists[AlertIndex]["Upgrade"];
                email.ReceiverAddress = sectionlists[AlertIndex]["UpgradeTo"];
                email.StopTimes = sectionlists[AlertIndex]["Stop"];
                email.WatchSheet = sectionlists[AlertIndex]["WatchSheet"];
                break;
            }
            Result.ErrorInformation = estr;
            Result.GetEmailAlertOK = ret;
            Result.ResponseData = email;
            return Result;
        }
Esempio n. 28
0
        public ActionResult AddUser(AddUser newUser)
        {
            using (mmpEntities mP = new mmpEntities())
            {
                ViewBag.roles       = mP.roles.ToList <role>();
                ViewBag.regions     = mP.regions.ToList <region>();
                ViewBag.supervisors = mP.users.Where(a => a.role_id == mP.roles.FirstOrDefault(x => x.role_name == "supervisor").role_id).ToList <user>();
                ViewBag.departments = mP.category_type_details.Where(x => x.category_id == (mP.categories.FirstOrDefault(z => z.category_name == "departments").category_id)).ToList <category_type_details>();
                ViewBag.projects    = mP.category_type_details.Where(x => x.category_id == (mP.categories.FirstOrDefault(z => z.category_name == "projects").category_id)).ToList <category_type_details>();

                ViewBag.supervisorsl = mP.users.Where(a => a.role_id == mP.roles.FirstOrDefault(x => x.role_name == "supervisor").role_id&& a.user_status == "active").Select(p => new SelectListItem()
                {
                    Text  = p.employee_id + "    " + p.user_name,
                    Value = p.user_id.ToString()
                }).ToList();

                #region Employee ID Already Exists
                var isEmployeeIDExists = isEmployeeIDExist(newUser.employee_id);
                if (isEmployeeIDExists)
                {
                    ModelState.AddModelError("EmployeeExist", "Employee already exists");
                    return(View(newUser));
                }
                #endregion

                /*#region User Already Exists
                 * var isUserExists = isUserExist(newUser.user_name);
                 * if (isUserExists)
                 * {
                 *  ModelState.AddModelError("UserExist", "User already exists");
                 *  return View(newUser);
                 * }
                 #endregion*/

                #region Email Already exists
                var isEmailExists = IsEmailExist(newUser.user_email);
                if (isEmailExists)
                {
                    ModelState.AddModelError("EmailExist", "Email already exists");
                    newUser.user_name = "Enter New Name";
                    return(View(newUser));
                }
                #endregion

                if (ModelState.IsValid)
                {
                    ModelState.AddModelError("UserExist", "User already exists");

                    #region Password Hashing
                    newUser.user_password   = Crypto.Hash(newUser.user_password);
                    newUser.confirmPassword = Crypto.Hash(newUser.confirmPassword);
                    #endregion

                    user user = new user()
                    {
                        role_id                 = newUser.role_id,
                        employee_id             = newUser.employee_id,
                        user_name               = newUser.user_name,
                        user_email              = newUser.user_email,
                        designation             = newUser.designation,
                        user_password           = newUser.user_password,
                        created_at              = DateTime.Now,
                        supervisor              = newUser.supervisor,
                        region_id               = newUser.region_id,
                        user_primary_department = newUser.user_primary_department,
                        user_primary_project    = newUser.user_primary_project,
                        user_status             = "active",
                        join_date               = newUser.joining_date
                    };

                    mP.users.Add(user);

                    //var timesheet = mP.timesheet_mr.Where(x => x.tsmr_valid_till > DateTime.Now && x.tsmr_start_date < DateTime.Now).FirstOrDefault<timesheet_mr>();
                    var timesheets = mP.timesheet_mr.Where(x => x.tsmr_valid_till > user.join_date).ToList <timesheet_mr>();
                    foreach (timesheet_mr timesheet in timesheets)
                    {
                        string body;
                        if (timesheet != null)
                        {
                            timesheet ts = new timesheet()
                            {
                                timesheet_user   = user.user_id,
                                time_my          = DateTime.Now,
                                timesheet_status = "saved",
                                timesheet_caller = timesheet.tsmr_id,
                                tsmr_extension   = timesheet.tsmr_valid_till > DateTime.Now ? timesheet.tsmr_valid_till : DateTime.Now.AddDays(-1)
                            };
                            mP.timesheets.Add(ts);


                            foreach (DateTime day in EachDay(timesheet.tsmr_start_date, timesheet.tsmr_valid_till))
                            {
                                presence ps = new presence()
                                {
                                    p_date       = day,
                                    total_hours  = 0,
                                    leave_status = "",
                                    user_id      = user.user_id
                                };
                                mP.presences.Add(ps);
                            }


                            body = "<br></br>" + user.user_name + ", New TimeSheet is assigned to you. TimeSheet is valid Till " + timesheet.tsmr_valid_till + ". Visit the following website to access timeSheet<br></br>" +
                                   "<a href='http://magcom-001-site3.etempurl.com'>http://magcom-001-site3.etempurl.com</a>";

                            Task.Run(() => EmailAlert.SendEmail(user.user_email, body));
                        }
                    }

                    #region Save to Database
                    mP.SaveChanges();
                    #endregion

                    return(Json(new { success = true, message = "Saved Successfully" }));
                }
                else
                {
                    return(Json(new { success = true, message = "Invalid Request" }));
                }
            }
        }
Esempio n. 29
0
        /// <summary>
        /// 
        /// </summary>
        /// <param name="AccessInformation"></param>
        /// <param name="AlertInformation"></param>
        /// <returns></returns>
        public UpdateAlertResult UpdateEmailAlert(AccessControl AccessInformation, EmailAlert AlertInformation,bool checkname)
        {
            UpdateAlertResult Result = new UpdateAlertResult();
            string estr = "";
            bool ret = true;
            string strServer = "";
            string strUser = "";

            while (ret)
            {

                ret = GetAccessControlInformation(AccessInformation);
                if (!ret)
                {
                    estr = keytext[ErrorInfo.AccessControlError.ToString()];
                }

                strServer = "localhost";
                strUser = "******";

                if (AccessInformation.LimitServer)
                {
                    strServer = AccessInformation.SVDBServer;
                }

                if (AccessInformation.LimitUser)
                {
                    strUser = AccessInformation.UserID;
                }
                if (checkname)
                {
                    if (IsAlertNameExist(AccessInformation, AlertInformation.BaseInfo.Name))
                    {
                        ret = false;
                        estr = keytext[ErrorInfo.AlertNameError.ToString()];
                        break;
                    }
                }
                //email����
                //if (string.IsNullOrEmpty(AlertInformation.EmailAddresss))
                //{
                //    ret = false;
                //    estr = keytext[ErrorInfo.EmailAddresssError.ToString()];
                //    break;
                //}

                //if (!string.IsNullOrEmpty(AlertInformation.EmailAddresss))
                //{
                //    if (!CheckEmail(AlertInformation.OtherAddress))
                //    {
                //        ret = false;
                //        estr = keytext[ErrorInfo.EmailAddresssError.ToString()];
                //        break;
                //    }
                //}

                if (!string.IsNullOrEmpty(AlertInformation.UpgradeTimes))
                {

                    if (!IsAlphaNumber(AlertInformation.UpgradeTimes))
                    {
                        ret = false;
                        estr = keytext[ErrorInfo.AlertTimesError.ToString()];
                        break;
                    }
                }

                if (!string.IsNullOrEmpty(AlertInformation.StopTimes))
                {
                    if (!IsAlphaNumber(AlertInformation.StopTimes))
                    {
                        ret = false;
                        estr = keytext[ErrorInfo.AlertTimesError.ToString()];
                        break;
                    }
                }

                break;
            }
            string strAlertIndex = "";

            while (ret)
            {
                strAlertIndex = AlertInformation.BaseInfo.ID;
                //���ݴ洢����
                ret = SetIniBaseAlertInfo(AccessInformation, AlertInformation.BaseInfo, estr);

                if (!ret)
                {
                    break;
                }

                //email����
                if (this.iniFile == null)
                {
                    this.iniFile = new IniFileDaoImpl();
                }
                this.iniFile.WriteIniFileString("alert.ini", strAlertIndex, "EmailAdress", AlertInformation.EmailAddresss);
                this.iniFile.WriteIniFileString("alert.ini", strAlertIndex, "OtherAdress", AlertInformation.OtherAddress);
                this.iniFile.WriteIniFileString("alert.ini", strAlertIndex, "EmailTemplate", AlertInformation.EmailTemplate);
                this.iniFile.WriteIniFileString("alert.ini", strAlertIndex, "WatchSheet", AlertInformation.WatchSheet);

                this.iniFile.WriteIniFileString("alert.ini", strAlertIndex, "Upgrade", AlertInformation.UpgradeTimes);
                this.iniFile.WriteIniFileString("alert.ini", strAlertIndex, "UpgradeTo", AlertInformation.ReceiverAddress);
                this.iniFile.WriteIniFileString("alert.ini", strAlertIndex, "Stop", AlertInformation.StopTimes);

                if (queue == null)
                {
                    this.queue = new QueueDaoImpl();
                }
                //send message to service
                bool meseagebool = this.queue.PushStringMessage("SiteView70-Alert", "IniChange", "alert.ini," + strAlertIndex + ",EDIT");

                if (!meseagebool)
                {
                    estr = keytext[ErrorInfo.PushMessageError.ToString()];
                }

                break;
            }

            Result.ErrorInformation = estr;
            Result.UpdateAlertOK = ret;
            return Result;
        }
Esempio n. 30
0
        public void Run_Test(int radiobutton , int addons)
        {
            driver.Navigate().GoToUrl("https://secure.safebytes.com/driverassist/14/register/?an=DRIV&ec=0&os=%D0%9C%D0%B0%D0%B9%D0%BA%D1%80%D0%BE%D1%81%D0%BE%D1%84%D1%82%20Windows%208.1%20%D0%9A%D0%BE%D1%80%D0%BF%D0%BE%D1%80%D0%B0%D1%82%D0%B8%D0%B2%D0%BD%D0%B0%D1%8F&osb=64bit&pr=AMD%20FX(tm)-8320%20Eight-Core%20Processor%20&mb=ASUSTeK%20Computer%20INC.%20&vc=NVIDIA%20GeForce%20GT%20630%20%20&ram=15%2C98%20GB&hd=232%2C88%20GB");

            IWebElement query = driver.FindElement(By.CssSelector("button.activate-now"));
            query.SendKeys(Keys.Enter);
            System.Threading.Thread.Sleep(5000);
            switch (radiobutton)
            {
                // Select 2 years plan ( left )
                case 1:
                    driver.FindElement(By.Id("donev")).Click();
                    break;
                // Select 6 months ( center)
                case 2:
                    driver.FindElement(By.Id("twov")).Click();
                    break;
                // Select 1 year ( right)
                case 3:
                    driver.FindElement(By.Id("dthreev")).Click();
                    break;
                // do nothing leave all as is ( preselected both addons )
                case 0:
                    break;
            }
            System.Threading.Thread.Sleep(5000);
            switch (addons)
            {
                case 1:
                    // here we UNselect SAF
                    driver.FindElement(By.XPath("//form[@id='select_form']/div/div[2]/div[3]/div[2]/div[7]/span")).Click();
                    break;
                case 2:
                    // here we UNselect TSC
            driver.FindElement(By.XPath("//form[@id='select_form']/div/div[2]/div[3]/div[2]/div[7]/div[2]/span")).Click();
                    break;

                // here we UNselect SAF + TSC
                case 12:
                    // here we UNselect SAF
                    driver.FindElement(By.XPath("//form[@id='select_form']/div/div[2]/div[3]/div[2]/div[7]/span")).Click();
                    // here we UNselect TSC
                driver.FindElement(By.XPath("//form[@id='select_form']/div/div[2]/div[3]/div[2]/div[7]/div[2]/span")).Click();
                    break;
                // do nothing leave preselected 6 months
                case 0:
                    break;
            }

            //driver.FindElement(By.Id("dthreev")).Click();
            // here we UNselect TSC
            driver.FindElement(By.XPath("//form[@id='select_form']/div/div[2]/div[3]/div[2]/div[7]/div[2]/span")).Click();
            // here we UNselect SAF
            driver.FindElement(By.XPath("//form[@id='select_form']/div/div[2]/div[3]/div[2]/div[7]/span")).Click();

            //query.SendKeys(Keys.Space);

            //driver.FindElement(By.Name("include-driver-updates")).Click();

            // end of selection Addons
            query = driver.FindElement(By.XPath("(//input[@value=' '])[4]"));
            query.SendKeys(Keys.Enter);

            driver.FindElement(By.Id("form_name")).Clear();
            driver.FindElement(By.Id("form_name")).SendKeys("max qa");
            driver.FindElement(By.Id("form_email")).Clear();
            driver.FindElement(By.Id("form_email")).SendKeys("*****@*****.**");
            driver.FindElement(By.Id("form_postal_zip")).Clear();
            driver.FindElement(By.Id("form_postal_zip")).SendKeys("V8V1J9");
            driver.FindElement(By.Id("cc_num")).Clear();
            driver.FindElement(By.Id("cc_num")).SendKeys("4111111111111111");
            new SelectElement(driver.FindElement(By.Id("cc_month"))).SelectByText("04");
            driver.FindElement(By.CssSelector("option[value=\"04\"]")).Click();
            new SelectElement(driver.FindElement(By.Id("cc_year"))).SelectByText("2016");
            driver.FindElement(By.Id("cc")).Clear();
            driver.FindElement(By.Id("cc")).SendKeys("123");
            driver.FindElement(By.Id("submit-button")).Click();
            // ERROR: Caught exception [Error: locator strategy either id or name must be specified explicitly.]
            // ERROR: Caught exception [ERROR: Unsupported command [waitForFrameToLoad | receipt_body | 25000]]
            // ERROR: Caught exception [ERROR: Unsupported command [selectFrame | name=receipt_body | ]]

            // Making sure there is "Thank you " line in receipt
            try
            {
                //make sure it is in the main document right now
                driver.SwitchTo().DefaultContent();

                //find the outer frame, and use switch to frame method
                IWebElement Receipt_iFrame = driver.FindElement(By.Id("receipt_body"));
                driver.SwitchTo().Frame(Receipt_iFrame);

                string thanks_purchase_css_text = driver.FindElement(By.ClassName("thanks-purchase")).Text;
                Assert.IsTrue(Regex.IsMatch(thanks_purchase_css_text, "Thank.You.for.Your.Purchase!"));
            }
            catch (AssertionException e)
            {
                EmailAlert EA = new EmailAlert();
                EA.send_email_alert("Text not found :Thank You for Your Purchase" + e.Message);

                verificationErrors.Append("Text not found :Thank You for Your Purchase");
            }

            // Making sure we got a license on receipt
            try
            {
                //make sure it is in the main document right now
                driver.SwitchTo().DefaultContent();

                //find the outer frame, and use switch to frame method
                IWebElement Receipt_iFrame = driver.FindElement(By.Id("receipt_body"));
                driver.SwitchTo().Frame(Receipt_iFrame);

                Assert.IsTrue(Regex.IsMatch(driver.FindElement(By.CssSelector("body")).Text, ".*[A-Z0-9]{8}-[A-Z0-9]{4}-[A-Z0-9]{4}-[A-Z0-9]{4}-[A-Z0-9]{12}.*"));

            }
            catch (AssertionException e)
            {
                EmailAlert EA = new EmailAlert();
                EA.send_email_alert("License Key Not found!" + e.Message);

                verificationErrors.Append("License Key Not found!");
            }
        }
Esempio n. 31
0
        public async Task CheckAlerts(Message message)
        {
            var sensorId = this.dbContext.Sensors.First(s => s.Label == message.Sensor).Id;

            var deviceSensor = this.dbContext.Devices
                               .Include(d => d.DeviceSensors)
                               .Include(d => d.User)
                               .First(d => d.Id == new Guid(message.DeviceId))
                               .DeviceSensors
                               .FirstOrDefault(ds => ds.SensorId == sensorId &&
                                               ds.DeviceId == new Guid(message.DeviceId));

            if (deviceSensor.IsNotificationOn == false)
            {
                return;
            }

            double?min = deviceSensor?.MinValue;
            double?max = deviceSensor?.MaxValue;

            if (!min.HasValue && !max.HasValue)
            {
                //Console.WriteLine($"No alerts for {message.DeviceId} / {message.Sensor}");
                return;
            }

            if (max.HasValue)
            {
                var lastAlert = this.dbContext.Alerts
                                .OrderByDescending(a => a.AlertStarted)
                                .FirstOrDefault(a => a.DeviceId == new Guid(message.DeviceId) &&
                                                a.SensorId == sensorId &&
                                                a.AlertClosed == null);

                if (max.Value < Convert.ToDouble(message.Value))
                {
                    if (lastAlert == null)
                    {
                        var newAlert = new Alert()
                        {
                            Id              = Guid.NewGuid(),
                            AlertStarted    = message.Time,
                            AlertType       = AlertTypeEnum.Above_Max_Value,
                            DeviceId        = new Guid(message.DeviceId),
                            SensorId        = this.dbContext.Sensors.First(s => s.Label == message.Sensor).Id,
                            TriggeringValue = message.Value.ToString(),
                            ValueType       = Enum.Parse <ValueTypeEnum>(message.ValueType)
                        };

                        this.dbContext.Alerts.Add(newAlert);
                        this.dbContext.SaveChanges();
                        Console.WriteLine($"     - !!! Alert {newAlert.AlertType} / {newAlert.TriggeringValue} !!!");

                        // send email
                        var emailProps = new EmailAlert()
                        {
                            ReceiverEmail = deviceSensor.Device.User.Email,
                            ReceiverName  = deviceSensor.Device.User.FirstName,
                            Subject       = $"[Alert] {message.Sensor} {newAlert.AlertType}",
                            HtmlContent   = $"<strong>[{message.Time}]:</strong> <br>Hello {deviceSensor.Device.User.FirstName},<br><br>" +
                                            $" <strong>DeivceId :</strong>{message.DeviceId} <br> <strong>Sensor: </strong> {message.Sensor} <br>" +
                                            $" Sensor's value <strong>{message.Value}</strong> triggered <i>{newAlert.AlertType} - {(newAlert.AlertType == AlertTypeEnum.Above_Max_Value ? max : min)}</i>"
                        };

                        await this.alertNotifier.Execute(emailProps);

                        Console.WriteLine($" == Email sent to {emailProps.ReceiverEmail}");
                    }
                }
                else
                {
                    if (lastAlert != null)
                    {
                        lastAlert.AlertClosed = message.Time;
                        this.dbContext.Alerts.Update(lastAlert);
                        this.dbContext.SaveChanges();
                        Console.WriteLine($"     - Alert {lastAlert.AlertType} closed w/ value {message.Value}");
                    }
                }
            }
        }
Esempio n. 32
0
        public async Task <dynamic> Get()
        {
            if (CheckClientSecret())
            {
                Entities db = new Entities();

                Dictionary <string, string> emailConfig = ConfigDictionary.EmailConfig();

                var storesRequiringUpdate = new List <StoreCustomData>();

                foreach (StoreCustomData store in db.StoreCustomDatas)
                {
                    DateTime lastUpdate = db.SalesTargetHistories
                                          .Where(x => x.StoreID == store.StoreID)
                                          .OrderByDescending(x => x.DateUpdated)
                                          .FirstOrDefault()
                                          .DateUpdated;

                    if ((DateTime.Now - lastUpdate).TotalDays > 30)
                    {
                        storesRequiringUpdate.Add(store);
                    }
                }

                if (storesRequiringUpdate.Any())
                {
                    string storeNames = string.Empty;

                    foreach (StoreCustomData store in storesRequiringUpdate)
                    {
                        storeNames += $"<li><b>{ store.StoreName }</b> - Current Sales Target: £{ store.SalesTarget }</li>";
                    }

                    string messageBody = "<html><body>" +
                                         $"<span style='display:inline-block;'><img src='https://cdn.shopify.com/s/files/applications/75204543d0fec5bbf9e7f1db609e8804_512x512.png?1594118407' style='width:50%;'/><h2>Sales Target Update Alert</h2></span>" +
                                         $"<p>It has been more than 30 days since Sales Targets were updated for the following stores:</p><br/>" +
                                         $"<ul>{ storeNames }</ul>" +
                                         "</body></html>";

                    try
                    {
                        await EmailAlert.SendEmailAlert(new EmailAddress(emailConfig["SalesTargetRecipientAddress"]), "Sales Target Update Alert", messageBody);

                        return("Email sent!");
                    }
                    catch (Exception exception)
                    {
                        Console.WriteLine(exception.ToString());

                        return("Email failed to send.");
                    }
                }
                else
                {
                    return("No updates required.");
                }
            }
            else
            {
                return(new HttpResponseMessage(System.Net.HttpStatusCode.Forbidden));
            }
        }
Esempio n. 33
0
    protected void EnableButton_Click(object sender, EventArgs e)
    {
        MembershipUser user = Membership.GetUser(UserName.Text.Trim());
        if (user != null)
        {
            user.IsApproved = true;
            Membership.UpdateUser(user);

            string connectionString = "AsiaWebShopDBConnectionString";
            string query = "UPDATE [Member]"+ "SET [active]="+ 1 +"WHERE ([username] =N'" + UserName.Text.Trim() + "')";
            // Create the connection and the SQL command.
            using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[connectionString].ConnectionString))
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                // Open the connection, execute the INSERT query and close the connection.
                command.Connection.Open();
                command.ExecuteNonQuery();
                command.Connection.Close();
            }
            MemberGridView.DataBind();

            using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["AsiaWebShopDBConnectionString"].ConnectionString))
            {
                // start to connect sql server
                connection.Open();

                Int32 count = 0;
                int emailSentNum = 0;
                do
                {
                    SqlCommand command = new SqlCommand("SELECT COUNT(*) FROM [WishListItem] WHERE (([userName]= N'" + UserName.Text.Trim() + "') AND ([emailSent] = N'" + false + "')  AND ([isAlert] = N'" + true + "') AND ([userName] in (SELECT userName FROM [member] WHERE [active] = N'" + true + "')))", connection);
                    count = (Int32)command.ExecuteScalar();

                    if (count != 0)
                    {
                        SqlCommand test = new SqlCommand("SELECT upc FROM [WishListItem] WHERE (([userName]= N'" + UserName.Text.Trim() + "') AND ([emailSent] = N'" + false + "')  AND ([isAlert] = N'" + true + "') AND ([userName] in (SELECT userName FROM [member] WHERE [active] = N'" + true + "')))", connection);
                        String upcNum = test.ExecuteScalar().ToString().Trim();
                        SqlCommand name = new SqlCommand("SELECT name FROM [Item] WHERE (([upc] = N'" + upcNum + "'))", connection);
                        String itemName = name.ExecuteScalar().ToString().Trim();
                        SqlCommand userEmail = new SqlCommand("SELECT email FROM [member] WHERE (([userName] = N'" + UserName.Text.Trim() + "'))", connection);
                        String email = userEmail.ExecuteScalar().ToString().Trim();

                        EmailAlert instance = new EmailAlert();
                        bool isEmailSent = instance.sendEmail(email, itemName + " is now availiable. Come to AisaWebShop.", "Dear customer " + UserName.Text.Trim() + ":\n\n  "
                            + itemName + " is now on stock. Visit our website and You will find products you want are all in our shop.\n\nBest wishes, \nASiaWebShop");
                        if (isEmailSent == true)
                        {
                            SqlCommand alertEmailSent = new SqlCommand("UPDATE [WishListItem] SET [isAlert]=N'" + false + "', [emailSent]= N'" + true + "' WHERE (([upc] = N'" + upcNum + "') AND ([userName] = N'" + UserName.Text.Trim() + "'))", connection);
                            alertEmailSent.ExecuteScalar();
                            emailSentNum++;
                        }
                        else
                        {
                            ShowPopUpMsg("Email can't be sent");
                        }
                    }
                } while (count != 0);

                if (emailSentNum != 0)
                    ShowPopUpMsg(emailSentNum + " email(s) are sent");
                connection.Close();

            }
        }
    }
Esempio n. 34
0
        public HttpStatusCode WebHook()
        {
            try
            {
                var    paymentAlertStatus = 0;
                string secret             = MppUtility.ReadConfig("MS_WebHookReceiverSecret_Custom");
                var    postdata           = new StreamReader(HttpContext.Request.InputStream).ReadToEnd();
                var    emailboday         = "";
                var    signature          = Request.Headers["Stripe-Signature"];
                var    stripeEvent        = StripeEventUtility.ConstructEvent(postdata, signature, secret);
                var    eventid            = stripeEvent.Id;
                var    eventdata          = StripeHelper.GetStripeEvent(eventid);
                var    data   = JObject.Parse(postdata);
                var    custid = data["data"].First().First["customer"].ToString();
                var    msg    = "";

                if (eventdata != null && (eventdata.Type == "invoice.payment_succeeded" || eventdata.Type == "invoice.payment_failed"))
                {
                    String coupon_id    = null;
                    var    list         = data["data"].First().First["lines"];
                    var    Amount       = ((double)list["data"].First["amount"]) / 100;
                    var    Amount_off   = ((double)data["data"].First().First["amount_due"]) / 100;
                    var    Discount     = data["data"].First().First["discount"];
                    var    start        = (double)list["data"].First["period"]["start"];
                    var    end          = (double)list["data"].First["period"]["end"];
                    var    startperiod  = MppUtility.UnixTimeStampToDateTime(start);
                    var    endperiod    = MppUtility.UnixTimeStampToDateTime(end);
                    var    discount     = Math.Round(Amount - Amount_off, 2, MidpointRounding.AwayFromZero);
                    var    customerdata = StripeHelper.GetStripeCustomer(custid);
                    var    email        = customerdata.Email;
                    var    last4        = "";
                    var    carddetails  = StripeHelper.GetCard(custid);
                    foreach (var card in carddetails)
                    {
                        last4 = card.Last4;
                    }

                    if (Discount.Count() > 0)
                    {
                        coupon_id = Discount["coupon"]["id"].ToString();
                    }

                    switch (eventdata.Type)
                    {
                    case "invoice.payment_succeeded":
                        msg                = AccountData.UpdatePaymentStatus(custid, Amount, Amount_off, coupon_id, discount, startperiod, endperiod, 1);
                        emailboday         = "A payment of $" + Amount_off + " was made using your card on file ending with <b> " + last4 + " </b>";
                        paymentAlertStatus = 1;
                        break;

                    case "invoice.payment_failed":
                        msg = AccountData.UpdatePaymentStatus(custid, Amount, Amount_off, coupon_id, discount, startperiod, endperiod, 0);
                        upData.UpdatePlanData(custid, 0);
                        StripeHelper.UnSubscribe(custid);
                        emailboday         = @"A payment $" + Amount_off + " failed from your card ending with <b> " + last4 + " </b>" + "Please check your card details or add new card.";
                        paymentAlertStatus = 2;
                        break;
                    }
                    if (msg == "" && Amount_off != 0)
                    {
                        var respo = EmailAlert.PaymentAlertMail(email, emailboday);
                        if (respo == "success")
                        {
                            sellerData.UpdatePaymentAlert(paymentAlertStatus, custid);
                        }
                    }
                }
                else if (stripeEvent.Type == "charge.failed")
                {
                    var Amount          = ((double)data["data"].First().First["amount"]) / 100;
                    var failure_message = data["data"].First().First["failure_message"].ToString();
                    // msg = AccountData.UpdatePaymentStatus(custid, Amount, Amount, 0, 0.00, startperiod, endperiod, 0);
                    if (Amount > 1)//Card verification charge
                    {
                        upData.UpdatePlanData(custid, 0);
                        StripeHelper.UnSubscribe(custid);
                    }
                    var last4        = "";
                    var carddetails  = StripeHelper.GetCard(custid);
                    var customerdata = StripeHelper.GetStripeCustomer(custid);
                    var email        = customerdata.Email;
                    foreach (var card in carddetails)
                    {
                        last4 = card.Last4;
                    }
                    emailboday = @"A payment $" + Amount + " failed from your card ending with <b> " + last4 + " </b>" + "Please check your card details or add new card.</b>Possible reason:" + failure_message;
                    var respo = EmailAlert.PaymentAlertMail(email, emailboday);
                    if (respo == "success" && Amount > 1)
                    {
                        sellerData.UpdatePaymentAlert(2, custid);
                    }
                }
            }
            catch (Exception ex)
            {
                String msg = ex.Message;
                LogFile.WriteLog(msg);
            }
            return(HttpStatusCode.OK);
        }
        private void SendEmployeeLeaveReportsToDecisionNotification(int employeeLeaveDaysId)
        {
            try
            {
                MailMessage mailMessage  = new MailMessage();
                string      emailAddress = "";
                string      subject      = "";
                string      body         = "";


                List <EmailAlert> emailAlertList = EmailAlert.GetEmployeeLeaveReportsToDecisionNotification(employeeLeaveDaysId);

                foreach (EmailAlert emailAlert in emailAlertList)
                {
                    emailAddress = emailAlert.EmailAddress;
                    mailMessage.CC.Add(emailAlert.EmailAddressReportsTo);
                    subject = emailAlert.EmailSubject;
                    body    = emailAlert.EmailBody;;
                }

                MailMessage fromToMailMessage = new MailMessage(ConfigurationManager.AppSettings["administrationEmailAddress"].ToString(), emailAddress /*"*****@*****.**"*/);

                mailMessage.From = fromToMailMessage.From;
                mailMessage.To.Add(emailAddress);

                mailMessage.Subject    = subject;
                mailMessage.Body       = body;
                mailMessage.IsBodyHtml = true;

                SmtpClient smtpClient = new SmtpClient(ConfigurationManager.AppSettings["mailRelay"].ToString());
                smtpClient.Port        = Convert.ToInt32(ConfigurationManager.AppSettings["port"]);
                smtpClient.Credentials = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["administrationEmailAddress"].ToString(), ConfigurationManager.AppSettings["password"].ToString());
                smtpClient.EnableSsl   = true;
                smtpClient.Send(mailMessage);
            }
            catch (Exception ex)
            {
                //LabelError.Text = "";
                //LabelError.Text += ex.Message;
                //PanelError.Visible = true;
            }

            //try
            //{
            //    List<EmailAlert> emailAlertList = EmailAlert.GetEmployeeLeaveReportsToDecisionNotification(employeeLeaveDaysId);

            //    foreach (EmailAlert emailAlert in emailAlertList)
            //    {
            //        MailMessage mailMessage = new MailMessage(ConfigurationManager.AppSettings["administrationEmailAddress"].ToString(), emailAlert.EmailAddress /*"*****@*****.**"*/);

            //        mailMessage.CC.Add(emailAlert.EmailAddressReportsTo);
            //        mailMessage.Subject = emailAlert.EmailSubject;
            //        mailMessage.Body = emailAlert.EmailBody;
            //        mailMessage.IsBodyHtml = true;

            //        SmtpClient smtpClient = new SmtpClient(ConfigurationManager.AppSettings["mailRelay"].ToString());
            //        smtpClient.Port = Convert.ToInt32(ConfigurationManager.AppSettings["port"]);
            //        smtpClient.Credentials = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["administrationEmailAddress"].ToString(), ConfigurationManager.AppSettings["password"].ToString());
            //        smtpClient.EnableSsl = true;
            //        smtpClient.Send(mailMessage);
            //    }
            //}
            //catch (Exception ex)
            //{
            //    //LabelError.Text = "";
            //    //LabelError.Text += ex.Message;
            //    //PanelError.Visible = true;
            //}
        }
Esempio n. 36
0
        public override Alert CreateAlert(string title, string msg, string recipient)
        {
            EmailAlert alert = new EmailAlert(recipient, title, msg, true);

            return(alert);
        }
Esempio n. 37
0
        public void WebHook()
        {
            try
            {
                var paymentAlertStatus = 0;
                var postdata           = new StreamReader(HttpContext.Request.InputStream).ReadToEnd();
                var data       = JObject.Parse(postdata);
                var signature  = Request.Headers["Stripe-Signature"];
                var eventid    = data["id"].ToString();
                var custid     = data["data"].First().First["customer"].ToString();
                var msg        = "";
                var emailboday = "";
                var eventdata  = StripeHelper.GetStripeEvent(eventid);

                if (eventdata != null && (eventdata.Type == "invoice.payment_succeeded" || eventdata.Type == "invoice.payment_failed"))
                {
                    String coupon_id    = null;
                    var    list         = data["data"].First().First["lines"];
                    var    Amount       = ((double)list["data"].First["amount"]) / 100;
                    var    Amount_off   = ((double)data["data"].First().First["amount_due"]) / 100;
                    var    Discount     = data["data"].First().First["discount"];
                    var    start        = (double)list["data"].First["period"]["start"];
                    var    end          = (double)list["data"].First["period"]["end"];
                    var    startperiod  = MppUtility.UnixTimeStampToDateTime(start);
                    var    endperiod    = MppUtility.UnixTimeStampToDateTime(end);
                    var    discount     = Math.Round(Amount - Amount_off, 2, MidpointRounding.AwayFromZero);
                    var    customerdata = StripeHelper.GetStripeCustomer(custid);
                    var    email        = customerdata.Email;
                    var    last4        = "";
                    var    carddetails  = StripeHelper.GetCard(custid);
                    foreach (var card in carddetails)
                    {
                        last4 = card.Last4;
                    }

                    if (Discount.Count() > 0)
                    {
                        coupon_id = Discount["coupon"]["id"].ToString();
                    }

                    switch (eventdata.Type)
                    {
                    case "invoice.payment_succeeded":
                        msg                = AccountData.UpdatePaymentStatus(custid, Amount, Amount_off, coupon_id, discount, startperiod, endperiod, 1);
                        emailboday         = "Payment Success. A payment of $" + Amount_off + " was made using your card on file ending with <b> " + last4 + " </b>";
                        paymentAlertStatus = 1;
                        break;

                    case "invoice.payment_failed":
                        msg                = AccountData.UpdatePaymentStatus(custid, Amount, Amount_off, coupon_id, discount, startperiod, endperiod, 0);
                        emailboday         = "Payment failed.Payment $" + Amount_off + " failed from your card ending with <b> " + last4 + " </b> ";
                        paymentAlertStatus = 2;
                        break;
                    }
                    if (msg == "" && Amount_off != 0)
                    {
                        var respo = EmailAlert.PaymentAlertMail(email, emailboday);
                        if (respo == "success")
                        {
                            sellerData.UpdatePaymentAlert(paymentAlertStatus, custid);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                String msg = ex.Message;
            }
        }
Esempio n. 38
0
    protected bool sendEmail(string upc)
    {
        using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["AsiaWebShopDBConnectionString"].ConnectionString))
        {
            // start to connect sql server
            connection.Open();

            Int32 count = 0;
            int emailSentNum = 0;
            do
            {
                SqlCommand command = new SqlCommand("SELECT COUNT(*) FROM [WishListItem] WHERE (([upc] = N'" + upc + "') AND ([emailSent] = N'" + false + "')  AND ([isAlert] = N'" + true + "') AND ([userName] in (SELECT userName FROM [member] WHERE [active] = N'" + true + "')))", connection);
                count = (Int32)command.ExecuteScalar();

                if (count != 0)
                {
                    SqlCommand test = new SqlCommand("SELECT userName FROM [WishListItem] WHERE (([upc] = N'" + upc + "') AND ([emailSent] = N'" + false + "')  AND ([isAlert] = N'" + true + "') AND ([userName] in (SELECT userName FROM [member] WHERE [active] = N'" + true + "')))", connection);
                    String customerName = test.ExecuteScalar().ToString().Trim();
                    SqlCommand name = new SqlCommand("SELECT name FROM [Item] WHERE (([upc] = N'" + upc + "'))", connection);
                    String itemName = name.ExecuteScalar().ToString().Trim();
                    SqlCommand userEmail = new SqlCommand("SELECT email FROM [member] WHERE (([userName] = N'" + customerName + "'))", connection);
                    String email = userEmail.ExecuteScalar().ToString().Trim();

                    EmailAlert instance = new EmailAlert();
                    bool isEmailSent = instance.sendEmail(email, itemName + " is now availiable. Come to AisaWebShop.", "Dear customer " + customerName + ":\n\n  "
                        + itemName + " is now on stock. Visit our website and You will find products you want are all in our shop.\n\nBest wishes, \nASiaWebShop");
                    if (isEmailSent == true)
                    {
                        SqlCommand alertEmailSent = new SqlCommand("UPDATE [WishListItem] SET [isAlert]= N'" + false + "', [emailSent]= N'" + true + "' WHERE (([upc] = N'" + upc + "') AND ([userName] = N'" + customerName + "'))", connection);
                        alertEmailSent.ExecuteScalar();
                        emailSentNum++;
                    }
                    else
                    {
                        ShowPopUpMsg("Email can't be sent");
                    }
                }
            } while (count != 0);

            if (emailSentNum != 0)
                ShowPopUpMsg(emailSentNum + " email(s) are sent");
            connection.Close();

        }
        return true;
    }