public void SaveOrderItems(long orderId, IList <OrderItemEntity> orderItemsToSave)
{
if (orderItemsToSave == null || !orderItemsToSave.Any())
{
return;
}
var sqlParams = new [] { OrderItemEntity.BindOrderItemTable("@@orderItems", orderItemsToSave), new SqlParameter("@orderId", SqlDbType.BigInt)
{
Value = orderId
} };
dbContext.ExecuteNonQuery("SaveOrderItems", Timeout, sqlParams);
}
public void SaveOrder(OrderEntity orderToSave, IList <OrderItemEntity> itemsToSave)
{
if (orderToSave == null || !itemsToSave.Any())
{
return;
}
var userIdParam = new SqlParameter("@userId", SqlDbType.BigInt)
{
Value = orderToSave.UserId
};
var orderDateParam = new SqlParameter("@orderDate", SqlDbType.DateTime2)
{
Value = orderToSave.OrderDate
};
var subTotalParam = new SqlParameter("@subTotal", SqlDbType.Decimal)
{
Value = orderToSave.SubTotal
};
var taxParam = new SqlParameter("@tax", SqlDbType.Decimal)
{
Value = orderToSave.Tax
};
var otherChargesParam = new SqlParameter("@otherCharges", SqlDbType.Decimal)
{
Value = orderToSave.OtherCharges
};
var notesParam = new SqlParameter("@notes", SqlDbType.NVarChar)
{
Value = orderToSave.Notes
};
var statusParam = new SqlParameter("@status", SqlDbType.Int)
{
Value = (int)orderToSave.Status
};
var orderItemParam = OrderItemEntity.BindOrderItemTable("@orderItems", itemsToSave);
dbContext.ExecuteNonQuery("SaveOrder", Timeout, userIdParam, orderDateParam, subTotalParam, taxParam, otherChargesParam, notesParam, statusParam, orderItemParam);
}
