once condition met, send email automatically

hey guys,

this is my code for if a certain number in my database table (eg:200) is equal too or below to notify that stock is low.

does anyone know how to add that once this condition is met to automatically send an email to the manager notifying him?

thanks guys!!!

Here's my emailing function. It mails to a yahoo account. Hope it'll help in someway.

private void MailtoYahoo()
{
string smtpAddress = "smtp.mail.yahoo.com";
int portNumber = 587;
bool enableSSL = true;
string emailFrom = "[email protected]";
string password = "mail pass";
string emailTo = "[email protected]";
string subject = "Nasa";
string body = "The Eagle has landed!";
using (MailMessage mail = new MailMessage())
{
try
{
mail.From = new MailAddress(emailFrom);
mail.To.Add(emailTo);
mail.Subject = subject;
mail.Body = body;
mail.IsBodyHtml = true;
// Can set to false, if you are sending pure text.
mail.Attachments.Add(new Attachment(fileName));
//mail.Attachments.Add(new Attachment("C:\\SomeZip.zip"));
using (SmtpClient smtp = new SmtpClient(smtpAddress, portNumber))
{
smtp.Credentials = new NetworkCredential(emailFrom, password);
smtp.EnableSsl = enableSSL;
smtp.Send(mail);
//MessageBox.Show("Mail Sent");
}
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString());
}
}
}

You will need to import System.Net and System.Net.Mail libs.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kasun Lee8y ago
Accepted answer
Here's my emailing function. It mails to a yahoo account. Hope it'll help in someway.
private void MailtoYahoo()
        {
            string smtpAddress = "smtp.mail.yahoo.com";
            int portNumber = 587;
            bool enableSSL = true;

            string emailFrom = "[email protected]";
            string password = "mail pass";
            string emailTo = "[email protected]";
            string subject = "Nasa";
            string body = "The Eagle has landed!";

            using (MailMessage mail = new MailMessage())
            {
                try
                {
                    mail.From = new MailAddress(emailFrom);
                    mail.To.Add(emailTo);
                    mail.Subject = subject;
                    mail.Body = body;
                    mail.IsBodyHtml = true;
                    // Can set to false, if you are sending pure text.

                    mail.Attachments.Add(new Attachment(fileName));
                    //mail.Attachments.Add(new Attachment("C:\\SomeZip.zip"));

                    using (SmtpClient smtp = new SmtpClient(smtpAddress, portNumber))
                    {
                        smtp.Credentials = new NetworkCredential(emailFrom, password);
                        smtp.EnableSsl = enableSSL;
                        smtp.Send(mail);
                        //MessageBox.Show("Mail Sent");
                    }
                }
                catch (Exception ex)
                {
                    //MessageBox.Show(ex.ToString());
                }
            }
        }

You will need to import System.Net and System.Net.Mail libs.
Kasun Lee8y ago
btw. You also need to enable "Less secure app" option on recieving end, whether it's yahoo, gmail, or something else.
Suraj Kumar8y ago
Hello,
You can try this
http://www.c-sharpcorner.com/UploadFile/87b416/sending-a-simple-email-using-smtpclient-in-C-Sharp/
Thanks