private void CreateOrder(String supplierName, String productName, UInt16 quantityOrdered)
{
using (SqlConnection conn = SQLAzureUtilities.GetActiveSqlConnection())
using (SqlCommand cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "AddOrder";
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter tenant = cmd.Parameters.Add("@Tenant", SqlDbType.NVarChar);
tenant.Value = spContext.SPHostUrl.ToString();
SqlParameter supplier = cmd.Parameters.Add("@Supplier", SqlDbType.NVarChar, 50);
supplier.Value = supplierName;
SqlParameter itemName = cmd.Parameters.Add("@ItemName", SqlDbType.NVarChar, 50);
itemName.Value = productName;
SqlParameter quantity = cmd.Parameters.Add("@Quantity", SqlDbType.SmallInt);
quantity.Value = quantityOrdered;
cmd.ExecuteNonQuery();
}
}