prs/prs.shared/Database Update Scripts/Update_7_48_RequisitionActualQuantity.cs

using Comal.Classes;
using InABox.Configuration;
using InABox.Core;
using InABox.Database;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace PRS.Shared;

using Comal.Classes;

public class Update_7_48_RequisitionActualQuantity : DatabaseUpdateScript
{
    public override VersionNumber Version => new VersionNumber(7, 48);

    public override bool Update()
    {
        Logger.Send(LogType.Information, "", "Updating Quantity -> ActualQuantity");

        var items = DbFactory.NewProvider(Logger.Main).Query(
            new Filter<RequisitionItem>(x=>x.ActualQuantity).IsEqualTo(0)
                .And(x=>x.Quantity).IsNotEqualTo(0),
            Columns.None<RequisitionItem>().Add(x => x.ID)
                .Add(x => x.Quantity)
                .Add(x=>x.ActualQuantity)
            ).ToObjects<RequisitionItem>().ToList();
        foreach (var item in items)
            item.ActualQuantity = item.Quantity;
        DbFactory.NewProvider(Logger.Main).Save(items);
        return true;
    }
}