private void cboDBType_SelectedIndexChanged(object sender, EventArgs e)
{
switch (cboDBType.SelectedIndex)
{
case 0:
connexionType = ConnexionType.SQLServer;
break;
case 1:
connexionType = ConnexionType.MySQL;
break;
case 2:
connexionType = ConnexionType.PostGrsSQL;
break;
case 3:
connexionType = ConnexionType.Oracle;
break;
case 4:
connexionType = ConnexionType.Access;
break;
}
}
public IDbConnection Initialise(Connexion connexion, ConnexionType connexionType)
{
switch (connexionType)
{
case ConnexionType.SQLServer:
_conn = new SqlConnection(string.Format("Data source={0};Initial catalog={1};User ID={2};Password={3}",
connexion.Serveur, connexion.Database, connexion.User, connexion.Password));
break;
case ConnexionType.MySQL:
_conn = new MySqlConnection(string.Format("Server={0};Database={1};UserID={2};Password={3}",
connexion.Serveur, connexion.Database, connexion.User, connexion.Password));
break;
case ConnexionType.PostGrsSQL:
_conn = new NpgsqlConnection(string.Format("Server={0};Database={1};Uid={2};Pwd={3};Port={4}",
connexion.Serveur, connexion.Database, connexion.User, connexion.Password, connexion.Port));
break;
case ConnexionType.Oracle:
return(null);
case ConnexionType.Access:
return(null);
}
return(_conn);
}
public IDbConnection Initialise(Connexion connexion, ConnexionType connexionType)
{
switch (connexionType)
{
case ConnexionType.SQLServer:
//_conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\QSTOCK DATABASE\QUINKA_STOCK.mdf;Integrated Security=True");
_conn = new SqlConnection(string.Format("Data source={0};Initial catalog={1};User ID={2};Password={3}",
connexion.Serveur, connexion.Database, connexion.User, connexion.Password));
break;
//case ConnexionType.MySQL:
// _conn = new MySqlConnection(string.Format("Server={0};Database={1};UserID={2};Password={3}",
// connexion.Serveur, connexion.Database, connexion.User, connexion.Password));
// break;
//case ConnexionType.PostGrsSQL:
// _conn = new NpgsqlConnection(string.Format("Server={0};Database={1};Uid={2};Pwd={3};Port={4}",
// connexion.Serveur, connexion.Database, connexion.User, connexion.Password, connexion.Port));
// break;
case ConnexionType.Oracle:
return(null);
case ConnexionType.Access:
return(null);
}
return(_conn);
}
public static bool CreationDeFichierConf(Connexions con, ConnexionType connexionType)
{
bool reponse = false;
string chemin = "";
switch (connexionType)
{
case ConnexionType.SQLServer:
chemin = "Data Source=" + con.Serveur + "; Initial Catalog=" + con.Database + "; User Id=" + con.User + "; Password="******";";
File.WriteAllText(ClsConstante.Table.cheminSql, chemin.ToString());
reponse = true;
break;
case ConnexionType.MySQL:
chemin = "Server=" + con.Serveur + "; Database=" + con.Database + "; UserId=" + con.User + "; Password="******";";
// File.WriteAllText(ClsConstante.Table.cheminMysql, chemin.ToString());
reponse = true;
break;
}
return(reponse);
}
