public ImportFileBatch CreateImportFileBatch(ImportFileType importFileType, string fileName)
{
//TODO Handle errors
var importFileBatch = new ImportFileBatch();
var mapper = new ImportFileBatchDataMapper(importFileType);
SetSqlConnection();
using (Connection)
using (var command = CreateSqlCommand(StoredProcedures.CreateImportFileBatch))
{
AddParameter(command, DbType.Int32, "ImportFileTypeId", importFileType.ImportFileTypeId);
AddParameter(command, DbType.String, "ImportFileName", fileName);
Connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
importFileBatch = mapper.MapSingle(reader);
}
}
}
return(importFileBatch);
}
public void UpdateImportFileBatchStatus(ImportFileBatch importFileBatch, ImportFileBatchStatus importFileBatchStatus)
{
SetSqlConnection();
using (Connection)
using (var command = CreateSqlCommand(StoredProcedures.UpdateImportFileBatchStatus))
{
AddParameter(command, DbType.Int16, "ImportFileBatchId", importFileBatch.ImportFileBatchId);
AddParameter(command, DbType.Int32, "ImportFileBatchStatusId", (short)importFileBatchStatus);
Connection.Open();
command.ExecuteNonQuery();
}
}
public void UpdateImportFileBatchRecordCount(ImportFileBatch importFileBatch, int batchRecordCount)
{
SetSqlConnection();
using (Connection)
using (var command = CreateSqlCommand(StoredProcedures.UpdateImportFileBatchRecordCount))
{
AddParameter(command, DbType.Int16, "ImportFileBatchId", importFileBatch.ImportFileBatchId);
AddParameter(command, DbType.Int32, "BatchRecordCount", batchRecordCount);
Connection.Open();
command.ExecuteNonQuery();
}
}
public void ExecutePostLoadProcedure(ImportFileBatch importFileBatch)
{
if (string.IsNullOrEmpty(importFileBatch.ImportFileType.PostLoadProcedure))
{
return;
}
SetSqlConnection();
using (Connection)
using (var command = CreateSqlCommand(importFileBatch.ImportFileType.PostLoadProcedure))
{
AddParameter(command, DbType.Int32, "ImportFileBatchId", importFileBatch.ImportFileBatchId);
Connection.Open();
command.ExecuteNonQuery();
}
}
public Collection <ImportFileBatchError> GetImportFileBatchErrors(ImportFileBatch importFileBatch)
{
var importFileBatchErrors = new Collection <ImportFileBatchError>();
var mapper = new ImportFileBatchErrorMapper(importFileBatch);
SetSqlConnection();
using (Connection)
using (var command = CreateSqlCommand(StoredProcedures.GetImportFileBatchErrors))
{
AddParameter(command, DbType.Int32, "ImportFileBatchId", importFileBatch.ImportFileBatchId);
Connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
importFileBatchErrors = mapper.MapAll(reader);
}
}
}
return(importFileBatchErrors);
}
public MonzoTransactionBulkWriter(ImportFileBatch importFileBatch) : base(importFileBatch)
{
}
protected BulkWriter(ImportFileBatch importFileBatch)
{
_importFileBatch = importFileBatch;
SetSqlConnection();
}
public ImportFileBatchErrorMapper(ImportFileBatch importFileBatch)
{
_importFileBatch = importFileBatch;
}
public SantanderTransactionBulkWriter(ImportFileBatch importFileBatch) : base(importFileBatch)
{
}
