123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354 |
- 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,
- x => x.Qty,
- x => x.Style.ID,
- x => x.Status
- )
- );
- 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,
- x => x.Style.ID
- ));
- }
- }
- }
|