public bool _checkMissingValuePlaceholder(long variableId, MissingValueStruct missingValue)
        {
            using (MissingValueManager missingValueManager = new MissingValueManager())
                using (DataStructureManager dataStructureManager = new DataStructureManager())
                {
                    Variable variable = dataStructureManager.VariableRepo.Get(variableId);
                    TypeCode typecode = new TypeCode();

                    foreach (DataTypeCode tc in Enum.GetValues(typeof(DataTypeCode)))
                    {
                        if (tc.ToString() == variable.DataAttribute.DataType.SystemType)
                        {
                            typecode = (TypeCode)tc;
                            break;
                        }
                    }
                    return(missingValueManager.ValidatePlaceholder(typecode, missingValue.Placeholder, missingValue.Id));
                }
        }
        public bool _checkMissingValueName(long variableId, MissingValueStruct missingValue)
        {
            MissingValueManager missingValueManager = null;

            try
            {
                missingValueManager = new MissingValueManager();
                List <MissingValue> missingValues = missingValueManager.Repo.Query(mv => mv.Variable.Id.Equals(variableId)).ToList();
                foreach (MissingValue mv in missingValues)
                {
                    if (mv.DisplayName == missingValue.DisplayName && mv.Id != missingValue.Id)
                    {
                        return(false);
                    }
                }
                return(true);
            }
            finally
            {
                missingValueManager.Dispose();
            }
        }
        public ActionResult _getMissingValueElement(long missinValueId = 0)
        {
            MissingValueStruct missingValueStruct = new MissingValueStruct();

            if (missinValueId > 0)
            {
                MissingValueManager missingValueManager = null;

                try
                {
                    missingValueManager = new MissingValueManager();
                    MissingValue missingValue = missingValueManager.Repo.Get(missinValueId);
                    if (missingValue == null)
                    {
                        return(null);
                    }
                    else
                    {
                        missingValueStruct = new MissingValueStruct()
                        {
                            Id          = missingValue.Id,
                            DisplayName = missingValue.DisplayName,
                            Description = missingValue.Description,
                            Placeholder = missingValue.Placeholder
                        };
                    }
                }
                catch
                {
                    return(null);
                }
                finally
                {
                    missingValueManager.Dispose();
                }
            }
            return(PartialView("_missingValueElement", missingValueStruct));
        }