Esempio n. 1
0
        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);
        }