internal void GenerateModel( AdvancedWizardForm wiz )
{
if (wiz.ForeignKeys != null)
wiz.ForeignKeys.Clear();
_table = wiz.TableName;
_connectionString = wiz.Connection.ConnectionString;
_columns = BaseWizard<BaseWizardForm, WindowsFormsCodeGeneratorStrategy>.GetColumnsFromTable(_table, wiz.Connection);
var wizardForeignKeys = wiz.ForeignKeys;
wiz.Wizard.RetrieveAllFkInfo(wiz.Connection, _table, out wizardForeignKeys);
wiz.ForeignKeys = wizardForeignKeys;
_colValidations = ValidationsGrid.GetColumnValidationList(_table, _columns, wiz.ForeignKeys);
}
internal override void OnStarting(BaseWizardForm wizard)
{
AdvancedWizardForm wiz = (AdvancedWizardForm)wizard;
// Populate grid
grdColumnsDetail.DataSource = null;
GenerateModel(wiz);
ValidationsGrid.LoadGridColumns(grdColumnsDetail, wiz.Connection, _detailTable, _colValidationsDetail, _detailColumns, wiz.DetailForeignKeys);
lblTitleDetail.Text = string.Format("Setup the validations for the columns in the table {0}", _detailTable);
_colValsByName = new Dictionary <string, ColumnValidation>();
for (int i = 0; i < _colValidationsDetail.Count; i++)
{
_colValsByName.Add(_colValidationsDetail[i].Name, _colValidationsDetail[i]);
}
}
/// <summary>
/// Generates the detail tables definition based on the master-detail data of the model, getting the detail foreign keys as well.
/// </summary>
private void GenerateDetailModelsForItemTemplates()
{
if (DetailForeignKeys != null)
{
DetailForeignKeys.Clear();
}
_detailTable = _detailEntity;
if (string.IsNullOrEmpty(_detailTable))
{
return;
}
_detailColumns = BaseWizard <BaseWizardForm, WindowsFormsCodeGeneratorStrategy> .GetColumnsFromTable(_detailTable, _connection);
ItemTemplateUtilities.RetrieveAllFkInfo(_connection, _detailTable, out DetailForeignKeys);
_colValidationsDetail = ValidationsGrid.GetColumnValidationList(_detailTable, _detailColumns, DetailForeignKeys);
}
internal void InitializeColumnMappings(Dictionary <string, ForeignKeyColumnInfo> fks)
{
foreach (KeyValuePair <string, ForeignKeyColumnInfo> kvp in fks)
{
string fkTableName = kvp.Value.ReferencedTableName;
if (string.IsNullOrEmpty(fkTableName))
{
continue;
}
if (ColumnMappings.ContainsKey(fkTableName))
{
continue;
}
Dictionary <string, Column> dicCols = GetColumnsFromTable(fkTableName, WizardForm.Connection);
List <ColumnValidation> myColValidations = ValidationsGrid.GetColumnValidationList(fkTableName, dicCols, null);
ColumnMappings.Add(fkTableName, myColValidations.ToDictionary(p => { return(p.Name); }));
}
}
/// <summary>
/// Generates the tables and columns based on the model information. Also, it gets the foreign keys data.
/// </summary>
private void GenerateModelsForItemTemplates()
{
if (_columns == null || _columns.Count == 0)
{
if (ForeignKeys != null)
{
ForeignKeys.Clear();
}
_table = _selectedEntity;
_columns = BaseWizard <BaseWizardForm, WindowsFormsCodeGeneratorStrategy> .GetColumnsFromTable(_table, _connection);
ItemTemplateUtilities.RetrieveAllFkInfo(_connection, _table, out ForeignKeys);
_colValidations = ValidationsGrid.GetColumnValidationList(_table, _columns, ForeignKeys);
}
if ((_GuiType == Wizards.GuiType.MasterDetail) && ((_detailColumns == null) || (_detailColumns.Count == 0)))
{
GenerateDetailModelsForItemTemplates();
}
}
internal void GenerateModel(AdvancedWizardForm wiz)
{
if (wiz.DetailForeignKeys != null)
{
wiz.DetailForeignKeys.Clear();
}
_connectionString = wiz.Connection.ConnectionString;
_detailTable = wiz.DetailTableName;
if (string.IsNullOrEmpty(_detailTable))
{
return;
}
_detailColumns = BaseWizard <BaseWizardForm, WindowsFormsCodeGeneratorStrategy> .GetColumnsFromTable(_detailTable, wiz.Connection);
var wizardDetailForeignKeys = wiz.DetailForeignKeys;
wiz.Wizard.RetrieveAllFkInfo(wiz.Connection, _detailTable, out wizardDetailForeignKeys);
wiz.DetailForeignKeys = wizardDetailForeignKeys;
_colValidationsDetail = ValidationsGrid.GetColumnValidationList(_detailTable, _detailColumns, wiz.DetailForeignKeys);
}
