prs/prs.stores/JobRequisitionItemStore.cs

using Comal.Classes;
using Comal.Stores;
using InABox.Core;
using System;
using System.Linq;

namespace PRSStores
{
    public class JobRequisitionItemStore : BaseStore<JobRequisitionItem>
    {
        protected override void BeforeSave(JobRequisitionItem item)
        {
            var table = DoQuery(item);
            item = DoStatusChecks(item, table);
            base.BeforeSave(item);
        }

        private CoreTable DoQuery(JobRequisitionItem item)
        { 
            return Provider.Query<StockMovement>(
               new Filter<StockMovement>(x => x.JobRequisitionItem.ID).IsEqualTo(item.ID),
               new Columns<StockMovement>(
                   x => x.Received
                   ));
        }

        public static JobRequisitionItem DoStatusChecks(JobRequisitionItem item, CoreTable table)
        {
            if (item.Cancelled != DateTime.MinValue)
                item.Status = JobRequisitionItemStatus.Cancelled;
            else if (item.Archived != DateTime.MinValue)
                item.Status = JobRequisitionItemStatus.Archived;
            else if (item.Ordered != DateTime.MinValue && item.PurchaseOrderItem.ReceivedDate == DateTime.MinValue)
                item.Status = JobRequisitionItemStatus.OnOrder;
            else if (item.PurchaseOrderItem.ReceivedDate != DateTime.MinValue)
                item.Status = JobRequisitionItemStatus.Received;
            else if (item.Status == JobRequisitionItemStatus.OrderRequired)
                return item;
            else
                item = CheckReserved(item, table);          

            return item;
        }

        private static JobRequisitionItem CheckReserved(JobRequisitionItem item, CoreTable table)
        {         
            if (!table.Rows.Any())
                return item;

            double total = 0;
            foreach (var row in table.Rows) 
                total = total + row.Get<StockMovement, double>(x => x.Received);

            if (total >= item.Qty)
                item.Status = JobRequisitionItemStatus.Reserved;
            else
                item.Status = JobRequisitionItemStatus.NotChecked;

            return item;
        }
    }    
}