public DataTable SqlExecute(Object GenericObject, int Action)
{
try
{
SqlCommand cmd = new SqlCommand();
SqlConnection conn = new SqlConnection();
ClsConexion conexion = new ClsConexion();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
conn = conexion.OpenSqlConection();
cmd.Connection = conn;
cmd.CommandText = String.Concat(Constants.SQLPrefix, GenericObject.GetType());
cmd.CommandType = CommandType.StoredProcedure;
foreach (PropertyInfo prop in Generic(GenericObject))
{
cmd.Parameters.AddWithValue("@"+prop.Name, prop.GetValue(GenericObject, null));
}
cmd.Parameters.AddWithValue("@Action", Action);
da.Fill(dt);
conexion.CloseSqlConection(conn);
return dt;
}
catch (Exception e)
{
throw;
}
}
public DataTable Execute(Object GenericObject, String Action)
{
try
{
MySqlCommand cmd = new MySqlCommand();
MySqlConnection conn = new MySqlConnection();
ClsConexion conexion = new ClsConexion();
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataTable dt = new DataTable();
conn = conexion.StartConection();
cmd.Connection = conn;
cmd.CommandText = String.Concat(Action, GenericObject.GetType().ToString().ToLower());
cmd.CommandType = CommandType.StoredProcedure;
foreach (PropertyInfo prop in Generic(GenericObject))
{
cmd.Parameters.AddWithValue(String.Concat(ConstantsMySQL.PrefixParammeter, prop.Name), prop.GetValue(GenericObject, null));
}
da.Fill(dt);
conexion.CloseConection(conn);
return dt;
}
catch (Exception)
{
throw;
}
}
