private void lstObjetos_SelectedIndexChanged(object sender, EventArgs e) { if (lstObjetos.SelectedItems.Count == 1) { foreach (ListViewItem lstIt in lstObjetos.Items) { lstIt.ForeColor = Color.Black; } SelectedObject = (GetJourneyObjectsDTO)lstObjetos.SelectedItems[0].Tag; lstObjetos.SelectedItems[0].ForeColor = Color.Red; GetCoordenadas(SelectedObject.idOBJ); lstObjetos.SelectedIndices.Clear(); } }
public List <GetJourneyObjectsDTO> GetJourneyObjects(Int64 idJourney) { List <GetJourneyObjectsDTO> res = new List <GetJourneyObjectsDTO>(); SqlConnection cnx = new SqlConnection(cnx_str); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnx; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[read].GetJourneyObjects"; cmd.Parameters.AddWithValue("@idJourney", idJourney); cnx.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { GetJourneyObjectsDTO _item = new GetJourneyObjectsDTO() { idOBJ = Int64.Parse(reader["idPoint"].ToString()), OBJDesc = reader["PointDesc"].ToString(), Color = reader["Color"].ToString(), Alto = int.Parse(reader["Height"].ToString()), Ancho = int.Parse(reader["Width"].ToString()) }; res.Add(_item); } reader.Close(); cnx.Close(); return(res); }