ChainStoreWeb.Pages.OrderForm.CreateOrder C# (CSharp) Метод

CreateOrder() приватный Метод

private CreateOrder ( String supplierName, String productName, UInt16 quantityOrdered ) : void
supplierName String
productName String
quantityOrdered UInt16
Результат void
        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();
            }
        }