How to save multi records from one dialog

[MAboKhadra]

Greetings every one this is a charity project (i have this problem that i need help with ) appreciate your help

[MAboKhadra]

and here is the answer on ver 6.9.6 after few month and no one respond

protected override void AfterSave()
{
    base.AfterSave();
    if (Row.Product == null)
        return;

    // Get the Product row based on the ProductId from PurchasDetails
    var product = Connection.TryFirst<ProductRow>(ProductRow.Fields.ProdId == Row.Product.Value);
    if (product != null)
    {
        // Update the Product's balance based on the purchase details
        // You'll need to determine the logic based on your system
        product.Balance += Row.Quantity;
        product.Price = Row.SellPrice;
        product.PurchasPrice = Row.PurchasPrice;
        product.Purchased++;
        // Assuming "Quantity" is a field in PurchasDetails

        // Save the updated Product row to the database
        Connection.UpdateById(product);
    }
}