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