public ImportFileType CreateImportFileType(ImportFileType importFileType)
{
var newImportFileType = new ImportFileType();
var mapper = new ImportFileTypeDataMapper();
SetSqlConnection();
using (Connection)
using (var command = CreateSqlCommand(StoredProcedures.CreateImportFileType))
{
AddParameter(command, DbType.String, "Description", importFileType.Description);
AddParameter(command, DbType.String, "FileExtension", importFileType.FileExtension);
AddParameter(command, DbType.String, "ColumnDelimiter", importFileType.ColumnDelimiter);
AddParameter(command, DbType.String, "SourceDirectory", importFileType.SourceDirectory);
AddParameter(command, DbType.String, "FileNamePattern", importFileType.FileNamePattern);
AddParameter(command, DbType.String, "PostLoadProcedure", importFileType.PostLoadProcedure);
AddParameter(command, DbType.String, "StagingTable", importFileType.StagingTable);
AddParameter(command, DbType.Boolean, "IsActive", importFileType.IsActive);
Connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
newImportFileType = mapper.MapSingle(reader);
}
}
}
return(newImportFileType);
}
public Collection <ImportFileType> GetImportFileTypes()
{
var mapper = new ImportFileTypeDataMapper();
SetSqlConnection();
using (Connection)
using (var command = CreateSqlCommand(StoredProcedures.GetImportFileTypes))
{
Connection.Open();
using (var reader = command.ExecuteReader())
{
return(mapper.MapAll(reader));
}
}
}
