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 Collection <ImportFileBatch> GetImportFileBatches()
{
var importFileBatches = new Collection <ImportFileBatch>();
var mapper = new ImportFileBatchDataMapper();
SetSqlConnection();
using (Connection)
using (var command = CreateSqlCommand(StoredProcedures.GetImportFileBatches))
{
Connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
importFileBatches = mapper.MapAll(reader);
}
}
}
return(MapImportFileTypesToImportFileBatches(importFileBatches));
}
public Collection <ImportFileBatch> GetImportFileBatchesByTypeAndDate(ImportFileType importFileType, DateTime fromDate)
{
var importFileBatches = new Collection <ImportFileBatch>();
var mapper = new ImportFileBatchDataMapper(importFileType);
SetSqlConnection();
using (Connection)
using (var command = CreateSqlCommand(StoredProcedures.GetImportFileBatchesByTypeAndDate))
{
AddParameter(command, DbType.Byte, "ImportFileTypeId", importFileType.ImportFileTypeId);
AddParameter(command, DbType.DateTime, "DateFrom", fromDate);
Connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
importFileBatches = mapper.MapAll(reader);
}
}
}
return(importFileBatches);
}
