public SSCCPendingChangeResponse GetPendingChangesForSSCC(string SSCCNumber)
        {
            SSCCPendingChangeResponse response = new SSCCPendingChangeResponse();

            using (var dbEntity = new BACKUP_SRL_20180613Entities())
            {
                return(response = dbEntity.API_PENDING_SSCC_CHANGE(SSCCNumber).ToList().ConvertSSCCPendingChange());
            }
        }
        public static SSCCPendingChangeResponse ConvertSSCCPendingChange(this List <API_PENDING_SSCC_CHANGE_Result> result)
        {
            SSCCPendingChangeResponse response       = new SSCCPendingChangeResponse();
            List <SSCCPendingChange>  pendingChanges = new List <SSCCPendingChange>();

            if (result.Any())
            {
                response.UpdateUser = result[0].UPDATE_USER;
                result.ForEach(p =>
                {
                    pendingChanges.Add(new SSCCPendingChange
                    {
                        ChangeType = p.CHANGE_TYPE,
                        OldValue   = p.OLD_VALUE,
                        NewValue   = p.NEW_VALUE
                    });
                });
                response.SSCCPendingChanges = pendingChanges;
            }
            return(response);
        }