public static int UpdateOrderDetailForStock(int OID, int PID, int IsStockUsed, int UsedStockAmount) { 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.UpdateOrderDetailForStock(OID, PID, IsStockUsed, UsedStockAmount); 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); }