private void Window_Loaded(object sender, RoutedEventArgs e)
{
txtTableDesc.Focus();
if (TableColumns != null)
{
_columns = new ObservableCollection <TableColumn>(TableColumn.BuildTableColumns(TableColumns, TableName));
}
else
{
if (Mode == 1)
{
_columns = _dbType == DatabaseType.SQLite ? TableColumn.GetNewSqlite : TableColumn.GetNew;
}
else
{
_columns = _dbType == DatabaseType.SQLite ? TableColumn.GetAllSqlite : TableColumn.GetAll;
}
}
if (Mode == 1 || Mode == 2)
{
AddButton.Visibility = Visibility.Collapsed;
DeleteButton.Visibility = Visibility.Collapsed;
dgridCols.CanUserAddRows = false;
dgridCols.CanUserDeleteRows = false;
lblTable.Content = "Table Name";
txtTableDesc.IsEnabled = false;
}
if (Mode == 1)
{
Title = "Add column";
}
if (Mode == 2)
{
colPrimary.Visibility = Visibility.Collapsed;
colName.IsReadOnly = true;
Title = "Edit column";
}
dgridCols.ItemsSource = _columns;
var items = TableDataType.GetAll.Where(i => !"REAL.INTEGER.TEXT.BLOB.NUMERIC".Contains(i.Key)).ToDictionary(i => i.Key, i => i.Value);
if (_dbType == DatabaseType.SQLite)
{
items = TableDataType.GetAll.Where(i => "REAL.INTEGER.TEXT.BLOB.NUMERIC".Contains(i.Key)).ToDictionary(i => i.Key, i => i.Value);
}
colDataType.ItemsSource = items;
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
this.txtTableDesc.Focus();
if (TableColumns != null)
{
columns = new ObservableCollection <TableColumn>(TableColumn.BuildTableColumns(TableColumns, TableName));
}
else
{
if (Mode == 1)
{
columns = TableColumn.GetNew;
}
else
{
columns = TableColumn.GetAll;
}
}
if (Mode == 1 || Mode == 2)
{
AddButton.Visibility = System.Windows.Visibility.Collapsed;
DeleteButton.Visibility = System.Windows.Visibility.Collapsed;
dgridCols.CanUserAddRows = false;
dgridCols.CanUserDeleteRows = false;
lblTable.Content = "Table Name";
txtTableDesc.IsEnabled = false;
}
if (Mode == 1)
{
this.Title = "Add column";
}
if (Mode == 2)
{
colPrimary.Visibility = System.Windows.Visibility.Collapsed;
colName.IsReadOnly = true;
this.Title = "Edit column";
}
this.dgridCols.ItemsSource = columns;
this.colDataType.ItemsSource = TableDataType.GetAll;
}
