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);
}
}
private void enregistrer_config_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(comboBox1.Text))
{
MessageBox.Show("DSN ODBC est obligatoire !!");
return;
}
if (string.IsNullOrEmpty(comboBox2.Text))
{
MessageBox.Show("DSN SQL est obligatoire !!");
return;
}
Connexion.Classes.ConfigurationConnexion configurationConnexion = new Connexion.Classes.ConfigurationConnexion(
new Connexion.Classes.Custom.ODBC(comboBox1.Text, textBox2.Text, textBox3.Text),
new Connexion.Classes.Custom.SQL(comboBox2.Text.Split(new String[] { "__" }, StringSplitOptions.None)[0], comboBox2.Text, textBox4.Text, textBox1.Text)
);
Connexion.ConnexionSaveLoad settings = new Connexion.ConnexionSaveLoad();
settings.configurationConnexion = configurationConnexion;
settings.saveInfo();
Close();
}
public string getDNS()
{
Connexion.ConnexionSaveLoad settings = new Connexion.ConnexionSaveLoad();
settings.Load();
return(settings.configurationConnexion.SQL.PREFIX);
}
