public List <Ramales> ListRamales() { List <Ramales> lista = new List <Ramales>(); SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["CONNECTIONIntranet"].ToString()); SqlCommand cmd = new SqlCommand("Select * from [dbo].[View_CotizadorTransporte_Ramal]", conn); try { conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Ramales r = new Ramales(); r.IdRamal = reader["id_ramal"].ToString(); r.Ramal = reader["Ramal"].ToString(); r.Ciudad = reader["Ciudad"].ToString(); r.Valor = Convert.ToInt32(reader["Valor"].ToString()); r.Opciones = "<a style = 'Color:Blue;text-decoration:none;cursor:pointer;' href = 'javascript:ModificaRamal(\"" + r.IdRamal + "\",\"" + r.Ramal + "\",\"" + r.Ciudad + "\",\"" + r.Valor + "\");' > Modificar </a> |" + "<a style = 'Color:Blue;text-decoration:none;cursor:pointer;' href = 'javascript:EliminaRamal(\"" + r.IdRamal + "\",\"" + r.Ramal + "\",\"" + r.Ciudad + "\",\"" + r.Valor + "\");' > Eliminar </a>"; //"<a style = 'Color:Blue;text-decoration:none;cursor:pointer;' href = 'javascript:alerta(\"" + 3 + "\");' > Modificar </a>" lista.Add(r); } }catch (Exception ex) { } cmd.Dispose(); conn.Close(); return(lista); }
public void AddRamal(TrenRamalItemViewModel linea) { Ramales.Add(linea); }