/// <summary>
/// Gets connections available in the file and loads into dropdowns
/// </summary>
private void LoadConnectionCombos()
{
ClearComboControls();
var connections = new ConnectionWriterReader().ReadConnections();
if (connections != null)
{
foreach (var connection in connections)
{
if (!cbDataSource.Items.Contains(connection.DataSource))
{
cbDataSource.Items.Add(connection.DataSource);
}
if (!cbDatabase.Items.Contains(connection.Database))
{
cbDatabase.Items.Add(connection.Database);
}
if (!cbSchema.Items.Contains(connection.Schema))
{
cbSchema.Items.Add(connection.Schema);
}
}
}
}
/// <summary>
/// Subscribe events for controls
/// </summary>
private void EventSubscribtion()
{
// loaded event for window
Loaded += (sender, e) =>
{
try
{
LoadConnectionCombos();
}
catch (Exception ex)
{
Logger.LogErrorIntoFile(ex);
this.ShowMessageAsync(Messages.Error, Messages.SomeThingWrong);
}
};
// datasource selection changed
cbDataSource.SelectionChanged += (sender, e) =>
{
if (cbDataSource.SelectedIndex > 0)
{
txtDataSource.Text = cbDataSource.SelectedValue.ToString();
}
};
// database selection changed
cbDatabase.SelectionChanged += (sender, e) =>
{
if (cbDatabase.SelectedIndex > 0)
{
txtDatabase.Text = cbDatabase.SelectedValue.ToString();
}
};
// schema selection changed
cbSchema.SelectionChanged += (sender, e) =>
{
if (cbSchema.SelectedIndex > 0)
{
txtSchema.Text = cbSchema.SelectedValue.ToString();
}
};
// Create Model click event
btnCreateModel.Click += async(sender, e) =>
{
try
{
string modelName = txtModelName.Text.Trim();
string tableName = lbTables.SelectedValue != null?lbTables.SelectedValue.ToString() : string.Empty;
string dataSource = txtDataSource.Text.Trim();
string dataBase = txtDatabase.Text.Trim();
string propertyNames = txtPropertyNames.Text.Trim();
string path = txtPath.Text.Trim();
bool? interfaceRequired = chkInterfaceRequired.IsChecked;
bool? ormRequired = chkOrmRequired.IsChecked;
bool? backingFieldsRequired = chkBackingField.IsChecked;
bool? validationRequired = chkValidation.IsChecked;
string dbType = cbProvider.Text.Trim();
var userInputs = new
{
TableName = tableName,
ModelName = modelName,
DataSource = dataSource,
DataBase = dataBase,
Path = path,
InterfaceRequired = interfaceRequired,
OrmRequired = ormRequired,
BackingFieldRequired = backingFieldsRequired,
ValidationRequired = validationRequired,
PropertyNames = propertyNames,
DbType = dbType,
DbConnection.Version
};
var propertyList = new List <Property>();
for (int i = 0; i < _properties.Count; i++)
{
var sortedProperties = _properties.OrderBy(x => Convert.ToInt32(x.Key.Split(',')[0]));
propertyList.Add(sortedProperties.ElementAt(i).Value);
}
string message = await ModelGenerator.GenerateModelAsync(userInputs, propertyList);
if (message.Contains("Successful"))
{
await this.ShowMessageAsync(Messages.Success, message);
ClearControlsDataSource();
}
else
{
await this.ShowMessageAsync(Messages.Failed, message);
}
}
catch (Exception ex)
{
Logger.LogErrorIntoFile(ex);
await this.ShowMessageAsync(Messages.Error, Messages.SomeThingWrong);
}
};
// Connection Status click event
btnLoadTables.Click += async(sender, e) =>
{
try
{
bool status = await LoadTablesAsync();
if (status)
{
await this.ShowMessageAsync(Messages.Success, Messages.ConnectionSuccessful);
}
else
{
await this.ShowMessageAsync(Messages.Failed, Messages.ConnectionFailed);
}
}
catch (Exception ex)
{
Logger.LogErrorIntoFile(ex);
await this.ShowMessageAsync(Messages.Error, Messages.SomeThingWrong);
}
};
// Browse for Location to store
btnBrowse.Click += (sender, e) =>
{
var dialog = new System.Windows.Forms.FolderBrowserDialog();
dialog.ShowDialog();
txtPath.Text = dialog.SelectedPath;
};
// Save Connection event
btnSaveConnection.Click += (sender, e) =>
{
string source = txtDataSource.Text.Trim();
string database = txtDatabase.Text.Trim();
string schema = txtSchema.Text.Trim();
try
{
if (!(string.IsNullOrEmpty(source) || string.IsNullOrEmpty(database) || string.IsNullOrEmpty(schema)))
{
if (!(cbDataSource.Items.Contains(source) && cbDatabase.Items.Contains(database) && cbSchema.Items.Contains(schema)))
{
string conString = source + "," + database + "," + schema;
var writer = new ConnectionWriterReader();
if (writer.WriteConnection(conString))
{
LoadConnectionCombos();
this.ShowMessageAsync(Messages.Success, Messages.ConnectionSaveSuccessful);
}
else
{
this.ShowMessageAsync(Messages.Failed, Messages.ConnectionSaveUnSuccessful);
}
return;
}
this.ShowMessageAsync(Messages.Failed, Messages.ConnectionAlreadyPresent);
return;
}
this.ShowMessageAsync(Messages.Failed, Messages.EnterMandatoryFields);
}
catch (Exception ex)
{
Logger.LogErrorIntoFile(ex);
this.ShowMessageAsync(Messages.Error, Messages.SomeThingWrong);
}
};
// Remove connection event
btnRemoveConnection.Click += (sender, e) =>
{
string source = txtDataSource.Text.Trim();
string database = txtDatabase.Text.Trim();
string schema = txtSchema.Text.Trim();
try
{
if (!(string.IsNullOrEmpty(source) && string.IsNullOrEmpty(database) && string.IsNullOrEmpty(schema)))
{
var reader = new ConnectionWriterReader();
if (reader.DeleteConnection(source, database, schema))
{
this.ShowMessageAsync(Messages.Success, Messages.DeletionSuccessful);
}
else
{
this.ShowMessageAsync(Messages.Failed, string.Format(Messages.DeletionUnSuccessful, source, database, schema));
}
LoadConnectionCombos();
}
else
{
this.ShowMessageAsync(Messages.Failed, Messages.EnterMandatoryFields);
}
}
catch (Exception ex)
{
Logger.LogErrorIntoFile(ex);
this.ShowMessageAsync(Messages.Error, Messages.SomeThingWrong);
}
};
// Tables selection event
lbTables.SelectionChanged += async(sender, e) =>
{
if (lbTables.SelectedItem != null)
{
try
{
string source = txtDataSource.Text.Trim();
string database = txtDatabase.Text.Trim();
string table = txtModelName.Text = lbTables.SelectedItem.ToString();
string conString = string.Format(Messages.SourceDatabaseSchema, source, database);
string query = string.Format(Messages.SchemaOnColumns, table);
if (string.IsNullOrEmpty(source) || string.IsNullOrEmpty(database))
{
await this.ShowMessageAsync(Messages.Failed, Messages.ConnectionFailed);
return;
}
lbColumns.ItemsSource = null;
var helper = new DbHelper();
var columnCollection = await helper.ExecuteReaderOnColumnsAsync(conString, query);
if (columnCollection.Count() > 0)
{
lbColumns.ItemsSource = columnCollection;
lbColumns.DisplayMemberPath = "ColumnName";
btnAddForPreview.IsEnabled = true;
}
}
catch (Exception ex)
{
Logger.LogErrorIntoFile(ex);
await this.ShowMessageAsync(Messages.Error, Messages.SomeThingWrong);
}
}
};
// Preview button click event
btnAddForPreview.Click += (sender, e) =>
{
string selectedColumns = "";
var selected = lbColumns.SelectedItems;
try
{
if (selected.Count > 0)
{
var obsoleteCols = _properties.Where(x => x.Key.Contains(lbTables.SelectedValue.ToString())).ToList();
for (int i = 0; i < obsoleteCols.Count; i++)
{
_properties.Remove(obsoleteCols[i].Key);
}
for (int i = 0; i < selected.Count; i++)
{
_properties.Add(_count + "," + lbTables.SelectedValue.ToString(), selected[i] as Property);
_count++;
}
for (int i = 0; i < _properties.Count; i++)
{
var sortedProperties = _properties.OrderBy(x => Convert.ToInt32(x.Key.Split(',')[0]));
selectedColumns += sortedProperties.ElementAt(i).Value.ColumnName + ",";
}
selectedColumns = selectedColumns.Substring(0, selectedColumns.Length - 1);
txtPreviewColumns.Text = selectedColumns;
return;
}
this.ShowMessageAsync(Messages.Failed, Messages.SelectAnyColumns);
}
catch (Exception ex)
{
Logger.LogErrorIntoFile(ex);
this.ShowMessageAsync(Messages.Error, Messages.SomeThingWrong);
}
};
// ClearAll button click event
btnClearAll.Click += (sender, e) =>
{
_properties.Clear();
_count = 0;
ClearControlsDataSource();
};
// SearchTables TextChanged event
txtSearchTables.TextChanged += (sender, e) =>
{
if (_tableCollections != null && _tableCollections.Count() > 0)
{
lbColumns.ItemsSource = null;
lbTables.ItemsSource = _tableCollections.Where(x => x.IndexOf(txtSearchTables.Text, StringComparison.OrdinalIgnoreCase) >= 0).AsEnumerable();
}
};
// SearchTables PreviewKeyDowm event
txtSearchTables.PreviewKeyDown += (sender, e) =>
{
if (e.Key == System.Windows.Input.Key.Down && lbTables.ItemsSource != null)
{
lbTables.Focus();
lbTables.SelectedIndex = 1;
}
};
// CopyCode button click event
btnCopyCode.Click += (sender, e) =>
{
string propInput = txtPropertyNames.Text;
string copyString = "";
if (chkCopyCode.IsChecked == true && !string.IsNullOrEmpty(propInput))
{
var props = propInput.Split(',');
var properties = new List <Property>();
for (int i = 0; i < props.Length; i++)
{
properties.Add(new Property
{
PropertyName = props[i].Trim()
});
}
if (properties.Count > 0)
{
copyString = ModelGenerator.CopyPropertyStrings(properties, chkBackingField.IsChecked == true);
}
System.Windows.Clipboard.SetText(copyString);
return;
}
this.ShowMessageAsync(Messages.Failed, Messages.CopyError);
};
// CopyCode checkbox click event
chkCopyCode.Click += (sender, e) =>
{
btnCopyCode.IsEnabled = chkCopyCode.IsChecked == true;
};
}