public int Save() { int nResult = -1; int nNewUID = -1; DataSet ds = new DataSet(); using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) { try { DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider(); nNewUID = oSqlClientProvider.SaveRawMaterials(this.ID, this.WireDiameter, this.Hardness, this.Compound, this.Amount, this.Quality, this.SurfaceCondition, (int)this.State, this.UpdateUserID, out nResult); if (nResult == 0) { this.ID = nNewUID; 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); }