public Task <int> InsertAsync(DyeingPrintingStockOpnameModel model)
{
model.FlagForCreate(_identityProvider.Username, UserAgent);
foreach (var item in model.DyeingPrintingStockOpnameProductionOrders)
{
item.FlagForCreate(_identityProvider.Username, UserAgent);
}
_dbSet.Add(model);
return(_dbContext.SaveChangesAsync());
}
public Task <int> UpdateAsync(int id, DyeingPrintingStockOpnameModel model)
{
var modelToUpdate = _dbSet.Include(s => s.DyeingPrintingStockOpnameProductionOrders).FirstOrDefault(s => s.Id == id);
modelToUpdate.SetBonNo(model.BonNo, _identityProvider.Username, UserAgent);
modelToUpdate.SetDate(model.Date, _identityProvider.Username, UserAgent);
foreach (var item in modelToUpdate.DyeingPrintingStockOpnameProductionOrders)
{
var localItem = model.DyeingPrintingStockOpnameProductionOrders.FirstOrDefault(s => s.Id == item.Id);
if (localItem == null)
{
item.FlagForDelete(_identityProvider.Username, UserAgent);
}
else
{
item.SetPackingCode(localItem.ProductSKUId, localItem.FabricSKUId, localItem.ProductSKUCode, localItem.ProductPackingId, localItem.FabricPackingId, localItem.ProductPackingCode, false, _identityProvider.Username, UserAgent);
item.SetBalance(localItem.Balance, _identityProvider.Username, UserAgent);
item.SetBuyer(localItem.BuyerId, localItem.Buyer, _identityProvider.Username, UserAgent);
item.SetCartNo(localItem.CartNo, _identityProvider.Username, UserAgent);
item.SetColor(localItem.Color, _identityProvider.Username, UserAgent);
item.SetConstruction(localItem.Construction, _identityProvider.Username, UserAgent);
item.SetGrade(localItem.Grade, _identityProvider.Username, UserAgent);
item.SetMotif(localItem.Motif, _identityProvider.Username, UserAgent);
item.SetProductionOrder(localItem.ProductionOrderId, localItem.ProductionOrderNo, localItem.ProductionOrderType, localItem.ProductionOrderOrderQuantity, _identityProvider.Username, UserAgent);
item.SetRemark(localItem.Remark, _identityProvider.Username, UserAgent);
item.SetPackingInstruction(localItem.PackingInstruction, _identityProvider.Username, UserAgent);
item.SetPackagingUnit(localItem.PackagingUnit, _identityProvider.Username, UserAgent);
item.SetPackagingType(localItem.PackagingType, _identityProvider.Username, UserAgent);
item.SetPackagingQty(localItem.PackagingQty, _identityProvider.Username, UserAgent);
item.SetPackagingLength(localItem.PackagingLength, _identityProvider.Username, UserAgent);
item.SetStatus(localItem.Status, _identityProvider.Username, UserAgent);
item.SetUnit(localItem.Unit, _identityProvider.Username, UserAgent);
item.SetUomUnit(localItem.UomUnit, _identityProvider.Username, UserAgent);
item.SetMaterial(localItem.MaterialId, localItem.MaterialName, _identityProvider.Username, UserAgent);
item.SetMaterialConstruction(localItem.MaterialConstructionId, localItem.MaterialConstructionName, _identityProvider.Username, UserAgent);
item.SetMaterialWidth(localItem.MaterialWidth, _identityProvider.Username, UserAgent);
item.SetDocumentNo(localItem.DocumentNo, _identityProvider.Username, UserAgent);
_dbContext.DyeingPrintingStockOpnameProductionOrders.Update(item);
}
}
foreach (var item in model.DyeingPrintingStockOpnameProductionOrders.Where(s => s.Id == 0))
{
item.FlagForCreate(_identityProvider.Username, UserAgent);
modelToUpdate.DyeingPrintingStockOpnameProductionOrders.Add(item);
}
return(_dbContext.SaveChangesAsync());
}
private async Task <int> CreateStockOpname(StockOpnameWarehouseViewModel viewModel)
{
int result = 0;
var model = _stockOpnameRepository.GetDbSet().AsNoTracking().FirstOrDefault(s => s.Area == DyeingPrintingArea.GUDANGJADI &&
s.Date.Date == viewModel.Date.Date &&
s.Type == DyeingPrintingArea.STOCK_OPNAME);
//viewModel.WarehousesProductionOrders = viewModel.WarehousesProductionOrders.Where(s => s.IsSave).ToList();
viewModel.WarehousesProductionOrders = viewModel.WarehousesProductionOrders.ToList();
if (model == null)
{
int totalCurrentYearData = _stockOpnameRepository.ReadAllIgnoreQueryFilter()
.Count(s => s.Area == DyeingPrintingArea.GUDANGJADI &&
s.CreatedUtc.Year == viewModel.Date.Year && s.Type == DyeingPrintingArea.STOCK_OPNAME);
string bonNo = GenerateBonNo(totalCurrentYearData + 1, viewModel.Date, viewModel.Area);
model = new DyeingPrintingStockOpnameModel(viewModel.Area, bonNo, viewModel.Date, viewModel.Type,
viewModel.WarehousesProductionOrders.Select(s =>
new DyeingPrintingStockOpnameProductionOrderModel(
s.Balance,
s.BuyerId,
s.Buyer,
s.Color,
s.Construction,
s.DocumentNo,
s.Grade,
s.MaterialConstruction.Id,
s.MaterialConstruction.Name,
s.Material.Id,
s.Material.Name,
s.MaterialWidth,
s.Motif,
s.PackingInstruction,
s.PackagingQty,
s.Quantity,
s.PackagingType,
s.PackagingUnit,
s.ProductionOrder.Id,
s.ProductionOrder.No,
s.ProductionOrder.Type,
s.ProductionOrder.OrderQuantity,
s.ProcessType.Id,
s.ProcessType.Name,
s.YarnMaterial.Id,
s.YarnMaterial.Name,
s.Remark,
s.Status,
s.Unit,
s.UomUnit
)).ToList());
result = await _stockOpnameRepository.InsertAsync(model);
//viewModel.WarehousesProductionOrders = viewModel.WarehousesProductionOrders
}
else
{
foreach (var item in viewModel.WarehousesProductionOrders)
{
var modelItem = new DyeingPrintingStockOpnameProductionOrderModel(
item.Balance,
item.BuyerId,
item.Buyer,
item.Color,
item.Construction,
item.DocumentNo,
item.Grade,
item.MaterialConstruction.Id,
item.MaterialConstruction.Name,
item.Material.Id,
item.Material.Name,
item.MaterialWidth,
item.Motif,
item.PackingInstruction,
item.PackagingQty,
item.Quantity,
item.PackagingType,
item.PackagingUnit,
item.ProductionOrder.Id,
item.ProductionOrder.No,
item.ProductionOrder.Type,
item.ProductionOrder.OrderQuantity,
item.ProcessType.Id,
item.ProcessType.Name,
item.YarnMaterial.Id,
item.YarnMaterial.Name,
item.Remark,
item.Status,
item.Unit,
item.UomUnit
);
modelItem.DyeingPrintingStockOpnameId = model.Id;
result += await _stockOpnameProductionOrderRepository.InsertAsync(modelItem);
}
}
return(result);
}
private async Task <StockOpnameWarehouseViewModel> MapToViewModel(DyeingPrintingStockOpnameModel model)
{
var vm = new StockOpnameWarehouseViewModel();
vm = new StockOpnameWarehouseViewModel()
{
Active = model.Active,
Id = model.Id,
Area = model.Area,
BonNo = model.BonNo,
Type = DyeingPrintingArea.STOCK_OPNAME,
Bon = new IndexViewModel
{
Area = model.Area,
BonNo = model.BonNo,
Date = model.Date,
Id = model.Id
},
CreatedAgent = model.CreatedAgent,
CreatedBy = model.CreatedBy,
CreatedUtc = model.CreatedUtc,
Date = model.Date,
DeletedAgent = model.DeletedAgent,
DeletedBy = model.DeletedBy,
DeletedUtc = model.DeletedUtc,
IsDeleted = model.IsDeleted,
LastModifiedAgent = model.LastModifiedAgent,
LastModifiedBy = model.LastModifiedBy,
LastModifiedUtc = model.LastModifiedUtc,
WarehousesProductionOrders = model.DyeingPrintingStockOpnameProductionOrders.Select(s => new StockOpnameWarehouseProductionOrderViewModel()
{
Active = s.Active,
LastModifiedUtc = s.LastModifiedUtc,
Balance = s.Balance,
Buyer = s.Buyer,
BuyerId = s.BuyerId,
Color = s.Color,
Construction = s.Construction,
CreatedAgent = s.CreatedAgent,
CreatedBy = s.CreatedBy,
CreatedUtc = s.CreatedUtc,
DeletedAgent = s.DeletedAgent,
DeletedBy = s.DeletedBy,
DeletedUtc = s.DeletedUtc,
Grade = s.Grade,
GradeProduct = new GradeProduct()
{
Type = s.Grade
},
PackingInstruction = s.PackingInstruction,
Remark = s.Remark,
Status = s.Status,
Id = s.Id,
IsDeleted = s.IsDeleted,
LastModifiedAgent = s.LastModifiedAgent,
LastModifiedBy = s.LastModifiedBy,
Motif = s.Motif,
ProductionOrder = new ProductionOrder()
{
Id = s.ProductionOrderId,
No = s.ProductionOrderNo,
OrderQuantity = s.ProductionOrderOrderQuantity,
Type = s.ProductionOrderType
},
Unit = s.Unit,
MaterialWidth = s.MaterialWidth,
Material = new Material()
{
Id = s.MaterialId,
Name = s.MaterialName
},
MaterialConstruction = new MaterialConstruction()
{
Name = s.MaterialConstructionName,
Id = s.MaterialConstructionId
},
YarnMaterial = new CommonViewModelObjectProperties.YarnMaterial()
{
Id = s.YarnMaterialId,
Name = s.YarnMaterialName
},
ProcessType = new CommonViewModelObjectProperties.ProcessType()
{
Id = s.ProcessTypeId,
Name = s.ProcessTypeName
},
UomUnit = s.UomUnit,
Uom = new UnitOfMeasurement()
{
Unit = s.PackagingUnit
},
PackagingQty = s.PackagingQty,
PackagingType = s.PackagingType,
PackagingUnit = s.PackagingUnit,
ProductionOrderNo = s.ProductionOrderNo,
QtyOrder = s.ProductionOrderOrderQuantity,
DocumentNo = s.DocumentNo,
Quantity = s.PackagingLength,
}).ToList()
};
//foreach (var item in vm.WarehousesProductionOrders)
//{
// var inputData = await _inputProductionOrderRepository.ReadByIdAsync(item.DyeingPrintingAreaInputProductionOrderId);
// if (inputData != null)
// {
// item.BalanceRemains = inputData.BalanceRemains + item.Balance;
// }
//}
return(vm);
}
private async Task <int> UpdateStockOpname(int id, StockOpnameWarehouseViewModel viewModel)
{
string type;
int result = 0;
var dbModel = await _stockOpnameRepository.ReadByIdAsync(id);
var model = new DyeingPrintingStockOpnameModel(
viewModel.Area,
viewModel.BonNo,
viewModel.Date,
viewModel.Type,
viewModel.WarehousesProductionOrders.Select(s => new DyeingPrintingStockOpnameProductionOrderModel(
s.Balance,
s.BuyerId,
s.Buyer,
s.Color,
s.Construction,
s.DocumentNo,
s.Grade,
s.MaterialConstruction.Id,
s.MaterialConstruction.Name,
s.Material.Id,
s.Material.Name,
s.MaterialWidth,
s.Motif,
s.PackingInstruction,
s.PackagingQty,
s.Quantity,
s.PackagingType,
s.PackagingUnit,
s.ProductionOrder.Id,
s.ProductionOrder.No,
s.ProductionOrder.Type,
s.ProductionOrder.OrderQuantity,
s.ProcessType.Id,
s.ProcessType.Name,
s.YarnMaterial.Id,
s.YarnMaterial.Name,
s.Remark,
s.Status,
s.Unit,
s.UomUnit
)
{
Id = s.Id
}).ToList());
Dictionary <int, double> dictBalance = new Dictionary <int, double>();
Dictionary <int, decimal> dictQtyPacking = new Dictionary <int, decimal>();
foreach (var item in dbModel.DyeingPrintingStockOpnameProductionOrders)
{
var lclModel = model.DyeingPrintingStockOpnameProductionOrders.FirstOrDefault(s => s.Id == item.Id);
if (lclModel != null)
{
var diffBalance = lclModel.Balance - item.Balance;
var diffQtyPacking = lclModel.PackagingQty - item.PackagingQty;
dictBalance.Add(lclModel.Id, diffBalance);
dictQtyPacking.Add(lclModel.Id, diffQtyPacking);
}
}
var deletedData = dbModel.DyeingPrintingStockOpnameProductionOrders.Where(s => !model.DyeingPrintingStockOpnameProductionOrders.Any(d => d.Id == s.Id)).ToList();
// result = await _outputRepository.UpdateAdjustmentData(id, model, dbModel);
if (dbModel != null)
{
result = await _stockOpnameRepository.UpdateAsync(id, model);
}
return(result);
}
