public static string CRUDParams(SqlNames Property, bool enableComa)
        {
            var result = "";

            result += "@" + Property.COLUMN_NAME + " " + DataTypeDeclare(Property, Property.DATA_TYPE) + (enableComa ? " ," : "") + Enter;

            return(result);
        }
        public static string CreateSample(SqlNames Property, bool enableComa)
        {
            var result = "";

            result += "[" + Property.COLUMN_NAME + "] " + DataTypeDeclare(Property, Property.DATA_TYPE) + " " + (enableComa ? "," : "") + Enter;

            return(result);
        }
        public static string ConditionFilters(SqlNames Property, bool enableComa)
        {
            var result = "";

            if (MinMaxDataTypes(Property.DATA_TYPE))
            {
                result += Enter + "@" + Property.COLUMN_NAME + " " + DataTypeDeclare(Property, Property.DATA_TYPE) + " = NULL ," + Enter;
                result += "@MultiText_" + Property.COLUMN_NAME + " nvarchar(MAX) = '' ," + Enter;
                result += "@Min" + Property.COLUMN_NAME + " " + DataTypeDeclare(Property, Property.DATA_TYPE) + " = NULL ," + Enter;
                result += "@Max" + Property.COLUMN_NAME + " " + DataTypeDeclare(Property, Property.DATA_TYPE) + (enableComa ? " = NULL ," : " = NULL") + Enter + Enter;
            }
            else
            {
                result += Enter + "@" + Property.COLUMN_NAME + " " + DataTypeDeclare(Property, Property.DATA_TYPE) + " = NULL ," + Enter;
                result += "@MultiText_" + Property.COLUMN_NAME + " nvarchar(MAX) = '' " + (enableComa ? "," : "") + Enter + Enter;
            }

            return(result);
        }
        public static string ConditionStatement(SqlNames Property, bool enableComa, string constName)
        {
            var result = "-- || Auto Generated Conditions || --" + Enter;
            var readSelectTemplateMinMax = System.IO.File.ReadAllText("sqlTemplates\\minMaxConditionsTemplate.txt");
            var readSelectTemplateSimple = System.IO.File.ReadAllText("sqlTemplates\\simpleConditionsTemplate.txt");
            var readSelectTemplateChar   = System.IO.File.ReadAllText("sqlTemplates\\charConditionTemplate.txt");

            if (MinMaxDataTypes(Property.DATA_TYPE))
            {
                result +=
                    readSelectTemplateMinMax.
                    Replace("#COLNAME#", Property.COLUMN_NAME).
                    Replace("#CONST#", constName).
                    Replace("#AND#", (enableComa ? "And" : ""))
                    + Enter + Enter;
            }
            else if (!CharType(Property.DATA_TYPE))
            {
                result +=
                    readSelectTemplateSimple.
                    Replace("#COLNAME#", Property.COLUMN_NAME).
                    Replace("#CONST#", constName).
                    Replace("#AND#", (enableComa ? "And" : ""))
                    + Enter + Enter;
            }
            else
            {
                result +=
                    readSelectTemplateChar.
                    Replace("#COLNAME#", Property.COLUMN_NAME).
                    Replace("#CONST#", constName).
                    Replace("#AND#", (enableComa ? "And" : ""))
                    + Enter + Enter;
            }
            return(result);
        }
        public static string DataTypeDeclare(SqlNames Property, string type)
        {
            var result = type;

            switch (type)
            {
            case "datetime2":
            {
                result += "(" + Property.DATETIME_PRECISION + ")";
                return(result);
            }

            case "datetimeoffset":
            {
                result += "(" + Property.DATETIME_PRECISION + ")";
                return(result);
            }

            case "decimal":
            {
                //result += "(" + Property.NUMERIC_PRECISION + "," + Property.NUMERIC_SCALE + ")";
                return(result);
            }

            case "nchar":
            {
                result += "(" + Property.CHARACTER_MAXIMUM_LENGTH + ")";
                return(result);
            }

            case "numeric":
            {
                //result += "(" + Property.NUMERIC_PRECISION + "," + Property.NUMERIC_SCALE + ")";
                return(result);
            }

            case "nvarchar":
            {
                result += "(" + (Property.CHARACTER_MAXIMUM_LENGTH == -1 ? "MAX" : Property.CHARACTER_MAXIMUM_LENGTH.ToString()) + ")";
                return(result);
            }

            case "time":
            {
                result += "(" + Property.DATETIME_PRECISION + ")";
                return(result);
            }

            case "varbinary":
            {
                result += "(" + (Property.CHARACTER_MAXIMUM_LENGTH == -1 ? "MAX" : Property.CHARACTER_MAXIMUM_LENGTH.ToString()) + ")";
                return(result);
            }

            case "varchar":
            {
                result += "(" + (Property.CHARACTER_MAXIMUM_LENGTH == -1 ? "MAX" : Property.CHARACTER_MAXIMUM_LENGTH.ToString()) + ")";
                return(result);
            }

            case "binary":
            {
                result += "(" + Property.CHARACTER_OCTET_LENGTH + ")";
                return(result);
            }

            case "char":
            {
                result += "(" + Property.CHARACTER_OCTET_LENGTH + ")";
                return(result);
            }

            default:
                return(result);
            }
        }