public Addmapform(Filesharingform parent, Categorie selected_map) { InitializeComponent(); bt_accept.Image = parent.imagelist_icons48x48.Images[6]; this.parent = parent; this.selected_map = selected_map; }
// haalt uit de database alle submappen en files in de geselecteerde map en laat deze netjes zien private void Treeview_categories_NodeMouseClick_1(object sender, TreeNodeMouseClickEventArgs e) { try { // root gedeelte if (e.Node.Text == "Mijn Bestanden") { File[] files = DatabaseKoppeling.searchUserFiles(RFID).ToArray(); listv_files.Items.Clear(); listv_files.Items.AddRange(files); bt_verwijdermap.Enabled = false; bt_nieuwemap.Enabled = false; bt_upload.Enabled = false; } else { Categorie current = e.Node as Categorie; current.Nodes.Clear(); Categorie[] lijst = DatabaseKoppeling.getFolders(current.Map_id).ToArray(); current.Nodes.AddRange(lijst); current.Expand(); folder_selection = current; if (type == type_gebruiker.Medewerker) { bt_nieuwemap.Enabled = true; if (current.Map_id != 0) { bt_verwijdermap.Enabled = true; } else { bt_verwijdermap.Enabled = false; } } bt_upload.Enabled = true; // // files gedeelte File[] files = DatabaseKoppeling.getFiles(current.Map_id).ToArray(); listv_files.Items.Clear(); listv_files.Items.AddRange(files); } // general gedeelte listv_files.Visible = true; bt_download.Enabled = false; bt_remove.Enabled = false; // } catch { MessageBox.Show("Ongeldige database actie. \nEr heeft zich een database restrictie voorgedaan of de connectie is verbroken.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static Categorie newFolder(string map_naam, int id_parent) { Categorie map; string map_id = ""; string sql = "SELECT seq_map.nextval FROM dual"; OracleCommand cmd = new OracleCommand(sql, conn); try { conn.Open(); OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { map_id = reader["nextval"].ToString(); } cmd = new OracleCommand(); cmd.Parameters.Add(new OracleParameter("map_naam", map_naam)); cmd.CommandText = "INSERT INTO MAP VALUES (" + map_id + ", :map_naam, " + id_parent.ToString() + ")"; cmd.Connection = conn; cmd.ExecuteNonQuery(); map = new Categorie(Convert.ToInt32(map_id), map_naam, id_parent); } catch (OracleException ex) { throw ex; } finally { conn.Close(); } return map; }
public static List<Categorie> getFolders(int id_parent) { List<Categorie> categorien = new List<Categorie>(); string sql = "SELECT * FROM MAP WHERE Parent_id = " + id_parent.ToString(); OracleCommand cmd = new OracleCommand(sql, conn); try { conn.Open(); OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Categorie ca = new Categorie(Convert.ToInt32(reader["MAP_ID"]), reader["MAP_NAAM"].ToString(), Convert.ToInt32(reader["PARENT_ID"])); if (ca.Parent_id != ca.Map_id) { categorien.Add(ca); } } } catch (OracleException ex) { throw ex; } finally { conn.Close(); } return categorien; }