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

namespace PRS.Shared
{
    public class Update_7_24a : DatabaseUpdateScript
    {
        public override VersionNumber Version => new(7, 24, "a");

        public override bool Update()
        {
            var pos = DbFactory.Provider.Query<PurchaseOrder>().ToObjects<PurchaseOrder>().ToList();
            foreach(var po in pos)
            {
                po.Description = po.Description.NotWhiteSpaceOr(po.Notes);
            }
            DbFactory.Provider.Save(pos);
            return true;
        }
    }
}