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(); }