public void UpdateList()
{
listView1.Items.Clear();
OleDbConnection conexiune = new OleDbConnection(Provider);
string sql = "SELECT * FROM retete;";
OleDbCommand comanda = new OleDbCommand(sql, conexiune);
try
{
conexiune.Open();
OleDbDataReader reader = comanda.ExecuteReader();
while (reader.Read())
{
ListViewItem item = new ListViewItem(reader["nr_crt"].ToString());
item.SubItems.Add(reader["pacient"].ToString());
item.SubItems.Add(reader["medic"].ToString());
item.SubItems.Add(reader["cantitate_medicamente"].ToString());
item.SubItems.Add(reader["pret"].ToString());
item.SubItems.Add(reader["data"].ToString());
Retete reteta = new Retete();
reteta.Nr_crt = Convert.ToInt32(reader["nr_crt"].ToString());
reteta.Pacient = reader["pacient"].ToString();
reteta.Medic = reader["medic"].ToString();
reteta.Cantitate = Convert.ToInt32(reader["cantitate_medicamente"].ToString());
reteta.Pret = Convert.ToDouble(reader["pret"].ToString());
reteta.Data = Convert.ToDateTime(reader["data"].ToString());
string sql2 = "SELECT denumire FROM medicamente WHERE nr_crt_reteta = @nrCRT";
OleDbCommand comanda2 = new OleDbCommand(sql2, conexiune);
OleDbParameter parameter = new OleDbParameter();
parameter.ParameterName = "@nrCRT";
parameter.Value = reteta.Nr_crt;
comanda2.Parameters.Add(parameter);
OleDbDataReader reader2 = comanda2.ExecuteReader();
TreeNode nod = new TreeNode(reteta.Pacient);
treeView1.Nodes.Add(nod);
while (reader2.Read())
{
nod.Nodes.Add(reader2["denumire"].ToString());
}
item.Tag = reteta;
listView1.Items.Add(item);
}
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conexiune.Close();
}
}
public int CompareTo(object obj)
{
Retete reteta = (Retete)obj;
if (this.cantitate_med > reteta.cantitate_med)
{
return(1);
}
else if (this.cantitate_med < reteta.cantitate_med)
{
return(-1);
}
else
{
return(this.cantitate_med.CompareTo(reteta.cantitate_med));
}
}
public Form_Retete(Retete r)
{
reteta = r;
InitializeComponent();
}
