|
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Web.Configuration;
/// <summary>
/// Summary description for Warehouse
/// </summary>
public class Warehouse
{
public static int GetItemQuantity(string itemID)
{
if (String.IsNullOrEmpty(itemID))
return 0;
System.Threading.Thread.Sleep(500);
using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["Items"].ConnectionString))
using(SqlCommand cmd = new SqlCommand("SELECT [Quantity] FROM Items WHERE [ItemID] = @itemID", conn))
{
conn.Open();
cmd.Parameters.AddWithValue("@itemID", new Guid(itemID));
return (int)cmd.ExecuteScalar();
}
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.