/// <summary>
/// لازم يكون معاه الهيدر بتاعه
/// </summary>
/// <param name="context"></param>
/// <param name="item"></param>
private static void GetAdjustmentItemDetails(WorkFlowManagerDBEntities context, TblAdjustmentDetail item)
{
// From
var tempFrom = context.GetItemDimDetails(item.ItemDimIserial);
var itemDimFromResult = tempFrom.FirstOrDefault();
item.ItemAdjustment.ItemId = itemDimFromResult.ItemIserial;
item.ItemAdjustment.ItemCode = context.FabricAccSearches.FirstOrDefault(fas =>
fas.Iserial == itemDimFromResult.ItemIserial && fas.ItemGroup == itemDimFromResult.ItemType).Code;
item.ItemAdjustment.ItemName = itemDimFromResult.ItemName;
item.ItemAdjustment.ItemType = itemDimFromResult.ItemType;
item.ItemAdjustment.DifferenceQuantity = item.DifferenceQuantity;
item.ItemAdjustment.AvailableQuantity = item.AvailableQuantity;
item.ItemAdjustment.CountedQuantity = item.CountedQuantity;
item.ItemAdjustment.ItemDimFromIserial = item.ItemDimIserial;
item.ItemAdjustment.ColorFromId = itemDimFromResult.ColorIserial;
item.ItemAdjustment.ColorFromCode = itemDimFromResult.ColorCode;
item.ItemAdjustment.SizeFrom = itemDimFromResult.Size;
item.ItemAdjustment.BatchNoFrom = itemDimFromResult.BatchNo;
item.ItemAdjustment.SiteFromIserial = itemDimFromResult.SiteIserial;
item.ItemAdjustment.Cost = item.Cost;
//string warehouseCode = context.TblWarehouses.FirstOrDefault(tw =>
//tw.Iserial == item.TblAdjustmentHeader.WarehouseIserial).Code;
//var itemdimfrom = context.TblItemDims.FirstOrDefault(id => id.Iserial == item.ItemDimIserial);
//string itemCode = context.FabricAccSearches.FirstOrDefault(fas =>
// fas.Iserial == itemdimfrom.ItemIserial && fas.ItemGroup == itemdimfrom.ItemType).Code;
//string colorCode = context.TblColors.FirstOrDefault(c => c.Iserial == itemdimfrom.TblColor).Code;
//item.ItemAdjustment.AvailableQuantity = WarehouseQuantities.GetAvilableQuantity(
// warehouseCode, itemCode, colorCode, itemdimfrom.Size, itemdimfrom.BatchNo);
}
/// <summary>
/// لازم يكون معاه الهيدر بتاعه
/// </summary>
/// <param name="context"></param>
/// <param name="item"></param>
private static void GetAdjustmentTempItemDetails(WorkFlowManagerDBEntities context, TblAdjustmentTempDetail item)
{
// From
var tempFrom = context.GetItemDimDetails(item.ItemDimIserial);
var itemDimFromResult = tempFrom.FirstOrDefault();
item.ItemAdjustment.ItemId = itemDimFromResult.ItemIserial;
item.ItemAdjustment.ItemName = itemDimFromResult.ItemName;
item.ItemAdjustment.ItemType = itemDimFromResult.ItemType;
item.ItemAdjustment.ItemCode = context.FabricAccSearches.FirstOrDefault(fas =>
fas.Iserial == itemDimFromResult.ItemIserial && fas.ItemGroup == itemDimFromResult.ItemType).Code;
item.ItemAdjustment.DifferenceQuantity = item.DifferenceQuantity;
item.ItemAdjustment.AvailableQuantity = item.AvailableQuantity;
item.ItemAdjustment.CountedQuantity = item.CountedQuantity;
item.ItemAdjustment.Cost = item.Cost;
item.ItemAdjustment.ItemDimFromIserial = item.ItemDimIserial;
item.ItemAdjustment.ColorFromId = itemDimFromResult.ColorIserial;
item.ItemAdjustment.ColorFromCode = itemDimFromResult.ColorCode;
item.ItemAdjustment.SizeFrom = itemDimFromResult.Size;
item.ItemAdjustment.BatchNoFrom = itemDimFromResult.BatchNo;
item.ItemAdjustment.SiteFromIserial = itemDimFromResult.SiteIserial;
var vendor = context.Vendor_new.FirstOrDefault(v => context.TblTradeAgreementHeaders.Any(tah =>
tah.Vendor == v.Vendor_Code && tah.TblTradeAgreementDetails.Any(tad => tad.ItemCode == itemDimFromResult.ItemIserial)));
item.ItemAdjustment.Vendor = (vendor == null ? "" : vendor.Vendor_Ename);
}
/// <summary>
/// لازم يكون معاه الهيدر بتاعه
/// </summary>
/// <param name="context"></param>
/// <param name="item"></param>
private static void GetTransferItemDetails(WorkFlowManagerDBEntities context, TblTransferDetail item)
{
// From
var tempFrom = context.GetItemDimDetails(item.ItemDimFrom);
var itemDimFromResult = tempFrom.FirstOrDefault();
item.ItemTransfer.ItemId = itemDimFromResult.ItemIserial;
item.ItemTransfer.ItemName = itemDimFromResult.ItemName;
item.ItemTransfer.ItemType = itemDimFromResult.ItemType;
item.ItemTransfer.ItemCode = context.FabricAccSearches.FirstOrDefault(fas =>
fas.Iserial == itemDimFromResult.ItemIserial && fas.ItemGroup == itemDimFromResult.ItemType).Code;
item.ItemTransfer.TransferredQuantity = Convert.ToDecimal(item.Quantity);
item.ItemTransfer.ItemDimFromIserial = item.ItemDimFrom;
item.ItemTransfer.ColorFromId = itemDimFromResult.ColorIserial;
item.ItemTransfer.ColorFrom.InjectFrom(context.TblColors.FirstOrDefault(c => c.Iserial == itemDimFromResult.ColorIserial));
item.ItemTransfer.ColorFromCode = itemDimFromResult.ColorCode;
item.ItemTransfer.SizeFrom = itemDimFromResult.Size;
item.ItemTransfer.BatchNoFrom = itemDimFromResult.BatchNo;
item.ItemTransfer.SiteFromIserial = itemDimFromResult.SiteIserial;
// TO
var tempTo = context.GetItemDimDetails(item.ItemDimTo);
var itemDimToResult = tempTo.FirstOrDefault();
item.ItemTransfer.ItemDimToIserial = item.ItemDimTo;
item.ItemTransfer.ColorToId = itemDimToResult.ColorIserial;
item.ItemTransfer.ColorPerRow.InjectFrom(context.TblColors.FirstOrDefault(c => c.Iserial == itemDimToResult.ColorIserial));
item.ItemTransfer.SizeTo = itemDimToResult.Size;
item.ItemTransfer.BatchNoTo = itemDimToResult.BatchNo;
item.ItemTransfer.SiteToIserial = itemDimToResult.SiteIserial;
// From
string warehouseCodeFrom = context.TblWarehouses.FirstOrDefault(tw =>
tw.Iserial == item.TblTransferHeader.WarehouseFrom).Code;
var itemdimFrom = context.TblItemDims.FirstOrDefault(id => id.Iserial == item.ItemDimFrom);
item.ItemTransfer.PendingQuantity = GetItemPendingByWarehouse(context, warehouseCodeFrom, itemdimFrom.Iserial);
if (item.ItemTransfer.ItemType.ToLower().Contains("acc") || item.ItemTransfer.ItemType.ToLower().Contains("fp"))// ده كده اكسيسورى
{
item.ItemTransfer.AvailableQuantity = GetItemQuantityByWarehouse(context, warehouseCodeFrom, itemdimFrom.Iserial);
}
else// كده قماش
{
string itemFromCode = context.FabricAccSearches.FirstOrDefault(fas =>
fas.Iserial == itemdimFrom.ItemIserial && fas.ItemGroup == itemdimFrom.ItemType).Code;
string colorCode = context.TblColors.FirstOrDefault(c => c.Iserial == itemdimFrom.TblColor).Code;
item.ItemTransfer.AvailableQuantity = WarehouseQuantities.GetAvilableQuantity(
warehouseCodeFrom, itemFromCode, colorCode, itemdimFrom.Size, itemdimFrom.BatchNo);
}
// To
string warehouseCodeTo = context.TblWarehouses.FirstOrDefault(tw =>
tw.Iserial == item.TblTransferHeader.WarehouseTo).Code;
var itemdimTo = context.TblItemDims.FirstOrDefault(id => id.Iserial == item.ItemDimTo);
item.ItemTransfer.PendingToQuantity = GetItemPendingByWarehouse(context, warehouseCodeTo, itemdimTo.Iserial);
if (item.ItemTransfer.ItemType.ToLower().Contains("acc") || item.ItemTransfer.ItemType.ToLower().Contains("fp"))// ده كده اكسيسورى
{
item.ItemTransfer.AvailableToQuantity = GetItemQuantityByWarehouse(context, warehouseCodeTo, itemdimTo.Iserial);
}
else// كده قماش
{
string itemToCode = context.FabricAccSearches.FirstOrDefault(fas =>
fas.Iserial == itemdimTo.ItemIserial && fas.ItemGroup == itemdimTo.ItemType).Code;
string colorCode = context.TblColors.FirstOrDefault(c => c.Iserial == itemdimTo.TblColor).Code;
item.ItemTransfer.AvailableToQuantity = WarehouseQuantities.GetAvilableQuantity(
warehouseCodeTo, itemToCode, colorCode, itemdimTo.Size, itemdimTo.BatchNo);
}
}
