Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
how to notify when stock levels have reached below a certain
Carol Cashman
Jan 8 2018 10:54 AM
150
Reply
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 border='1'>");
table.Append("<tr><th>ID</th><th>Amount Of Stickers</th><th>Amount of Small Jars</th><th>Amount of Large Jars</th><th> Amount of Lids</th>");
table.Append("</tr>");
if (rd.HasRows)
{
while (rd.Read())
{
table.Append("<tr>");
table.Append("<td>" + rd[0] + "</td>");
table.Append("<td>" + rd[1] + "</td>");
table.Append("<td>" + rd[2] + "</td>");
table.Append("<td>" + rd[3] + "</td>");
table.Append("<td>" + rd[4] + "</td>");
table.Append("</tr>");
}
}
table.Append("</table");
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!
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Error when trying reduce a certain number from the database
How to fetch data from perticular column in excel using C# ?