public override string GenerateSQLQuery() { StringBuilder query = new StringBuilder(); if (IsNew) { query.Append($"create table {ConnectionSettings.getInstance().NameScheme}.{NameTable} ( "); } else { query.Append($"alter table {ConnectionSettings.getInstance().NameScheme}.{NameTable} add "); } foreach (var col in ColumnInTable) { query.Append($"{col.NameColumn} {col.NameType} {col.SizeTypeQuery}, "); } if (IsNew) { query.Replace(", ", ") ", query.Length - 2, 2); } else { query.Replace(", ", " ", query.Length - 2, 2); } return(IsNew ? GenerateQueryWorker.CurentGenerate.GetCreateTableQuery($"{ConnectionSettings.getInstance().NameScheme}.{NameTable}", ColumnInTable.ToList().Select(col => $"{col.NameColumn} {col.NameType} {col.SizeTypeQuery}").ToList()) : GenerateQueryWorker.CurentGenerate.GetAddColumnsQuery($"{ConnectionSettings.getInstance().NameScheme}.{NameTable}", ColumnInTable.ToList().Select(col => $"{col.NameColumn} {col.NameType} {col.SizeTypeQuery}").ToList())); }
public override bool IsValid() { if (!String.IsNullOrEmpty(NameTable) && (ColumnInTable.Count(c => c.isValid) == ColumnInTable.Count)) { return(true); } return(false); }
public override bool IsValid() { return(ColumnInTable.Count(c => c.IsSelect) > 0 ? true : false); }
public void AddValue() { AddColumn(new Column()); SelectedColumnInTable = ColumnInTable.LastOrDefault(); }
public override string GenerateSQLQuery() { return(GenerateQueryWorker.CurentGenerate.GetDeleteColumnsQuery($"{ConnectionSettings.getInstance().NameScheme}.{NameTable}", ColumnInTable.ToList().FindAll(c => c.IsSelect).Select(c => c.NameColumn).ToList())); }