prs/prs.stores/StockMovementStore.cs

using Comal.Classes;
using Comal.Stores;
using InABox.Core;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace PRSStores
{
    public class StockMovementStore : BaseStore<StockMovement>
    {
        protected override void AfterSave(StockMovement sm)
        {
            if (sm.JobRequisitionItem.ID != Guid.Empty)
            {
                CoreTable table = Provider.Query<JobRequisitionItem>(
                    new Filter<JobRequisitionItem>(x => x.ID).IsEqualTo(sm.JobRequisitionItem.ID),
                    new Columns<JobRequisitionItem>(x => x.ID, x => x.Cancelled, x => x.Archived, x => x.PurchaseOrderItem.ReceivedDate, x => x.Ordered)
                    );
                var item = table.Rows.FirstOrDefault().ToObject<JobRequisitionItem>();

                item = JobRequisitionItemStore.DoStatusChecks(item, DoQuery(item));
                Provider.Save(item);
            }

            base.AfterSave(sm);
        }

        private JobRequisitionItem QueryJobRequiItem(Guid itemID)
        {
            CoreTable table = Provider.Query<JobRequisitionItem>(new Filter<JobRequisitionItem>(x => x.ID).IsEqualTo(itemID));
            return table.Rows.FirstOrDefault().ToObject<JobRequisitionItem>();
        }

        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
                   ));
        }
    }
}