private string GetLookupDataAndWriteToDropdown(SQLTableColumn column) { StringBuilder lookupDataAndDropDown = new StringBuilder(); string tableName = column.TableName; string loweredTableName = Library.LowerFirstCharacter(tableName); string primaryKey = Library.LowerFirstCharacter(column.ParentTable.PrimaryKey.Name); string firstColumn = Library.LowerFirstCharacter(column.ParentTable.Columns[1].Name); lookupDataAndDropDown.AppendLine($"\tasync get{tableName}Data() {{"); lookupDataAndDropDown.AppendLine($"\t\tconst response = await fetch(process.env.REACT_APP_API_ENDPOINT + '{loweredTableName}');"); lookupDataAndDropDown.AppendLine("\t\tconst data = await response.json();"); lookupDataAndDropDown.AppendLine($"\t\tthis.setState({{ {loweredTableName}s: data.map(({loweredTableName}) => new {tableName}Option({loweredTableName}.{primaryKey}, {loweredTableName}.{primaryKey}, {loweredTableName}.{firstColumn})), loading: false }});"); lookupDataAndDropDown.AppendLine("}"); lookupDataAndDropDown.AppendLine(""); lookupDataAndDropDown.AppendLine($"\tDisplay{tableName}Dropdown() {{"); lookupDataAndDropDown.AppendLine("\t\tconst { value } = this.state;"); lookupDataAndDropDown.AppendLine("\t\treturn (<Dropdown"); lookupDataAndDropDown.AppendLine($"\t\t\tplaceholder='Select {tableName}'"); lookupDataAndDropDown.AppendLine("\t\t\tfluid"); lookupDataAndDropDown.AppendLine("\t\t\tselection"); lookupDataAndDropDown.AppendLine("\t\t\tsearch"); lookupDataAndDropDown.AppendLine($"\t\t\toptions={{this.state.{loweredTableName}s}}"); lookupDataAndDropDown.AppendLine($"\t\t\tname=\"{primaryKey}\""); lookupDataAndDropDown.AppendLine("\t\t\tonChange={this.handleDropDownChange}"); lookupDataAndDropDown.AppendLine("\t\t\tvalue={value}"); lookupDataAndDropDown.AppendLine("\t\t/>"); lookupDataAndDropDown.AppendLine("\t\t);"); lookupDataAndDropDown.AppendLine("\t}"); return(lookupDataAndDropDown.ToString()); }
private string ForeignKeyCode(SQLTable table, CodeFunction codeFunction, bool prepend) { StringBuilder foreignKeyCode = new StringBuilder(); foreach (SQLForeignKeyRelation foreignKey in sQLForeignKeyRelationsForTable(table)) { SQLTableColumn column = foreignKey.ReferencedTableColumn; if (prepend) { foreignKeyCode.Insert(0, codeFunction(column.ParentTable) + Environment.NewLine); } else { foreignKeyCode.Append(codeFunction(column.ParentTable) + Environment.NewLine); } string childForeignKeyCreateFunctions = ForeignKeyCode(column.ParentTable, codeFunction, prepend); if (childForeignKeyCreateFunctions != "") { if (prepend) { foreignKeyCode.Insert(0, childForeignKeyCreateFunctions); } else { foreignKeyCode.Append(childForeignKeyCreateFunctions); } } } return(foreignKeyCode.ToString()); }
private string GenerateBindText(string statementParameter, SQLTableColumn column, int columnCounter, bool includeClassNameInParameter) { string parameterToBind = $"{(includeClassNameInParameter ? Library.LowerFirstCharacter(column.TableName) + "." : "")}{Library.LowerFirstCharacter(column.Name)}"; return(column.sqlLiteDataType switch { sqlLiteStorageDataTypes.intStore => $"sqlite3_bind_int({statementParameter}, {columnCounter}, {parameterToBind}) == SQLITE_OK", sqlLiteStorageDataTypes.floatStore => (column.DataType == SQLDataTypes.dateTime ? $"sqlite3_bind_double({statementParameter}, {columnCounter}, {parameterToBind}.timeIntervalSince1970) == SQLITE_OK": $"sqlite3_bind_double({statementParameter}, {columnCounter}, {parameterToBind}) == SQLITE_OK"), sqlLiteStorageDataTypes.textStore => $"sqlite3_bind_{column.sqlLiteBindType}({statementParameter}, {columnCounter}, NSString(string: {parameterToBind}).utf8String, -1, nil) == SQLITE_OK", sqlLiteStorageDataTypes.blobStore => throw new NotImplementedException("Blob storage bind not implemented"), _ => throw new SQLDataTypeNotHandledInSwiftDatabaseBindText(column.DataType) });
private string CreateLookupClass(SQLTableColumn column) { StringBuilder lookupClass = new StringBuilder(); lookupClass.AppendLine($"export class {column.TableName}Option {{"); lookupClass.AppendLine("\tconstructor(key, value, text) {"); lookupClass.AppendLine("\t\tthis.text = text;"); lookupClass.AppendLine("\t\tthis.key = key;"); lookupClass.AppendLine("\t\tthis.value = value;"); lookupClass.AppendLine("\t}"); lookupClass.AppendLine("}"); return(lookupClass.ToString()); }
void GenerateForeignKeyStatements(SQLTable table, StringBuilder sqlStatement) { List <SQLForeignKeyRelation> foreignKeys = sQLForeignKeyRelationsForTable(table); foreach (SQLForeignKeyRelation foreignKey in foreignKeys) { SQLTableColumn column = foreignKey.ReferencedTableColumn; sqlStatement.AppendLine(go); sqlStatement.Append("CREATE PROCEDURE [dbo].[" + table.Name + "GetBy" + column.Name + "]" + Environment.NewLine); sqlStatement.Append("@" + column.Name + " " + column.DataType.ToString() + Environment.NewLine); GenerateSelectStatement(table, sqlStatement); sqlStatement.AppendLine(sqlRowIdentifier(column.Name)); sqlStatement.AppendLine(end); sqlStatement.AppendLine(procedureDivider); } }
public static List <SQLTableColumn> LoadColumnsForTable(string tableName, string connectionString, SQLTable parentTable, ref List <SQLTable> databaseTables) { List <SQLTableColumn> columns = new List <SQLTableColumn>(); string selectStatement; selectStatement = "select COLUMN_NAME, TABLE_NAME, ORDINAL_POSITION, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH, DATA_TYPE, NUMERIC_PRECISION, NUMERIC_SCALE, DATETIME_PRECISION from INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + tableName + "'"; SqlDataReader dataReader = SQLDataServer.ExecuteSQLStringReturnDataReader(selectStatement, connectionString); while (dataReader.Read()) { SQLTableColumn column = new SQLTableColumn(); column.Name = Convert.ToString(dataReader["COLUMN_NAME"]); column.TableName = Convert.ToString(dataReader["TABLE_NAME"]); column.OrdinalPosition = Convert.ToInt32(dataReader["ORDINAL_POSITION"]); column.Nullable = DBBooleanValues.ReturnBooleanFromYesOrNo(dataReader["IS_NULLABLE"]); column.DataType = Convert.ToString(dataReader["DATA_TYPE"]); column.MaximumLength = DBNullReturnValues.Return0(dataReader["CHARACTER_MAXIMUM_LENGTH"]); column.NumericPrecision = DBNullReturnValues.Return0(dataReader["NUMERIC_PRECISION"]); column.NumericScale = DBNullReturnValues.Return0(dataReader["NUMERIC_SCALE"]); column.DateTimePrecision = DBNullReturnValues.Return0(dataReader["DATETIME_PRECISION"]); column.ParentTable = parentTable; if (column.OrdinalPosition == 1) { column.PrimaryKey = true; } column.ForeignKeys = SQLForeignKeyRelation.LoadForeignKeysForColumn(column.ParentTable.id, column.OrdinalPosition, connectionString, ref databaseTables); columns.Add(column); } dataReader.Close(); return(columns); }
void GenerateForeignKeyDeleteStatements(SQLTable table, StringBuilder sqlStatement) { List <SQLForeignKeyRelation> foreignKeys = sQLForeignKeyRelationsForTable(table); foreach (SQLForeignKeyRelation foreignKey in foreignKeys) { SQLTableColumn column = foreignKey.ReferencedTableColumn; sqlStatement.AppendLine(go); sqlStatement.AppendLine("CREATE PROCEDURE [dbo].[" + table.Name + "DeleteFor" + column.TableName + "]" + Environment.NewLine); sqlStatement.AppendLine($"@{column.Name} {column.DataType}"); sqlStatement.AppendLine(sqlAs); sqlStatement.AppendLine(begin); sqlStatement.AppendLine(setNoCount); sqlStatement.AppendLine($"DELETE FROM [{table.Name}]"); sqlStatement.AppendLine(sqlRowIdentifier(column.Name)); sqlStatement.AppendLine(end); } }
public static List <SQLTable> LoadTables(string connectionString) { List <SQLTable> tables = new List <SQLTable>(); SqlDataReader dataReader; dataReader = SQLDataServer.ExecuteSQLStringReturnDataReader("select name, object_id from sys.tables where name <> 'sysdiagrams' and name not like 'aspnet_%'", connectionString); while (dataReader.Read()) { SQLTable table = new SQLTable(); table.Name = Convert.ToString(dataReader["name"]); table.id = Convert.ToInt32(dataReader["object_id"]); table.Columns = SQLTableColumn.LoadColumnsForTable(table.Name, connectionString, table, ref tables); tables.Add(table); } dataReader.Close(); return(tables); }
private string CreateInputsCode(SQLTableColumn column) { StringBuilder inputsCode = new StringBuilder(); string loweredName = Library.LowerFirstCharacter(column.Name); inputsCode.AppendLine("\t\t\t\t<label>"); bool usedropdown = false; string tableName = ""; foreach (SQLForeignKeyRelation foreignKeyRelation in foreignKeys) { if (foreignKeyRelation.ParentTableColum == column) { usedropdown = true; tableName = foreignKeyRelation.ReferencedTableColumn.TableName; } } if (!usedropdown) { inputsCode.AppendLine("\t\t\t\t\t" + column.Name + ":"); inputsCode.AppendLine($"\t\t\t\t\t<input type=\"{column.htmlInputFormType}\" name=\"{loweredName}\" value={{this.state.{loweredName}}} onChange={{this.handleInputChange}} />"); } else { loweredName = Library.LowerFirstCharacter(tableName); inputsCode.AppendLine($"\t\t\t\t\t{tableName}"); inputsCode.AppendLine($"\t\t\t\t\t{{{loweredName}Dropdown}}"); } inputsCode.AppendLine("\t\t\t\t</label>"); return(inputsCode.ToString()); }
string AddParameter(string parameterValue, SQLTableColumn column) { return($"SQLDataServer.AddParameter(ref parameters, \"@{column.Name}\", {parameterValue}, SqlDbType.{column.dotNetSqlDataTypes}, {column.MaximumLength});"); }
string AddParameter(SQLTableColumn column) { return($"SQLDataServer.AddParameter(ref parameters, \"@{column.Name}\", {Library.LowerFirstCharacter(column.TableName)}.{column.Name}, SqlDbType.{column.dotNetSqlDataTypes}, {column.MaximumLength});"); }
internal override void GenerateFilePerTable(SQLTable table) { List <SQLForeignKeyRelation> foreignKeys = sQLForeignKeyRelationsForTable(table); classText.AppendLine("using DataServer;"); classText.AppendLine("using System;"); classText.AppendLine("using System.Collections.Generic;"); classText.AppendLine("using System.Data;"); classText.AppendLine("using System.Data.SqlClient;"); classText.AppendLine($"using {_nameSpace}.Repository;"); classText.AppendLine(""); classText.AppendLine($"namespace {_nameSpace}.SqlRepository"); classText.AppendLine("{"); classText.AppendLine($"\tpublic class {table.Name}RepositorySql : IRepository<{dataObjectClassIdentifier}, {table.PrimaryKey.cSharpDataType}>"); classText.AppendLine("\t{"); classText.AppendLine("\t\t#region Loading Methods"); classText.AppendLine($"\t\tpublic List<{dataObjectClassIdentifier}> GetAll()"); classText.AppendLine("\t\t{"); classText.AppendLine($"\t\t\treturn Populate{table.Name}List(\"{table.Name}GetAll\", new List<SqlParameter>());"); classText.AppendLine("\t\t}"); classText.AppendLine(""); classText.AppendLine($"\t\tpublic {dataObjectClassIdentifier} GetByID({table.PrimaryKey.cSharpDataType} {Library.LowerFirstCharacter(table.PrimaryKey.Name)})"); classText.AppendLine("\t\t{"); classText.AppendLine("\t\t\tList<SqlParameter> parameters = new List<SqlParameter>();"); classText.AppendLine($"\t\t\tSQLDataServer.AddParameter(ref parameters, \"@{table.PrimaryKey.Name}\", {Library.LowerFirstCharacter(table.PrimaryKey.Name)}, SqlDbType.{table.PrimaryKey.dotNetSqlDataTypes}, {table.PrimaryKey.MaximumLength});"); classText.AppendLine($"\t\t\tList<{dataObjectClassIdentifier}> {table.Name}Bases = Populate{table.Name}List(\"{table.Name}GetByID\", parameters);"); classText.AppendLine(""); classText.AppendLine($"\t\t\t\tswitch ({table.Name}Bases.Count)"); classText.AppendLine("\t\t\t\t{"); classText.AppendLine("\t\t\t\t\tcase 1:"); classText.AppendLine($"\t\t\t\t\t\treturn {table.Name}Bases[0];"); classText.AppendLine("\t\t\t\t\tcase 0:"); classText.AppendLine("\t\t\t\t\t\treturn null;"); classText.AppendLine("\t\t\t\t\tdefault:"); classText.AppendLine("\t\t\t\t\t\tthrow new Exception(\"Get by ID returning more than one record\");"); classText.AppendLine("\t\t\t\t}"); classText.AppendLine("\t\t}"); classText.AppendLine(""); foreach (SQLForeignKeyRelation foreignKeyRelation in foreignKeys) { SQLTableColumn column = foreignKeyRelation.ReferencedTableColumn; classText.AppendLine($"\t\tpublic List<{dataObjectClassIdentifier}> GetBy{column.Name}({column.cSharpDataType} {Library.LowerFirstCharacter(column.Name)})"); classText.AppendLine("\t\t{"); classText.AppendLine("\t\t\tList<SqlParameter> parameters = new List<SqlParameter>();"); classText.AppendLine($"\t\t\tSQLDataServer.AddParameter(ref parameters, \"@{column.Name}\", {Library.LowerFirstCharacter(column.Name)}, SqlDbType.{column.dotNetSqlDataTypes}, {column.MaximumLength});"); classText.AppendLine($"\t\t\treturn Populate{table.Name}List(\"{table.Name}GetBy{column.Name}\", parameters);"); classText.AppendLine("\t\t}"); classText.AppendLine(""); } classText.AppendLine(""); classText.AppendLine($"\t\tprivate List<{dataObjectClassIdentifier}> Populate{table.Name}List(string storedProcedure, List<SqlParameter> parameters)"); classText.AppendLine("\t\t{"); //Check for guid columns as they need to use their ordinal to be identified foreach (SQLTableColumn column in table.Columns) { if (column.DataType == SQLDataTypes.uniqueIdentifier || column.DataType == SQLDataTypes.timeType) { classText.AppendLine($"\t\t\tint {Library.LowerFirstCharacter(column.Name)}Column = {(column.OrdinalPosition - 1)};"); } } classText.AppendLine(""); classText.AppendLine($"\t\t\tList<{dataObjectClassIdentifier}> {Library.LowerFirstCharacter(table.Name)}s = new List<{dataObjectClassIdentifier}>();"); classText.AppendLine(""); classText.AppendLine($"\t\t\tSqlDataReader {Library.LowerFirstCharacter(table.Name)}sData = SQLDataServer.ExecuteSPReturnDataReader(storedProcedure, parameters);"); classText.AppendLine($"\t\t\twhile ({Library.LowerFirstCharacter(table.Name)}sData.Read())"); classText.AppendLine("\t\t\t{"); if (table.PrimaryKey.DataType == SQLDataTypes.uniqueIdentifier) { classText.AppendLine($"\t\t\t\t{dataObjectClassIdentifier} {Library.LowerFirstCharacter(table.Name)} = new {dataObjectClassIdentifier}({Library.LowerFirstCharacter(table.Name)}sData.GetGuid({Library.LowerFirstCharacter(table.PrimaryKey.Name)}Column));"); } else { classText.AppendLine($"\t\t\t\t{dataObjectClassIdentifier} {Library.LowerFirstCharacter(table.Name)} = new {dataObjectClassIdentifier}(Convert.ToInt32({Library.LowerFirstCharacter(table.Name)}sData[\"{table.PrimaryKey.Name}\"]));"); } foreach (SQLTableColumn column in table.Columns) { if (!column.PrimaryKey) { if (column.Nullable) { classText.AppendLine(""); classText.AppendLine($"\t\t\t\tif ({Library.LowerFirstCharacter(table.Name)}sData[\"{column.Name}\"] != DBNull.Value)"); classText.Append("\t"); } classText.Append($"\t\t\t\t{Library.LowerFirstCharacter(table.Name)}.{column.Name} = "); string dataReaderReadStatement; switch (column.DataType) { case SQLDataTypes.uniqueIdentifier: dataReaderReadStatement = $"{Library.LowerFirstCharacter(table.Name)}sData.GetGuid({Library.LowerFirstCharacter(column.Name)}Column);"; break; case SQLDataTypes.intData: dataReaderReadStatement = $"Convert.ToInt32({Library.LowerFirstCharacter(table.Name)}sData[\"{column.Name}\"]);"; break; case SQLDataTypes.varChar: dataReaderReadStatement = $"Convert.ToString({Library.LowerFirstCharacter(table.Name)}sData[\"{column.Name}\"]);"; break; case SQLDataTypes.bit: dataReaderReadStatement = $"Convert.ToBoolean({Library.LowerFirstCharacter(table.Name)}sData[\"{column.Name}\"]);"; break; case SQLDataTypes.dateTime: dataReaderReadStatement = $"Convert.ToDateTime({Library.LowerFirstCharacter(table.Name)}sData[\"{column.Name}\"]);"; break; case SQLDataTypes.varBinary: dataReaderReadStatement = "0; //to be honest, I'm a little surpised"; break; case SQLDataTypes.decimalData: dataReaderReadStatement = $"Convert.ToDecimal({Library.LowerFirstCharacter(table.Name)}sData[\"{column.Name}\"]);"; break; case SQLDataTypes.floatData: dataReaderReadStatement = $"(float){Library.LowerFirstCharacter(table.Name)}sData[\"{column.Name}\"];"; break; case SQLDataTypes.binary: dataReaderReadStatement = "Need another look at this"; break; case SQLDataTypes.ncharData: dataReaderReadStatement = $"Convert.ToString({Library.LowerFirstCharacter(table.Name)}sData[\"{column.Name}\"]);"; break; case SQLDataTypes.charType: dataReaderReadStatement = $"Convert.ToString({Library.LowerFirstCharacter(table.Name)}sData[\"{column.Name}\"]);"; break; case SQLDataTypes.timeType: dataReaderReadStatement = $"{Library.LowerFirstCharacter(table.Name)}sData.GetTimeSpan({Library.LowerFirstCharacter(column.Name)}Column);"; break; case SQLDataTypes.moneyType: dataReaderReadStatement = $"Convert.ToDecimal({Library.LowerFirstCharacter(table.Name)}sData[\"{column.Name}\"]);"; break; default: throw new SQLDBTypeNotSupported(column.DataType); } classText.AppendLine(dataReaderReadStatement); if (column.Nullable) { classText.AppendLine(""); } } } classText.AppendLine(""); classText.AppendLine($"\t\t\t\t{Library.LowerFirstCharacter(table.Name)}s.Add({Library.LowerFirstCharacter(table.Name)});"); classText.AppendLine("\t\t\t}"); classText.AppendLine($"\t\t\t{Library.LowerFirstCharacter(table.Name)}sData.Close();"); classText.AppendLine(""); classText.AppendLine($"\t\t\treturn {Library.LowerFirstCharacter(table.Name)}s;"); classText.AppendLine("\t\t}"); classText.AppendLine(""); classText.AppendLine("\t\t#endregion"); classText.AppendLine(""); classText.AppendLine("\t\t#region Updating the database"); classText.AppendLine($"\t\tpublic void Save({dataObjectClassIdentifier} {Library.LowerFirstCharacter(table.Name)})"); classText.AppendLine("\t\t{"); classText.AppendLine("\t\t\tList<SqlParameter> parameters = new List<SqlParameter>();"); classText.AppendLine(""); foreach (SQLTableColumn column in table.Columns) { if (!column.PrimaryKey) { classText.AppendLine($"\t\t\t{AddParameter(column)}"); } } foreach (SQLTableColumn column in table.Columns) { if (column.PrimaryKey) { if (column.DataType == SQLDataTypes.uniqueIdentifier) { classText.AppendLine($"\t\t\tif ({Library.LowerFirstCharacter(table.Name)}.{column.Name} == Guid.Empty)"); classText.AppendLine("\t\t\t{"); classText.AppendLine($"\t\t\t\t{Library.LowerFirstCharacter(table.Name)}.{column.Name} = SQLDataServer.ExecuteSPReturnGuid(\"{table.Name}Insert\", parameters);"); classText.AppendLine("\t\t\t}"); classText.AppendLine("\t\t\telse"); classText.AppendLine("\t\t\t{"); classText.AppendLine($"\t\t\t\t{AddParameter(column)}"); classText.AppendLine($"\t\t\t\t{ExecuteSP(table.Name, "Update")}"); classText.AppendLine("\t\t\t}"); } else { classText.AppendLine($"\t\t\tif ({Library.LowerFirstCharacter(table.Name)}.{column.Name} == 0)"); classText.AppendLine("\t\t\t{"); classText.AppendLine($"\t\t\t\t{Library.LowerFirstCharacter(table.Name)}.{column.Name}= SQLDataServer.ExecuteSPReturnLong(\"{table.Name}Insert\", parameters, \"@{column.Name}\");"); classText.AppendLine("\t\t\t}"); classText.AppendLine("\t\t\telse"); classText.AppendLine("\t\t\t{"); classText.AppendLine($"\t\t\t\t{AddParameter(column)}"); classText.AppendLine($"\t\t\t\t{ExecuteSP(table.Name, "Update")}"); classText.AppendLine("\t\t\t}"); } } } classText.AppendLine("\t\t}"); classText.AppendLine("\t\t#endregion"); classText.AppendLine(""); classText.AppendLine($"\t\t{newRegion}Deleting Items from the database"); classText.AppendLine($"\t\tpublic void Delete({table.PrimaryKey.cSharpDataType} {Library.LowerFirstCharacter(table.Name)}Id)"); classText.AppendLine($"\t\t{{"); classText.AppendLine($"\t\t\tList<SqlParameter> parameters = new List<SqlParameter>();"); classText.AppendLine(""); classText.AppendLine($"\t\t\t{AddParameter(Library.LowerFirstCharacter(table.Name) + "Id", table.PrimaryKey)}"); classText.AppendLine(); classText.AppendLine($"\t\t\t{ExecuteSP(table.Name.ToString(), "Delete")}"); classText.AppendLine($"\t\t}}"); classText.AppendLine(""); foreach (SQLForeignKeyRelation foreignKeyRelation in foreignKeys) { SQLTableColumn column = foreignKeyRelation.ReferencedTableColumn; string loweredColumnName = Library.LowerFirstCharacter(column.Name); classText.AppendLine($"\t\tpublic void DeleteBy{column.Name}({column.cSharpDataType} {loweredColumnName})"); classText.AppendLine($"\t\t{{"); classText.AppendLine($"\t\t\tList<SqlParameter> parameters = new List<SqlParameter>();"); classText.AppendLine(""); classText.AppendLine($"\t\t\t{AddParameter(loweredColumnName, column)}"); classText.AppendLine(); classText.AppendLine($"\t\t\t{ExecuteSP(table.Name.ToString(), "DeleteFor" + column.TableName)}"); classText.AppendLine($"\t\t}}"); } classText.AppendLine("\t\t" + endRegion); classText.AppendLine("\t}"); // This is the closing of the class. classText.AppendLine("}"); // This is the closing of the namespace. }
private string GetLookupData(SQLTableColumn column) { return($"\t\tthis.get{column.TableName}Data();"); }
private string StateLookupStorage(SQLTableColumn column) { return($"\t\t\t{Library.LowerFirstCharacter(column.TableName)}s : [],"); }
private string DropdownLoadingCodeForForeignKey(SQLTableColumn column) { return($"\t\tlet {Library.LowerFirstCharacter(column.TableName)}Dropdown = this.state.loading ? <p><em>Loading</em></p> : this.Display{column.TableName}Dropdown();"); }
private string CreateClassCode(SQLTableColumn column) { return($"\t\t\t{Library.LowerFirstCharacter(column.Name)}: this.state.{Library.LowerFirstCharacter(column.Name)},"); }
private string CreateStateCode(SQLTableColumn column) { return($"\t\t\t{Library.LowerFirstCharacter(column.Name)}: {(column.htmlInputFormType == htmlFormValueType.text ? "''" : "null")},"); }