//--------BUSCAR PARA VIAJE--------------------------------------------------------------
public Terminal BuscarParaViaje(string cod)
{
SqlConnection cnn = new SqlConnection(Conexion.CONEXION);
SqlCommand cmd = new SqlCommand("BuscarTerminalParaViaje", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@codigo", cod);
Terminal terminal = null;
try
{
cnn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
string codigo = (string)dr[0];
string ciudad = (string)dr[1];
string pais = (string)dr[2];
List <string> facilidades = PersistenciaFacilidadTerminal.CargarFacilidades(codigo);
terminal = new Terminal(codigo, ciudad, pais, facilidades);
}
dr.Close();
}
catch (Exception ex) { throw ex; }
finally { cnn.Close(); }
return(terminal);
}
//------listar----------------------------------
public List <Terminal> Listar()
{
List <Terminal> resp = null;
SqlConnection cnn = new SqlConnection(Conexion.CONEXION);
SqlCommand cmd = new SqlCommand("ListarTerminales", cnn);
cmd.CommandType = CommandType.StoredProcedure;
try
{
cnn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
resp = new List <Terminal>();
Terminal ter = null;
while (dr.Read())
{
string codigo = (string)dr[0];
string ciudad = (string)dr[1];
string pais = (string)dr[2];
List <string> facilidades = PersistenciaFacilidadTerminal.CargarFacilidades((string)dr[0]);
ter = new Terminal(codigo, ciudad, pais, facilidades);
resp.Add(ter);
}
}
dr.Close();
}
catch (Exception ex) { throw ex; }
finally { cnn.Close(); }
return(resp);
}