how to notify when stock levels have reached below a certain

I'm stuck with a part of a project. I have a database set up in SQL server with a table called stockTable which keep account of the four different types of materials needed.

I am using c# and ASP.net and doing this is Visual studio 2013.

I ultimately want to be able to be notified (maybe a messagebox) when these stock levels have reached below a certain level (EG: 200) and then email the manager to order some more materials.

I have the materials within a table and they are out putted by using a placeholder.

I am unsure in how to check the values in this placeholder and compare it to the minimum level that i will set. (EG:200).

This is how the table is created and shown on the webform.

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

SqlConnection con = new SqlConnection();

con.ConnectionString = ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ToString();

con.Open();

SqlCommand cmd = new SqlCommand();

cmd.CommandText = "Select * from [StockTable]";

cmd.Connection = con;

SqlDataReader rd = cmd.ExecuteReader();

table.Append("");

table.Append("

");

table.Append("

");

if (rd.HasRows)

{

while (rd.Read())

{

table.Append("

");

table.Append("

");

table.Append("

");

table.Append("

");

table.Append("

");

table.Append("

");

table.Append("

");

}

table.Append("

PlaceHolder1.Controls.Add(new Literal { Text = table.ToString() });

rd.Close();

}

Does anyone know how to do this, was thinking an if statement comparing the values but i am unsure of how to go about this.

if anyone has suggestions or snippets of code, it would be greatly appreciated, or easier ways in order to email the manager when stock levels are low.

Thank you very much!

4 Replies

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

Nitin Sontakke8y ago
Only if you already know those technologies already. If not there is learning curve involved. There is no few sentenses answer to this question.

Easiest probably is the console application. If you take Scheduled jobs path, will you be in a position configure smpt mail in sql server?

If you wish to avoid coding and do just configuration you probably will have google and learn these things.

Otherwise do the coding, write console application and schedule it as a Scheduled Task in Windows. (Hope you know that already. If not, again google)
Carol Cashman8y ago
thank you @Nitin
how would i go about using SSRS or job scheduling?

Thank you!
Laxmidhar Sahoo8y ago
sir
Mr Nitin Sontakke is correct.You should take timer control using ajax to check
Nitin Sontakke8y ago
I guess you will have to do it at a place where the stock actually get depleted. All I see here is a report. Where is the update to StockTable happening?

In addition, please be aware that, as a Manager, I may not like to receive every now then stating that the stock of A is low then after an hour stock of B is low. How exactly am I going to remember all of that at the end of the day?

Better solution would be a single mail at a specified time of the day that summarizes the result and sends it.

To implement such a solution, an independent console application which is scheduled to execute at an interval is the best option. If you know already, you can even use such features in SSRS. Or use Scheduled Jobs in SQL Server.

ID	Amount Of Stickers	Amount of Small Jars	Amount of Large Jars	Amount of Lids
" + rd[0] + "	" + rd[1] + "	" + rd[2] + "	" + rd[3] + "	" + rd[4] + "