public void CreateOrderItemTest() { List <string> errors = new List <string>(); //create new order first to get a new order id 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); //now safe to create new order item Order_item oi = new Order_item(); order.order_id = id; oi.order_id = id; oi.product_variation_id = 10; oi.quantity = 100; oi.sale_price = 15.8F; oi.tax = 0.0875F; int result = DALOrder_item.CreateOrderItem(order, oi, ref errors); Assert.AreEqual(1, result); Assert.AreEqual(0, errors.Count); Order_item temp = DALOrder_item.ReadOrderItem(id, 10, ref errors); Assert.AreEqual(0, errors.Count); Assert.AreEqual(temp.order_id, id); Assert.AreEqual(temp.product_variation_id, 10); Assert.AreEqual(temp.quantity, oi.quantity); Assert.AreEqual(temp.sale_price, oi.sale_price); Assert.AreEqual(temp.tax, oi.tax); Assert.AreEqual(temp.condition, 'a'); Orders temp2 = DALOrders.ReadOrder(id, ref errors); Assert.AreEqual(1580, temp2.subtotal); Assert.AreEqual(138.25, temp2.tax_total); Assert.AreEqual(1718.25, temp2.grand_total); Assert.AreEqual('a', temp.condition); }
public static List <Order_item> ReadOrderItems(int o, ref List <string> errors) { if (o <= 0) { errors.Add("Invalid order id"); } if (errors.Count > 0) { return(null); } return(DALOrder_item.ReadOrderItems(o, ref errors)); }
public void ReadOrderItemTest() { List <string> errors = new List <string>(); Order_item temp = null; temp = DALOrder_item.ReadOrderItem(16, 1, ref errors); Assert.AreEqual(0, errors.Count); Assert.AreEqual(16, temp.order_id); Assert.AreEqual(1, temp.product_variation_id); Assert.AreEqual(49, temp.quantity); Assert.AreEqual(42, temp.sale_price); Assert.AreEqual(0, temp.tax); Assert.AreEqual('a', temp.condition); }
public static int DeleteOrderItem(int o, int pv, ref List <string> errors) { if (o <= 0) { errors.Add("Invalid order id"); } if (pv <= 0) { errors.Add("Invalid product variation id"); } if (errors.Count > 0) { return(-1); } return(DALOrder_item.DeleteOrderItem(o, pv, ref errors)); }
public static int CreateOrderItem(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(DALOrder_item.CreateOrderItem(order, oi, ref errors)); }
public void ReadOrderItemsTest() { List <string> errors = new List <string>(); List <Order_item> temp = null; List <Order_item> temp2 = null; temp = DALOrder_item.ReadOrderItems(19, ref errors); temp2 = DALOrder_item.ReadOrderItems(19, ref errors); Assert.AreEqual(0, errors.Count); Assert.AreEqual(19, temp[0].order_id); Assert.AreEqual(5, temp[0].product_variation_id); Assert.AreEqual(1, temp[0].quantity); Assert.AreEqual(28, temp[0].sale_price); Assert.AreEqual(0.01F, temp[0].tax); Assert.AreEqual('a', temp[0].condition); Assert.AreEqual(19, temp[1].order_id); Assert.AreEqual(36, temp[1].product_variation_id); Assert.AreEqual(38, temp[1].quantity); Assert.AreEqual(43, temp[1].sale_price); Assert.AreEqual(0, temp[1].tax); Assert.AreEqual('a', temp[1].condition); Assert.AreEqual(temp.Count, temp2.Count); for (int i = 0; i < temp.Count(); i++) { Assert.AreEqual(temp[i].order_id, temp2[i].order_id); Assert.AreEqual(temp[i].product_variation_id, temp2[i].product_variation_id); Assert.AreEqual(temp[i].tax, temp2[i].tax); Assert.AreEqual(temp[i].quantity, temp2[i].quantity); Assert.AreEqual(temp[i].sale_price, temp2[i].sale_price); Assert.AreEqual(temp[i].condition, temp2[i].condition); } }
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 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); }