using Comal.Classes;
using InABox.Core;
using InABox.Database;

namespace PRS.Shared;

public class Update_6_38 : DatabaseUpdateScript
{

    public override VersionNumber Version => new (6, 38);
        
    public override bool Update()
    {
        Logger.Send(LogType.Information, "", "Converting Job Requisition Dates to Due Dates");
        List<JobRequisition> updates = new List<JobRequisition>();
        var columns = Columns.None<JobRequisition>().Add(x => x.ID);
        columns.Add("Date");
        CoreTable requis = DbFactory.NewProvider(Logger.Main).Query<JobRequisition>(null, columns);
        foreach (var row in requis.Rows)
        {
            var requi = row.ToObject<JobRequisition>();
            requi.Approved = row.Get<DateTime>("Date");
            updates.Add(requi);
        }
        DbFactory.NewProvider(Logger.Main).Save(updates);
            
        return true;
    }
    
}