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