Esempio n. 1
0
        //[TestMethod]
        public void DeleteCustomIngredientQueryString()
        {
            //SqlConnectionBuilder CB = new SqlConnectionBuilder("(localdb)\\V11.0", "PizzaWaiter", "", "");
            //Assert.IsTrue(CB.CheckConnection());

            IPizzaWaiterTestService proxy = new PizzaWaiterTestServiceClient("WSHttpBinding_IPizzaWaiterTestService");

            List<PartOrder> partOrders = proxy.GetPartOrdersByOrderId(5).ToList();

            string[] completeString = new string[partOrders.Count];
            int var = 0;
            foreach (PartOrder po in partOrders)
            {
                ///Delete from (class name) where id=(orderIdn0) OR id=(orderIdn..) OR id=(orderIdn)
                string joinPartOrdersID = string.Format("PartOrderID = {0}", po.ID);
                completeString[var] = joinPartOrdersID;
                var++;

            }
            string sqlCondition = string.Join(" OR ", completeString);

            Assert.AreEqual("PartOrderID = 5 OR PartOrderID = 6 OR PartOrderID = 7", sqlCondition);
        }