LogicColumn CreateDefaultListFunctionAgainLogicColumn(int colCounter, int colCounter2, Model.DataColumn col, Model.DataColumn col2, DataSourceLogicTable newTable)
{
if (colCounter2 >= colCounter && col2.DataType.ToLower().Contains("int") && col2.Key == false && col.ColumnName.Equals(col2.ColumnName) == false)
{
Model.LogicColumn logicColumn = new Model.LogicColumn();
logicColumn.ColumnName = col.ColumnName;
logicColumn.ColumnText = col.ColumnText;
logicColumn.ReturnType = "List<" + newTable.TableName + ">";
logicColumn.Tag = "list-int-and-int";
logicColumn.Use = true;
logicColumn.FunctionName = "FindBy" + col.ColumnName + "And" + col2.ColumnName;
string dtType = Helper.DatabaseMapper.MapType(col.DataType);
string varName1 = Helper.StrUtil.LowFirst(col.ColumnName) + "";
string varName2 = Helper.StrUtil.LowFirst(col2.ColumnName) + "";
List <FunctionParameter> parameters = new List <FunctionParameter>();
parameters.Add(new FunctionParameter(varName1, dtType, col));
parameters.Add(new FunctionParameter(varName2, dtType, col2));
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("Parameters", parameters);
logicColumn.ConfigContent = new FunctionConfigurator();
logicColumn.ConfigContent.DisplayConfiguration(dict);
return(logicColumn);
}
else
{
return(null);
}
}
LogicColumn CreateNewDeleteLogicColumn(DataSourceTable table, DataSourceLogicTable newTable, List <Model.DataColumn> datacols)
{
Model.LogicColumn logicColumn = new Model.LogicColumn();
logicColumn.ReturnType = "void";
logicColumn.Tag = "delete-int-and-int";
logicColumn.Use = true;
logicColumn.FunctionName = "DeleteBy";
List <FunctionParameter> parameters = new List <FunctionParameter>();
foreach (Model.DataColumn col in datacols)
{
logicColumn.FunctionName += col.ColumnName + "And";
string dtType = Helper.DatabaseMapper.MapType(col.DataType);
string varName1 = Helper.StrUtil.LowFirst(col.ColumnName) + "";
parameters.Add(new FunctionParameter(varName1, dtType, col));
}
if (logicColumn.FunctionName.Length > 0)
{
logicColumn.FunctionName = logicColumn.FunctionName.Substring(0, logicColumn.FunctionName.Length - 3);
}
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("Parameters", parameters);
logicColumn.ConfigContent = new FunctionConfigurator();
logicColumn.ConfigContent.DisplayConfiguration(dict);
return(logicColumn);
}
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);
}
Model.LogicColumn SetDefaultConfigContent(Model.LogicColumn logicColumn)
{
string[] words = Regex.Matches(logicColumn.ColumnName, "(^[a-z]+|[A-Z]+(?![a-z])|[A-Z][a-z]+)")
.OfType <Match>()
.Select(m => m.Value)
.ToArray();
string result = string.Join(" ", words);
logicColumn.ColumnText = result;
logicColumn.ConfigContent = new FunctionConfigurator();
logicColumn.ConfigContent.InitConfiguration(logicColumn);
return(logicColumn);
}
LogicColumn CreateDefaultLogicColumn()
{
Model.LogicColumn logicColumn = new Model.LogicColumn();
logicColumn.ColumnName = "NewColumn";
logicColumn.ColumnText = "New Column";
logicColumn.ReturnType = "List<" + CurrentTable.TableName + ">";
logicColumn.Tag = "list";
logicColumn.Use = true;
logicColumn.FunctionName = "NewFunction";
List <FunctionParameter> parameters = new List <FunctionParameter>();
parameters.Add(new FunctionParameter("newParam", "string"));
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);
}
