private void caricaEsami() { Ambulatorio amb = (Ambulatorio)lstAmbul.SelectedItem; ParteCorpo par = (ParteCorpo)lstPartiCorpo.SelectedItem; if (esamiCtrl.LoadEsami(amb.Id, par != null ? par.Id : 0)) { loadEsami(); } }
private void lstPartiCorpo_SelectedIndexChanged(object sender, EventArgs e) { Ambulatorio amb = (Ambulatorio)lstAmbul.SelectedItem; ParteCorpo par = (ParteCorpo)lstPartiCorpo.SelectedItem; if (esamiCtrl.LoadEsami(amb.Id, par.Id)) { loadEsami(); } abilitaDisabilitaSelezioneEsame(); }
public bool LoadPartiCorpo(int idambulatorio) { bool res = true; try { _parcorp.Clear(); myConnection.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = myConnection; //command.CommandText = "SELECT * FROM PartiCorpo"; StringBuilder sql = new StringBuilder("SELECT DISTINCT [PartiCorpo].id, [PartiCorpo].descrizione"); sql.Append(" FROM[Ambulatori]"); sql.Append(" JOIN[AmbulatoriEsami] ON[AmbulatoriEsami].idambulatorio = [Ambulatori].id"); sql.Append(" JOIN[Esami] ON[AmbulatoriEsami].idesame = [Esami].id"); sql.Append(" JOIN[PartiCorpo] ON[PartiCorpo].id =[Esami].idpartecorpo"); sql.Append(" where[Ambulatori].id = "); sql.Append(idambulatorio); command.CommandText = sql.ToString(); //whenever you want to get some data from the database using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { var par = new ParteCorpo() { Id = (int)reader["Id"], Descrizione = reader["Descrizione"].ToString() }; _parcorp.Add(par); } } } res = true; } catch (Exception l) { System.Console.WriteLine("Error:" + l); } finally { myConnection.Close(); } return(res); }