public IDbConnection Initialize(Connexion connexion, Sgbd sgbd)
{
switch (sgbd)
{
case Sgbd.SQLServer:
_conn = new SqlConnection(string.Format("Data source ={0}; Initial catalog = {1}; User ID = {2}; Password ={3}",
connexion.Server, 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 Sgbd.Oracle:
return(null);
case Sgbd.Access:
_conn = new OleDbConnection(string.Format("Data Source ={ 0 }; Initial catalog ={ 1 }; User ID ={ 2 }; Password ={ 3 }",
connexion.Server, connexion.Database, connexion.User, connexion.Password));
break;
}
return(_conn);
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
switch (comboBox1.SelectedIndex)
{
case 0:
sgbd = Sgbd.SQLServer;
break;
case 1:
sgbd = Sgbd.MySQL;
break;
case 2:
sgbd = Sgbd.PostGrsSQL;
break;
case 3:
sgbd = Sgbd.Oracle;
break;
case 4:
sgbd = Sgbd.Access;
break;
}
}
public Database SetSgbd(Sgbd sgbd)
{
Sgbd = sgbd;
ConnectionString = GetConnectionStringByConfig();
Connection?.Dispose();
return(this);
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
switch (comboBox1.SelectedIndex)
{
case 0:
sgbd = Sgbd.SQLServer;
break;
}
}
public Database(Sgbd sgbd, string connectionString)
{
Sgbd = sgbd;
ConnectionString = connectionString;
Parameters = new List <DatabaseParameter>();
CloseConnectionAfterExecuted = true;
OpenConnectionBeforeExecuted = true;
UseTransaction = false;
AutoCommit = true;
UseDataReaderToGetData = true;
}
public DataBase(Sgbd.Type type, string connexionstring)
{
try
{
switch (type)
{
case Sgbd.Type.POSTGRES:
sgbd = new Postgres(connexionstring);
break;
case Sgbd.Type.MYSQL:
sgbd = new Mysql(connexionstring);
break;
}
foreach (PropertyInfo dbset in GetType().GetProperties())
{
Type[] arguments = dbset.PropertyType.GetGenericArguments();
if (arguments.Length > 0)
{
Type table = arguments[0];
string query = sgbd.CreateTable(table);
Console.WriteLine(query);
using (DbConnection dbcon = sgbd.GetConnection())
{
if (dbcon != null)
{
DbCommand command = sgbd.GetCommand(query, dbcon);
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
}
dbset.SetValue(this, Activator.CreateInstance(dbset.PropertyType));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
instance = this;
}
public LogImportacaoRepository(Sgbd sgbd, string connectionString) : base(sgbd, connectionString)
{
}
public LogImportacaoRepository(Sgbd sgbd) : base(sgbd)
{
}
