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

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

namespace PRS.Shared
{
    public class Update_7_48 : DatabaseUpdateScript
    {
        public override VersionNumber Version => new VersionNumber(7, 48);

        public override bool Update()
        {
            var items = DbFactory.Provider.Query(
                new Filter<RequisitionItem>(x=>x.ActualQuantity).IsEqualTo(0)
                    .And(x=>x.Quantity).IsNotEqualTo(0),
                new Columns<RequisitionItem>(x => x.ID)
                    .Add(x => x.Quantity)
                    .Add(x=>x.ActualQuantity)
                ).ToObjects<RequisitionItem>().ToList();
            foreach (var item in items)
                item.ActualQuantity = item.Quantity;
            DbFactory.Provider.Save(items);
            return true;
        }
    }
}