public void create()
{
db = new Database();
space = new Space();
try
{
pathQuery = new MySqlCommand();
pathQuery.Connection = db.Connection();
pathQuery.CommandText = "INSERT INTO path(path) VALUES(@Path)";
pathQuery.Prepare();
pathQuery.Parameters.AddWithValue("@Path", path);
pathQuery.ExecuteNonQuery();
MessageBox.Show("O Caminho " + path + " foi criado com sucesso.");
}
catch (MySqlException ex)
{
MessageBox.Show("Ocurreu um erro");
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
db.Close();
}
}
public void findAll()
{
db = new Database();
space = new Space();
paths.Clear();
pathQuery = new MySqlCommand();
pathQuery.Connection = db.Connection();
pathQuery.CommandText = "SELECT * FROM path ORDER BY path ASC";
pathResult = pathQuery.ExecuteReader();
while (pathResult.Read())
{
if (!pathResult.IsDBNull(0))
{
idpath = pathResult.GetInt32(0);
}
if (!pathResult.IsDBNull(1))
{
path = pathResult.GetString(1);
}
paths.Add(new Path { idpath = this.idpath, path = this.path });
}
db.Close();
}
public void findByPath()
{
db = new Database();
space = new Space();
paths.Clear();
pathQuery = new MySqlCommand();
pathQuery.Connection = db.Connection();
pathQuery.CommandText = "SELECT * FROM path WHERE path = @Path";
pathQuery.Prepare();
pathQuery.Parameters.AddWithValue("@Path", path);
pathResult = pathQuery.ExecuteReader();
while (pathResult.Read())
{
if (!pathResult.IsDBNull(0))
{
idpath = pathResult.GetInt32(0);
}
if (!pathResult.IsDBNull(1))
{
path = pathResult.GetString(1);
}
}
db.Close();
}
