using Comal.Classes;
using InABox.Core;
using InABox.Database;
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.NewProvider(Logger.Main).Query<PurchaseOrder>().ToObjects<PurchaseOrder>().ToList();
            foreach(var po in pos)
            {
                po.Description = po.Description.NotWhiteSpaceOr(String.Join("\n",po.Notes ??  new String[] { }));
            }
            DbFactory.NewProvider(Logger.Main).Save(pos);
            return true;
        }
    }
}