public ImportError ImportExceptionIgnore(ImportQueueFilter filter, bool reprocess)
{
ImportError retVal = new EmptyImportError();
using (IDbConnection connection = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@ExceptionId", filter.ExceptionId.Value, DbType.Int32);
para.Add("@IsExcluded", true, DbType.Int32);
if (!reprocess)
{
para.Add("@Reprocess", reprocess, DbType.Boolean);
}
var results = connection.Query <ImportError>("dbo.Fdp_ImportErrorExclusion_Save", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public ImportError ImportExceptionSave(ImportQueueFilter filter)
{
ImportError retVal = new EmptyImportError();
using (IDbConnection connection = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpImportErrorId", filter.ExceptionId.Value, DbType.Int32);
para.Add("@IsExcluded", true, DbType.Boolean);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var results = connection.Query <ImportError>("dbo.Fdp_ImportError_Save", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
public ImportError ImportErrorGet(ImportQueueFilter filter)
{
ImportError retVal = new EmptyImportError();
using (var connection = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@ExceptionId", filter.ExceptionId, DbType.Int32);
var results = connection.Query <ImportError>("dbo.Fdp_ImportError_Get", para, commandType: CommandType.StoredProcedure);
var importErrors = results as IList <ImportError> ?? results.ToList();
if (importErrors.Any())
{
retVal = importErrors.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
private void InitialiseMembers()
{
CurrentImport = new EmptyImportQueue();
CurrentException = new EmptyImportError();
CurrentAction = enums.ImportAction.NotSet;
CurrentFeatureGroup = string.Empty;
CurrentFeatureSubGroup = new EmptyFeatureGroup();
CurrentFeature = new EmptyFeature();
CurrentMarket = new EmptyMarket();
AvailableDocuments = Enumerable.Empty <OXODoc>();
AvailableEngines = Enumerable.Empty <ModelEngine>();
AvailableTransmissions = Enumerable.Empty <ModelTransmission>();
AvailableBodies = Enumerable.Empty <ModelBody>();
AvailableTrim = Enumerable.Empty <OxoTrim>();
AvailableSpecialFeatures = Enumerable.Empty <SpecialFeature>();
AvailableMarkets = Enumerable.Empty <Market>();
AvailableFeatures = Enumerable.Empty <FdpFeature>();
AvailableFeatureGroups = Enumerable.Empty <FeatureGroup>();
AvailableDerivatives = Enumerable.Empty <Derivative>();
AvailableImportDerivatives = Enumerable.Empty <ImportDerivative>();
AvailableImportTrimLevels = Enumerable.Empty <ImportTrim>();
AvailableExceptionTypes = Enumerable.Empty <ImportExceptionType>();
AvailableImportStatuses = Enumerable.Empty <ImportStatus>();
AvailableTrimLevels = Enumerable.Empty <TrimLevel>();
IdentifierPrefix = "Page";
}
private void InitialiseMembers()
{
CurrentImport = new EmptyImportQueue();
CurrentException = new EmptyImportError();
CurrentAction = enums.ImportAction.NotSet;
CurrentFeatureGroup = string.Empty;
CurrentFeatureSubGroup = new EmptyFeatureGroup();
CurrentFeature = new EmptyFeature();
CurrentMarket = new EmptyMarket();
AvailableDocuments = Enumerable.Empty<OXODoc>();
AvailableEngines = Enumerable.Empty<ModelEngine>();
AvailableTransmissions = Enumerable.Empty<ModelTransmission>();
AvailableBodies = Enumerable.Empty<ModelBody>();
AvailableTrim = Enumerable.Empty<OxoTrim>();
AvailableSpecialFeatures = Enumerable.Empty<SpecialFeature>();
AvailableMarkets = Enumerable.Empty<Market>();
AvailableFeatures = Enumerable.Empty<FdpFeature>();
AvailableFeatureGroups = Enumerable.Empty<FeatureGroup>();
AvailableDerivatives = Enumerable.Empty<Derivative>();
AvailableImportDerivatives = Enumerable.Empty<ImportDerivative>();
AvailableImportTrimLevels = Enumerable.Empty<ImportTrim>();
AvailableExceptionTypes = Enumerable.Empty<ImportExceptionType>();
AvailableImportStatuses = Enumerable.Empty<ImportStatus>();
AvailableTrimLevels = Enumerable.Empty<TrimLevel>();
IdentifierPrefix = "Page";
}
public ImportError ImportExceptionSave(ImportQueueFilter filter)
{
ImportError retVal = new EmptyImportError();
using (IDbConnection connection = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@FdpImportErrorId", filter.ExceptionId.Value, DbType.Int32);
para.Add("@IsExcluded", true, DbType.Boolean);
para.Add("@CDSId", CurrentCDSID, DbType.String);
var results = connection.Query<ImportError>("dbo.Fdp_ImportError_Save", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public ImportError ImportExceptionIgnore(ImportQueueFilter filter, bool reprocess)
{
ImportError retVal = new EmptyImportError();
using (IDbConnection connection = DbHelper.GetDBConnection())
{
try
{
var para = DynamicParameters.FromCDSId(CurrentCDSID);
para.Add("@ExceptionId", filter.ExceptionId.Value, DbType.Int32);
para.Add("@IsExcluded", true, DbType.Int32);
if (!reprocess)
{
para.Add("@Reprocess", reprocess, DbType.Boolean);
}
var results = connection.Query<ImportError>("dbo.Fdp_ImportErrorExclusion_Save", para, commandType: CommandType.StoredProcedure);
if (results.Any())
{
retVal = results.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public ImportError ImportErrorGet(ImportQueueFilter filter)
{
ImportError retVal = new EmptyImportError();
using (var connection = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@ExceptionId", filter.ExceptionId, DbType.Int32);
var results = connection.Query<ImportError>("dbo.Fdp_ImportError_Get", para, commandType: CommandType.StoredProcedure);
var importErrors = results as IList<ImportError> ?? results.ToList();
if (importErrors.Any())
{
retVal = importErrors.First();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
