Exemple #1
0
        public void ClientDeletion(MaterialDto data, string userId)
        {
            var original = _repository.Get(x => x.STICKER_CODE == data.STICKER_CODE && x.WERKS == data.WERKS, null, "").FirstOrDefault();


            var datatobeclientdeleted = _repository.Get(x => x.STICKER_CODE == data.STICKER_CODE, null, "").ToList();

            foreach (var detail in datatobeclientdeleted)
            {
                if (original.CLIENT_DELETION != data.CLIENT_DELETION)
                {
                    var changes = new CHANGES_HISTORY
                    {
                        FORM_TYPE_ID  = Core.Enums.MenuList.MaterialMaster,
                        FORM_ID       = detail.STICKER_CODE + detail.WERKS,
                        FIELD_NAME    = "CLIENT_DELETION",
                        MODIFIED_BY   = userId,
                        MODIFIED_DATE = DateTime.Now,
                        OLD_VALUE     = detail.CLIENT_DELETION.HasValue ? detail.CLIENT_DELETION.Value.ToString() : "NULL",
                        NEW_VALUE     = data.CLIENT_DELETION.HasValue ? data.CLIENT_DELETION.ToString() : "NULL"
                    };

                    _changesHistoryBll.AddHistory(changes);
                }
                detail.CLIENT_DELETION = data.CLIENT_DELETION;
            }


            //_uow.SaveChanges();
        }
Exemple #2
0
        public void SaveUoM(MATERIAL_UOM data, string userid)
        {
            try
            {
                string newdata = string.Format("{0} - {1}", data.MEINH, data.UMREN);

                var changes = new CHANGES_HISTORY
                {
                    FORM_TYPE_ID  = Core.Enums.MenuList.MaterialMaster,
                    FORM_ID       = data.STICKER_CODE + data.WERKS,
                    FIELD_NAME    = "CONVERTION_ADDED",
                    MODIFIED_BY   = userid,
                    MODIFIED_DATE = DateTime.Now,
                    OLD_VALUE     = string.Empty,
                    NEW_VALUE     = newdata
                };
                _repositoryUoM.InsertOrUpdate(data);
                _changesHistoryBll.AddHistory(changes);
                //_uow.SaveChanges();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #3
0
        public int DeleteMaterialUom(int id, string userId, string mn, string p)
        {
            try
            {
                var    existingData = _repositoryUoM.GetByID(id);
                string oldData      = string.Format("{0} - {1}", existingData.MEINH, existingData.UMREN);

                _repositoryUoM.Delete(id);

                var changes = new CHANGES_HISTORY
                {
                    FORM_TYPE_ID  = Core.Enums.MenuList.MaterialMaster,
                    FORM_ID       = mn + p,
                    FIELD_NAME    = "CONVERTION_DELETED",
                    MODIFIED_BY   = userId,
                    MODIFIED_DATE = DateTime.Now,
                    OLD_VALUE     = oldData,
                    NEW_VALUE     = string.Empty
                };

                _changesHistoryBll.AddHistory(changes);

                _uow.SaveChanges();
            }
            catch (Exception)
            {
                return(-1);
            }
            return(0);
        }
        public bool Delete(int id, string userId)
        {
            var newStatus = false;
            var data      = _repository.GetByID(id);

            var changes = new CHANGES_HISTORY
            {
                FORM_TYPE_ID  = Core.Enums.MenuList.VirtualMappingPlant,
                FORM_ID       = data.VIRTUAL_PLANT_MAP_ID.ToString(),
                FIELD_NAME    = "IS_ACTIVE",
                MODIFIED_BY   = userId,
                MODIFIED_DATE = DateTime.Now,
                OLD_VALUE     = data.IS_DELETED.HasValue ? data.IS_DELETED.Value.ToString() : "NULL",
                NEW_VALUE     = data.IS_DELETED.HasValue && data.IS_DELETED.Value ? "FALSE" : "TRUE"
            };

            if (data.IS_DELETED.HasValue && data.IS_DELETED.Value)
            {
                //Activate
                data.IS_DELETED = false;
            }
            else
            {
                //DeActivate
                data.IS_DELETED = true;
                newStatus       = true;
            }
            _repository.Update(data);

            _changesHistoryBll.AddHistory(changes);

            _uow.SaveChanges();

            return(newStatus);
        }
        private void SetChange(EX_GROUP_TYPE origin, List <EX_GROUP_TYPE_DETAILS> data, string userId)
        {
            var changesData          = new Dictionary <string, bool>();
            var originExgoodTyplDesc = string.Empty;
            var goodtypeslist        = _repositoryGoodType.Get().ToList();

            if (origin.EX_GROUP_TYPE_DETAILS != null)
            {
                var orlength = origin.EX_GROUP_TYPE_DETAILS.Count;
                var currOr   = 0;
                foreach (var or in origin.EX_GROUP_TYPE_DETAILS)
                {
                    currOr++;
                    originExgoodTyplDesc += or.ZAIDM_EX_GOODTYP.EXT_TYP_DESC;
                    if (currOr < orlength)
                    {
                        originExgoodTyplDesc += ",";
                    }
                }
            }
            var editExgoodTyplDesc = string.Empty;

            if (data != null)
            {
                var newLenght = data.Count;
                var currNew   = 0;
                foreach (var newdata in data)
                {
                    currNew++;
                    editExgoodTyplDesc += goodtypeslist.Where(x => x.EXC_GOOD_TYP == newdata.GOODTYPE_ID).Select(x => x.EXT_TYP_DESC).FirstOrDefault();
                    if (currNew < newLenght)
                    {
                        editExgoodTyplDesc += ",";
                    }
                }
            }
            changesData.Add("Excisable Group Details", originExgoodTyplDesc == editExgoodTyplDesc);
            foreach (var listChange in changesData)
            {
                if (!listChange.Value)
                {
                    var changes = new CHANGES_HISTORY
                    {
                        FORM_TYPE_ID  = Core.Enums.MenuList.GoodsTypeGroup,
                        FORM_ID       = origin.EX_GROUP_TYPE_ID.ToString(),
                        FIELD_NAME    = listChange.Key,
                        MODIFIED_BY   = userId,
                        MODIFIED_DATE = DateTime.Now
                    };
                    switch (listChange.Key)
                    {
                    case "Excisable Group Details":
                        changes.OLD_VALUE = originExgoodTyplDesc;
                        changes.NEW_VALUE = editExgoodTyplDesc;
                        break;
                    }
                    _changesHistoryBll.AddHistory(changes);
                }
            }
        }
Exemple #6
0
        private bool SetChangesHistory(POA_DELEGATIONDto origin, POA_DELEGATIONDto data, string userId)
        {
            bool isModified = false;

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

            changesData.Add("DELEGATION_FROM", origin.POA_FROM == data.POA_FROM);
            changesData.Add("DELEGATION_TO", origin.POA_TO == data.POA_TO);
            changesData.Add("FROM_DATE", origin.DATE_FROM == data.DATE_FROM);
            changesData.Add("TO_DATE", origin.DATE_TO == data.DATE_TO);
            changesData.Add("REASON", origin.REASON == data.REASON);

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

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

                case "FROM_DATE":
                    changes.OLD_VALUE = ConvertHelper.ConvertDateToStringddMMMyyyy(origin.DATE_FROM);
                    changes.NEW_VALUE = ConvertHelper.ConvertDateToStringddMMMyyyy(data.DATE_FROM);
                    break;

                case "TO_DATE":
                    changes.OLD_VALUE = ConvertHelper.ConvertDateToStringddMMMyyyy(origin.DATE_TO);
                    changes.NEW_VALUE = ConvertHelper.ConvertDateToStringddMMMyyyy(data.DATE_TO);
                    break;

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

                _changesHistoryBll.AddHistory(changes);
                isModified = true;
            }
            return(isModified);
        }
        private void AddHistoryCreate(string plant, string facode, string stickercode)
        {
            var history = new CHANGES_HISTORY();

            history.FORM_TYPE_ID  = Enums.MenuList.BrandRegistration;
            history.FORM_ID       = plant + facode + stickercode;
            history.FIELD_NAME    = "NEW_DATA";
            history.OLD_VALUE     = "";
            history.NEW_VALUE     = "";
            history.MODIFIED_DATE = DateTime.Now;
            history.MODIFIED_BY   = CurrentUser.USER_ID;

            _changesHistoryBll.AddHistory(history);
        }
        private void SetChanges(VIRTUAL_PLANT_MAP origin, VIRTUAL_PLANT_MAP data, string userId)
        {
            var changesData = new Dictionary <string, bool>();

            changesData.Add("COMPANY_ID", origin.COMPANY_ID.Equals(data.COMPANY_ID));
            changesData.Add("IMPORT_PLANT_ID", origin.IMPORT_PLANT_ID.Equals(data.IMPORT_PLANT_ID));
            changesData.Add("EXPORT_PLANT_ID", origin.EXPORT_PLANT_ID.Equals(data.EXPORT_PLANT_ID));
            changesData.Add("IS_DELETED", origin.IS_DELETED.Equals(data.IS_DELETED));


            foreach (var listChange in changesData)
            {
                if (!listChange.Value)
                {
                    var changes = new CHANGES_HISTORY
                    {
                        FORM_TYPE_ID  = Core.Enums.MenuList.HeaderFooter,
                        FORM_ID       = data.VIRTUAL_PLANT_MAP_ID.ToString(),
                        FIELD_NAME    = listChange.Key,
                        MODIFIED_BY   = userId,
                        MODIFIED_DATE = DateTime.Now
                    };
                    switch (listChange.Key)
                    {
                    case "COMPANY_ID":
                        changes.OLD_VALUE = origin.COMPANY_ID;
                        changes.NEW_VALUE = data.COMPANY_ID;
                        break;

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

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

                    case "IS_DELETED":
                        changes.OLD_VALUE = origin.IS_DELETED.HasValue ? origin.IS_DELETED.Value.ToString() : "NULL";
                        changes.NEW_VALUE = data.IS_DELETED.HasValue ? data.IS_DELETED.Value.ToString() : "NULL";
                        break;
                    }
                    _changesHistoryBll.AddHistory(changes);
                }
            }
        }
Exemple #9
0
        private void SetChangeHistory(string oldValue, string newValue, string fieldName,
                                      string userId, string wasteRoleId)
        {
            var changes = new CHANGES_HISTORY();

            changes.FORM_TYPE_ID  = Enums.MenuList.WasteRole;
            changes.FORM_ID       = wasteRoleId;
            changes.FIELD_NAME    = fieldName;
            changes.MODIFIED_BY   = userId;
            changes.MODIFIED_DATE = DateTime.Now;

            changes.OLD_VALUE = oldValue;
            changes.NEW_VALUE = newValue;

            _changesHistoryBll.AddHistory(changes);
        }
        private void SetChanges(UserAuthorizationDto origin, List <PageMapDto> New)
        {
            var changesData    = new Dictionary <string, bool>();
            var originPageList = string.Empty;

            if (origin.PageMaps != null)
            {
                for (int i = 0; i < origin.PageMaps.Count; i++)
                {
                    originPageList += origin.PageMaps[i].Page.PageName;
                    if (i < (origin.PageMaps.Count - 1))
                    {
                        originPageList += ", ";
                    }
                }
            }
            var newPageList = string.Empty;

            if (New != null)
            {
                for (int i = 0; i < New.Count; i++)
                {
                    newPageList += New[i].Page.PageName;
                    if (i < (New.Count - 1))
                    {
                        newPageList += ", ";
                    }
                }
            }

            if (originPageList != newPageList)
            {
                var changes = new CHANGES_HISTORY();
                changes.FORM_TYPE_ID  = Enums.MenuList.UserAuthorization;
                changes.FORM_ID       = origin.Brole;
                changes.FIELD_NAME    = "PAGE";
                changes.MODIFIED_BY   = CurrentUser.USER_ID;
                changes.MODIFIED_DATE = DateTime.Now;

                changes.OLD_VALUE = originPageList;
                changes.NEW_VALUE = newPageList;


                _changesHistoryBll.AddHistory(changes);
            }
        }
        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);
        }
