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);
}