public ResultService(PowerLinesContext context, IResultReader resultReader, IRatingService ratingService, IBulkInsert <Result> bulkInsert)
{
db = context;
this.resultReader = resultReader;
this.ratingService = ratingService;
this.bulkInsert = bulkInsert;
}
public static async Task InsertAsync <TEntity>(this IBulkInsert bulkInsert, IEnumerable <TEntity> list)
{
var dataTable = list.ToDataTable();
bulkInsert.Table = dataTable;
await bulkInsert.InsertAsync();
}
public ReportDataPersistanceService(string tableName, IBulkInsert bulkInsert, Func <SqlConnection> sqlConnectionFunc, ILogger logger)
{
_bulkInsert = bulkInsert;
_sqlConnectionFunc = sqlConnectionFunc;
_logger = logger;
_tableName = tableName;
}
public static void Insert <TEntity>(this IBulkInsert bulkInsert, IEnumerable <TEntity> list)
{
var dataTable = list.ToDataTable();
bulkInsert.Table = dataTable;
bulkInsert.Insert();
}
private ValidationErrorLoggerService NewService(
IEasServiceConfiguration easServiceConfiguration = null,
IBulkInsert bulkInsert = null,
IDateTimeProvider dateTimeProvider = null,
ILogger logger = null)
{
return(new ValidationErrorLoggerService(easServiceConfiguration, bulkInsert, dateTimeProvider, logger ?? Mock.Of <ILogger>()));
}
public PersistenceService(Func <INcsContext> ncsContext, ILogger logger, IDateTimeProvider dateTimeProvider, IBulkInsert bulkInsert, IClearService clearService, IDataServiceConfiguration dataServiceConfiguration)
{
_ncsContext = ncsContext;
_logger = logger;
_dateTimeProvider = dateTimeProvider;
_bulkInsert = bulkInsert;
_clearService = clearService;
_dataServiceConfiguration = dataServiceConfiguration;
}
public ValidationErrorLoggerService(
IEasServiceConfiguration easServiceConfiguration,
IBulkInsert bulkInsert,
IDateTimeProvider dateTimeProvider,
ILogger logger)
{
_easServiceConfiguration = easServiceConfiguration;
_bulkInsert = bulkInsert;
_dateTimeProvider = dateTimeProvider;
_logger = logger;
}
private static void InsertValuesIntoTempTable <TKey, TValue>(
IDatabase database,
IDictionary <TKey, TValue> values,
string tempTableName)
{
database.ExecuteNonQuery(
$"CREATE TABLE {tempTableName}([Key] {typeof(TKey).ToSqlDataType()}, [Value] {typeof(TValue).ToSqlDataType()})");
using IBulkInsert bulkInsert = database.CreateBulkInsert();
bulkInsert.DestinationTableName = tempTableName;
using var reader = new EnumerableDataReader <KeyValuePair <TKey, TValue> >(values, new string[] { "Key", "Value" });
bulkInsert.Insert(reader);
}
private static void InsertValuesIntoTempTable <TValue>(
IDatabase database,
IEnumerable <TValue> values,
string tempTableName)
{
TableInfo tableInfo = Database.DatabaseMapper.GetTableInfo <TValue>();
string columns = GetColumnsWithSqlTypes(tableInfo, typeof(TValue));
database.ExecuteNonQuery($"CREATE TABLE {tempTableName} ( {columns} )");
using IBulkInsert bulkInsert = database.CreateBulkInsert();
bulkInsert.DestinationTableName = tempTableName;
using var reader = new EnumerableDataReader <TValue>(values, GetColumns(tableInfo, typeof(TValue)));
bulkInsert.Insert(reader);
}
public StoreFM70(IBulkInsert bulkInsert)
{
_bulkInsert = bulkInsert;
}
public IlrReferenceDataRepositoryService(IDbContextFactory <IIlrReferenceDataContext> ilrReferenceDataContextFactory, IBulkInsert bulkInsert)
{
_ilrReferenceDataContextFactory = ilrReferenceDataContextFactory;
_bulkInsert = bulkInsert;
}
public PersistenceService(IBulkInsert bulkInsert, ILogger logger, ITelemetry telemetry)
{
_bulkInsert = bulkInsert;
_logger = logger;
_telemetry = telemetry;
}
public void SetBulkInsert(IBulkInsert bulkInsert)
{
_bulkInsert = bulkInsert;
}
public PagedBulk(List <T> items, IBulkInsert bulkInsert)
{
Items = items;
_bulkInsert = bulkInsert;
}
public StoreValidationOutput(IBulkInsert bulkInsert)
: base(bulkInsert)
{
}
private IlrReferenceDataRepositoryService NewService(IDbContextFactory <IIlrReferenceDataContext> ilrReferenceDataContextFactory = null, IBulkInsert bulkInsert = null)
{
return(new IlrReferenceDataRepositoryService(ilrReferenceDataContextFactory, bulkInsert));
}
public StoreFM36History(IBulkInsert bulkInsert)
{
_bulkInsert = bulkInsert;
}
public BulkInsertService(IBulkInsert <TBulkData> bulkInsert, IDataTransformer <IEnumerable <TData>, TBulkData> dataTransformer, IMappingAdapter <TData> mappingAdapter)
{
_bulkInsert = bulkInsert ?? throw new ArgumentNullException(nameof(bulkInsert));
_dataTransformer = dataTransformer ?? throw new ArgumentNullException(nameof(dataTransformer));
_mappingAdapter = mappingAdapter ?? throw new ArgumentNullException(nameof(mappingAdapter));
}
protected AbstractStore(IBulkInsert bulkInsert)
{
_bulkInsert = bulkInsert;
}
public StoreInvalidHeader(IBulkInsert bulkInsert)
: base(bulkInsert)
{
}
public DataStoreQueryExecutionService(IBulkInsert bulkInsert)
{
_bulkInsert = bulkInsert;
}
public PersistReportData(IBulkInsert bulkInsert, ILogger logger)
{
_bulkInsert = bulkInsert;
_logger = logger;
}
public SummarisedActualsPersistBAU(IBulkInsert bulkInsert)
{
_bulkInsert = bulkInsert;
}
public StoreValidLearnerData(IBulkInsert bulkInsert)
: base(bulkInsert)
{
}
public RatingService(PowerLinesContext context, IBulkInsert <Dataset> bulkInsert)
{
db = context;
this.bulkInsert = bulkInsert;
}
public StoreALB(IBulkInsert bulkInsert)
{
_bulkInsert = bulkInsert;
}
public QuickInsert(IBulkInsert bulkInsert)
{
_bulkInsert = bulkInsert;
}