Exemple #12
0
        private bool SetChangesHistory(WasteRoleDto origin, WasteRoleDto data, string userId)
        {
            bool isModified = false;

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

            changesData.Add("USER_ID", origin.USER_ID == data.USER_ID);
            changesData.Add("PLANT_ID", origin.WERKS == data.WERKS);
            changesData.Add("WASTE_GROUP", origin.GROUP_ROLE == data.GROUP_ROLE);

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

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

                case "WASTE_GROUP":
                    changes.OLD_VALUE = EnumHelper.GetDescription(origin.GROUP_ROLE);
                    changes.NEW_VALUE = EnumHelper.GetDescription(data.GROUP_ROLE);
                    break;
                }

                _changesHistoryBll.AddHistory(changes);
                isModified = true;
            }
            return(isModified);
        }
        private void SetChanges(UOM origin, UOM data, string userId)
        {
            var changesData = new Dictionary <string, bool>();

            changesData.Add("UOM_ID", origin.UOM_ID == data.UOM_ID);
            changesData.Add("UOM_DESC", origin.UOM_DESC == data.UOM_DESC);
            changesData.Add("IS_EMS", origin.IS_EMS == data.IS_EMS);
            //changesData.Add("HEADER_FOOTER_FORM_MAP", origin.HEADER_FOOTER_FORM_MAP.Equals(poa.HEADER_FOOTER_FORM_MAP));

            foreach (var listChange in changesData)
            {
                if (!listChange.Value)
                {
                    var changes = new CHANGES_HISTORY
                    {
                        FORM_TYPE_ID  = Core.Enums.MenuList.Uom,
                        FORM_ID       = data.UOM_ID.ToString(),
                        FIELD_NAME    = listChange.Key,
                        MODIFIED_BY   = userId,
                        MODIFIED_DATE = DateTime.Now
                    };
                    switch (listChange.Key)
                    {
                    case "UOM_ID":
                        changes.OLD_VALUE = origin.UOM_ID.ToString();
                        changes.NEW_VALUE = data.UOM_ID.ToString();
                        break;

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

                    case "IS_EMS":
                        changes.OLD_VALUE = origin.IS_EMS.HasValue? origin.IS_EMS.Value? "Yes" : "No" : "No";
                        changes.NEW_VALUE = data.IS_EMS.HasValue ? data.IS_EMS.Value ? "Yes" : "No" : "No";
                        break;

                    default: break;
                    }
                    _changeBLL.AddHistory(changes);
                }
            }
        }
