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 bool UpdateShipScheduleTripStop(ShipScheduleStop stop)
{
//
bool updated = false;
try {
updated = new DataService().ExecuteNonQuery(SQL_CONNID, USP_SS_STOP_UPDATE,
new object[] { stop.StopID, stop.Notes,
(stop.ScheduledArrival != DateTime.MinValue ? stop.ScheduledArrival : null as object),
(stop.ScheduledOFD1 != DateTime.MinValue ? stop.ScheduledOFD1 : null as object),
stop.LastUpdated, stop.UserID, stop.RowVersion });
}
catch (Exception ex) { throw new ApplicationException(ex.Message, ex); }
return(updated);
}
public bool UpdateShipSchedule(int terminalID, ShipScheduleTrip trip, ShipScheduleStop stop1, ShipScheduleStop stop2)
{
//Update the specified ship schedule including the trip and 2 stops
bool updated = false;
try {
//Create the TransactionScope to execute the commands, guaranteeing that both commands can commit or roll back as a single unit of work
using (TransactionScope scope = new TransactionScope()) {
//UPdate trip and stop1; update stop2 if not null
new TsortGateway(terminalID).UpdateShipScheduleTrip(trip);
new TsortGateway(terminalID).UpdateShipScheduleTripStop(stop1);
if (stop2 != null)
{
new TsortGateway(terminalID).UpdateShipScheduleTripStop(stop2);
}
updated = true;
//Commits the transaction; if an exception is thrown, Complete is not called and the transaction is rolled back
scope.Complete();
}
}
catch (Exception ex) { throw new FaultException <ShipScheduleFault>(new ShipScheduleFault(ex.Message), "Service Error"); }
return(updated);
}
public static bool UpdateShipScheduleTripStop(ShipScheduleDataset.ShipScheduleStopTableRow stop)
{
//
bool updated = false;
ShipScheduleServiceClient client = new ShipScheduleServiceClient();
try {
//Map datarow to data transfer object
ShipScheduleStop ssstop = new ShipScheduleStop();
ssstop.StopID = stop.StopID;
ssstop.TripID = stop.TripID;
ssstop.StopNumber = !stop.IsStopNumberNull() ? stop.StopNumber : "";
ssstop.AgentTerminalID = !stop.IsAgentTerminalIDNull() ? stop.AgentTerminalID : 0;
ssstop.Tag = !stop.IsTagNull() ? stop.Tag : "";
ssstop.Notes = !stop.IsNotesNull() ? stop.Notes : "";
if (!stop.IsScheduledArrivalNull())
{
ssstop.ScheduledArrival = stop.ScheduledArrival;
}
if (!stop.IsScheduledOFD1Null())
{
ssstop.ScheduledOFD1 = stop.ScheduledOFD1;
}
ssstop.LastUpdated = DateTime.Now;
ssstop.UserID = Environment.UserName;
ssstop.RowVersion = stop.RowVersion;
updated = client.UpdateShipScheduleTripStop(int.Parse(Program.TerminalCode), ssstop);
client.Close();
}
catch (TimeoutException te) { client.Abort(); throw new ApplicationException(te.Message); }
catch (FaultException <ShipScheduleFault> ssf) { client.Abort(); throw new ApplicationException(ssf.Detail.Message); }
catch (FaultException fe) { client.Abort(); throw new ApplicationException(fe.Message); }
catch (CommunicationException ce) { client.Abort(); throw new ApplicationException(ce.Message); }
return(updated);
}
public static bool UpdateShipSchedule(ShipScheduleDataset.ShipScheduleViewTableRow viewItem)
{
//
bool updated = false;
ShipScheduleServiceClient client = new ShipScheduleServiceClient();
try {
//Map datarows to data transfer objects
ShipScheduleTrip sstrip = new ShipScheduleTrip();
sstrip.TripID = viewItem.TripID;
sstrip.ScheduleID = viewItem.ScheduleID;
sstrip.TemplateID = viewItem.TemplateID;
sstrip.BolNumber = !viewItem.IsBolNumberNull() ? viewItem.BolNumber : 0;
sstrip.CarrierServiceID = !viewItem.IsCarrierServiceIDNull() ? viewItem.CarrierServiceID : 0;
sstrip.LoadNumber = !viewItem.IsLoadNumberNull() ? viewItem.LoadNumber : "";
sstrip.TrailerNumber = !viewItem.IsTrailerNumberNull() ? viewItem.TrailerNumber : "";
sstrip.TractorNumber = !viewItem.IsTractorNumberNull() ? viewItem.TractorNumber : "";
sstrip.DriverName = !viewItem.IsDriverNameNull() ? viewItem.DriverName : "";
if (!viewItem.IsScheduledCloseNull())
{
sstrip.ScheduledClose = viewItem.ScheduledClose;
}
if (!viewItem.IsScheduledDepartureNull())
{
sstrip.ScheduledDeparture = viewItem.ScheduledDeparture;
}
sstrip.IsMandatory = !viewItem.IsIsMandatoryNull() ? viewItem.IsMandatory : (byte)0;
if (!viewItem.IsFreightAssignedNull())
{
sstrip.FreightAssigned = viewItem.FreightAssigned;
}
if (!viewItem.IsTrailerCompleteNull())
{
sstrip.TrailerComplete = viewItem.TrailerComplete;
}
if (!viewItem.IsPaperworkCompleteNull())
{
sstrip.PaperworkComplete = viewItem.PaperworkComplete;
}
if (!viewItem.IsTrailerDispatchedNull())
{
sstrip.TrailerDispatched = viewItem.TrailerDispatched;
}
if (!viewItem.IsCanceledNull())
{
sstrip.Canceled = viewItem.Canceled;
}
sstrip.LastUpdated = DateTime.Now;
sstrip.UserID = Environment.UserName;
sstrip.RowVersion = viewItem.SCDERowVersion;
ShipScheduleStop ssstop1 = new ShipScheduleStop();
ssstop1.StopID = viewItem.StopID;
ssstop1.TripID = viewItem.TripID;
ssstop1.StopNumber = !viewItem.IsStopNumberNull() ? viewItem.StopNumber : "";
ssstop1.AgentTerminalID = !viewItem.IsAgentTerminalIDNull() ? viewItem.AgentTerminalID : 0;
ssstop1.Tag = !viewItem.IsTagNull() ? viewItem.Tag : "";
ssstop1.Notes = !viewItem.IsNotesNull() ? viewItem.Notes : "";
if (!viewItem.IsScheduledArrivalNull())
{
ssstop1.ScheduledArrival = viewItem.ScheduledArrival;
}
if (!viewItem.IsScheduledOFD1Null())
{
ssstop1.ScheduledOFD1 = viewItem.ScheduledOFD1;
}
ssstop1.LastUpdated = DateTime.Now;
ssstop1.UserID = Environment.UserName;
ssstop1.RowVersion = viewItem.S1RowVersion;
ShipScheduleStop ssstop2 = null;
if (!viewItem.IsS2MainZoneNull() && viewItem.S2MainZone.Trim().Length > 0)
{
ssstop2 = new ShipScheduleStop();
ssstop2.StopID = viewItem.S2StopID;
ssstop2.TripID = viewItem.TripID;
ssstop2.StopNumber = !viewItem.IsS2StopNumberNull() ? viewItem.S2StopNumber : "";
ssstop2.AgentTerminalID = !viewItem.IsS2AgentTerminalIDNull() ? viewItem.S2AgentTerminalID : 0;
ssstop2.Tag = !viewItem.IsS2TagNull() ? viewItem.S2Tag : "";
ssstop2.Notes = !viewItem.IsS2NotesNull() ? viewItem.S2Notes : "";
if (!viewItem.IsS2ScheduledArrivalNull())
{
ssstop2.ScheduledArrival = viewItem.S2ScheduledArrival;
}
if (!viewItem.IsS2ScheduledOFD1Null())
{
ssstop2.ScheduledOFD1 = viewItem.S2ScheduledOFD1;
}
ssstop2.LastUpdated = DateTime.Now;
ssstop2.UserID = Environment.UserName;
ssstop2.RowVersion = viewItem.S2RowVersion;
}
updated = client.UpdateShipSchedule(int.Parse(Program.TerminalCode), sstrip, ssstop1, ssstop2);
client.Close();
}
catch (TimeoutException te) { client.Abort(); throw new ApplicationException(te.Message); }
catch (FaultException <ShipScheduleFault> ssf) { client.Abort(); throw new ApplicationException(ssf.Detail.Message); }
catch (FaultException fe) { client.Abort(); throw new ApplicationException(fe.Message); }
catch (CommunicationException ce) { client.Abort(); throw new ApplicationException(ce.Message); }
return(updated);
}
