/// <summary>
/// Function creation wizard
/// </summary>
/// <param name="schema">Name of postgres schema or database name for mysql</param>
public WizardFunction(string schema)
{
InitializeComponent();
string lastError;
var dt = DataTools.Data(WizardSQLHelper.BuildSQLFromFile("functionList.sql", new String[] { schema }), Program.AppSet.ConnectionString, out lastError);
cmbFunction.DataSource = dt;
cmbFunction.DisplayMember = dt.Columns[1].ColumnName;
}
/// <summary>
/// create sql command if necessary
/// </summary>
/// <param name="chkNewField"></param>
/// <param name="cmbField"></param>
/// <param name="txtField"></param>
/// <returns></returns>
private string buildField(RadioButton chkNewField, ComboBox cmbField, TextBox txtField, ref string sql)
{
if (chkNewField.Checked)
{
var param = new string[] { _view.NomTable, txtField.Text, "timestamp", _view.Schema };
sql += WizardSQLHelper.BuildSQLFromFile("addField.sql", param);
return(txtField.Text);
}
return(cmbField.Text);
}