internal void SaveMailJob(MailSend mailJob)
        {
            IDataConnection connection = DatabaseAPI.GetConnection();
            try
            {
                connection.open();

                if (MailJobExistsById(mailJob.ID.ToString()))
                { // update
                    string query = string.Format("update mail_send set invoice_number='{0}', status={1}, message_type={2} where id={3}",
                        mailJob.Invoice.InvoiceNo, (int)mailJob.Status, (int)mailJob.MessageType, mailJob.ID);
                    connection.runNonQuery(query);
                }
                else
                { // insert
                    string query = string.Format("insert into mail_send (invoice_number, status, message_type) values ('{0}', {1}, {2}); SELECT LAST_INSERT_ID();",
                        mailJob.Invoice.InvoiceNo, (int)mailJob.Status, (int)mailJob.MessageType);
                    mailJob.ID = int.Parse(connection.runScalar(query).ToString());
                }
            }
            catch (Exception exc)
            {
                throw exc;
            }
            finally
            {
                if (connection != null && connection.State == ConnectionState.Open)
                    connection.close();
            }
        }
        internal void SaveMailJob(MailSend mailJob)
        {
            bool add = false;

            DBMailEntry mail = _dbcontext.MailEntry.Where(x => x.EntryId == mailJob.ID).FirstOrDefault();
            if (mail == default(DBMailEntry))
            {
                add = true;
                mail = new DBMailEntry();
                mail.DateCreated = DateTime.Now;
            }

            mail.Invoice = _dbcontext.Invoice.Where(x => x.InvoiceId == mailJob.Invoice.Id).FirstOrDefault();
            mail.MessageType = (int)mailJob.MessageType;
            mail.Status = (int)mailJob.Status;
            if(add)
                _dbcontext.MailEntry.Add(mail);
            _dbcontext.SaveChanges();
        }
        public static List<MailSend> GetMailSendsByInvoiceAndStatus(string invoiceID, Enums.MailStatus status)
        {
            List<MailSend> mailers = new List<MailSend>();

            try {

                using (IDataReader reader = API.EmailingAPI.GetMailJobByInvoiceAndStatus(invoiceID, (int)status)) {
                    while (reader.Read()) {
                        MailSend mailsend = new MailSend();
                        mailsend.ID = int.Parse(reader["id"].ToString());
                        mailsend.Invoice = new Invoice(reader["invoice_number"].ToString());
                        mailsend.MessageType = ((Enums.MessageType)int.Parse(reader["message_type"].ToString()));
                        mailsend.Status = ((Enums.MailStatus)int.Parse(reader["status"].ToString()));

                        mailers.Add(mailsend);
                    }
                }

            } catch (Exception exc) {
                // Trouble connecting to database
                Console.WriteLine("Problem connecting: {0}", exc.Message);
            }
            return mailers;
        }
예제 #4
0
 public static void SaveMailJob(MailSend mailJob)
 {
     Actions.SaveMailJob(mailJob);
 }
 void sendParcelSentEmailNotification(Invoice invoice)
 {
     IMailSender email = new MailSend(invoice, Enums.MessageType.PARCEL_SENT_NOTIFICATION);
     email.SaveJob();
 }
        private string GetTemplatedEmail(MailSend mail)
        {
            string templatePath = string.Format("{0}{1}.htm", GetTemplatesPath(), mail.Invoice.Provider.CarrierId);
            string template = "";

            try {
                template = File.ReadAllBytes(templatePath).ToString();
            }
            catch(Exception exc) {
                Console.WriteLine("Problem occured: ", exc.Message);
            }
            return template;
        }
        private void SendEmails(object sender, System.Timers.ElapsedEventArgs args)
        {
            if (Connection != null) {

                if (Connection.open()) {
                    List<int> ids = new List<int>();

                    // Get a list of all emails past the window time
                    DateTime cutoff = DateTime.Now.AddHours(-GetSendWindowHours());

                    string sql = string.Format("select id from mail_send where status={0} and date_created < '{1}';",
                        (int)BusinessLayer.Enums.MailStatus.WAITING, cutoff.ToString("yyyy-MM-dd HH:mm:ss"));
                    using (DbDataReader reader = Connection.getDataReader(sql)) {

                        while (reader.Read()) {
                            ids.Add(int.Parse(reader["id"].ToString()));
                        }
                    }

                    // Create the mailsends from the ids
                    foreach (int id in ids) {
                        MailSend mail = new MailSend(id);
                        SendEmail(mail);

                        // Update mailsend item as sent
                        mail.Status = BusinessLayer.Enums.MailStatus.SENT;
                        mail.save();
                    }

                } else {
                    Console.WriteLine("Cannot connect to database.");
                }

            }
        }
        private void SendEmail(MailSend mail)
        {
            string from = GetFromAddress();
            //string to = mail.Invoice.InvoiceCustomer.EmailAddress;
            string to = "*****@*****.**";

            MailMessage msg = new MailMessage(from, to);
            SmtpClient client = new SmtpClient();
            client.Port = 25;
            client.DeliveryMethod = SmtpDeliveryMethod.Network;
            client.UseDefaultCredentials = false;
            client.Host = GetSMTP();
            msg.Subject = "this is a test email.";
            msg.Body = GetTemplatedEmail(mail);
            client.Send(msg);
        }