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; }