private string GetPrimaryKeyTableColumnRow(string input, Entities.MetaDataSchema.Table table)
{
StringBuilder result = new StringBuilder();
int index = 0;
foreach (Entities.MetaDataSchema.Column col in table.Columns)
{
if (col.IsPrimary)
{
string tempValue = input;
string dataType = GetDataType(col);
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.DataTypeCommand, GeneratorCommands.PrimaryKeyOption, "", dataType);
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.LibraryTypeCommand, GeneratorCommands.PrimaryKeyOption, "", col.ColumnDataType.LibraryType);
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.DataTypeLengthCommand, GeneratorCommands.PrimaryKeyOption, "", GetDataTypeLength(col));
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.NameCommand, GeneratorCommands.PrimaryKeyOption, "", col.Name);
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.NameCommand, GeneratorCommands.PrimaryKeyOption, GeneratorCommands.LowerCaseOption, col.Name.ToLower());
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.NameCommand, GeneratorCommands.PrimaryKeyOption, GeneratorCommands.UpperCaseOption, col.Name.ToUpper());
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.NameCommand, GeneratorCommands.PrimaryKeyOption, GeneratorCommands.FirstLowerOption, FirstLetterLower(col.Name));
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.NameCommand, GeneratorCommands.PrimaryKeyOption, GeneratorCommands.FirstUpperOption, FirstLetterUpper(col.Name));
tempValue = RemoveEnvelope(tempValue);
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.NewLineCommand, GeneratorCommands.NewLineValue);
result.Append(tempValue);
index++;
}
}
return(result.ToString());
}
private string GetForeignKeyTableColumnRow(string input, Entities.MetaDataSchema.Table table)
{
StringBuilder result = new StringBuilder();
int index = 0;
foreach (Entities.MetaDataSchema.Column col in table.Columns)
{
if (col.IsForeign)
{
string tempValue = input;
string dataType = GetDataType(col);
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.DataTypeCommand, GeneratorCommands.ForeignKeyOption, "", dataType);
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.LibraryTypeCommand, GeneratorCommands.ForeignKeyOption, "", col.ColumnDataType.LibraryType);
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.DataTypeLengthCommand, GeneratorCommands.ForeignKeyOption, "", GetDataTypeLength(col));
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.NameCommand, GeneratorCommands.ForeignKeyOption, "", col.Name);
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.NameCommand, GeneratorCommands.ForeignKeyOption, GeneratorCommands.LowerCaseOption, col.Name.ToLower());
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.NameCommand, GeneratorCommands.ForeignKeyOption, GeneratorCommands.UpperCaseOption, col.Name.ToUpper());
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.NameCommand, GeneratorCommands.ForeignKeyOption, GeneratorCommands.FirstLowerOption, FirstLetterLower(col.Name));
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnCommand, GeneratorCommands.NameCommand, GeneratorCommands.ForeignKeyOption, GeneratorCommands.FirstUpperOption, FirstLetterUpper(col.Name));
var fkParent = (from x in col.ParentTable.ParentRelationShips where x.ChildColumn.Name == col.Name && x.ChildTable.Name == col.ParentTable.Name select x).FirstOrDefault();
if (fkParent != null)
{
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.ParentTableColumnCommand, GeneratorCommands.NameCommand, "", GeneratorCommands.FirstUpperOption, FirstLetterUpper(fkParent.MasterTable.Name));
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.ParentTableColumnCommand, GeneratorCommands.NameCommand, "", GeneratorCommands.FirstLowerOption, FirstLetterLower(fkParent.MasterTable.Name));
}
tempValue = RemoveEnvelope(tempValue);
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.NewLineCommand, GeneratorCommands.NewLineValue);
result.Append(tempValue);
index++;
}
}
return(result.ToString());
}
private string GetNormalParameters(string input, Entities.MetaDataSchema.Table table)
{
StringBuilder result = new StringBuilder();
int index = 0;
foreach (Entities.MetaDataSchema.Column col in table.Columns)
{
string tempValue = input;
string dataType = GetDataType(col);
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnParamCommand, GeneratorCommands.DataTypeCommand, "", "", dataType);
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnParamCommand, GeneratorCommands.NameCommand, "", "", col.Name);
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnParamCommand, GeneratorCommands.NameCommand, "", GeneratorCommands.LowerCaseOption, col.Name.ToLower());
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnParamCommand, GeneratorCommands.NameCommand, "", GeneratorCommands.UpperCaseOption, col.Name.ToUpper());
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnParamCommand, GeneratorCommands.NameCommand, "", GeneratorCommands.FirstLowerOption, FirstLetterLower(col.Name));
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnParamCommand, GeneratorCommands.NameCommand, "", GeneratorCommands.FirstUpperOption, FirstLetterUpper(col.Name));
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnParamCommand, GeneratorCommands.LibraryTypeCommand, "", "", col.ColumnDataType.LibraryType);
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.TableColumnParamCommand, GeneratorCommands.DataTypeLengthCommand, "", "", GetDataTypeLength(col));
if (index < (table.Columns.Count - 1))
{
tempValue += parameterSeperator;
}
tempValue = GeneratorCommands.ReplaceCommand(tempValue, GeneratorCommands.NewLineCommand, GeneratorCommands.NewLineValue);
tempValue = RemoveEnvelope(tempValue);
result.Append(tempValue);
index++;
}
return(result.ToString());
}
