public static BearwareTrip GetTripAssignment(string stationNumber)
{
//Get the trip assigned to the specified station
BearwareTrip trip = null;
try {
DataSet ds = App.Mediator.FillDataset(USP_TRIP_ASSIGNMENT, TBL_TRIP_ASSIGNMENT, new object[] { stationNumber });
if (ds.Tables[TBL_TRIP_ASSIGNMENT].Rows.Count == 0)
{
throw new ApplicationException("There are no trips assigned to station " + stationNumber + ".");
}
else if (ds.Tables[TBL_TRIP_ASSIGNMENT].Rows.Count > 0)
{
BearwareDS dsAssignment = new BearwareDS();
dsAssignment.Merge(ds);
BearwareDS.BwareTripTableRow row = (BearwareDS.BwareTripTableRow)dsAssignment.BwareTripTable.Rows[0];
trip = new BearwareTrip();
trip.Number = row.Number.TrimEnd();
trip.CartonCount = row.IsCartonCountNull() ? 0 : row.CartonCount;
trip.Carrier = row.IsCarrierNull() ? "" : row.Carrier.TrimEnd();
trip.TrailerNumber = row.IsTrailerNumberNull() ? "" : row.TrailerNumber.TrimEnd();
}
}
catch (Exception ex) { throw new ApplicationException("Unexpected error reading trip assignments for station " + stationNumber + ".", ex); }
return(trip);
}
public BearwareTrip(BearwareDS.BwareTripTableRow trip)
{
//Constructor
try {
if (trip != null)
{
this.mNumber = trip.Number.Trim();
if (!trip.IsCartonCountNull())
{
this.mCartonCount = trip.CartonCount;
}
if (!trip.IsCarrierNull())
{
this.mCarrier = trip.Carrier;
}
if (!trip.IsTrailerNumberNull())
{
this.mTrailerNumber = trip.TrailerNumber;
}
if (!trip.IsStartedNull())
{
this.mStarted = trip.Started;
}
if (!trip.IsExportedNull())
{
this.mExported = trip.Exported;
}
if (!trip.IsStoppedNull())
{
this.mStopped = trip.Stopped;
}
if (!trip.IsImportedNull())
{
this.mImported = trip.Imported;
}
if (!trip.IsScannedNull())
{
this.mScanned = trip.Scanned;
}
if (!trip.IsOSDSendNull())
{
this.mOSDSend = trip.OSDSend;
}
if (!trip.IsReceivedNull())
{
this.mReceived = trip.Received;
}
if (!trip.IsCartonsExportedNull())
{
this.mCartonsExported = trip.CartonsExported;
}
}
}
catch (Exception ex) { throw new ApplicationException("Unexpected error while creating new BearwareTrip instance.", ex); }
}
public BearwareTrip(BearwareDS.BwareTripTableRow trip)
{
//Constructor
if (trip != null)
{
this.mNumber = trip.Number.Trim();
if (!trip.IsCartonCountNull())
{
this.mCartonCount = trip.CartonCount;
}
if (!trip.IsCarrierNull())
{
this.mCarrier = trip.Carrier;
}
if (!trip.IsTrailerNumberNull())
{
this.mTrailerNumber = trip.TrailerNumber;
}
if (!trip.IsStartedNull())
{
this.mStarted = trip.Started;
}
if (!trip.IsExportedNull())
{
this.mExported = trip.Exported;
}
if (!trip.IsStoppedNull())
{
this.mStopped = trip.Stopped;
}
if (!trip.IsImportedNull())
{
this.mImported = trip.Imported;
}
if (!trip.IsScannedNull())
{
this.mScanned = trip.Scanned;
}
if (!trip.IsOSDSendNull())
{
this.mOSDSend = trip.OSDSend;
}
if (!trip.IsReceivedNull())
{
this.mReceived = trip.Received;
}
if (!trip.IsCartonsExportedNull())
{
this.mCartonsExported = trip.CartonsExported;
}
}
}
public DataSet ToDataSet()
{
//Return a dataset containing values for this terminal
BearwareDS ds = null;
try {
ds = new BearwareDS();
BearwareDS.BwareTripTableRow trip = ds.BwareTripTable.NewBwareTripTableRow();
trip.Number = this.mNumber;
trip.CartonCount = this.mCartonCount;
trip.Carrier = this.mCarrier;
trip.TrailerNumber = this.mTrailerNumber;
if (this.mStarted != Convert.ToDateTime(null))
{
trip.Started = this.mStarted;
}
if (this.mExported != Convert.ToDateTime(null))
{
trip.Exported = this.mExported;
}
if (this.mStopped != Convert.ToDateTime(null))
{
trip.Stopped = this.mStopped;
}
if (this.mImported != Convert.ToDateTime(null))
{
trip.Imported = this.mImported;
}
if (this.mScanned != Convert.ToDateTime(null))
{
trip.Scanned = this.mScanned;
}
if (this.mOSDSend != Convert.ToDateTime(null))
{
trip.OSDSend = this.mOSDSend;
}
if (this.mReceived != Convert.ToDateTime(null))
{
trip.Received = this.mReceived;
}
if (this.mCartonsExported != -1)
{
trip.CartonsExported = this.mCartonsExported;
}
ds.BwareTripTable.AddBwareTripTableRow(trip);
}
catch (Exception) { }
return(ds);
}
public static BearwareTrip GetFreight(string tripNumber)
{
//Get a Bearware trip
BearwareTrip trip = null;
try {
if (tripNumber.Length > 0)
{
//Merge from collection (dataset)
BearwareDS.BwareTripTableRow row = (BearwareDS.BwareTripTableRow)_InboundFreight.BwareTripTable.Select("Number='" + tripNumber + "'")[0];
trip = new BearwareTrip(row);
}
else
{
trip = new BearwareTrip();
}
trip.Changed += new EventHandler(OnTripChanged);
}
catch (Exception ex) { throw ex; }
return(trip);
}