public static int UpdateOrderItem(Orders order, Order_item oi, ref List <string> errors) { if (order == null || oi == null) { errors.Add("Order cannot be null"); } if (errors.Count > 0) { return(-1); } if (order.order_id <= 0 || oi.order_id <= 0) { errors.Add("Invalid order id"); } if (oi.product_variation_id < 0) { errors.Add("Invalid product variation id"); } if (oi.tax < 0) { errors.Add("Invalid tax range"); } if (oi.quantity < 0) { errors.Add("Invalid quantity"); } if (oi.sale_price < 0) { errors.Add("Invalid sale price"); } if (oi.condition != 'a' && oi.condition != 'd') { errors.Add("Invalid order item condition"); } if (errors.Count > 0) { return(-1); } return(DALOrders.UpdateOrder(order, ref errors)); }
public string InsertOrderJSON(Order order) { if (!CheckBasicAuthentication()) { //Autenticazione non riuscita throw new WebFaultException(HttpStatusCode.Unauthorized); } try { DALOrders DAL = new DALOrders(); string result = DAL.InsertOrder(order); return(result); } catch (Exception ex) { throw ex; } }
public void UpdateOrderItemTest() { List <string> errors = new List <string>(); //update exist record Order_item oi = new Order_item(); oi.order_id = 1; oi.product_variation_id = 32; oi.quantity = 13; int result = DALOrder_item.UpdateOrderItem(oi, ref errors); Assert.AreEqual(0, errors.Count); Assert.AreEqual(1, result); Order_item temp2 = null; temp2 = DALOrder_item.ReadOrderItem(1, 32, ref errors); Assert.AreEqual(1, temp2.order_id); Assert.AreEqual(32, temp2.product_variation_id); Assert.AreEqual(13, temp2.quantity); Assert.AreEqual(18.99F, temp2.sale_price); Assert.AreEqual(0F, temp2.tax); Assert.AreEqual('a', temp2.condition); //check subtotal, grand total, tax total update Orders temp = DALOrders.ReadOrder(1, ref errors); Assert.AreEqual(0, errors.Count); Assert.AreEqual(2260.81F, temp.subtotal); Assert.AreEqual(545F, temp.customer_id); Assert.AreEqual(2260.81F, temp.grand_total); Assert.AreEqual(0F, temp.tax_total); Assert.AreEqual('a', temp.condition); }
public void DeleteOrdersTest() { List <string> errors = new List <string>(); Orders order = new Orders(); order.order_id = 1; order.customer_id = 1; order.grand_total = 0; order.tax_total = 0; order.subtotal = order.grand_total + order.tax_total; order.date_created = new DateTime(); order.condition = 'a'; int id = DALOrders.CreateOrder(order, ref errors); Assert.AreEqual(0, errors.Count); Assert.AreNotEqual(-1, id); int status = DALOrders.DeleteOrder(id, ref errors); Assert.AreEqual(0, errors.Count); Assert.AreEqual(1, status); }
public void DeleteOrderItemTest() { List <string> errors = new List <string>(); //Insert new order Orders order = new Orders(); order.order_id = 1; order.customer_id = 1; order.grand_total = 0; order.tax_total = 0; order.subtotal = order.grand_total + order.tax_total; order.date_created = new DateTime(); order.condition = 'a'; int id = DALOrders.CreateOrder(order, ref errors); Assert.AreEqual(0, errors.Count); Assert.AreNotEqual(-1, id); order.order_id = id; //Insert new order_item Order_item new_item = new Order_item(); new_item.order_id = id; new_item.product_variation_id = 13; new_item.tax = 0.07F; new_item.quantity = 2; new_item.condition = 'a'; int result = DALOrder_item.CreateOrderItem(order, new_item, ref errors); Assert.AreEqual(0, errors.Count); Assert.AreEqual(1, result); //make sure the record exist! Order_item t = DALOrder_item.ReadOrderItem(id, 13, ref errors); Assert.AreEqual(0, errors.Count); Assert.AreEqual(id, t.order_id); Assert.AreEqual(13, t.product_variation_id); Assert.AreEqual(0.07F, t.tax); Assert.AreEqual(2, t.quantity); Assert.AreEqual('a', t.condition); //delete the new record result = DALOrder_item.DeleteOrderItem(id, 13, ref errors); Assert.AreEqual(0, errors.Count); Assert.AreEqual(1, result); t = DALOrder_item.ReadOrderItem(id, 13, ref errors); Assert.AreEqual(0, errors.Count); Assert.AreEqual(id, t.order_id); Assert.AreEqual(13, t.product_variation_id); Assert.AreEqual(0.07F, t.tax); Assert.AreEqual(2, t.quantity); Assert.AreEqual('d', t.condition); }