public static int SaveProductionPhase(int PID, int MID, float PTime) { int retval = -1; DAL.DataProvider.SqlClientProvider oProvider = new DAL.DataProvider.SqlClientProvider(); DataSet ds = new DataSet(); using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) { try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); retval = oSqlClientProvider.SaveProductionPhase(PID, MID, PTime); if (retval == 0) { scope1.Complete(); } } catch (System.Data.SqlClient.SqlException Exp) { } catch (Exception Exp) { } } return(retval); }