/// <summary>
/// Display field list
/// </summary>
void upDateList()
{
if (cmbTypeJointure.SelectedItem == null)
{
return;
}
var tableToJoin = (string)cmbTable.SelectedItem; //getNewJoinedTable();
var is1N = cmbTypeJointure.SelectedItem.ToString() == "1:N"; //1:N complex list
if (is1N)
{
lblChampRef2.Text = string.Format(Properties.Resources.RefFieldForTable, tableToJoin);
lblChampRef.Text = string.Format(Properties.Resources.RefFieldForTable, getJoinParentView());
WizardSQLHelper.displayField(cmbChampRef2, tableToJoin, _connectionString, "");
WizardSQLHelper.displayField(cmbChampRef, getJoinParentView().NomTable, _connectionString, getJoinParentView().Schema, "", false, !chkCmbChRefHT.Checked);
}
else
{
lblChampRef.Text = string.Format(Properties.Resources.RefFieldForTable, getJoinParentView());//1:N
WizardSQLHelper.displayField(cmbChampRef, getJoinParentView().NomTable, _connectionString, getJoinParentView().Schema, "", false, !chkCmbChRefHT.Checked);
}
WizardSQLHelper.displayField(cmbOrder, tableToJoin, _connectionString, getJoinParentView().Schema, "", true);
}
private void cmbTable_SelectedIndexChanged(object sender, EventArgs e)
{
WizardSQLHelper.displayField(cmbChamp, ((TabloidConfigView)cmbTable.SelectedValue).NomTable, _connectionString);
if (init)
{
return;
}
if (cmbJoin.SelectedIndex == -1 || ((TabloidConfigView)cmbTable.SelectedItem).NomTable != ((TabloidConfigJointure)cmbJoin.SelectedItem).NomTable)//no selection look for an interesting join in current list
{
cmbJoin.SelectedItem = null;
selectJoinFromTableName();
if (cmbJoin.SelectedIndex == -1)//no interesting join in current list try to create one from joins in joined table list
{
var joinedTable = (TabloidConfigView)cmbTable.SelectedItem;
foreach (TabloidConfigJointure j in joinedTable.Jointures)
{
if (j.NomTable == _view.NomTable)
{
var dr = MetroMessageBox.Show(this, Properties.Resources.NoJoinCreate, Properties.Resources.CreateJoin, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.No)
{
break;
}
WizardJoin.joinConverter(j, true, joinedTable);
cmbJoin.DataSource = get1NJoin();
selectJoinFromTableName();
}
}
}
}
}
private void cmbTable_SelectedIndexChanged(object sender, System.EventArgs e)
{
WizardSQLHelper.displayField(fieldSelector1.lstChamp, fieldSelector1.cmbTable.SelectedItem.ToString(), Program.AppSet.ConnectionString);
}
public WizardList(TabloidConfigView v)
{
Init(v);
WizardSQLHelper.displayField(cmbExistingField, _view, Program.AppSet.ConnectionString);
}
public WizardList(TabloidConfigView v, string title)
{
Init(v);
txtViewName.Text = title;
WizardSQLHelper.displayField(cmbExistingField, _view, Program.AppSet.ConnectionString);
}
