public DataSet GetSortCenters(int terminalID)
{
DataSet sortCenters = new DataSet();
DataSet ds = null;
try {
if (terminalID == 0)
{
ds = new TsortGateway(terminalID).GetTerminals();
if (ds != null && ds.Tables["TerminalTable"] != null && ds.Tables["TerminalTable"].Rows.Count > 0)
{
sortCenters.Merge(ds.Tables["TerminalTable"].Select("", "Description ASC"));
}
}
else if (terminalID == 1)
{
ds = new TsortGateway(terminalID).GetShippers();
if (ds != null && ds.Tables["TerminalTable"] != null && ds.Tables["TerminalTable"].Rows.Count > 0)
{
sortCenters.Merge(ds.Tables["TerminalTable"].Select("", "Description ASC"));
}
}
else if (terminalID > 1)
{
ds = new TsortGateway(terminalID).GetTerminals();
if (ds != null && ds.Tables["TerminalTable"] != null && ds.Tables["TerminalTable"].Rows.Count > 0)
{
sortCenters.Merge(ds.Tables["TerminalTable"].Select("", "Description ASC"));
}
}
}
catch (Exception ex) { throw new FaultException <ShipScheduleFault>(new ShipScheduleFault(ex.Message), "Service Error"); }
return(sortCenters);
}
public DateTime FindEarlierTripOnCurrentSchedule(int terminalID, DateTime scheduleDate, string tripID, string freightID)
{
//Return an earlier trip from the current schedule than the one specified if one exists
DateTime tripDate = DateTime.MinValue;
try {
//Get all earlier trips (open, not cancelled)
DataSet schedule = new DataSet();
DataSet ds = new TsortGateway(terminalID).GetPriorTrips(tripID, freightID);
if (ds != null && ds.Tables["ShipScheduleViewTable"] != null && ds.Tables["ShipScheduleViewTable"].Rows.Count > 0)
{
schedule.Merge(ds);
int tag = 0;
for (int i = 0; i < schedule.Tables["ShipScheduleViewTable"].Rows.Count; i++)
{
//Select only trips with the same schedule date as this.mScheduleDate
DataRow _trip = schedule.Tables["ShipScheduleViewTable"].Rows[i];
DateTime _scheduleDate = DateTime.Parse(_trip["ScheduleDate"].ToString());
if (_scheduleDate.CompareTo(scheduleDate) == 0)
{
//Capture the trip with the largest tag #
int _tag = int.Parse(_trip["Tag"].ToString().Trim());
if (_tag > tag)
{
tag = _tag;
tripDate = _scheduleDate;
}
}
}
}
}
catch (Exception ex) { throw new FaultException <ShipScheduleFault>(new ShipScheduleFault(ex.Message), "Service Error"); }
return(tripDate);
}
public string GetExportFilename(int terminalID, string counterKey)
{
string filename = "";
try {
filename = new TsortGateway(terminalID).GetExportFilename(counterKey);
}
catch (Exception ex) { throw new FaultException <ISDExportFault>(new ISDExportFault(ex.Message), "Service Error"); }
return(filename);
}
public DateTime FindShipSchedule(int terminalID, string tlNumber)
{
//Find a TL on an existing ship schedule
DateTime schedulDate = DateTime.MinValue;
try {
schedulDate = new TsortGateway(terminalID).FindShipSchedule(tlNumber);
}
catch (Exception ex) { throw new FaultException <ShipScheduleFault>(new ShipScheduleFault(ex.Message), "Service Error"); }
return(schedulDate);
}
public bool UpdateShipScheduleTripStop(int terminalID, ShipScheduleStop stop)
{
//Update the specified ship schedule stop
bool updated = false;
try {
updated = new TsortGateway(terminalID).UpdateShipScheduleTripStop(stop);
}
catch (Exception ex) { throw new FaultException <ShipScheduleFault>(new ShipScheduleFault(ex.Message), "Service Error"); }
return(updated);
}
public string FindShipScheduleTrip(int terminalID, DateTime scheduleDate, long carrierServiceID, string loadNumber)
{
//Find a ship schedue trip for the specified scheduleDate, carrierServiceID, and loadNumber
string tripID = "";
try {
tripID = new TsortGateway(terminalID).FindShipScheduleTrip(scheduleDate, carrierServiceID, loadNumber);
}
catch (Exception ex) { throw new FaultException <ShipScheduleFault>(new ShipScheduleFault(ex.Message), "Service Error"); }
return(tripID);
}
public string CreateShipScheduleTrip(int terminalID, string scheduleID, string templateID, DateTime lastUpdated, string userID)
{
//Create a new ship schedule trip from a template specified by templateID on the ship schedule specified by scheduleID
string tripID = "";
try {
tripID = new TsortGateway(terminalID).CreateShipScheduleTrip(scheduleID.Trim(), templateID.Trim(), lastUpdated, userID);
}
catch (Exception ex) { throw new FaultException <ShipScheduleFault>(new ShipScheduleFault(ex.Message), "Service Error"); }
return(tripID);
}
public bool DeleteISDClient(int terminalID, ISDClient client)
{
//
bool deleted = false;
try {
deleted = new TsortGateway(terminalID).DeleteISDClient(client);
}
catch (Exception ex) { throw new FaultException <ISDExportFault>(new ISDExportFault(ex.Message), "Service Error"); }
return(deleted);
}
public bool OpenTrip(int terminalID, string tripID)
{
//Open a trip to further TL assignments
bool ret = false;
try {
//Validate, then open
ret = new TsortGateway(terminalID).UpdateTripStatus(tripID, 0);
}
catch (Exception ex) { throw new FaultException <ShipScheduleFault>(new ShipScheduleFault(ex.Message), "Service Error"); }
return(ret);
}
public DataSet GetISDClients(int terminalID, string clientNumber)
{
DataSet clients = new DataSet();
try {
DataSet ds = new TsortGateway(terminalID).ReadISDClients(clientNumber);
if (ds != null && ds.Tables["ClientTable"] != null && ds.Tables["ClientTable"].Rows.Count > 0)
{
clients.Merge(ds);
}
}
catch (Exception ex) { throw new FaultException <ISDExportFault>(new ISDExportFault(ex.Message), "Service Error"); }
return(clients);
}
public DataSet GetSortedItems(int terminalID, string pickupID)
{
//Get sorted items for a pickup
DataSet items = new DataSet();
try {
DataSet ds = new TsortGateway(terminalID).GetSortedItems(pickupID);
if (ds != null && ds.Tables["SortedItemTable"] != null && ds.Tables["SortedItemTable"].Rows.Count > 0)
{
items.Merge(ds);
}
}
catch (Exception ex) { throw new FaultException <ISDExportFault>(new ISDExportFault(ex.Message), "Service Error"); }
return(items);
}
public DataSet GetPickups(int terminalID, DateTime pickupDate)
{
//Get a collection of all pickups for the terminal on the local LAN database
DataSet pickups = new DataSet();
try {
DataSet ds = new TsortGateway(terminalID).GetPickups(pickupDate);
if (ds != null && ds.Tables["PickupTable"] != null && ds.Tables["PickupTable"].Rows.Count > 0)
{
pickups.Merge(ds);
}
}
catch (Exception ex) { throw new FaultException <ISDExportFault>(new ISDExportFault(ex.Message), "Service Error"); }
return(pickups);
}
public DataSet GetCarriers(int terminalID)
{
DataSet carriers = new DataSet();
try {
if (terminalID >= 0)
{
DataSet ds = new TsortGateway(terminalID).GetCarriers();
if (ds != null && ds.Tables["CarrierTable"] != null && ds.Tables["CarrierTable"].Rows.Count > 0)
{
carriers.Merge(ds.Tables["CarrierTable"].Select("", "Description ASC"));
}
}
}
catch (Exception ex) { throw new FaultException <ShipScheduleFault>(new ShipScheduleFault(ex.Message), "Service Error"); }
return(carriers);
}
public DateTime FindEarlierTripOnPriorSchedule(int terminalID, DateTime scheduleDate, string tripID, string freightID)
{
//Return an earlier trip from a schedule prior to the one specified
DateTime tripDate = DateTime.MinValue;
try {
//Get all earlier trips (open, not cancelled)
DataSet schedule = new DataSet();
DataSet ds = new TsortGateway(terminalID).GetPriorTrips(tripID, freightID);
if (ds != null && ds.Tables["ShipScheduleViewTable"] != null && ds.Tables["ShipScheduleViewTable"].Rows.Count > 0)
{
schedule.Merge(ds);
DateTime date = scheduleDate.AddYears(-5);
int tag = 0;
for (int i = 0; i < schedule.Tables["ShipScheduleViewTable"].Rows.Count; i++)
{
//Select a trip with the most recent schedule date (not including trip.ScheduleDate)
DataRow _trip = schedule.Tables["ShipScheduleViewTable"].Rows[i];
DateTime _scheduleDate = DateTime.Parse(_trip["ScheduleDate"].ToString());
if (_scheduleDate.CompareTo(scheduleDate) < 0)
{
//Capture the most recent trip date
if (_scheduleDate.CompareTo(date) > 0)
{
date = _scheduleDate; tag = 0;
}
if (_scheduleDate.CompareTo(date) == 0)
{
//Capture the trip that is most recent and with the largest tag #
int _tag = int.Parse(_trip["Tag"].ToString().Trim());
if (_tag > tag)
{
tag = _tag;
tripDate = _scheduleDate;
}
}
}
}
}
}
catch (Exception ex) { throw new FaultException <ShipScheduleFault>(new ShipScheduleFault(ex.Message), "Service Error"); }
return(tripDate);
}
public DataSet GetShipScheduleView(int terminalID, DateTime scheduleDate)
{
//Return a ship schedule for the specified terminal
DataSet schedule = new DataSet();
try {
//AgentLineHaulDataset trips = new AgentLineHaulDataset();
DataSet trips = new TsortGateway(terminalID).GetTrips(scheduleDate);
if (trips != null && trips.Tables["ShipScheduleViewTable"] != null && trips.Tables["ShipScheduleViewTable"].Rows.Count > 0)
{
schedule.Merge(trips);
string scheduleID = trips.Tables["ShipScheduleViewTable"].Rows[0]["ScheduleID"].ToString();
//AgentLineHaulDataset tls = new AgentLineHaulDataset();
DataSet tls = new TsortGateway(terminalID).GetTLs(scheduleID);
if (tls != null && tls.Tables["ShipScheduleTLTable"] != null && tls.Tables["ShipScheduleTLTable"].Rows.Count > 0)
{
schedule.Merge(tls);
}
}
}
catch (Exception ex) { throw new FaultException <ShipScheduleFault>(new ShipScheduleFault(ex.Message), "Service Error"); }
return(schedule);
}