public void UpdateList() { listView1.Items.Clear(); OleDbConnection conexiune = new OleDbConnection(Provider); string sql = "SELECT * FROM departamente;"; OleDbCommand comanda = new OleDbCommand(sql, conexiune); try { conexiune.Open(); OleDbDataReader reader = comanda.ExecuteReader(); while (reader.Read()) { ListViewItem item = new ListViewItem(reader["id_departament"].ToString()); item.SubItems.Add(reader["denumire"].ToString()); item.SubItems.Add(reader["id_supervizor"].ToString()); Departamente dep = new Departamente(); dep.Id_departament = Convert.ToInt32(reader["id_departament"].ToString()); dep.Denumire = reader["denumire"].ToString(); dep.Id_supervizor = Convert.ToInt32(reader["id_supervizor"].ToString()); item.Tag = dep; listView1.Items.Add(item); } }catch (OleDbException ex) { MessageBox.Show(ex.Message); } finally { conexiune.Close(); } }
public Form_Departamente(Departamente d) { dep = d; InitializeComponent(); }
public Medici(int id_medic, string nume, int varsta, double ore_lucrate, double salariul, int nr_p, List <Pacienti> pacienti, Departamente dep) { this.id_medic = id_medic; this.nume = nume; this.varsta = varsta; this.ore_lucrate_pe_saptamana = ore_lucrate; this.salariul = salariul; this.numar_pacienti = nr_p; // this.pacienti = new List<Pacienti>[nr_p]; this.pacienti = pacienti; this.departament = dep.Denumire; }