public List <TramaViaje> ListarViajes()
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["cnxTramarsa"].ConnectionString);
SqlCommand cmd = new SqlCommand("USP_GET_VIAJES_PENDIENTES_TDEPOT", cn);
cmd.CommandType = CommandType.StoredProcedure;
List <TramaViaje> listaviaje = new List <TramaViaje>();
try
{
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
TramaViaje t = new TramaViaje();
t.VesselIMO = dr.IsDBNull(dr.GetOrdinal("VesselIMO")) ? "" : dr.GetString(dr.GetOrdinal("VesselIMO"));
t.VoyageNumber = dr.IsDBNull(dr.GetOrdinal("VoyageNumber")) ? "" : dr.GetString(dr.GetOrdinal("VoyageNumber"));
t.RowStatus = dr.IsDBNull(dr.GetOrdinal("RowStatus")) ? true : dr.GetBoolean(dr.GetOrdinal("RowStatus"));
VoyageStopsC v = new VoyageStopsC();
v.CodNav = dr.IsDBNull(dr.GetOrdinal("CodNav")) ? "" : dr.GetString(dr.GetOrdinal("CodNav"));
v.CodSuc = dr.IsDBNull(dr.GetOrdinal("CodSuc")) ? "" : dr.GetString(dr.GetOrdinal("CodSuc"));
v.NumVia = dr.IsDBNull(dr.GetOrdinal("NumVia")) ? "" : dr.GetString(dr.GetOrdinal("NumVia"));
v.VoyageStopExternalCode = dr.IsDBNull(dr.GetOrdinal("VoyageStopExternalCode")) ? "" : dr.GetString(dr.GetOrdinal("VoyageStopExternalCode"));
v.Port = dr.IsDBNull(dr.GetOrdinal("Port")) ? "" : dr.GetString(dr.GetOrdinal("Port"));
v.ManifestNumber = dr.IsDBNull(dr.GetOrdinal("ManifestNumber")) ? "" : dr.GetString(dr.GetOrdinal("ManifestNumber"));
v.ManifestYear = dr.IsDBNull(dr.GetOrdinal("ManifestYear")) ? "" : dr.GetString(dr.GetOrdinal("ManifestYear"));
v.Direction = dr.IsDBNull(dr.GetOrdinal("Direction")) ? null : dr.GetString(dr.GetOrdinal("Direction"));
v.EstimatedArrivalDate = dr.IsDBNull(dr.GetOrdinal("EstimatedArrivalDate")) ? default(DateTime) : dr.GetDateTime(dr.GetOrdinal("EstimatedArrivalDate"));
v.EstimatedDepartureDate = dr.IsDBNull(dr.GetOrdinal("EstimatedDepartureDate")) ? default(DateTime) : dr.GetDateTime(dr.GetOrdinal("EstimatedDepartureDate"));
v.ActualArrivalDate = dr.IsDBNull(dr.GetOrdinal("ActualArrivalDate")) ? default(DateTime) : dr.GetDateTime(dr.GetOrdinal("ActualArrivalDate"));
v.ActualDepartureDate = dr.IsDBNull(dr.GetOrdinal("ActualDepartureDate")) ? default(DateTime) : dr.GetDateTime(dr.GetOrdinal("ActualDepartureDate"));
v.CutoffDate = dr.IsDBNull(dr.GetOrdinal("CutoffDate")) ? default(DateTime) : dr.GetDateTime(dr.GetOrdinal("CutoffDate"));
v.CutoffDateReefer = dr.IsDBNull(dr.GetOrdinal("CutoffDateReefer")) ? default(DateTime) : dr.GetDateTime(dr.GetOrdinal("CutoffDateReefer"));
v.VoyageNumberLine = dr.IsDBNull(dr.GetOrdinal("VoyageNumberLine")) ? "" : dr.GetString(dr.GetOrdinal("VoyageNumberLine"));
t.VoyageStops.Add(v);
listaviaje.Add(t);
}
}
catch (Exception ex)
{
InsertLog.Instanse.Insert(string.Format(@"Error en el metodo: {0}{1}Mensaje Error:{2}{3}Detalle Error:{4}", MethodBase.GetCurrentMethod().Name, Environment.NewLine, ex.Message, Environment.NewLine, ex.StackTrace));
return(null);
}
finally
{
cn.Close();
}
return(listaviaje);
}
public RequestRegistroViaje()
{
Trama = new TramaViaje();
}
