public List <GetJourneysDTO> GetJourneys() { List <GetJourneysDTO> res = new List <GetJourneysDTO>(); SqlConnection cnx = new SqlConnection(cnx_str); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnx; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[read].GetJourneys"; cnx.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { GetJourneysDTO _item = new GetJourneysDTO() { idJourney = Int64.Parse(reader["idJourney"].ToString()), dtInicio = DateTime.Parse(reader["dtInicio"].ToString()), numObjetos = int.Parse(reader["numObjetos"].ToString()), numCoordenadasTotal = Int64.Parse(reader["numCoordenadasTotal"].ToString()) }; res.Add(_item); } reader.Close(); cnx.Close(); return(res); }
private void lstTrayectos_SelectedIndexChanged(object sender, EventArgs e) { if (lstTrayectos.SelectedItems.Count == 1) { foreach (ListViewItem lstIt in lstTrayectos.Items) { lstIt.ForeColor = Color.Black; } SelectedJourney = (GetJourneysDTO)lstTrayectos.SelectedItems[0].Tag; lstTrayectos.SelectedItems[0].ForeColor = Color.Red; GetObjetos(SelectedJourney.idJourney); lstTrayectos.SelectedIndices.Clear(); } }