public void Delete(TModel model) { var queryStrategy = _queryStrategyProvider.GetDeleteStrategy <TModel>(_queryTable.ModelStrategy); var sql = queryStrategy.GetDbQueryScript(); var dbparams = queryStrategy.GetDbParameters(); DbModelBindingHelper.BindingModelToParameters( model, _queryTable.ModelStrategy.PropertyStrategies, dbparams); try { _serviceProvider.Open(); if (_serviceProvider.Execute(sql, dbparams) == 0) { throw new DbOperationException("ERROR_SQL_EXECUTION_FAILED", sql, dbparams); } } catch (Exception exception) { throw new DbOperationException("ERROR_SQL_EXECUTION_FAILED", exception, sql, dbparams); } finally { _serviceProvider.Close(); } }
private void ExecuteModelDbOperation(IDbQueryStrategy strategy, TModel model = null) { Exception exception = null; var dbparams = (model == null) ? new List <IDbDataParameter>() : DbModelBindingHelper.BindingModelToParameters(model, ModelStrategy.PropertyStrategies, strategy.GetDbParameters()); _serviceProvider.Open(); try { if (_serviceProvider.Execute(strategy.GetDbQueryScript(), dbparams) == 0) { throw new DbChangeNoAffectException(); } } catch (Exception ex) { exception = ex; } _serviceProvider.Close(); if (exception != null) { throw new DbAggregateException(exception); } }
public int Delete(IEnumerable <TModel> models, bool throwIfAnyModelFailed = true) { int success = 0; var queryStrategy = _queryStrategyProvider.GetDeleteStrategy <TModel>(_queryTable.ModelStrategy); var sql = queryStrategy.GetDbQueryScript(); var dbparams = queryStrategy.GetDbParameters(); var exceptions = new List <DbOperationException>(); _serviceProvider.Open(); foreach (var model in models) { DbModelBindingHelper.BindingModelToParameters( model, _queryTable.ModelStrategy.PropertyStrategies, dbparams); try { if (_serviceProvider.Execute(sql, dbparams) > 0) { success++; } else { exceptions.Add(new DbOperationException("ERROR_SQL_EXECUTION_FAILED", sql, dbparams)); } } catch (Exception ex) { exceptions.Add(new DbOperationException("ERROR_SQL_EXECUTION_FAILED", ex, sql, dbparams)); } } _serviceProvider.Close(); if (throwIfAnyModelFailed) { throw new DbMultipleOperationsException(exceptions); } return(success); }
private void ExecuteModelDbOperation(IDbQueryStrategy strategy, IEnumerable <TModel> models) { var exceptions = new Dictionary <int, Exception>(); _serviceProvider.Open(); _serviceProvider.BeginTransaction(); var modelIdx = 0; foreach (var model in models) { try { var dbparams = DbModelBindingHelper.BindingModelToParameters( model, ModelStrategy.PropertyStrategies, strategy.GetDbParameters()); if (_serviceProvider.Execute(strategy.GetDbQueryScript(), dbparams) == 0) { throw new DbChangeNoAffectException(); } } catch (Exception ex) { exceptions.Add(modelIdx, ex); } modelIdx++; } if (!exceptions.Any()) { _serviceProvider.Commit(); _serviceProvider.Close(); } else { _serviceProvider.Rollback(); _serviceProvider.Close(); throw new DbAggregateException(exceptions); } }