Exemple #14
0
        private void UpdateChangesHistory(MASTER_DATA_APPROVAL data)
        {
            var formId = data.FORM_ID.Split('-');

            foreach (var detail in data.MASTER_DATA_APPROVAL_DETAIL)
            {
                var changesFormId = "";
                switch (data.PAGE_ID)
                {
                case (int)Enums.MenuList.BrandRegistration:
                    var werks       = formId[0];
                    var facode      = formId[1];
                    var stickerCode = formId[2];
                    changesFormId = werks + facode + stickerCode;
                    break;

                case (int)Enums.MenuList.POA:
                    changesFormId = data.FORM_ID;
                    break;

                case (int)Enums.MenuList.POAMap:
                    changesFormId = data.FORM_ID;
                    break;

                case (int)Enums.MenuList.MaterialMaster:
                    var werksM = formId[0];

                    var stickerCodeM = formId[1];
                    changesFormId = stickerCodeM + werksM;
                    break;
                }

                CHANGES_HISTORY changes = new CHANGES_HISTORY();
                changes.FIELD_NAME    = detail.COLUMN_DESCRIPTION.ToUpper();
                changes.FORM_ID       = changesFormId;
                changes.FORM_TYPE_ID  = (Enums.MenuList)data.PAGE_ID;
                changes.MODIFIED_BY   = data.APPROVED_BY;
                changes.MODIFIED_DATE = data.APPROVED_DATE;
                changes.NEW_VALUE     = detail.NEW_VALUE;
                changes.OLD_VALUE     = detail.OLD_VALUE;

                _changesHistoryBLL.AddHistory(changes);
            }
        }
        private void SetChanges(VIRTUAL_PLANT_MAP origin, VirtualMappingPlantEditViewModel data, string userId)
        {
            var changesData = new Dictionary <string, bool>();

            changesData.Add("COMPANY_ID", origin.COMPANY_ID.Equals(data.CompanyId));
            changesData.Add("EXPORT_PLANT", origin.EXPORT_PLANT_ID.Equals(data.ExportPlantId));
            changesData.Add("IMPORT_PLANT", origin.IMPORT_PLANT_ID.Equals(data.ImportPlantId));

            foreach (var listChange in changesData)
            {
                if (listChange.Value == false)
                {
                    var changes = new CHANGES_HISTORY
                    {
                        FORM_TYPE_ID  = Core.Enums.MenuList.VirtualMappingPlant,
                        FORM_ID       = data.VirtualMapId.ToString(),
                        FIELD_NAME    = listChange.Key,
                        MODIFIED_BY   = userId,
                        MODIFIED_DATE = DateTime.Now
                    };
                    switch (listChange.Key)
                    {
                    case "COMPANY_ID":
                        changes.OLD_VALUE = origin.COMPANY_ID;
                        changes.NEW_VALUE = data.CompanyId;
                        break;

                    case "EXPORT_PLANT":
                        changes.OLD_VALUE = origin.EXPORT_PLANT_ID;
                        changes.NEW_VALUE = data.ExportPlantId;
                        break;

                    case "IMPORT_PLANT":
                        changes.OLD_VALUE = origin.IMPORT_PLANT_ID;
                        changes.NEW_VALUE = data.ImportPlantId;
                        break;
                    }
                    _changesHistoryBLL.AddHistory(changes);
                }
            }
        }
        public void Delete(int id, string userId)
        {
            var existingData = _repository.GetByID(id);

            _repository.Update(existingData);

            var changes = new CHANGES_HISTORY
            {
                FORM_TYPE_ID  = Core.Enums.MenuList.HeaderFooter,
                FORM_ID       = existingData.HEADER_FOOTER_ID.ToString(),
                FIELD_NAME    = "IS_DELETED",
                MODIFIED_BY   = userId,
                MODIFIED_DATE = DateTime.Now,
                OLD_VALUE     = existingData.IS_DELETED.HasValue ? existingData.IS_DELETED.Value.ToString() : "NULL",
                NEW_VALUE     = true.ToString()
            };

            existingData.IS_DELETED = true;
            _changesHistoryBll.AddHistory(changes);
            _uow.SaveChanges();
        }
        public void AddChangeLog(EMSDataModel context, int formType, string formId, string field, string oldVal, string newVal, string actor, DateTime?logTime)
        {
            try
            {
                CHANGES_HISTORY log = new CHANGES_HISTORY()
                {
                    FORM_TYPE_ID  = formType,
                    FORM_ID       = formId,
                    FIELD_NAME    = field,
                    OLD_VALUE     = oldVal,
                    NEW_VALUE     = newVal,
                    MODIFIED_BY   = actor,
                    MODIFIED_DATE = logTime
                };

                context.CHANGES_HISTORY.Add(log);
            }
            catch (Exception ex)
            {
                throw this.HandleException("Exception occured on SystemReferenceService. See Inner Exception property to see details", ex);
            }
        }
