LogicColumn CreateDefaultDeleteLogicColumn(Model.DataSourceTable sourceTable, Model.DataColumn col, DataSourceLogicTable newTable)
        {
            Model.LogicColumn logicColumn = new Model.LogicColumn();
            logicColumn.ColumnName = col.ColumnName;
            logicColumn.ColumnText = col.ColumnText;
            logicColumn.ReturnType = "void";

            logicColumn.Use = true;
            List <FunctionParameter> parameters = new List <FunctionParameter>();

            logicColumn.Tag          = "delete-by-column";
            logicColumn.FunctionName = "DeleteBy" + logicColumn.ColumnName;
            string dtType  = Helper.DatabaseMapper.MapType(col.DataType);
            string varName = Helper.StrUtil.LowFirst(col.ColumnName);

            parameters.Add(new FunctionParameter(varName, dtType, col));

            Dictionary <string, object> dict = new Dictionary <string, object>();

            dict.Add("Parameters", parameters);

            logicColumn.ConfigContent = new FunctionConfigurator();
            logicColumn.ConfigContent.DisplayConfiguration(dict);

            return(logicColumn);
        }
        LogicColumn CreateDefaultFindAllLogicColumn(Model.DataSourceTable sourceTable, Model.DataColumn col, DataSourceLogicTable newTable)
        {
            Model.LogicColumn logicColumn = new Model.LogicColumn();
            logicColumn.ColumnName = col.ColumnName;
            logicColumn.ColumnText = col.ColumnText;
            logicColumn.ReturnType = "List<" + newTable.TableName + ">";

            logicColumn.Use = true;
            List <FunctionParameter> parameters = new List <FunctionParameter>();

            if (col.DataType.ToLower().Contains("date"))
            {
                logicColumn.Tag          = "list-date";
                logicColumn.FunctionName = "FindBy" + logicColumn.ColumnName + "Between";
                string dtType   = Helper.DatabaseMapper.MapType(col.DataType);
                string varName1 = Helper.StrUtil.LowFirst(col.ColumnName) + "1";
                string varName2 = Helper.StrUtil.LowFirst(col.ColumnName) + "2";
                parameters.Add(new FunctionParameter(varName1, dtType, col));
                parameters.Add(new FunctionParameter(varName2, dtType, col));
            }
            else
            {
                logicColumn.Tag          = "list-string";
                logicColumn.FunctionName = "FindBy" + logicColumn.ColumnName;
                string dtType  = Helper.DatabaseMapper.MapType(col.DataType);
                string varName = Helper.StrUtil.LowFirst(col.ColumnName);
                parameters.Add(new FunctionParameter(varName, dtType, col));
            }


            Dictionary <string, object> dict = new Dictionary <string, object>();

            dict.Add("Parameters", parameters);

            logicColumn.ConfigContent = new FunctionConfigurator();
            logicColumn.ConfigContent.DisplayConfiguration(dict);

            return(logicColumn);
        }