Database

<br />
trx = conn.BeginTransaction();<br />
acc = AccBean.Load(acc_id, conn);<br />
request = RequestBean.Load(request_id, conn);<br />
<br />
//STEP 1: check and validate acc has sufficient funds<br />
if (acc.Balance >= request.Amount) {<br />
  <br />
   //STEP 2: update request status<br />
   request.Status = Status.APPROVED;<br />
<br />
   //STEP 3: approve request - update acc balance<br />
   acc.Balance = acc.Balance - request.Amount;<br />
}<br />
trx.Commit();<br />

<br />
trx = conn.BeginTransaction();<br />
acc = AccBean.Load(acc_id, conn);<br />
request = RequestBean.Load(request_id, conn);<br />
<br />
//STEP 1: check and validate acc has sufficient funds<br />
if (acc.Balance >= request.Amount) {<br />
  <br />
   //STEP 2: update request status - Now we have an UPDATE trigger on "request" table - to update acc Balance.<br />
   request.Status = Status.APPROVED;<br />
<br />
}<br />
trx.Commit();<br />

<br />
CREATE PROCEDURE FeatureBusinessByTown @County int, @Town int, @Type int AS<br />
<br />
Select Top 5 BusinessID<br />
FROM SELECT TOP 5 fbisBusinessLookup.BusinessID<br />
 FROM fbisBusinessLookup INNER JOIN<br />
 DIRECTORY ON fbisBusinessLookup.BusinessID = directory.[id]<br />
 WHERE <br />
<br />
IF (@county > 0) THEN "(fbisBusinessLookup.countyid = @County)"<br />
IF (@Town > 0) THEN " AND fbisBusinessLookup.TownID = @Town"<br />
IF (@Type>0) THEN " AND fbisBusinessLookup.TypeID = @Type"<br />
<br />
 ORDER BY NEWID()) DERIVEDTBL<br />
GO<br />