Exemple #18
0
        public void PlantDeletion(MaterialDto data, string userId)
        {
            var original = _repository.Get(x => x.STICKER_CODE == data.STICKER_CODE && x.WERKS == data.WERKS, null, "").FirstOrDefault();

            if (original.PLANT_DELETION != data.PLANT_DELETION)
            {
                var changes = new CHANGES_HISTORY
                {
                    FORM_TYPE_ID  = Core.Enums.MenuList.MaterialMaster,
                    FORM_ID       = data.STICKER_CODE + data.WERKS,
                    FIELD_NAME    = "PLANT_DELETION",
                    MODIFIED_BY   = userId,
                    MODIFIED_DATE = DateTime.Now,
                    OLD_VALUE     = data.PLANT_DELETION.HasValue ? data.PLANT_DELETION.Value.ToString() : "NULL",
                    NEW_VALUE     = true.ToString()
                };

                _changesHistoryBll.AddHistory(changes);
            }

            original.PLANT_DELETION = data.PLANT_DELETION;
        }
        private void SetChanges(HEADER_FOOTER_FORM_MAP origin, HEADER_FOOTER_FORM_MAP data, string userId)
        {
            var changeData = new Dictionary <string, bool>();

            changeData.Add("FORM_TYPE_ID", origin.FORM_TYPE_ID.Equals(data.FORM_TYPE_ID));
            changeData.Add("IS_HEADER_SET", origin.IS_HEADER_SET.Equals(data.IS_HEADER_SET));
            changeData.Add("IS_FOOTER_SET", origin.IS_FOOTER_SET.Equals(data.IS_FOOTER_SET));

            foreach (var listchange in changeData)
            {
                var change = new CHANGES_HISTORY
                {
                    FORM_TYPE_ID  = Enums.MenuList.HeaderFooter,
                    FORM_ID       = data.HEADER_FOOTER_FORM_MAP_ID.ToString(),
                    FIELD_NAME    = listchange.Key,
                    MODIFIED_BY   = userId,
                    MODIFIED_DATE = DateTime.Now
                };
                switch (listchange.Key)
                {
                case "IS_HEADER_SET":
                    change.OLD_VALUE = origin.IS_HEADER_SET.ToString();
                    change.NEW_VALUE = data.IS_HEADER_SET.ToString();
                    break;

                case "IS_FOOTER_SET":
                    change.OLD_VALUE = origin.IS_FOOTER_SET.ToString();
                    change.NEW_VALUE = origin.IS_FOOTER_SET.ToString();
                    break;

                case "FORM_TYPE_ID":
                    change.OLD_VALUE = origin.FORM_TYPE_ID.ToString();
                    change.NEW_VALUE = origin.IS_FOOTER_SET.ToString();
                    break;
                }
                _changesHistoryBll.AddHistory(change);
            }
        }
Exemple #20
0
        public void Delete(string mn, string p, string userId)
        {
            var existingData = _repository.GetByID(mn, p);

            //existingData.CHANGED_BY = userId;
            //existingData.CHANGED_DATE = DateTime.Now;
            _repository.Update(existingData);

            var changes = new CHANGES_HISTORY
            {
                FORM_TYPE_ID  = Core.Enums.MenuList.MaterialMaster,
                FORM_ID       = existingData.STICKER_CODE,
                FIELD_NAME    = "IS_DELETED",
                MODIFIED_BY   = userId,
                MODIFIED_DATE = DateTime.Now,
                NEW_VALUE     = true.ToString()
            };

            _changesHistoryBll.AddHistory(changes);

            var output = new MaterialOutput();

            try
            {
                _uow.SaveChanges();
                output.Success    = true;
                output.materialId = existingData.STICKER_CODE;
            }
            catch (Exception exception)
            {
                _logger.Error(exception);
                output.Success      = false;
                output.ErrorCode    = ExceptionCodes.BaseExceptions.unhandled_exception.ToString();
                output.ErrorMessage = EnumHelper.GetDescription(ExceptionCodes.BaseExceptions.unhandled_exception);
            }
        }
Exemple #21
0
        private bool SetChange(WasteDto origin, WasteDto data, string userId)
        {
            bool isModified = false;
            var  changeData = new Dictionary <string, bool>();

            changeData.Add("COMPANY_CODE", origin.CompanyCode == data.CompanyCode);
            changeData.Add("WERKS", origin.PlantWerks == data.PlantWerks);
            changeData.Add("FA_CODE", origin.FaCode == data.FaCode);
            changeData.Add("WASTE_DATE", origin.WasteProductionDate == data.WasteProductionDate);
            changeData.Add("BRAND_DESC", origin.BrandDescription == data.BrandDescription);
            changeData.Add("PLANT_NAME", origin.PlantName == data.PlantName);
            changeData.Add("COMPANY_NAME", origin.CompanyName == data.CompanyName);
            changeData.Add("MARKER_REJECT_STICK_QTY", origin.MarkerRejectStickQty == Convert.ToDecimal(data.MarkerStr));
            changeData.Add("PACKER_REJECT_STICK_QTY", origin.PackerRejectStickQty == Convert.ToDecimal(data.PackerStr));
            changeData.Add("DUST_WASTE_GRAM_QTY", origin.DustWasteGramQty == Convert.ToDecimal(data.DustGramStr));
            changeData.Add("FLOOR_WASTE_GRAM_QTY", origin.FloorWasteGramQty == Convert.ToDecimal(data.FloorGramStr));
            //changeData.Add("DUST_WASTE_STICK_QTY", origin.DustWasteStickQty == data.DustWasteStickQty);
            //changeData.Add("FLOOR_WASTE_STICK_QTY", origin.FloorWasteStickQty == data.FloorWasteStickQty);
            changeData.Add("STAMP_WASTE_QTY", origin.StampWasteQty == Convert.ToDecimal(data.StampWasteQtyStr));

            foreach (var listChange in changeData)
            {
                if (listChange.Value)
                {
                    continue;
                }
                {
                    var changes = new CHANGES_HISTORY()
                    {
                        FORM_TYPE_ID = Core.Enums.MenuList.CK4C,
                        FORM_ID      = "Waste_" + data.CompanyCode + "_" + data.PlantWerks + "_" + data.FaCode + "_" +
                                       data.WasteProductionDate.ToString("ddMMMyyyy"),
                        FIELD_NAME    = listChange.Key,
                        MODIFIED_BY   = userId,
                        MODIFIED_DATE = DateTime.Now
                    };

                    switch (listChange.Key)
                    {
                    case "COMPANY_CODE":
                        changes.OLD_VALUE  = origin.CompanyCode;
                        changes.NEW_VALUE  = data.CompanyCode;
                        changes.FIELD_NAME = "Company";
                        break;

                    case "WERKS":
                        changes.OLD_VALUE  = origin.PlantWerks;
                        changes.NEW_VALUE  = data.PlantWerks;
                        changes.FIELD_NAME = "Plant";
                        break;

                    case "FA_CODE":
                        changes.OLD_VALUE  = origin.FaCode;
                        changes.NEW_VALUE  = data.FaCode;
                        changes.FIELD_NAME = "Finish Goods";
                        break;

                    case "WASTE_DATE":
                        changes.OLD_VALUE  = origin.WasteProductionDate.ToString();
                        changes.NEW_VALUE  = data.WasteProductionDate.ToString();
                        changes.FIELD_NAME = "Waste Production Date";
                        break;

                    case "BRAND_DESC":
                        changes.OLD_VALUE  = origin.BrandDescription;
                        changes.NEW_VALUE  = data.BrandDescription;
                        changes.FIELD_NAME = "Brand Description";
                        break;

                    case "PLANT_NAME":
                        changes.OLD_VALUE  = origin.PlantName;
                        changes.NEW_VALUE  = data.PlantName;
                        changes.FIELD_NAME = "Plant";
                        break;

                    case "COMPANY_NAME":
                        changes.OLD_VALUE  = origin.CompanyName;
                        changes.NEW_VALUE  = data.CompanyName;
                        changes.FIELD_NAME = "Company";
                        break;

                    case "MARKER_REJECT_STICK_QTY":
                        changes.OLD_VALUE  = origin.MarkerRejectStickQty.ToString();
                        changes.NEW_VALUE  = data.MarkerStr;
                        changes.FIELD_NAME = "Maker Reject Cigarette(stick)";
                        break;

                    case "PACKER_REJECT_STICK_QTY":
                        changes.OLD_VALUE  = origin.PackerRejectStickQty.ToString();
                        changes.NEW_VALUE  = data.PackerStr;
                        changes.FIELD_NAME = "Packer Reject Cigarette(stick)";
                        break;

                    case "DUST_WASTE_GRAM_QTY":
                        changes.OLD_VALUE  = origin.DustWasteGramQty.ToString();
                        changes.NEW_VALUE  = data.DustGramStr;
                        changes.FIELD_NAME = "Dust Waste QTY (gram)";
                        break;

                    case "FLOOR_WASTE_GRAM_QTY":
                        changes.OLD_VALUE  = origin.FloorWasteGramQty.ToString();
                        changes.NEW_VALUE  = data.FloorGramStr;
                        changes.FIELD_NAME = "Floor Waste QTY (gram)";
                        break;

                    //case "DUST_WASTE_STICK_QTY":
                    //    changes.OLD_VALUE = origin.DustWasteStickQty.ToString();
                    //    changes.NEW_VALUE = data.DustWasteStickQty.ToString();
                    //    changes.FIELD_NAME = "Dust Waste QTY (Stick)";
                    //    break;
                    //case "FLOOR_WASTE_STICK_QTY":
                    //    changes.OLD_VALUE = origin.FloorWasteStickQty.ToString();
                    //    changes.NEW_VALUE = data.FloorWasteStickQty.ToString();
                    //    changes.FIELD_NAME = "Floor Waste QTY (Stick)";
                    //    break;
                    case "STAMP_WASTE_QTY":
                        changes.OLD_VALUE = origin.StampWasteQty.ToString();
                        changes.NEW_VALUE = data.StampWasteQtyStr;
                        break;

                    default: break;
                    }

                    _changesHistoryBll.AddHistory(changes);
                    isModified = true;
                }
            }
            return(isModified);
        }
