Send email products with low quantity

Question

2.00/5 (1 vote)

See more:

Hi guys continuing to have problems with asp.net/c# web site where i' implemeting.
I have a database with fields (Id,Name,Price,Quantity) i want to sen an email to administrator with products id and name when the quantity of the product is less<5 with the following code i send an email when only the first product has low quantity if any other products has low quantity it didn't send anything what should i change in order to works properly?

Thnx in advance!!!!

-------------------------------------------------------

C#

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand sqlCommand = new SqlCommand("select Id, quantity from products", con);
        int var = 0;
        string pro = "";
        con.Open();
        using (SqlDataReader read = sqlCommand.ExecuteReader())
        {
            while (read.Read())
            {
                string numquant = read["quantity"].ToString();
                string Id1;
                Id1 = read["Id"].ToString();
                Response.Write(numquant);
                pro ="You product with low quantity is :"+ Convert.ToString(Id1);
                GridView1.DataSource = read;
                GridView1.DataBind();
                var = Convert.ToInt32(numquant);
            }
           
            
            int quantity = var;
            if (quantity < 5)
            {

                        
                MailMessage mailObj = new MailMessage(
                "from", "to", "product low quantity",pro);

                SmtpClient SMTPServer = new SmtpClient("localhost");
                try
                {
                    SMTPServer.UseDefaultCredentials = false;
                    SMTPServer.Host = "smtp.gmail.com";
                    SMTPServer.Port = 587;
                    SMTPServer.Credentials = new NetworkCredential("email", "password");
                    SMTPServer.EnableSsl = true;
                    SMTPServer.Send(mailObj);
                }
                catch (Exception ex)
                {
                    // Label1.Text = ex.ToString();
                }
                read.Close();
                con.Close();
            }
        }
    }      
}

-----------------------------------------------------------------------

Posted 3-Oct-13 8:40am

JasonTsoum77

Updated 3-Oct-13 8:45am

Azee

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Girish Vadhel · Accepted Answer · 2013-10-03T14:39:00

Change your code something like and try :

C#

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand sqlCommand = new SqlCommand("select Id, quantity from products", con);
        int var = 0;
        string pro = "";
        con.Open();
        using (SqlDataReader read = sqlCommand.ExecuteReader())
        {
            while (read.Read())
            {
                string numquant = read["quantity"].ToString();
                string Id1;
                Id1 = read["Id"].ToString();
                Response.Write(numquant);
                pro ="You product with low quantity is :"+ Convert.ToString(Id1);
                
                var = Convert.ToInt32(numquant);
                if (var < 5)      
                  sendmail(pro);
            }
           
            GridView1.DataSource = read;
            GridView1.DataBind();
            read.Close();
            con.Close();
        }
    } 

    private void sendmail(string msg)     
    {
                 MailMessage mailObj = new MailMessage(
                "from", "to", "product low quantity",msg);
 
                SmtpClient SMTPServer = new SmtpClient("localhost");
                try
                {
                    SMTPServer.UseDefaultCredentials = false;
                    SMTPServer.Host = "smtp.gmail.com";
                    SMTPServer.Port = 587;
                    SMTPServer.Credentials = new NetworkCredential("email", "password");
                    SMTPServer.EnableSsl = true;
                    SMTPServer.Send(mailObj);
                }
                catch (Exception ex)
                {
                    // Label1.Text = ex.ToString();
                }
    }
}

**Azee** · Accepted Answer · 2013-10-03T08:53:00

Solution 1

Hey there,

If I remember correctly, I gave you another solution to send email using DataKeyNames.

Anyway, try moving the code that sends email inside the while loop.

Let me know if it works.

Azee...

Posted 3-Oct-13 8:53am

Azee

v2

Comments

JasonTsoum77 3-Oct-13 15:11pm

Hi Azee thank you for your response and your help
I remove (while loop) but now it didn't send nothing!
what else i shooul try?

thank you again for your help!

Azee 3-Oct-13 15:18pm

Hey, dont remove the while loop, just move the email code:
int quantity = var;
if (quantity < 5)
{

MailMessage mailObj = new MailMessage(
"from", "to", "product low quantity",pro);

SmtpClient SMTPServer = new SmtpClient("localhost");
try
{
SMTPServer.UseDefaultCredentials = false;
SMTPServer.Host = "smtp.gmail.com";
SMTPServer.Port = 587;
SMTPServer.Credentials = new NetworkCredential("email", "password");
SMTPServer.EnableSsl = true;
SMTPServer.Send(mailObj);
}
catch (Exception ex)
{
// Label1.Text = ex.ToString();
}
}
Inside the loop.

and keep these two lines outside the loop.
read.Close();
con.Close();

JasonTsoum77 4-Oct-13 15:16pm

It worked thank you very much for your help and your response!!! Azee

Renju Vinod · Accepted Answer · 2013-10-03T18:41:00

Hi,

Please check this.

Sending low product quantity details in a single mail

C#

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new  SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        SqlCommand sqlCommand = new SqlCommand("select Id from products where quantity<5", con);
        int var = 0;
        string pro = "You product with low quantity are :";
        con.Open();
        using (SqlDataReader read = sqlCommand.ExecuteReader())
        {
            while (read.Read())
            {
                string Id1;
                Id1 = read["Id"].ToString();
                pro += Convert.ToString(Id1)+", ";                
            }
                pro = pro.Substring(0,pro.Length - 2);       
                MailMessage mailObj = new MailMessage(
                "from", "to", "product low quantity",pro);
 
                SmtpClient SMTPServer = new SmtpClient("localhost");
                try
                {
                    SMTPServer.UseDefaultCredentials = false;
                    SMTPServer.Host = "smtp.gmail.com";
                    SMTPServer.Port = 587;
                    SMTPServer.Credentials = new NetworkCredential("email", "password");
                    SMTPServer.EnableSsl = true;
                    SMTPServer.Send(mailObj);
                }
                catch (Exception ex)
                {
                    // Label1.Text = ex.ToString();
                }
                read.Close();
                con.Close();
        }
    }      
}

Send email products with low quantity

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0