Database

<br />
class SQLServerDataObjectFactory : DataObjectFactory<br />
{<br />
    public IDbConnection CreateConnection(...)<br />
    {<br />
        return new SqlConnection(...);<br />
    }<br />
}<br />
<br />
class OracleDataObjectFactory : DataObjectFactory<br />
{<br />
    public IDbConnection CreateConnection(...)<br />
    {<br />
        // The class name may be wrong - I don't have the .NET 1.1 framework installed<br />
        return new OracleConnection(...);<br />
    }<br />
}<br />
<br />
class MyDataLayerObject<br />
{<br />
    public void MyDataLayerMethod()<br />
    {<br />
        // Do stuff<br />
<br />
        // The data object factory was instantiated somewhere in the <br />
        // program's initialisation code.<br />
        IDbConnection connection = myDataObjectFactory.CreateConnection(...);<br />
<br />
        // Do stuff with connection. At this point, I don't care what<br />
        // concrete type it is.<br />
    }<br />
} <br />
<br />
Brad

ALTER TRIGGER CheckInOut_ValidatedTrigger
ON dbo.CheckInOut
FOR UPDATE
AS
   IF @@ROWCOUNT = 0 RETURN

   IF NOT UPDATE( Validated ) RETURN
		
   UPDATE Schedule
   SET 
      CompletedDate = OD.CompletedDate,
      CompletedOrderMainStatus = 
         CASE dbo.IsOrderCompleted( I.OrderNumber )
            WHEN 0 THEN 3
            ELSE 5
         END
   FROM
      inserted I
   INNER JOIN
      OrderDetail OD
         ON I.OrderNumber = OD.OrderNumber
   WHERE
      I.Validated = 1 AND
      Schedule.OrderNumber = I.OrderNumber

<small><br />
SET NOCOUNT ON<br />
					<br />
					<br />
DECLARE @OrderNumber varchar(10)<br />
DECLARE @ScheduleID bigint<br />
DECLARE @DispatcherID smallint<br />
DECLARE @ScheduleComplete bit<br />
<br />
DECLARE OrderCursor CURSOR FOR<br />
SELECT OrderNumber, ScheduleID, CheckOutDispatcherID, ScheduleComplete FROM inserted WHERE Validated = 1<br />
<br />
OPEN OrderCursor<br />
FETCH NEXT FROM OrderCursor INTO @OrderNumber, @ScheduleID, @DispatcherID, @ScheduleComplete<br />
<br />
WHILE @@FETCH_STATUS = 0<br />
    BEGIN<br />
	IF ( @ScheduleComplete IS NULL OR @ScheduleComplete = 0 )<br />
	BEGIN<br />
	        UPDATE Schedule<br />
		    SET Attempts = Attempts + 1<br />
		WHERE Schedule.ID = @ScheduleID<br />
	END<br />
	ELSE<br />
	BEGIN<br />
		UPDATE Schedule<br />
			SET CompletedDate = GETDATE(),<br />
			CompletedOrderMainStatus = ( CASE [Convert].IsOrderCompleted(@OrderNumber) WHEN 0 THEN 3 ELSE 5 END ),<br />
			CompletedOrderStatus = ( CASE [Convert].IsOrderCompleted(@OrderNumber) WHEN 0 THEN 3 ELSE 8 END ),<br />
			CompletedDispatcherID = (@DispatcherID)<br />
		WHERE Schedule.ID = @ScheduleID<br />
	END<br />
							FETCH NEXT FROM OrderCursor INTO @OrderNumber, @ScheduleID, @DispatcherID, @ScheduleComplete<br />
    END<br />
<br />
CLOSE OrderCursor<br />
DEALLOCATE OrderCursor<br />
				<br />
SET NOCOUNT OFF<br />