Exemple #22
0
        private void SetChanges(T001W origin, Plant data, string userId, List <PLANT_RECEIVE_MATERIAL> originReceive)
        {
            var changesData = new Dictionary <string, bool>();

            changesData.Add("NPPBKC_ID", origin.NPPBKC_ID == data.NPPBKC_ID);
            changesData.Add("NPPBKC_IMPORT_ID", origin.NPPBKC_IMPORT_ID == data.NPPBKC_IMPORT_ID);
            changesData.Add("CITY", origin.ORT01 == data.ORT01);
            changesData.Add("ADDRESS", origin.ADDRESS == data.ADDRESS);
            changesData.Add("SKEPTIS", origin.SKEPTIS == data.SKEPTIS);
            changesData.Add("IS_MAIN_PLANT", origin.IS_MAIN_PLANT == data.IS_MAIN_PLANT);
            changesData.Add("PHONE", origin.PHONE == data.PHONE);

            var originMaterialDesc = string.Empty;

            if (originReceive != null)
            {
                var orLength = originReceive.Count;
                var currOr   = 0;
                foreach (var or in originReceive)
                {
                    currOr++;
                    originMaterialDesc += or.ZAIDM_EX_GOODTYP.EXT_TYP_DESC;
                    if (currOr < orLength)
                    {
                        originMaterialDesc += ", ";
                    }
                }
            }
            var editMaterialDesc = string.Empty;

            if (data.PLANT_RECEIVE_MATERIAL != null)
            {
                var orLength = data.PLANT_RECEIVE_MATERIAL.Count;
                var currOr   = 0;
                foreach (var or in data.PLANT_RECEIVE_MATERIAL)
                {
                    currOr++;
                    editMaterialDesc += or.ZAIDM_EX_GOODTYP.EXT_TYP_DESC;
                    if (currOr < orLength)
                    {
                        editMaterialDesc += ", ";
                    }
                }
            }
            changesData.Add("RECEIVE_MATERIAL", originMaterialDesc == editMaterialDesc);
            foreach (var listChange in changesData)
            {
                if (!listChange.Value)
                {
                    var changes = new CHANGES_HISTORY
                    {
                        FORM_TYPE_ID  = Core.Enums.MenuList.MasterPlant,
                        FORM_ID       = data.WERKS,
                        FIELD_NAME    = listChange.Key,
                        MODIFIED_BY   = userId,
                        MODIFIED_DATE = DateTime.Now
                    };
                    switch (listChange.Key)
                    {
                    case "NPPBKC_ID":
                        changes.OLD_VALUE = origin.ZAIDM_EX_NPPBKC != null ? origin.NPPBKC_ID : "NULL";
                        changes.NEW_VALUE = data.NPPBKC_ID;
                        break;

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

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

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

                    case "IS_MAIN_PLANT":
                        changes.OLD_VALUE = origin.IS_MAIN_PLANT.HasValue ? origin.IS_MAIN_PLANT.Value.ToString() : "NULL";
                        changes.NEW_VALUE = data.IS_MAIN_PLANT.HasValue ? data.IS_MAIN_PLANT.Value.ToString() : "NULL";
                        break;

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

                    case "RECEIVE_MATERIAL":
                        changes.OLD_VALUE = originMaterialDesc;
                        changes.NEW_VALUE = editMaterialDesc;
                        break;

                    case "NPPBKC_IMPORT_ID":
                        changes.OLD_VALUE = origin.NPPBKC_IMPORT_ID;
                        changes.NEW_VALUE = data.NPPBKC_IMPORT_ID;
                        break;
                    }
                    _changesHistoryBll.AddHistory(changes);
                }
            }
        }
        private void SetChangesLog(ZAIDM_EX_BRAND origin, BrandRegistrationEditViewModel updatedModel)
        {
            var changesData = new Dictionary <string, bool>();

            updatedModel.HjeValue      = updatedModel.HjeValueStr == null ? 0: Convert.ToDecimal(updatedModel.HjeValueStr);
            updatedModel.Tariff        = updatedModel.TariffValueStr == null ? 0 : Convert.ToDecimal(updatedModel.TariffValueStr);
            updatedModel.Conversion    = updatedModel.ConversionValueStr == null ? 0 : Convert.ToDecimal(updatedModel.ConversionValueStr);
            updatedModel.PrintingPrice = updatedModel.PrintingPriceValueStr == null ? 0 : Convert.ToDecimal(updatedModel.PrintingPriceValueStr);


            if (origin.IS_FROM_SAP.HasValue == false || origin.IS_FROM_SAP.Value == false)
            {
                changesData.Add("FACode", origin.FA_CODE == updatedModel.FaCode);
                changesData.Add("PersonalizationCode", origin.PER_CODE == updatedModel.PersonalizationCode);
                changesData.Add("BrandName", origin.BRAND_CE == updatedModel.BrandName);
                changesData.Add("SkepNo", origin.SKEP_NO == updatedModel.SkepNo);
                changesData.Add("SkepDate", origin.SKEP_DATE == updatedModel.SkepDate);
                changesData.Add("ProductCode", origin.PROD_CODE == updatedModel.ProductCode);
                changesData.Add("SeriesId", origin.SERIES_CODE == updatedModel.SeriesId);
                changesData.Add("Content", origin.BRAND_CONTENT == updatedModel.Content);
                changesData.Add("MarketId", origin.MARKET_ID == updatedModel.MarketId);
                changesData.Add("CountryId", origin.COUNTRY == updatedModel.CountryId);
                changesData.Add("HjeValue", origin.HJE_IDR == updatedModel.HjeValue);
                changesData.Add("HjeCurrency", origin.HJE_CURR == updatedModel.HjeCurrency);
                changesData.Add("Tariff", origin.TARIFF == updatedModel.Tariff);
                changesData.Add("TariffCurrency", origin.TARIF_CURR == updatedModel.TariffCurrency);
                changesData.Add("ColourName", origin.COLOUR == updatedModel.ColourName);
                changesData.Add("GoodType", origin.EXC_GOOD_TYP == updatedModel.GoodType);
                changesData.Add("StartDate", origin.START_DATE == updatedModel.StartDate);
                changesData.Add("EndDate", origin.END_DATE == updatedModel.EndDate);
                changesData.Add("Status", origin.STATUS == updatedModel.IsActive);
            }

            changesData.Add("Conversion", origin.CONVERSION == updatedModel.Conversion);
            changesData.Add("CutFilterCode", origin.CUT_FILLER_CODE == updatedModel.CutFillerCode);
            changesData.Add("PRINTING_PRICE", origin.PRINTING_PRICE == updatedModel.PrintingPrice);
            changesData.Add("BahanKemasan", origin.BAHAN_KEMASAN == updatedModel.BahanKemasan);

            foreach (var listChange in changesData)
            {
                if (listChange.Value)
                {
                    continue;
                }
                var changes = new CHANGES_HISTORY();
                changes.FORM_TYPE_ID  = Enums.MenuList.BrandRegistration;
                changes.FORM_ID       = origin.WERKS + origin.FA_CODE + origin.STICKER_CODE;
                changes.FIELD_NAME    = listChange.Key;
                changes.MODIFIED_BY   = CurrentUser.USER_ID;
                changes.MODIFIED_DATE = DateTime.Now;
                switch (listChange.Key)
                {
                case "STICKER_CODE":
                    changes.OLD_VALUE = origin.STICKER_CODE ?? null;
                    changes.NEW_VALUE = updatedModel.StickerCode ?? null;
                    break;

                case "PlantId":
                    changes.OLD_VALUE = _plantBll.GetPlantWerksById(origin.WERKS);
                    changes.NEW_VALUE = _plantBll.GetPlantWerksById(updatedModel.PlantId);
                    break;

                case "FACode":
                    changes.OLD_VALUE = origin.FA_CODE;
                    changes.NEW_VALUE = updatedModel.FaCode;
                    break;

                case "PersonalizationCode":
                    changes.OLD_VALUE = _masterBll.GetPersonalizationDescById(origin.PER_CODE);
                    changes.NEW_VALUE = _masterBll.GetPersonalizationDescById(updatedModel.PersonalizationCode);
                    break;

                case "BrandName":
                    changes.OLD_VALUE = origin.BRAND_CE;
                    changes.NEW_VALUE = updatedModel.BrandName;
                    break;

                case "SkepNo":
                    changes.OLD_VALUE = origin.SKEP_NO;
                    changes.NEW_VALUE = updatedModel.SkepNo;
                    break;

                case "SkepDate":
                    changes.OLD_VALUE = origin.SKEP_DATE == null ? string.Empty : Convert.ToDateTime(origin.SKEP_DATE).ToString("dd MMM yyyy");
                    changes.NEW_VALUE = updatedModel.SkepDate.ToString("dd MMM yyyy");
                    break;

                case "ProductCode":
                    changes.OLD_VALUE = _masterBll.GetProductCodeTypeDescById(origin.PROD_CODE);
                    changes.NEW_VALUE = _masterBll.GetProductCodeTypeDescById(updatedModel.ProductCode);
                    break;

                case "SeriesId":
                    changes.OLD_VALUE = _masterBll.GetDataSeriesDescById(origin.SERIES_CODE).ToString();
                    changes.NEW_VALUE = _masterBll.GetDataSeriesDescById(updatedModel.SeriesId).ToString();
                    break;

                case "Content":
                    changes.OLD_VALUE = origin.BRAND_CONTENT == null ? string.Empty : origin.BRAND_CONTENT.ToString();
                    changes.NEW_VALUE = updatedModel.Content == null? string.Empty : updatedModel.Content.ToString();
                    break;

                case "MarketId":
                    changes.OLD_VALUE = _masterBll.GetMarketDescById(origin.MARKET_ID);
                    changes.NEW_VALUE = _masterBll.GetMarketDescById(updatedModel.MarketId);
                    break;

                case "CountryId":
                    changes.OLD_VALUE = origin.COUNTRY;
                    changes.NEW_VALUE = updatedModel.CountryId;
                    break;

                case "HjeValue":
                    changes.OLD_VALUE = origin.HJE_IDR.ToString();
                    changes.NEW_VALUE = updatedModel.HjeValue.ToString();
                    break;

                case "HjeCurrency":
                    changes.OLD_VALUE = origin.HJE_CURR;
                    changes.NEW_VALUE = updatedModel.HjeCurrency;
                    break;

                case "Tariff":
                    changes.OLD_VALUE = origin.TARIFF.ToString();
                    changes.NEW_VALUE = updatedModel.Tariff.ToString();
                    break;

                case "TariffCurrency":
                    changes.OLD_VALUE = origin.TARIF_CURR;
                    changes.NEW_VALUE = updatedModel.TariffCurrency;
                    break;

                case "ColourName":
                    changes.OLD_VALUE = origin.COLOUR;
                    changes.NEW_VALUE = updatedModel.ColourName;
                    break;

                case "GoodType":
                    changes.OLD_VALUE = _goodTypeBll.GetGoodTypeDescById(origin.EXC_GOOD_TYP);
                    changes.NEW_VALUE = _goodTypeBll.GetGoodTypeDescById(updatedModel.GoodType);
                    break;

                case "StartDate":
                    changes.OLD_VALUE = origin.START_DATE.HasValue ? origin.START_DATE.Value.ToString("dd MMM yyyy") : string.Empty;
                    changes.NEW_VALUE = updatedModel.StartDate.HasValue? updatedModel.StartDate.Value.ToString("dd MMM yyyy") : string.Empty;
                    break;

                case "EndDate":
                    changes.OLD_VALUE = origin.END_DATE.HasValue ? origin.END_DATE.Value.ToString("dd MMM yyyy"): string.Empty;
                    changes.NEW_VALUE = updatedModel.EndDate.HasValue ? updatedModel.EndDate.Value.ToString("dd MMM yyyy"): string.Empty;
                    break;

                case "Conversion":
                    changes.OLD_VALUE = origin.CONVERSION.ToString();
                    changes.NEW_VALUE = updatedModel.Conversion.ToString();
                    break;

                case "CutFilterCode":
                    changes.OLD_VALUE = origin.CUT_FILLER_CODE;
                    changes.NEW_VALUE = updatedModel.CutFillerCode;
                    break;

                case "Status":
                    changes.OLD_VALUE = origin.STATUS.ToString();
                    changes.NEW_VALUE = updatedModel.IsActive.ToString();
                    break;

                case "PRINTING_PRICE":
                    changes.OLD_VALUE = origin.PRINTING_PRICE.ToString();
                    changes.NEW_VALUE = updatedModel.PrintingPrice.ToString();
                    break;

                case "BahanKemasan":
                    changes.OLD_VALUE = origin.BAHAN_KEMASAN;
                    changes.NEW_VALUE = updatedModel.BahanKemasan;
                    break;
                }
                _changesHistoryBll.AddHistory(changes);
            }
        }
