public System.Data.SqlClient.SqlTransaction CompleteScaling(Guid truckId) { IGINProcess originalGIN = new GINProcessBLL(currentGINProcess.GINProcessInformation.TransactionId); SqlTransaction transaction = currentGINProcess.CompleteScaling(truckId); var ginChanges = (from oGIN in originalGIN.GINProcessInformation.Trucks join cGIN in currentGINProcess.GINProcessInformation.Trucks on oGIN.TruckId equals cGIN.TruckId where oGIN.TruckId == truckId select new object[] { oGIN, cGIN, AuditTrailWrapper.ExistingRecord }); try { AuditTrailWrapper atw = new AuditTrailWrapper(AuditTrailWrapper.TruckWeighing, "GIN Process"); atw.AddChange(ginChanges.ToArray()); if (!atw.Save()) { transaction.Rollback(); throw new Exception("Failed to save audit trail!"); } } catch (Exception ex) { transaction.Rollback(); throw ex; } return(transaction); }
public static void CompleteScaling(Guid truckId) { IGINProcess ginProcess = GetGINProcess(true); SqlTransaction transaction = null; try { transaction = ginProcess.CompleteScaling(truckId); TruckRegistrationInfo truckReistration = new TruckRegistrationInfo() { GINTruck = ginProcess.GINProcessInformation.Trucks.Find(t => t.TruckId == truckId) }; TruckWeight trackWeight = truckReistration.TruckWeight; trackWeight.Id = Guid.NewGuid(); trackWeight.Save(transaction); CompleteWorkflowTask(ginProcess.GINProcessInformation.Trucks[0].TransactionId); transaction.Commit(); } catch (Exception ex) { try { if (transaction != null) { transaction.Rollback(); } } catch (Exception ex2) { throw ex2; } throw ex; } }