TAD-569-JAMES_CONFIG_TASK

boomaze commented 2 years ago

Update all places taking following values from FORM

                using (var _context = new TMSEntities())
                {
                    var defaultConfig = _context.FP_DEFAULT_CONFIG.ToList().FirstOrDefault();
                    form.TOOL_PFF_PFH_UPCHARGE = form.FP_FF_TEMPERATURE_PROTECTION_ID == 4 ? 0 : defaultConfig.PFF_PFH_UPCHARGE;
                    form.TOOL_COOLER_FREEZER_UPCHARGE = form.FP_FF_TEMPERATURE_ID == 3 ? 0 : defaultConfig.COOLER_FREEZER_UPCHARGE;
                    form.TOOL_MARGIN_TARGET = defaultConfig.MARGIN_TARGET;
                    form.TOOL_FUEL_SURCHARGE = defaultConfig.FUEL_SURCHARGE;
                    form.BACKHAUL_PALLET_RATE = defaultConfig.BACKHAUL_PALLET_RATE;
                    form.CROSSDOCK_PALLET_RATE = defaultConfig.CROSSDOCK_PALLET_RATE;

                    _context.AddToFP_FREIGHT_FORM(form);
                    _context.SaveChanges();

                    long result = form.FP_FREIGHT_FORM_ID;

                    _context.SP_FP_TOOL_CREATE_FORM_LOG(form.FP_FREIGHT_FORM_ID, form.CREATED_BY, null);

                    return result;
                }

boomaze commented 2 years ago

https://unfisc.atlassian.net/jira/software/projects/TAD/boards/667?selectedIssue=TAD-569

boomaze commented 2 years ago

Add 6 fields for UCS, key on them in needed sprocs. May be difficult

boomaze / henrysmind

TAD-569-JAMES_CONFIG_TASK #3