Exemple #24
0
        private bool SetChange(ProductionDto origin, ProductionDto data, string userId)
        {
            bool isModified = false;

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

            changeData.Add("COMPANY_CODE", origin.CompanyCode == data.CompanyCode);
            changeData.Add("WERKS", origin.PlantWerks == data.PlantWerks);
            changeData.Add("FA_CODE", origin.FaCode == data.FaCode);
            changeData.Add("PRODUCTION_DATE", origin.ProductionDate == data.ProductionDate);
            changeData.Add("BRAND_DESC", origin.BrandDescription == data.BrandDescription);
            changeData.Add("QTY_PACKED", origin.QtyPacked == Convert.ToDecimal(data.QtyPackedStr));
            changeData.Add("QTY", origin.Qty == Convert.ToDecimal(data.QtyStr));
            changeData.Add("UOM", origin.Uom == data.Uom);
            //changeData.Add("PROD_QTY_STICK", origin.ProdQtyStick == Convert.ToDecimal(data.ProdQtyStickStr));

            string isFromSapString = string.IsNullOrEmpty(origin.Batch) ? "" : "[FROM SAP]";

            foreach (var listChange in changeData)
            {
                if (listChange.Value)
                {
                    continue;
                }
                {
                    var changes = new CHANGES_HISTORY
                    {
                        FORM_TYPE_ID  = Core.Enums.MenuList.CK4C,
                        FORM_ID       = "Daily_" + data.CompanyCode + "_" + data.PlantWerks + "_" + data.FaCode + "_" + data.ProductionDate.ToString("ddMMMyyyy"),
                        FIELD_NAME    = listChange.Key,
                        MODIFIED_BY   = userId,
                        MODIFIED_DATE = DateTime.Now
                    };

                    switch (listChange.Key)
                    {
                    case "COMPANY_CODE":
                        changes.OLD_VALUE  = origin.CompanyCode;
                        changes.NEW_VALUE  = data.CompanyCode;
                        changes.FIELD_NAME = "Company" + isFromSapString;
                        break;

                    case "WERKS":
                        changes.OLD_VALUE  = origin.PlantWerks;
                        changes.NEW_VALUE  = data.PlantWerks;
                        changes.FIELD_NAME = "Plant";
                        break;

                    case "FA_CODE":
                        changes.OLD_VALUE  = origin.FaCode;
                        changes.NEW_VALUE  = data.FaCode;
                        changes.FIELD_NAME = "Finish Goods";
                        break;

                    case "PRODUCTION_DATE":
                        changes.OLD_VALUE  = origin.ProductionDate.ToString();
                        changes.NEW_VALUE  = data.ProductionDate.ToString();
                        changes.FIELD_NAME = "Daily Production Date";
                        break;

                    case "BRAND_DESC":
                        changes.OLD_VALUE  = origin.BrandDescription;
                        changes.NEW_VALUE  = data.BrandDescription;
                        changes.FIELD_NAME = "Brand Description";
                        break;

                    case "QTY_PACKED":
                        changes.OLD_VALUE  = origin.QtyPacked.ToString();
                        changes.NEW_VALUE  = data.QtyPackedStr;
                        changes.FIELD_NAME = "Qty Packed" + isFromSapString;
                        break;

                    case "QTY":
                        changes.OLD_VALUE  = origin.Qty.ToString();
                        changes.NEW_VALUE  = data.QtyStr;
                        changes.FIELD_NAME = "Produced Qty" + isFromSapString;
                        break;

                    case "UOM":
                        changes.OLD_VALUE  = origin.Uom;
                        changes.NEW_VALUE  = data.Uom;
                        changes.FIELD_NAME = "Uom";
                        break;

                    //case "PROD_QTY_STICK":
                    //    changes.OLD_VALUE = origin.ProdQtyStick.ToString();
                    //    changes.NEW_VALUE = data.ProdQtyStickStr;
                    //    changes.FIELD_NAME = " Produced Qty Stick";
                    //    break;
                    default: break;
                    }
                    _changesHistoryBll.AddHistory(changes);
                    isModified = true;
                }
            }
            return(isModified);
        }
