public ConfigConnexion()
{
InitializeComponent();
List <string> list1 = EnumDsn();
for (int i = 0; i < list1.Count; i++)
{
comboBox1.Items.Add(list1[i]);
}
List <string> list2 = EnumDsn();
for (int i = 0; i < list2.Count; i++)
{
comboBox2.Items.Add(list2[i]);
}
Connexion.ConnexionSaveLoad settings = new Connexion.ConnexionSaveLoad();
if (settings.isSettings())
{
settings.Load();
comboBox1.Text = settings.configurationConnexion.ODBC.DNS;
textBox2.Text = settings.configurationConnexion.ODBC.USER;
textBox3.Text = settings.configurationConnexion.ODBC.PWD;
comboBox2.Text = settings.configurationConnexion.SQL.DNS;
textBox4.Text = settings.configurationConnexion.SQL.USER;
textBox1.Text = settings.configurationConnexion.SQL.PWD;
}
}
public static string getPrefix()
{
string result = "";
string pathModule = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location);
Connexion.ConnexionSaveLoad connexionSaveLoad = new Connexion.ConnexionSaveLoad();
if (connexionSaveLoad.isSettings())
{
connexionSaveLoad.Load();
result = connexionSaveLoad.configurationConnexion.SQL.PREFIX + ".dbo.";
}
return(result);
}
public string ReturnTaskName()
{
string taskName = "ConnecteurSage";
try
{
Connexion.ConnexionSaveLoad settings = new Connexion.ConnexionSaveLoad();
if (!settings.isSettings())
{
MessageBox.Show("Veuillez renseigner la configuration de connexion ODBC d'abord.", "Config Général", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(null);
}
settings.Load();
taskName += "_" + settings.configurationConnexion.SQL.PREFIX;
return(taskName);
}
catch (Exception ex)
{
MessageBox.Show("Message: " + ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(null);
}
}
