public static int UpdateOrderDetail(int OID, int PID, int OrderCount, int UsedStockCountColored, int UsedStockCountNonColored, int ProductionCount, int CID, string PackageType, int OPStatus, int Operator, int ProductedAmount) { int nResult = -1; DataSet ds = new DataSet(); using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) { try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); nResult = oSqlClientProvider.UpdateOrderDetail(OID, PID, OrderCount, UsedStockCountColored, UsedStockCountNonColored, ProductionCount, CID, PackageType, OPStatus, Operator, ProductedAmount); if (nResult == 0) { scope1.Complete(); } } catch (System.Data.SqlClient.SqlException Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Data Policy"); //if (rethrow) //{ // throw; //} } catch (Exception Exp) { //bool rethrow = // ExceptionPolicy.HandleException(Exp, "StoreLocator Business Policy"); //if (rethrow) //{ // throw; //} } } return(nResult); }