updateSalesOrderSummary method

Future<void> updateSalesOrderSummary(
  1. int salesOrderId
)

Implementation

Future<void> updateSalesOrderSummary(int salesOrderId) async {
  List<SalesOrderLineData> lines = await (db.select(
    db.salesOrderLine,
  )..where((e) => e.salesOrderId.equals(salesOrderId))).get();
  double amount = 0;
  double taxAmount = 0;
  for (var line in lines) {
    amount += line.amount;
    taxAmount += line.taxAmount;
  }
  print("Update SalesOrder: Amount: $amount");

  db.update(db.salesOrder)
    ..where((u) => u.id.equals(salesOrderId))
    ..write(
      SalesOrderCompanion(amount: Value(amount), taxAmount: Value(taxAmount)),
    );
}