public static ShipScheduleTrip GetEarlierTripFromThisSchedule(string tripID, string freightID) { //Return an earlier trip from the current schedule than the one specified if one exists ShipScheduleTrip earlierTrip = null; try { //Get all earlier trips (open, not cancelled) DataSet ds = App.Mediator.FillDataset(USP_SHIPSCHEDULE_PRIORTRIPS, TBL_SHIPSCHEDULE_PRIORTRIPS, new object[] { tripID, freightID }); if (ds.Tables[TBL_SHIPSCHEDULE_PRIORTRIPS].Rows.Count > 0) { ShipScheduleDS schedule = new ShipScheduleDS(); schedule.Merge(ds); int tag = 0; for (int i = 0; i < schedule.ShipScheduleMasterTable.Rows.Count; i++) { //Select only trips with the same schedule date as this.mScheduleDate ShipScheduleDS.ShipScheduleMasterTableRow trip = (ShipScheduleDS.ShipScheduleMasterTableRow)schedule.ShipScheduleMasterTable.Rows[i]; if (trip.ScheduleDate.CompareTo(_ScheduleDate) == 0) { //Capture the trip with the largest tag # if (int.Parse(trip.Tag.Trim()) > tag) { tag = int.Parse(trip.Tag.Trim()); earlierTrip = new ShipScheduleTrip(trip); } } } } } catch (Exception ex) { throw new ApplicationException("Failed determine if an earlier ship schedule trip exists.", ex); } return(earlierTrip); }
public static ShipScheduleTrip GetTrip(string tripID) { //Return an existing trip from this ship schedule ShipScheduleTrip trip = null; try { //Merge from collection (dataset) ShipScheduleDS.ShipScheduleMasterTableRow _trip = (ShipScheduleDS.ShipScheduleMasterTableRow)_Trips.ShipScheduleMasterTable.Select("TripID='" + tripID + "'")[0]; ShipScheduleDS.ShipScheduleDetailTableRow[] _tls = (ShipScheduleDS.ShipScheduleDetailTableRow[])_Trips.ShipScheduleDetailTable.Select("TripID='" + tripID + "'"); trip = new ShipScheduleTrip(_trip, _tls); } catch (Exception ex) { throw new ApplicationException("Failed to get trip " + tripID + ".", ex); } return(trip); }
private void OnTripSelectionChanged(object sender, Infragistics.Win.UltraWinGrid.AfterSelectChangeEventArgs e) { //Event handler for change in trip selections try { //Clear reference to prior trip object this.mDestinationTrip = null; if (this.grdShipSchedule.Selected.Rows.Count > 0) { //Get a trip object for the selected trip record string id = this.grdShipSchedule.Selected.Rows[0].Cells["TripID"].Value.ToString(); ShipScheduleDS.ShipScheduleMasterTableRow row = (ShipScheduleDS.ShipScheduleMasterTableRow) this.mShipScheduleDS.ShipScheduleMasterTable.Select("TripID='" + id + "'")[0]; this.mDestinationTrip = new ShipScheduleTrip(row); } } catch (Exception ex) { App.ReportError(ex, false, LogLevel.Warning); } finally { OnValidateForm(null, null); } }
public static ShipScheduleTrip GetEarlierTripFromAPriorSchedule(string tripID, string freightID) { //Return an earlier trip from a schedule prior to the one specified ShipScheduleTrip earlierTrip = null; try { //Get all earlier trips (open, not cancelled) DataSet ds = App.Mediator.FillDataset(USP_SHIPSCHEDULE_PRIORTRIPS, TBL_SHIPSCHEDULE_PRIORTRIPS, new object[] { tripID, freightID }); if (ds.Tables[TBL_SHIPSCHEDULE_PRIORTRIPS].Rows.Count > 0) { ShipScheduleDS schedule = new ShipScheduleDS(); schedule.Merge(ds); DateTime date = _ScheduleDate.AddYears(-5); int tag = 0; for (int i = 0; i < schedule.ShipScheduleMasterTable.Rows.Count; i++) { //Select a trip with the most recent schedule date (not including this.mScheduleDate) ShipScheduleDS.ShipScheduleMasterTableRow trip = (ShipScheduleDS.ShipScheduleMasterTableRow)schedule.ShipScheduleMasterTable.Rows[i]; if (trip.ScheduleDate.CompareTo(_ScheduleDate) < 0) { //Capture the most recent trip date if (trip.ScheduleDate.CompareTo(date) > 0) { date = trip.ScheduleDate; tag = 0; } if (trip.ScheduleDate.CompareTo(date) == 0) { //Capture the trip taht is most recent and with the largest tag # if (int.Parse(trip.Tag.Trim()) > tag) { tag = int.Parse(trip.Tag.Trim()); earlierTrip = new ShipScheduleTrip(trip); } } } } } } catch (Exception ex) { throw new ApplicationException("Failed determine if an earlier ship schedule trip exists.", ex); } return(earlierTrip); }
public ShipScheduleTrip(ShipScheduleDS.ShipScheduleMasterTableRow trip, ShipScheduleDS.ShipScheduleDetailTableRow[] tls) { //Constructor try { this.mAssignedTLs = new ShipScheduleDS(); if (trip != null) { this._scheduleid = trip.ScheduleID; this._sortcenterid = trip.SortCenterID; if (!trip.IsSortCenterNull()) { this._sortcenter = trip.SortCenter; } this._scheduledate = trip.ScheduleDate; this._tripid = trip.TripID; if (!trip.IsTemplateIDNull()) { this._templateid = trip.TemplateID; } if (!trip.IsBolNumberNull()) { this._bolnumber = trip.BolNumber; } if (!trip.IsCarrierServiceIDNull()) { this._carrierserviceid = trip.CarrierServiceID; } if (!trip.IsCarrierNull()) { this._carrier = trip.Carrier; } if (!trip.IsLoadNumberNull()) { this._loadnumber = trip.LoadNumber; } if (!trip.IsTrailerIDNull()) { this._trailerid = trip.TrailerID; } if (!trip.IsTrailerNumberNull()) { this._trailernumber = trip.TrailerNumber; } if (!trip.IsTractorNumberNull()) { this._tractornumber = trip.TractorNumber; } if (!trip.IsScheduledCloseNull()) { this._scheduledclose = trip.ScheduledClose; } if (!trip.IsScheduledDepartureNull()) { this._scheduleddeparture = trip.ScheduledDeparture; } if (!trip.IsIsMandatoryNull()) { this._ismandatory = trip.IsMandatory; } if (!trip.IsFreightAssignedNull()) { this._freightassigned = trip.FreightAssigned; } if (!trip.IsTrailerCompleteNull()) { this._trailercomplete = trip.TrailerComplete; } if (!trip.IsPaperworkCompleteNull()) { this._paperworkcomplete = trip.PaperworkComplete; } if (!trip.IsTrailerDispatchedNull()) { this._trailerdispatched = trip.TrailerDispatched; } if (!trip.IsCanceledNull()) { this._canceled = trip.Canceled; } if (!trip.IsSCDEUserIDNull()) { this._scdeuserid = trip.SCDEUserID; } if (!trip.IsSCDELastUpdatedNull()) { this._scdelastupdated = trip.SCDELastUpdated; } if (!trip.IsSCDERowVersionNull()) { this._scderowversion = trip.SCDERowVersion; } if (!trip.IsStopIDNull()) { this._stopid = trip.StopID; } if (!trip.IsStopNumberNull()) { this._stopnumber = trip.StopNumber; } if (!trip.IsAgentTerminalIDNull()) { this._agentterminalid = trip.AgentTerminalID; } if (!trip.IsAgentNumberNull()) { this._agentnumber = trip.AgentNumber; } if (!trip.IsMainZoneNull()) { this._mainzone = trip.MainZone; } if (!trip.IsTagNull()) { this._tag = trip.Tag; } if (!trip.IsNotesNull()) { this._notes = trip.Notes; } if (!trip.IsScheduledArrivalNull()) { this._scheduledarrival = trip.ScheduledArrival; } if (!trip.IsScheduledOFD1Null()) { this._scheduledofd1 = trip.ScheduledOFD1; } if (!trip.IsS1UserIDNull()) { this._s1userid = trip.S1UserID; } if (!trip.IsS1LastUpdatedNull()) { this._s1lastupdated = trip.S1LastUpdated; } if (!trip.IsS1RowVersionNull()) { this._s1rowversion = trip.S1RowVersion; } if (!trip.IsS2StopIDNull()) { this._s2stopid = trip.S2StopID; } if (!trip.IsS2StopNumberNull()) { this._s2stopnumber = trip.S2StopNumber; } if (!trip.IsS2AgentTerminalIDNull()) { this._s2agentterminalid = trip.S2AgentTerminalID; } if (!trip.IsS2AgentNumberNull()) { this._s2agentnumber = trip.S2AgentNumber; } if (!trip.IsS2MainZoneNull()) { this._s2mainzone = trip.S2MainZone; } if (!trip.IsS2TagNull()) { this._s2tag = trip.S2Tag; } if (!trip.IsS2NotesNull()) { this._s2notes = trip.S2Notes; } if (!trip.IsS2ScheduledArrivalNull()) { this._s2scheduledarrival = trip.S2ScheduledArrival; } if (!trip.IsS2ScheduledOFD1Null()) { this._s2scheduledofd1 = trip.S2ScheduledOFD1; } if (!trip.IsS2UserIDNull()) { this._s2userid = trip.S2UserID; } if (!trip.IsS2LastUpdatedNull()) { this._s2lastupdated = trip.S2LastUpdated; } if (!trip.IsS2RowVersionNull()) { this._s2rowversion = trip.S2RowVersion; } if (!trip.IsNextCarrierNull()) { this._nextcarrier = trip.NextCarrier; } if (!trip.IsCarrierIDNull()) { this._carrierid = trip.CarrierID; } if (tls != null) { ShipScheduleDS.ShipScheduleMasterTableRow _trip = this.mAssignedTLs.ShipScheduleMasterTable.NewShipScheduleMasterTableRow(); _trip.ScheduleID = this.ScheduleID; _trip.SortCenterID = this.SortCenterID; _trip.TripID = this.TripID; this.mAssignedTLs.ShipScheduleMasterTable.AddShipScheduleMasterTableRow(_trip); this.mAssignedTLs.Merge(tls); } } } catch (Exception ex) { throw new ApplicationException("Could not create a new ship schedule trip.", ex); } }
public ShipScheduleTrip(ShipScheduleDS.ShipScheduleMasterTableRow trip) : this(trip, null) { }