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()));
}
