private void getDefaultValues()
{
this.Icon = Properties.Resources.icooddb;
if (dbconfig != null && dbconfig.Db != null)
{
dbHelper = new DatabaseHelper(dbconfig);
this.txbServer.Text = dbconfig.Server;
this.txbPort.Text = dbconfig.Port;
this.txbUser.Text = dbconfig.User;
this.txbPassword.Text = dbconfig.Password;
try
{
updateCmbDBsItems(true);
}
catch (Exception ex)
{
Console.Out.Write(ex.Message);
}
if (dbHelper.isConnectionAvailable(dbconfig))
{
lblTestResult.Text = testSuccess;
this.lblTestResult.ForeColor = System.Drawing.Color.Green;
}
else
{
lblTestResult.Text = testFail;
this.lblTestResult.ForeColor = System.Drawing.Color.Red;
}
}
}
public DialogInsertingForm(DatabaseHelper dbHelper, TableList tablesList)
{
this.dbHelper = dbHelper;
this.tablesList = tablesList;
InitializeComponent();
getLocalizedLabelsMessages();
getDefaultValues();
}
public AddDBForm(DBConfig dbconfig)
{
this.dbconfig = dbconfig;
dbHelper = new DatabaseHelper(dbconfig);
InitializeComponent();
getDefaultValues();
getLocalizedLabelsMessages();
}
public ChangeTablesForm(List<Table> tables, DBConfig dbconfig)
{
this.Tables = tables;
this.dbconfig = dbconfig;
this.dbHelper = new DatabaseHelper(dbconfig);
InitializeComponent();
getLocalizedLabelsMessages();
getDefaultValues();
}
public InsertDataForm(StartScreenForm startForm, TableList tablesList)
{
this.startForm = startForm;
InitializeComponent();
this.dbHelper = new DatabaseHelper(startForm.Template.DBconfig);
this.TablesList = tablesList;
getLocalizedLabelsMessages();
getDefaultValues();
createTablesView();
}
public ExecuteSQLForm(TableList tablesList, DBConfig dbconfig, Boolean isInserting)
{
this.isInserting = isInserting;
this.dbconfig = dbconfig;
this.tablesList = tablesList;
this.dbHelper = new DatabaseHelper(dbconfig);
InitializeComponent();
getLocalizedLabelsMessages();
getDefaultValues();
}
public ChangeColumnForm(List<Table> tables, DBConfig dbconfig)
{
this.TablesList = new TableList(tables);
this.dbconfig = dbconfig;
this.dbHelper = new DatabaseHelper(dbconfig);
InitializeComponent();
getLocalizedLabelsMessages();
getDefaultValues();
createTablesView();
}
public TableDescriptionForm(DBConfig dbconfig, String tableName)
{
InitializeComponent();
this.txbLimit.DataBindings.Add("Text", this, "Limit");
this.tableName = tableName;
this.dbconfig = dbconfig;
this.dbHelper = new DatabaseHelper(dbconfig);
getLocalizedLabelsMessages();
getDefaultValues();
setFormSize();
}
private void updateCmbDBsItems(bool select)
{
cmbDBs.Items.Clear();
cmbDBs.Text = "";
cmbDBs.SelectedIndex = -1;
dbHelper = new DatabaseHelper(dbconfig);
List<String> dbList = dbHelper.selectDataBases();
foreach (String s in dbList)
{
int index = cmbDBs.Items.Add(s);
if (select && s.Equals(dbconfig.DbName))
cmbDBs.SelectedIndex = index;
}
}
private Boolean validateTemplateFileConnection()
{
if (Template != null)
{
if (Template.DBconfig != null && Template.DBconfig.Db != null && !"".Equals(Template.DBconfig.Db))
{
dbHelper = new DatabaseHelper(Template.DBconfig);
return dbHelper.isConnectionAvailable(Template.DBconfig);
}
}
return false;
}
private void btnTest_Click(object sender, EventArgs e)
{
DatabaseHelper dbHelper = new DatabaseHelper(this.Template.DBconfig);
this.Template.DBconfig.Db = cmbDB.SelectedItem.ToString();
this.Template.DBconfig.Server = txbServer.Text;
this.Template.DBconfig.Port = txbPort.Text;
this.Template.DBconfig.User = txbUser.Text;
this.Template.DBconfig.Password = txbPassword.Text;
if (dbHelper.isConnectionAvailableNoDB(this.Template.DBconfig))
{
this.lblTestResult.Text = testSuccess;
this.lblTestResult.ForeColor = System.Drawing.Color.Green;
this.btnAddDB.Enabled = true;
this.cmbDBs.Enabled = true;
this.lblDatabase.Enabled = true;
updateCmbDBsItems(false);
}
else
{
this.lblTestResult.Text = testFail;
this.lblTestResult.ForeColor = System.Drawing.Color.Red;
this.btnAddDB.Enabled = false;
this.cmbDBs.Enabled = false;
this.lblDatabase.Enabled = false;
}
}
private Boolean validateStep()
{
switch (step)
{
case 1:
if (this.txbDataFilePath.Text == null || "".Equals(this.txbDataFilePath.Text))
{
showErrorInfoWindow(msgErrorNoDataFile);
return false;
}
break;
case 2:
if (this.cmbDB.SelectedItem != null && !"".Equals(this.cmbDB.SelectedItem.ToString()))
{
DBConfig dbconfig = new DBConfig();
String db = this.cmbDB.SelectedItem.ToString();
this.Template = this.Template == null ? new Template(null, new DBConfig()) : this.Template;
this.Template.DBconfig = this.Template.DBconfig == null ? new DBConfig() : this.Template.DBconfig;
this.Template.DBconfig.Db = db;
dbHelper = new DatabaseHelper(this.Template.DBconfig);
updateCmbDBsItems(false);
}
else
return false;
break;
case 3:
break;
}
return true;
}
