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 Object Insert(Object obj)
{
string query = null;
string valeur = "";
string champs = "";
PropertyInfo key = null;
try
{
List <DbParameter> parameters = new List <DbParameter>();
query = "insert into " + sgbd.TableName(obj.GetType()) + " (";
foreach (PropertyInfo colonne in obj.GetType().GetProperties(flag))
{
Object annotation = colonne.GetCustomAttribute(typeof(Id));
if (annotation != null ? !(annotation as Id).AutoIncrement : true)
{
champs += sgbd.ColonnName(colonne) + ",";
valeur += ":" + sgbd.ColonnName(colonne) + ",";
parameters.Add(sgbd.GetParameter(sgbd.ColonnName(colonne), colonne.GetValue(obj)));
}
else
{
key = colonne;
}
}
query += champs.Substring(0, champs.Length - 1) + ") values (" + valeur.Substring(0, valeur.Length - 1) + ")";
Console.WriteLine(query);
using (DbConnection dbcon = sgbd.GetConnection())
{
if (dbcon != null)
{
DbCommand command = sgbd.GetCommand(query, dbcon);
try
{
command.Parameters.AddRange(parameters.ToArray());
int result = command.ExecuteNonQuery();
if (result == 1 && key != null)
{
query = "select " + sgbd.ColonnName(key) + " from " + sgbd.TableName(obj.GetType()) + " order by " + sgbd.ColonnName(key) + " desc limit 1";
command = sgbd.GetCommand(query, dbcon);
try
{
using (DbDataReader reader = command.ExecuteReader())
{
if (reader.HasRows ? reader.Read() : false)
{
Object id = reader[0];
key.SetValue(obj, id);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(obj);
}
