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