public static Medici operator +(Medici m, Pacienti p)
{
m.pacienti.Add(p);
m.numar_pacienti++;
List <Pacienti> list = m.pacienti;
Medici med = new Medici(m.id_medic, m.nume, m.varsta, m.ore_lucrate_pe_saptamana, m.salariul, m.numar_pacienti, list);
return(med);
}
public Form_adauga_medic(Medici m)
{
medic = m;
InitializeComponent();
numeTXT.Text = medic.Nume;
varstTXT.Text = medic.Varsta.ToString();
oreTXT.Text = medic.Ore_lucrate.ToString();
salariulTXT.Text = medic.Salariul.ToString();
departamentTXT.Text = medic.Departament;
}
public Retete(int nr_crt, Pacienti p, Medici m, string[] medicament, int cantitate, double pret, DateTime date)
{
this.nr_crt = nr_crt;
this.pacient = p.Nume;
this.medic = m.Nume;
this.cantitate_med = cantitate;
this.medicament = new string[cantitate];
this.medicament = medicament;
this.pret = pret;
this.data = date;
}
public int CompareTo(object obj)
{
Medici medic = (Medici)obj;
if (this.ore_lucrate_pe_saptamana > medic.ore_lucrate_pe_saptamana)
{
return(-1);
}
else if (this.ore_lucrate_pe_saptamana < medic.ore_lucrate_pe_saptamana)
{
return(1);
}
else
{
return(this.ore_lucrate_pe_saptamana.CompareTo(medic.ore_lucrate_pe_saptamana));
}
}
public void UpdateList()
{
listView1.Items.Clear();
treeView1.Nodes.Clear();
OleDbConnection conexiune = new OleDbConnection(Provider);
string sql = "SELECT * FROM medici";
OleDbCommand comanda = new OleDbCommand(sql, conexiune);
try
{
conexiune.Open();
OleDbDataReader reader = comanda.ExecuteReader();
while (reader.Read())
{
ListViewItem item = new ListViewItem(reader["id_medic"].ToString());
item.SubItems.Add(reader["nume"].ToString());
item.SubItems.Add(reader["varsta"].ToString());
item.SubItems.Add(reader["ore_lucrate_pe_saptamana"].ToString());
item.SubItems.Add(reader["salariul"].ToString());
item.SubItems.Add(reader["numar_pacienti"].ToString());
item.SubItems.Add(reader["departament"].ToString());
Medici medic = new Medici();
medic.Id_medic = Convert.ToInt32(reader["id_medic"].ToString());
medic.Nume = reader["nume"].ToString();
medic.Varsta = Convert.ToInt32(reader["varsta"].ToString());
medic.Ore_lucrate = Convert.ToDouble(reader["ore_lucrate_pe_saptamana"].ToString());
medic.Salariul = Convert.ToDouble(reader["salariul"].ToString());
medic.Numar_pacienti = Convert.ToInt32(reader["numar_pacienti"].ToString());
medic.Departament = reader["departament"].ToString();
nr_pacienti = medic.Numar_pacienti;
string sql2 = "SELECT nume, denumire_boala FROM pacienti WHERE medic = @Med";
OleDbCommand comanda2 = new OleDbCommand(sql2, conexiune);
OleDbParameter param = new OleDbParameter();
param.ParameterName = "@Med";
param.Value = medic.Nume;
comanda2.Parameters.Add(param);
OleDbDataReader reader2 = comanda2.ExecuteReader();
TreeNode node = new TreeNode(medic.Nume);
treeView1.Nodes.Add(node);
while (reader2.Read())
{
node.Nodes.Add(reader2["nume"].ToString() + ", diagnosticat cu " + reader2["denumire_boala"].ToString());
}
item.Tag = medic;
listView1.Items.Add(item);
}
}catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conexiune.Close();
}
}
public Form_Medici(Medici m)
{
med = m;
InitializeComponent();
}
