public List <Database> PegaBanco(long id)
{
List <Database> tabeladebancos = new List <Database>();
ConnectionSqlServer cc = new ConnectionSqlServer();
cc.abrir();
string cadena = "select b.Name,b.ConnectionString,b.IdDatabase from UserDatabase a inner join Databases b on a.IdDatabase = b.IdDatabase inner join Users c on a.IdUser = c.IdUser where c.IdUser ="******"errado " + err.Message);
}
return(tabeladebancos);
}
public Resultado ultimoId()
{
Resultado rr = new Resultado();
ConnectionSqlServer cc = new ConnectionSqlServer();
cc.abrir();
string cadena = "select max(idDatabase) from Databases ";
try
{
SqlCommand command = new SqlCommand(cadena, cc.conectarbd);
SqlDataReader lector = command.ExecuteReader();
while (lector.Read())
{
rr.textresult = lector[0].ToString();
}
}
catch (Exception err)
{
Console.WriteLine("errado " + err.Message);
}
return(rr);
}
static void Main(string[] args)
{
Voiture ka = new Voiture
{
Brand = "Ford",
Model = "Ka",
CreateDate = DateTime.Today.AddDays(-1),
Distance = 100454356578,
Power = 4,
Sizecar = 5.25,
Isitok = true
};
Voiture mustang = new Voiture
{
Brand = "Ford",
Model = "Mustang",
CreateDate = DateTime.Today.AddDays(5),
Distance = 100,
Power = 360,
Sizecar = 5.25,
Isitok = true
};
Voiture golf = new Voiture
{
Brand = "Volkswagen",
Model = "Golf 7",
CreateDate = DateTime.Today,
Distance = 25324,
Power = 120,
Sizecar = 4.25,
Isitok = true
};
Voiture aventador = new Voiture
{
Brand = "Lamborghini",
Model = "Aventador",
CreateDate = DateTime.Today,
Distance = 2500,
Power = 120,
Sizecar = 4.25,
Isitok = true
};
////Test of MySQL
ConnectionMySql connectionMySql = new ConnectionMySql("MySQL ODBC 5.3 ANSI Driver", "localhost",
"test", "root", "root");
MySqlMapping.DropTableNextGen(connectionMySql, new Voiture());
MySqlMapping.CreateTableNextGen(connectionMySql, new Voiture());
MySqlMapping.InsertNextGen(connectionMySql, ka);
MySqlMapping.InsertNextGen(connectionMySql, mustang);
MySqlMapping.InsertNextGen(connectionMySql, golf);
MySqlMapping.InsertNextGen(connectionMySql, aventador);
List <Voiture> GarageMySql =
MySqlMapping.SelectTableNextGen(connectionMySql, "Brand", "Ford", new Voiture());
ka.Power = 250;
MySqlMapping.UpdateElementNextGen(connectionMySql, 1, ka);
MySqlMapping.DeleteElemetFromTableNextGen(connectionMySql, "Brand", "Lamborghini", new Voiture());
//Test of PostGre
ConnectionPostGre connectionPostGre = new ConnectionPostGre("PostgreSQL Unicode", "localhost", "5432",
"testorm", "postgres", "root");
PostGreMapping.DropTableNextGen(connectionPostGre, new Voiture());
PostGreMapping.CreateTableNextGen(connectionPostGre, new Voiture());
PostGreMapping.InsertNextGen(connectionPostGre, ka);
PostGreMapping.InsertNextGen(connectionPostGre, mustang);
PostGreMapping.InsertNextGen(connectionPostGre, golf);
PostGreMapping.InsertNextGen(connectionPostGre, aventador);
List <Voiture> GaragePostGre =
PostGreMapping.SelectTableNextGen(connectionPostGre, "Brand", "Ford", new Voiture());
PostGreMapping.DeleteElemetFromTableNextGen(connectionPostGre, "Brand", "Lamborghini", new Voiture());
mustang.Power = 2501;
PostGreMapping.UpdateElementNextGen(connectionPostGre, 2, mustang);
//Test of SQL Server
ConnectionSqlServer connectionSqlServer =
new ConnectionSqlServer("(local)", "testorm", "dinesh", "root1234");
SQLServerMapping.DropTableNextGen(connectionSqlServer, new Voiture());
SQLServerMapping.CreateTableNextGen(connectionSqlServer, new Voiture());
SQLServerMapping.InsertNextGen(connectionSqlServer, ka);
SQLServerMapping.InsertNextGen(connectionSqlServer, mustang);
SQLServerMapping.InsertNextGen(connectionSqlServer, golf);
SQLServerMapping.InsertNextGen(connectionSqlServer, aventador);
List <Voiture> GarageSqlServer =
SQLServerMapping.SelectTableNextGen(connectionSqlServer, "Brand", "Ford", new Voiture());
SQLServerMapping.DeleteElemetFromTableNextGen(connectionSqlServer, "Model", "Ka", new Voiture());
aventador.Power = 783;
SQLServerMapping.UpdateElementNextGen(connectionSqlServer, 4, aventador);
// SQLServerMapping.DeleteElemetFromTableNextGen("Brand", "Lamborghini", new Voiture());
Console.WriteLine("End");
}
public FrmPeople(ConnectionSqlServer connectionSqlServer)
{
InitializeComponent();
DalPeople = new DalPeople(connectionSqlServer);
}
private static TableMapper LoadSQLServer(String TableName)
{
var TableMapper = new TableMapper();
var Query = "SELECT " +
"UPPER(A.COLUMN_NAME) COLUMN_NAME, " +
"LOWER(A.IS_NULLABLE) IS_NULLABLE, " +
"LOWER(A.DATA_TYPE) DATA_TYPE, " +
"LOWER(A.CHARACTER_MAXIMUM_LENGTH) MAXIMUM_LENGTH, " +
"B.COLUMN_KEY " +
"FROM " +
"INFORMATION_SCHEMA.COLUMNS A LEFT JOIN " +
"(SELECT UPPER(KCU.TABLE_NAME) AS TABLE_NAME, " +
" UPPER(KCU.COLUMN_NAME) AS COLUMN_NAME, " +
" CASE WHEN LOWER(TC.CONSTRAINT_TYPE) = 'PRIMARY KEY' THEN 'pk' " +
" WHEN LOWER(TC.CONSTRAINT_TYPE) = 'FOREIGN KEY' THEN 'fk' " +
" WHEN LOWER(TC.CONSTRAINT_TYPE) = 'UNIQUE' THEN NULL " +
" WHEN LOWER(TC.CONSTRAINT_TYPE) = NULL THEN NULL " +
" END AS COLUMN_KEY " +
" FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU " +
" LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC " +
" ON KCU.TABLE_NAME = TC.TABLE_NAME " +
" AND KCU.TABLE_SCHEMA = TC.TABLE_SCHEMA " +
" AND KCU.TABLE_CATALOG = TC.TABLE_CATALOG " +
" AND KCU.CONSTRAINT_CATALOG = TC.CONSTRAINT_CATALOG " +
" AND KCU.CONSTRAINT_NAME = TC.CONSTRAINT_NAME " +
" LEFT JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC " +
" ON RC.CONSTRAINT_SCHEMA = TC.CONSTRAINT_SCHEMA " +
" AND RC.CONSTRAINT_CATALOG = TC.CONSTRAINT_CATALOG " +
" AND RC.CONSTRAINT_NAME = TC.CONSTRAINT_NAME " +
" LEFT JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CCU " +
" ON RC.UNIQUE_CONSTRAINT_SCHEMA = CCU.CONSTRAINT_SCHEMA " +
" AND RC.UNIQUE_CONSTRAINT_CATALOG = CCU.CONSTRAINT_CATALOG " +
" AND RC.UNIQUE_CONSTRAINT_NAME = CCU.CONSTRAINT_NAME) B " +
" ON A.TABLE_NAME = B.TABLE_NAME AND A.COLUMN_NAME = B.COLUMN_NAME " +
"WHERE " +
"A.TABLE_NAME = '" + TableName.ToLower() + "'";
using (var Conexao = new ConnectionSqlServer(Query))
{
if (Conexao.Open())
{
TableMapper.TableName = TableName;
var CollectionColumnMapper = new List <ColumnMapper>();
while (Conexao.LerRegistro())
{
var Column = new ColumnMapper();
Column.ColumnName = Conexao.Ler("COLUMN_NAME").ToString();
Column.IsNullable = Conexao.Ler("IS_NULLABLE").ToString();
Column.DataType = Conexao.Ler("DATA_TYPE").ToString();
Column.MaxLenght = Conexao.Ler("MAXIMUM_LENGTH").ToString();
Column.ColumnKey = Conexao.Ler("COLUMN_KEY").ToString();
CollectionColumnMapper.Add(Column);
}
TableMapper.CollectionColumn = CollectionColumnMapper;
}
}
return(TableMapper);
}
private void FrmPrincipal_FormClosing(object sender, FormClosingEventArgs e)
{
ConnectionSqlServer?.Dispose();
ConnectionSqlServer = null;
}
public FrmPrincipal()
{
InitializeComponent();
ConnectionSqlServer = new ConnectionSqlServer();
}
