protected override void InitializeObject(IGenericEntity ent) { if (ent is IExtract) { IExtract extract = (IExtract)ent; DBStoredProcedure spSelectProjectReforcast = new DBStoredProcedure(); spSelectProjectReforcast.ProcedureName = "extExtractProjectReforcastData"; spSelectProjectReforcast.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, extract.IdProject)); spSelectProjectReforcast.AddParameter(new DBParameter("@IdGeneration", DbType.Int32, ParameterDirection.Input, extract.IdGeneration)); spSelectProjectReforcast.AddParameter(new DBParameter("@WPActiveStatus", DbType.String, ParameterDirection.Input, extract.ActiveStatus)); spSelectProjectReforcast.AddParameter(new DBParameter("@IdCurrencyAssociate", DbType.String, ParameterDirection.Input, extract.IdCurrencyAssociate)); this.AddStoredProcedure("ExtractProjectReforcastData", spSelectProjectReforcast); DBStoredProcedure spSelectProgramReforcast = new DBStoredProcedure(); spSelectProgramReforcast.ProcedureName = "extExtractProgramReforcastData"; spSelectProgramReforcast.AddParameter(new DBParameter("@IdProgram", DbType.Int32, ParameterDirection.Input, extract.IdProgram)); spSelectProgramReforcast.AddParameter(new DBParameter("@IdGeneration", DbType.Int32, ParameterDirection.Input, extract.IdGeneration)); spSelectProgramReforcast.AddParameter(new DBParameter("@WPActiveStatus", DbType.String, ParameterDirection.Input, extract.ActiveStatus)); spSelectProgramReforcast.AddParameter(new DBParameter("@IdCurrencyAssociate", DbType.String, ParameterDirection.Input, extract.IdCurrencyAssociate)); this.AddStoredProcedure("ExtractProgramReforcastData", spSelectProgramReforcast); DBStoredProcedure spSelectProjectRevised = new DBStoredProcedure(); spSelectProjectRevised.ProcedureName = "extExtractProjectRevisedData"; spSelectProjectRevised.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, extract.IdProject)); spSelectProjectRevised.AddParameter(new DBParameter("@IdGeneration", DbType.Int32, ParameterDirection.Input, extract.IdGeneration)); spSelectProjectRevised.AddParameter(new DBParameter("@WPActiveStatus", DbType.String, ParameterDirection.Input, extract.ActiveStatus)); spSelectProjectRevised.AddParameter(new DBParameter("@IdCurrencyAssociate", DbType.String, ParameterDirection.Input, extract.IdCurrencyAssociate)); this.AddStoredProcedure("ExtractProjectRevisedData", spSelectProjectRevised); DBStoredProcedure spSelectProgramRevised = new DBStoredProcedure(); spSelectProgramRevised.ProcedureName = "extExtractProgramRevisedData"; spSelectProgramRevised.AddParameter(new DBParameter("@IdProgram", DbType.Int32, ParameterDirection.Input, extract.IdProgram)); spSelectProgramRevised.AddParameter(new DBParameter("@IdGeneration", DbType.Int32, ParameterDirection.Input, extract.IdGeneration)); spSelectProgramRevised.AddParameter(new DBParameter("@WPActiveStatus", DbType.String, ParameterDirection.Input, extract.ActiveStatus)); spSelectProgramRevised.AddParameter(new DBParameter("@IdCurrencyAssociate", DbType.String, ParameterDirection.Input, extract.IdCurrencyAssociate)); this.AddStoredProcedure("ExtractProgramRevisedData", spSelectProgramRevised); DBStoredProcedure spSelectProjectInitial = new DBStoredProcedure(); spSelectProjectInitial.ProcedureName = "extExtractProjectInitialData"; spSelectProjectInitial.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, extract.IdProject)); spSelectProjectInitial.AddParameter(new DBParameter("@WPActiveStatus", DbType.String, ParameterDirection.Input, extract.ActiveStatus)); spSelectProjectInitial.AddParameter(new DBParameter("@IdCurrencyAssociate", DbType.String, ParameterDirection.Input, extract.IdCurrencyAssociate)); this.AddStoredProcedure("ExtractProjectInitialData", spSelectProjectInitial); DBStoredProcedure spSelectProgramInitial = new DBStoredProcedure(); spSelectProgramInitial.ProcedureName = "extExtractProgramInitialData"; spSelectProgramInitial.AddParameter(new DBParameter("@IdProgram", DbType.Int32, ParameterDirection.Input, extract.IdProgram)); spSelectProgramInitial.AddParameter(new DBParameter("@WPActiveStatus", DbType.String, ParameterDirection.Input, extract.ActiveStatus)); spSelectProgramInitial.AddParameter(new DBParameter("@IdCurrencyAssociate", DbType.String, ParameterDirection.Input, extract.IdCurrencyAssociate)); this.AddStoredProcedure("ExtractProgramInitialData", spSelectProgramInitial); DBStoredProcedure spSelectProjectActual = new DBStoredProcedure(); spSelectProjectActual.ProcedureName = "extExtractProjectActualData"; spSelectProjectActual.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, extract.IdProject)); spSelectProjectActual.AddParameter(new DBParameter("@WPActiveStatus", DbType.String, ParameterDirection.Input, extract.ActiveStatus)); spSelectProjectActual.AddParameter(new DBParameter("@IdCurrencyAssociate", DbType.String, ParameterDirection.Input, extract.IdCurrencyAssociate)); this.AddStoredProcedure("ExtractProjectActualData", spSelectProjectActual); DBStoredProcedure spSelectProgramActual = new DBStoredProcedure(); spSelectProgramActual.ProcedureName = "extExtractProgramActualData"; spSelectProgramActual.AddParameter(new DBParameter("@IdProgram", DbType.Int32, ParameterDirection.Input, extract.IdProgram)); spSelectProgramActual.AddParameter(new DBParameter("@WPActiveStatus", DbType.String, ParameterDirection.Input, extract.ActiveStatus)); spSelectProgramActual.AddParameter(new DBParameter("@IdCurrencyAssociate", DbType.String, ParameterDirection.Input, extract.IdCurrencyAssociate)); this.AddStoredProcedure("ExtractProgramActualData", spSelectProgramActual); DBStoredProcedure spSelectProjectAnnual = new DBStoredProcedure(); spSelectProjectAnnual.ProcedureName = "extExtractProjectAnnualData"; spSelectProjectAnnual.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, extract.IdProject)); spSelectProjectAnnual.AddParameter(new DBParameter("@Year", DbType.Int32, ParameterDirection.Input, extract.Year)); spSelectProjectAnnual.AddParameter(new DBParameter("@WPActiveStatus", DbType.String, ParameterDirection.Input, extract.ActiveStatus)); spSelectProjectAnnual.AddParameter(new DBParameter("@IdCurrencyAssociate", DbType.String, ParameterDirection.Input, extract.IdCurrencyAssociate)); this.AddStoredProcedure("ExtractProjectAnnualData", spSelectProjectAnnual); DBStoredProcedure spSelectProgramAnnual = new DBStoredProcedure(); spSelectProgramAnnual.ProcedureName = "extExtractProgramAnnualData"; spSelectProgramAnnual.AddParameter(new DBParameter("@IdProgram", DbType.Int32, ParameterDirection.Input, extract.IdProgram)); spSelectProgramAnnual.AddParameter(new DBParameter("@Year", DbType.Int32, ParameterDirection.Input, extract.Year)); spSelectProgramAnnual.AddParameter(new DBParameter("@WPActiveStatus", DbType.String, ParameterDirection.Input, extract.ActiveStatus)); spSelectProgramAnnual.AddParameter(new DBParameter("@IdCurrencyAssociate", DbType.String, ParameterDirection.Input, extract.IdCurrencyAssociate)); this.AddStoredProcedure("ExtractProgramAnnualData", spSelectProgramAnnual); } }
public ExtractController(IExtract extract) { _extract = extract; }
/// <summary> /// Internal creation only /// </summary> /// <param name="extract">IExtract</param> /// <param name="schema">IWpDbSchema</param> internal PostsTaxonomyPartsBuilder(IExtract extract, IWpDbSchema schema) : base(extract, schema) { }
internal DataLanguageParserImplementation(IParserHelper parserHelper, IDev2DataLanguageParser dev2DataLanguageParser, IExtract extract) { _parserHelper = parserHelper; _dev2DataLanguageParser = dev2DataLanguageParser; _extract = extract; }
protected abstract TBuilder GetConfiguredBuilder(IExtract extract);