Exemple #25
0
 public void MoveHistoryToNewData(CHANGES_HISTORY history, string formId)
 {
     history.FORM_ID = formId;
     _repository.Update(history);
 }
Exemple #26
0
 public void AddHistory(CHANGES_HISTORY history)
 {
     history.MODIFIED_DATE = DateTime.Now;
     _repository.Insert(history);
 }
Exemple #27
0
        private void SetChanges(MaterialDto origin, MaterialDto data, string userid)
        {
            var changesData = new Dictionary <string, bool>();

            changesData.Add("MATERIAL_DESC", origin.MATERIAL_DESC == data.MATERIAL_DESC);
            changesData.Add("PURCHASING_GROUP", origin.PURCHASING_GROUP == data.PURCHASING_GROUP);
            changesData.Add("MATERIAL_GROUP", origin.MATERIAL_GROUP == data.MATERIAL_GROUP);
            changesData.Add("BASE_UOM", origin.BASE_UOM_ID == data.BASE_UOM_ID);
            changesData.Add("ISSUE_STORANGE_LOC", origin.ISSUE_STORANGE_LOC == data.ISSUE_STORANGE_LOC);
            changesData.Add("EX_GOODTYP", origin.EXC_GOOD_TYP == data.EXC_GOOD_TYP);
            changesData.Add("TARIFF", origin.TARIFF == data.TARIFF);
            changesData.Add("TARIFF_CURR", origin.TARIFF_CURR == data.TARIFF_CURR);
            changesData.Add("HJE", origin.HJE == data.HJE);
            changesData.Add("HJE_CURR", origin.HJE_CURR == data.HJE_CURR);
            //changesData.Add("PLANT_DELETION", origin.PLANT_DELETION.Equals(data.PLANT_DELETION));
            //changesData.Add("CLIENT_DELETION", origin.CLIENT_DELETION.Equals(data.CLIENT_DELETION));

            foreach (var listChange in changesData)
            {
                if (!listChange.Value)
                {
                    var changes = new CHANGES_HISTORY
                    {
                        FORM_TYPE_ID  = Core.Enums.MenuList.MaterialMaster,
                        FORM_ID       = data.STICKER_CODE + data.WERKS,
                        FIELD_NAME    = listChange.Key,
                        MODIFIED_BY   = userid,
                        MODIFIED_DATE = DateTime.Now
                    };
                    switch (listChange.Key)
                    {
                    case "MATERIAL_DESC":
                        changes.OLD_VALUE = origin.MATERIAL_DESC;
                        changes.NEW_VALUE = data.MATERIAL_DESC;
                        break;

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

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

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

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

                    case "TARIFF":
                        changes.OLD_VALUE = origin.TARIFF.HasValue? origin.TARIFF.Value.ToString() : "0";
                        changes.NEW_VALUE = data.TARIFF.HasValue? data.TARIFF.Value.ToString() : "0";
                        break;

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

                    case "HJE":
                        changes.OLD_VALUE = origin.HJE.HasValue ? origin.HJE.Value.ToString() : "0";
                        changes.NEW_VALUE = data.HJE.HasValue ? data.HJE.Value.ToString() : "0";
                        break;

                    case "HJE_CURR":
                        changes.OLD_VALUE = origin.HJE_CURR;
                        changes.NEW_VALUE = data.HJE_CURR;
                        break;
                        //case "PLANT_DELETION":
                        //    changes.OLD_VALUE = origin.IsPlantDelete.ToString();
                        //    changes.NEW_VALUE = data.PLANT_DELETION.ToString();
                        //    break;
                        //case "CLIENT_DELETION":
                        //    changes.OLD_VALUE = origin.IsClientDelete.ToString();
                        //    changes.NEW_VALUE = data.CLIENT_DELETION.ToString();
                        //    break;
                    }
                    _changesHistoryBll.AddHistory(changes);
                }
            }
        }
        private void SetChanges(HEADER_FOOTER origin, HEADER_FOOTER data, string userId)
        {
            var changesData = new Dictionary <string, bool>();

            changesData.Add("COMPANY_ID", origin.BUKRS == data.BUKRS);
            changesData.Add("HEADER_IMAGE_PATH", origin.HEADER_IMAGE_PATH == data.HEADER_IMAGE_PATH);
            changesData.Add("FOOTER_CONTENT", origin.FOOTER_CONTENT == data.FOOTER_CONTENT);
            changesData.Add("IS_ACTIVE", origin.IS_ACTIVE == data.IS_ACTIVE);
            changesData.Add("IS_DELETED", origin.IS_DELETED == data.IS_DELETED);
            var originHeaderFooterCheck = string.Empty;
            var originIndex             = 0;
            var originMap = origin.HEADER_FOOTER_FORM_MAP;

            if (originMap != null)
            {
                foreach (var orMap in originMap)
                {
                    originIndex++;
                    originHeaderFooterCheck += orMap.FORM_TYPE_ID.ToString() + ": Footer Set : " + (orMap.IS_FOOTER_SET == true ? "Yes" : "No") + " Header Set : " + (orMap.IS_HEADER_SET == true ? "Yes" : "No");

                    if (originIndex < originMap.Count)
                    {
                        originHeaderFooterCheck += ", ";
                    }
                }
            }
            var dataHeaderFooterCheck = string.Empty;
            var dataIndex             = 0;
            var dataMap = data.HEADER_FOOTER_FORM_MAP;

            if (dataMap != null)
            {
                foreach (var dtMap in dataMap)
                {
                    dataIndex++;
                    dataHeaderFooterCheck += dtMap.FORM_TYPE_ID.ToString() + ": Footer Set : " + (dtMap.IS_FOOTER_SET == true ? "Yes" : "No") + " Header Set : " + (dtMap.IS_HEADER_SET == true ? "Yes" : "No");

                    if (dataIndex < dataMap.Count)
                    {
                        dataHeaderFooterCheck += ", ";
                    }
                }
            }
            changesData.Add("HEADER_FOOTER_FORM_MAP", originHeaderFooterCheck == dataHeaderFooterCheck);


            foreach (var listChange in changesData)
            {
                if (!listChange.Value)
                {
                    var changes = new CHANGES_HISTORY
                    {
                        FORM_TYPE_ID  = Core.Enums.MenuList.HeaderFooter,
                        FORM_ID       = data.HEADER_FOOTER_ID.ToString(),
                        FIELD_NAME    = listChange.Key,
                        MODIFIED_BY   = userId,
                        MODIFIED_DATE = DateTime.Now
                    };
                    switch (listChange.Key)
                    {
                    case "COMPANY_ID":
                        changes.OLD_VALUE = origin.BUKRS;
                        changes.NEW_VALUE = data.BUKRS;
                        break;

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

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

                    case "IS_ACTIVE":
                        changes.OLD_VALUE = origin.IS_ACTIVE.HasValue ? origin.IS_ACTIVE.Value.ToString() : "NULL";
                        changes.NEW_VALUE = data.IS_ACTIVE.HasValue ? data.IS_ACTIVE.Value.ToString() : "NULL";
                        break;

                    case "IS_DELETED":
                        changes.OLD_VALUE = origin.IS_DELETED.HasValue ? origin.IS_DELETED.Value.ToString() : "NULL";
                        changes.NEW_VALUE = data.IS_DELETED.HasValue ? data.IS_DELETED.Value.ToString() : "NULL";
                        break;

                    case "HEADER_FOOTER_FORM_MAP":
                        changes.OLD_VALUE = originHeaderFooterCheck;
                        changes.NEW_VALUE = dataHeaderFooterCheck;
                        break;
                    }
                    _changesHistoryBll.AddHistory(changes);
                }
            }
        }