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);
}
