prs/prs.mobile/comal.timesheets/Scripts/ChangePONumbers.cs

using Comal.Classes;
using InABox.Core;
using System;
using System.Collections.Generic;
using System.Text;
using InABox.Clients;

namespace comal.timesheets
{
    public class ChangePONumbers
    {
        public ChangePONumbers()
        {
            int count = 2;
            List<PurchaseOrder> orders = new List<PurchaseOrder>();
            CoreTable table = new Client<PurchaseOrder>().Query
                (new Filter<PurchaseOrder>(x => x.PONumber).IsEqualTo("101832")
                );
            foreach (CoreRow row in table.Rows)
            {
                PurchaseOrder purchaseOrder = row.ToObject<PurchaseOrder>();
                if (count < 10)
                {
                    purchaseOrder.PONumber = "PRS 00000" + count;
                }
                else if (count >= 10)
                {
                    purchaseOrder.PONumber = "PRS 0000" + count;
                }
                else if (count >= 100)
                {
                    purchaseOrder.PONumber = "PRS 000" + count;
                }
                orders.Add(purchaseOrder);
                count++;
            }
            new Client<PurchaseOrder>().Save(orders, "Bulk Update By Nick");
        }
    }
}