public bool ChangeTrailerEntry(TrailerEntry entry)
{
//Change an existing trailer log entry
bool changed = 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()) {
//
changed = new DispatchGateway().UpdateTrailerEntry(entry);
//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 <DispatchFault>(new DispatchFault(ex.Message), "Service Error"); }
return(changed);
}
public bool UpdateTrailerEntry(TrailerEntry entry)
{
//Update an existing trailer entry in the Trailer Log
bool updated = false;
try {
updated = new DataService().ExecuteNonQuery(SQL_CONNID, USP_TRAILERLOG_UPDATE,
new object[] {
entry.ID, entry.ScheduleDate, entry.TrailerNumber,
(entry.InboundDate != DateTime.MinValue ? entry.InboundDate : null as object),
entry.InboundCarrier, entry.InboundSeal, entry.InboundDriverName, entry.TDSNumber, entry.InitialYardLocation,
(entry.OutboundDate != DateTime.MinValue ? entry.OutboundDate : null as object),
entry.OutboundCarrier, entry.OutboundSeal, entry.OutboundDriverName, entry.BOLNumber,
entry.Comments, entry.LastUpdated, entry.UserID
});
}
catch (Exception ex) { throw new ApplicationException(ex.Message, ex); }
return(updated);
}
