예제 #1
0
        //public WasteStockDto GetExisWasteStockByWerksAndMaterial(string werks, string materialNumber)
        //{
        //    var dbdata = _uow.GetGenericRepository<WASTE_STOCK>().Get(p => p.WERKS == werks && p.MATERIAL_NUMBER == materialNumber).FirstOrDefault();

        //    return Mapper.Map<WasteStockDto>(dbdata);
        //}

        public void UpdateWasteStockFromWaste(WasteStockDto input, string userId)
        {
            var dbWasteStock =
                _repository.Get(c => c.WERKS == input.WERKS && c.MATERIAL_NUMBER == input.MATERIAL_NUMBER)
                .FirstOrDefault();

            var origin = Mapper.Map <WasteStockDto>(dbWasteStock);

            if (dbWasteStock == null)
            {
                dbWasteStock = new WASTE_STOCK();
                Mapper.Map <WasteStockDto, WASTE_STOCK>(input, dbWasteStock);

                dbWasteStock.CREATED_BY   = input.CREATED_BY;
                dbWasteStock.CREATED_DATE = DateTime.Now;
            }
            else
            {
                //update
                dbWasteStock.STOCK = input.STOCK;

                dbWasteStock.MODIFIED_BY   = input.CREATED_BY;
                dbWasteStock.MODIFIED_DATE = DateTime.Now;
                var dbData = _repository.GetByID(dbWasteStock.WASTE_STOCK_ID);

                var inputNew = Mapper.Map <WasteStockDto>(dbData);
                if (inputNew.WASTE_STOCK_ID > 0)
                {
                    SetChangesHistory(origin, inputNew, userId);
                }
            }

            _repository.InsertOrUpdate(dbWasteStock);
        }
예제 #2
0
        private bool SetChangesHistory(WasteStockDto origin, WasteStockDto data, string userId)
        {
            bool isModified = false;

            var changesData = new Dictionary <string, bool>();

            changesData.Add("PLANT_ID", origin.WERKS == data.WERKS);
            changesData.Add("MATERIAL_NUMBER", origin.MATERIAL_NUMBER == data.MATERIAL_NUMBER);
            changesData.Add("STOCK", origin.STOCK == data.STOCK);

            foreach (var listChange in changesData)
            {
                if (listChange.Value)
                {
                    continue;
                }
                var changes = new CHANGES_HISTORY();
                changes.FORM_TYPE_ID  = Enums.MenuList.WasteStock;
                changes.FORM_ID       = origin.WASTE_STOCK_ID.ToString();
                changes.FIELD_NAME    = listChange.Key;
                changes.MODIFIED_BY   = userId;
                changes.MODIFIED_DATE = DateTime.Now;
                switch (listChange.Key)
                {
                case "PLANT_ID":
                    changes.OLD_VALUE = origin.WERKS;
                    changes.NEW_VALUE = data.WERKS;
                    break;

                case "MATERIAL_NUMBER":
                    changes.OLD_VALUE = origin.MATERIAL_NUMBER;
                    changes.NEW_VALUE = data.MATERIAL_NUMBER;
                    break;

                case "STOCK":
                    changes.OLD_VALUE = ConvertHelper.ConvertDecimalToStringMoneyFormat(origin.STOCK);
                    changes.NEW_VALUE = ConvertHelper.ConvertDecimalToStringMoneyFormat(data.STOCK);
                    break;
                }

                _changesHistoryBll.AddHistory(changes);
                isModified = true;
            }
            return(isModified);
        }
예제 #3
0
        private void UpdateWasteStockTable(WASTE dbWaste, string userId, bool isNewData)
        {
            var dbdata = GetAllByParam(new WasteGetByParamInput
            {
                Plant = dbWaste.WERKS
            });
            var dbQtyWaste = CalculateWasteQuantity(dbdata);

            if (dbQtyWaste != null)
            {
                var listWasteStockDto = new List <WasteStockDto>();

                decimal?updateValueFloor = dbQtyWaste.FloorWasteGramQty;
                decimal?updateValueDust  = dbQtyWaste.DustWasteGramQty;
                decimal?updateValueStamp = dbQtyWaste.StampWasteQty;

                //if (isNewData && dbQtyWaste.PlantWerks == dbWaste.WERKS)
                //{
                //    updateValueFloor = dbQtyWaste.FloorWasteGramQty + dbWaste.FLOOR_WASTE_GRAM_QTY;
                //    updateValueDust = dbQtyWaste.DustWasteGramQty + dbWaste.DUST_WASTE_GRAM_QTY;
                //    updateValueStamp = dbQtyWaste.StampWasteQty + dbWaste.STAMP_WASTE_QTY;

                //}

                var wasStockWsapoon = new WasteStockDto();
                wasStockWsapoon.WERKS           = dbQtyWaste.PlantWerks;
                wasStockWsapoon.MATERIAL_NUMBER = Constans.WasteFloor;
                wasStockWsapoon.STOCK           = Convert.ToDecimal(updateValueFloor);
                wasStockWsapoon.CREATED_BY      = userId;

                listWasteStockDto.Add(wasStockWsapoon);

                var wasteStockGagang = new WasteStockDto();
                wasteStockGagang.WERKS           = dbQtyWaste.PlantWerks;
                wasteStockGagang.MATERIAL_NUMBER = Constans.WasteDust;
                wasteStockGagang.STOCK           = Convert.ToDecimal(updateValueDust);
                wasteStockGagang.CREATED_BY      = userId;

                listWasteStockDto.Add(wasteStockGagang);

                var wasteStockStem = new WasteStockDto();
                wasteStockStem.WERKS           = dbQtyWaste.PlantWerks;
                wasteStockStem.MATERIAL_NUMBER = Constans.WasteStem;
                wasteStockStem.STOCK           = Convert.ToDecimal(updateValueStamp);
                wasteStockStem.CREATED_BY      = userId;

                listWasteStockDto.Add(wasteStockStem);



                foreach (var wasteStockDto in listWasteStockDto)
                {
                    //CHECK ON MATERIAL PLANT AND STICKER CODE EXIST

                    var dbMaterial = _materialBll.GetByPlantIdAndStickerCode(wasteStockDto.WERKS, wasteStockDto.MATERIAL_NUMBER);

                    if (dbMaterial == null)
                    {
                        throw new BLLException(ExceptionCodes.BLLExceptions.PlantInWasteNotHaveStickerCode);
                    }
                    else
                    {
                        _wasteStockBll.UpdateWasteStockFromWaste(wasteStockDto, userId);
                    }
                }
            }
        }