public SyncProductionBatchPickedInventoryHelper(IProductionUnitOfWork unitOfWork, RioAccessSQLEntities oldContext)
{
if(unitOfWork == null) { throw new ArgumentNullException("unitOfWork"); }
if(oldContext == null) { throw new ArgumentNullException("oldContext"); }
_unitOfWork = unitOfWork;
_oldContext = oldContext;
}
internal SetLotProductionResultItemsCommand(IProductionUnitOfWork productionUnitOfWork)
{
if (productionUnitOfWork == null)
{
throw new ArgumentNullException("productionUnitOfWork");
}
_productionUnitOfWork = productionUnitOfWork;
}
public RequsitionInfoBusiness(IProductionUnitOfWork productionDb, IInventoryUnitOfWork inventoryDb)
{
this._productionDb = productionDb;
requsitionInfoRepository = new RequsitionInfoRepository(this._productionDb);
this._inventoryDb = inventoryDb;
_warehouseStockInfoBusiness = new WarehouseStockInfoBusiness(this._inventoryDb);
itemBusiness = new ItemBusiness(this._inventoryDb);
}
public CreateProductionBatchCommand(IProductionUnitOfWork productionUnitOfWork)
{
if (productionUnitOfWork == null)
{
throw new ArgumentNullException("productionUnitOfWork");
}
_productionUnitOfWork = productionUnitOfWork;
}
protected ProductionScheduleConductorBase(IProductionUnitOfWork productionUnitOfWork)
{
if (productionUnitOfWork == null)
{
throw new ArgumentNullException("productionUnitOfWork");
}
ProductionUnitOfWork = productionUnitOfWork;
}
public UpdatePackScheduleCommand(IProductionUnitOfWork productionUnitOfWork)
{
if (productionUnitOfWork == null)
{
throw new ArgumentNullException("productionUnitOfWork");
}
_productionUnitOfWork = productionUnitOfWork;
}
public ProductionBaseRepository(IProductionUnitOfWork productionUnitOfWork)
{
if (productionUnitOfWork == null)
{
throw new ArgumentNullException("Product DbContext is not assigned");
}
this._productionUnitOfWork = productionUnitOfWork;
dbSet = this._productionUnitOfWork.Db.Set <T>();
}
private readonly IProductionUnitOfWork _productionDb; // database;
public WarehouseStockDetailBusiness(IInventoryUnitOfWork inventoryDb, IItemBusiness itemBusiness, IWarehouseStockInfoBusiness warehouseStockInfoBusiness, IProductionUnitOfWork productionDb)
{
this._inventoryDb = inventoryDb;
_itemBusiness = itemBusiness;
warehouseStockDetailRepository = new WarehouseStockDetailRepository(this._inventoryDb);
_warehouseStockInfoBusiness = warehouseStockInfoBusiness;
warehouseStockInfoRepository = new WarehouseStockInfoRepository(this._inventoryDb);
this._productionDb = productionDb;
_requsitionInfoBusiness = new RequsitionInfoBusiness(this._productionDb, this._inventoryDb);
_requsitionDetailBusiness = new RequsitionDetailBusiness(this._productionDb);
}
private readonly IInventoryUnitOfWork _inventoryDb; // database
public ProductionStockDetailBusiness(IProductionUnitOfWork productionDb, IInventoryUnitOfWork inventoryDb)
{
this._productionDb = productionDb;
this._inventoryDb = inventoryDb;
_productionStockDetailRepository = new ProductionStockDetailRepository(this._productionDb);
_productionStockInfoRepository = new ProductionStockInfoRepository(this._productionDb);
_productionStockInfoBusiness = new ProductionStockInfoBusiness(this._productionDb);
_requsitionInfoBusiness = new RequsitionInfoBusiness(this._productionDb, this._inventoryDb);
_requsitionDetailBusiness = new RequsitionDetailBusiness(this._productionDb);
_itemBusiness = new ItemBusiness(this._inventoryDb);
}
private readonly ProductionStockInfoRepository productionStockInfoRepository; // table
public ProductionStockInfoBusiness(IProductionUnitOfWork productionDb)
{
this._productionDb = productionDb;
productionStockInfoRepository = new ProductionStockInfoRepository(this._productionDb);
}
private readonly RequsitionDetailRepository requsitionDetailRepository; // table
public RequsitionDetailBusiness(IProductionUnitOfWork productionDb)
{
this._productionDb = productionDb;
requsitionDetailRepository = new RequsitionDetailRepository(this._productionDb);
}
public ProductionStockDetailRepository(IProductionUnitOfWork productionUnitOfWork) : base(productionUnitOfWork)
{
}
internal static IEnumerable <Expression <Func <PackSchedule, PackSchedulePickSheetReturn> > > SplitSelectPickSheet(IProductionUnitOfWork productionUnitOfWork, DateTime currentDate)
{
var product = ProductProjectors.SelectProductKeyName();
var pickedItem = PickedInventoryItemProjectors.SplitSelectBatch(productionUnitOfWork, currentDate);
return(pickedItem.Select(p => Projector <PackSchedule> .To(a => new PackSchedulePickSheetReturn
{
PickedItems = a.ProductionBatches.SelectMany(b => b.Production.PickedInventory.Items.Select(i => p.Invoke(i)))
}))
.ToAppendedList(SelectBase().Merge(p => new PackSchedulePickSheetReturn
{
SummaryOfWork = p.SummaryOfWork,
DateCreated = p.DateCreated,
ChileProduct = product.Invoke(p.ChileProduct.Product)
}).ExpandAll()));
}
public ProductionLineRepository(IProductionUnitOfWork productionUnitOfWork) : base(productionUnitOfWork)
{
}
public ProductionStockInfoRepository(IProductionUnitOfWork productionUnitOfWork) : base(productionUnitOfWork)
{
}
public RequsitionDetailRepository(IProductionUnitOfWork productionUnitOfWork) : base(productionUnitOfWork)
{
}
internal static IEnumerable <Expression <Func <PickedInventoryItem, BatchPickedInventoryItemReturn> > > SplitSelectBatch(IProductionUnitOfWork productionUnitOfWork, DateTime currentDate)
{
var batches = productionUnitOfWork.ProductionBatchRepository.All();
var lotKey = LotProjectors.SelectLotKey <ProductionBatch>();
return(SplitSelect(productionUnitOfWork, currentDate)
.Select(p => p.Merge(i => new BatchPickedInventoryItemReturn {
}))
.ToAppendedList(i => new BatchPickedInventoryItemReturn
{
NewLotKeyReturn = lotKey.Invoke(batches.FirstOrDefault(b => b.Production.PickedInventoryDateCreated == i.DateCreated && b.Production.PickedInventorySequence == i.Sequence))
}));
}
private readonly ProductionLineRepository productionLineRepository; // table
public ProductionLineBusiness(IProductionUnitOfWork productionDb)
{
this._productionDb = productionDb;
productionLineRepository = new ProductionLineRepository(this._productionDb);
}
internal static Expression <Func <PickedInventory, IEnumerable <PickedChileInventoryItem> > > SelectPickedChileInventoryItem(IProductionUnitOfWork productionUnitOfWork)
{
if (productionUnitOfWork == null)
{
throw new ArgumentNullException("productionUnitOfWork");
}
var chileLots = productionUnitOfWork.ChileLotRepository.All();
return(pickedInventory => chileLots.Join(pickedInventory.Items,
chileLot => new { chileLot.LotDateCreated, chileLot.LotDateSequence, chileLot.LotTypeId },
item => new { item.LotDateCreated, item.LotDateSequence, item.LotTypeId },
(chileLot, item) => new PickedChileInventoryItem
{
PickedInventoryItem = item,
ChileLot = chileLot,
Packaging = item.PackagingProduct
}));
}
internal static Expression <Func <PickedInventory, IEnumerable <PickedAdditiveInventoryItem> > > SelectPickedAdditiveInventoryItem(IProductionUnitOfWork productionUnitOfWork)
{
if (productionUnitOfWork == null)
{
throw new ArgumentNullException("productionUnitOfWork");
}
var additiveLots = productionUnitOfWork.AdditiveLotRepository.All();
return(pickedInventory => additiveLots.Join(pickedInventory.Items,
additiveLot => new { additiveLot.LotDateCreated, additiveLot.LotDateSequence, additiveLot.LotTypeId },
item => new { item.LotDateCreated, item.LotDateSequence, item.LotTypeId },
(additiveLot, item) => new PickedAdditiveInventoryItem
{
PickedInventoryItem = item,
AdditiveLot = additiveLot,
AdditiveProduct = additiveLot.AdditiveProduct,
AdditiveType = additiveLot.AdditiveProduct.AdditiveType,
Packaging = item.PackagingProduct
}));
}
internal CreateProductionScheduleConductor(IProductionUnitOfWork productionUnitOfWork) : base(productionUnitOfWork)
{
}
public RequsitionInfoRepository(IProductionUnitOfWork productionUnitOfWork) : base(productionUnitOfWork)
{
}
