protected override void InitializeObject(IGenericEntity ent) { if (ent is IAnnualUpload) { IAnnualUpload annualUpload = (IAnnualUpload)ent; DBStoredProcedure spWriteToAnnualImportTable = new DBStoredProcedure(); spWriteToAnnualImportTable.ProcedureName = "impWriteToAnnualImportTable"; spWriteToAnnualImportTable.AddParameter(new DBParameter("@fileName", DbType.String, ParameterDirection.Input, annualUpload.FileName)); spWriteToAnnualImportTable.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, annualUpload.IdAssociate)); this.AddStoredProcedure("WriteToAnnualImportTable", spWriteToAnnualImportTable); DBStoredProcedure spWriteToAnnualTable = new DBStoredProcedure(); spWriteToAnnualTable.ProcedureName = "impWriteToAnnualTable"; spWriteToAnnualTable.AddParameter(new DBParameter("@fileName", DbType.String, ParameterDirection.Input, annualUpload.FileName)); spWriteToAnnualTable.AddParameter(new DBParameter("@IdImport", DbType.Int32, ParameterDirection.Input, annualUpload.IdImport)); spWriteToAnnualTable.AddParameter(new DBParameter("@SkipStartEndPhaseErrorsHours", DbType.Int32, ParameterDirection.Input, annualUpload.SkipStartEndPhaseErrorsHours)); spWriteToAnnualTable.AddParameter(new DBParameter("@SkipStartEndPhaseErrorsCosts", DbType.Int32, ParameterDirection.Input, annualUpload.SkipStartEndPhaseErrorsCosts)); spWriteToAnnualTable.AddParameter(new DBParameter("@SkipStartEndPhaseErrorsSales", DbType.Int32, ParameterDirection.Input, annualUpload.SkipStartEndPhaseErrorsSales)); this.AddStoredProcedure("WriteToAnnualTable", spWriteToAnnualTable); DBStoredProcedure spCheckFileAlreadyUploaded = new DBStoredProcedure(); spCheckFileAlreadyUploaded.ProcedureName = "impCheckAnnualFileAlreadyUploaded"; spCheckFileAlreadyUploaded.AddParameter(new DBParameter("@fileName", DbType.String, ParameterDirection.Input, annualUpload.FileName)); this.AddStoredProcedure("CheckAnnualFileAlreadyUploaded", spCheckFileAlreadyUploaded); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IFunction) { IFunction Function = (IFunction)ent; DBStoredProcedure spInsert = new DBStoredProcedure(); spInsert.ProcedureName = "catInsertFunction"; spInsert.AddParameter(new DBParameter("@Name", DbType.String, ParameterDirection.Input, Function.Name)); DBStoredProcedure spUpdate = new DBStoredProcedure(); spUpdate.ProcedureName = "catUpdateFunction"; spUpdate.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Function.Id)); spUpdate.AddParameter(new DBParameter("@Name", DbType.String, ParameterDirection.Input, Function.Name)); DBStoredProcedure spDelete = new DBStoredProcedure(); spDelete.ProcedureName = "catDeleteFunction"; spDelete.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Function.Id)); this.AddStoredProcedure("InsertObject", spInsert); this.AddStoredProcedure("UpdateObject", spUpdate); this.AddStoredProcedure("DeleteObject", spDelete); DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "catSelectFunction"; spSelect.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Function.Id)); this.AddStoredProcedure("SelectObject", spSelect); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IAnnualDataLogs) { IAnnualDataLogs dataLogs = (IAnnualDataLogs)ent; DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "abgtSelectAnnualDataLogs"; if(string.IsNullOrEmpty(dataLogs.CountryCode)) spSelect.AddParameter(new DBParameter("@CountryCode", DbType.String, ParameterDirection.Input, DBNull.Value)); else spSelect.AddParameter(new DBParameter("@CountryCode", DbType.String, ParameterDirection.Input, dataLogs.CountryCode)); this.AddStoredProcedure("SelectObject", spSelect); DBStoredProcedure spGetDetail = new DBStoredProcedure(); spGetDetail.ProcedureName = "abgtSelectAnnualDataLogsDetail"; spGetDetail.AddParameter(new DBParameter("@IdImport", DbType.Int32, ParameterDirection.Input, dataLogs.IdImport)); this.AddStoredProcedure("GetAnnualDataLogsDetail", spGetDetail); DBStoredProcedure spDelete = new DBStoredProcedure(); spDelete.ProcedureName = "abgtDeleteAnnualImport"; spDelete.AddParameter(new DBParameter("@IdImport", DbType.Int32, ParameterDirection.Input, dataLogs.IdImport)); this.AddStoredProcedure("DeleteObject", spDelete); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IProjectType) { IProjectType ProjectType = (IProjectType)ent; DBStoredProcedure spInsert = new DBStoredProcedure(); spInsert.ProcedureName = "catInsertProjectType"; spInsert.AddParameter(new DBParameter("@Type", DbType.String, ParameterDirection.Input, ProjectType.Type)); spInsert.AddParameter(new DBParameter("@Rank", DbType.Int32, ParameterDirection.Input, ProjectType.Rank)); DBStoredProcedure spUpdate = new DBStoredProcedure(); spUpdate.ProcedureName = "catUpdateProjectType"; spUpdate.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, ProjectType.Id)); spUpdate.AddParameter(new DBParameter("@Type", DbType.String, ParameterDirection.Input, ProjectType.Type)); spUpdate.AddParameter(new DBParameter("@Rank", DbType.Int32, ParameterDirection.Input, ProjectType.Rank)); DBStoredProcedure spDelete = new DBStoredProcedure(); spDelete.ProcedureName = "catDeleteProjectType"; spDelete.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, ProjectType.Id)); this.AddStoredProcedure("InsertObject", spInsert); this.AddStoredProcedure("UpdateObject", spUpdate); this.AddStoredProcedure("DeleteObject", spDelete); DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "catSelectProjectType"; spSelect.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, ProjectType.Id)); this.AddStoredProcedure("SelectObject", spSelect); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IAnnualImports) { IAnnualImports annualImports = (IAnnualImports)ent; DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "impSelectAnnualImports"; spSelect.AddParameter(new DBParameter("@IdImport", DbType.Int32, ParameterDirection.Input, annualImports.IdImport)); this.AddStoredProcedure("SelectObject", spSelect); DBStoredProcedure spLogErrorsToDatabase = new DBStoredProcedure(); spLogErrorsToDatabase.ProcedureName = "impAnnualUploadErrorsToLogTables"; spLogErrorsToDatabase.AddParameter(new DBParameter("@fileName", DbType.String, ParameterDirection.Input, annualImports.FileName)); spLogErrorsToDatabase.AddParameter(new DBParameter("@Message", DbType.String, ParameterDirection.Input, annualImports.Message)); spLogErrorsToDatabase.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, annualImports.IdAssociate)); this.AddStoredProcedure("AnnualUploadErrorsToLogTables", spLogErrorsToDatabase); DBStoredProcedure spProcessErrorsToDatabase = new DBStoredProcedure(); spProcessErrorsToDatabase.ProcedureName = "impAnnualProcessErrorsToLogTables"; spProcessErrorsToDatabase.AddParameter(new DBParameter("@fileName", DbType.String, ParameterDirection.Input, annualImports.FileName)); spProcessErrorsToDatabase.AddParameter(new DBParameter("@Message", DbType.String, ParameterDirection.Input, annualImports.Message)); spProcessErrorsToDatabase.AddParameter(new DBParameter("@IdImport", DbType.Int32, ParameterDirection.Input, annualImports.IdImport)); this.AddStoredProcedure("AnnualProcessErrorsToLogTables", spProcessErrorsToDatabase); DBStoredProcedure spSelectAnnualImportDetailsHeader = new DBStoredProcedure(); spSelectAnnualImportDetailsHeader.ProcedureName = "impSelectAnnualImportDetailsHeader"; spSelectAnnualImportDetailsHeader.AddParameter(new DBParameter("@IdImport", DbType.Int32, ParameterDirection.Input, annualImports.IdImport)); this.AddStoredProcedure("SelectAnnualImportDetailsHeader", spSelectAnnualImportDetailsHeader); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is ITimingAndInterco) { ITimingAndInterco timingAndInterco = (ITimingAndInterco)ent; DBStoredProcedure spGetPeriodAfectation = new DBStoredProcedure(); spGetPeriodAfectation.ProcedureName = "bgtGetAffectedWPTiming"; spGetPeriodAfectation.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, timingAndInterco.IdProject)); this.AddStoredProcedure("GetAffectedWPTiming", spGetPeriodAfectation); DBStoredProcedure spGetWPTiming = new DBStoredProcedure(); spGetWPTiming.ProcedureName = "bgtGetWPTiming"; spGetWPTiming.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, timingAndInterco.IdProject)); spGetWPTiming.AddParameter(new DBParameter("@IdPhase", DbType.Int32, ParameterDirection.Input, timingAndInterco.IdPhase)); spGetWPTiming.AddParameter(new DBParameter("@IdWP", DbType.Int32, ParameterDirection.Input, timingAndInterco.IdWP)); spGetWPTiming.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, timingAndInterco.IdAssociate)); this.AddStoredProcedure("GetWPTiming", spGetWPTiming); DBStoredProcedure spGetWPInterco = new DBStoredProcedure(); spGetWPInterco.ProcedureName = "bgtGetAffectedWPInterco"; spGetWPInterco.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, timingAndInterco.IdProject)); this.AddStoredProcedure("GetAffectedWPInterco", spGetWPInterco); DBStoredProcedure spGetUnaffectedWP = new DBStoredProcedure(); spGetUnaffectedWP.ProcedureName = "bgtGetUnaffectedWP"; spGetUnaffectedWP.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, timingAndInterco.IdProject)); this.AddStoredProcedure("GetUnaffectedWP", spGetUnaffectedWP); DBStoredProcedure spGetWPIntercoCountries = new DBStoredProcedure(); spGetWPIntercoCountries.ProcedureName = "bgtGetWPIntercoCountries"; spGetWPIntercoCountries.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, timingAndInterco.IdProject)); this.AddStoredProcedure("GetWPIntercoCountries", spGetWPIntercoCountries); DBStoredProcedure spUpdate = new DBStoredProcedure(); spUpdate.ProcedureName = "bgtUpdateWPTiming"; spUpdate.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, timingAndInterco.IdProject)); spUpdate.AddParameter(new DBParameter("@IdPhase", DbType.Int32, ParameterDirection.Input, timingAndInterco.IdPhase)); spUpdate.AddParameter(new DBParameter("@IdWP", DbType.Int32, ParameterDirection.Input, timingAndInterco.IdWP)); spUpdate.AddParameter(new DBParameter("@StartYearMonth", DbType.Int32, ParameterDirection.Input, timingAndInterco.StartYearMonth)); spUpdate.AddParameter(new DBParameter("@EndYearMonth", DbType.Int32, ParameterDirection.Input, timingAndInterco.EndYearMonth)); spUpdate.AddParameter(new DBParameter("@LastUserUpdate", DbType.Int32, ParameterDirection.Input, timingAndInterco.LastUserUpdate)); if (string.IsNullOrEmpty(timingAndInterco.WPCode)) { spUpdate.AddParameter(new DBParameter("@WPCode", DbType.String, ParameterDirection.Input, DBNull.Value)); } else { spUpdate.AddParameter(new DBParameter("@WPCode", DbType.String, ParameterDirection.Input, timingAndInterco.WPCode)); } this.AddStoredProcedure("UpdateObject", spUpdate); DBStoredProcedure sdDelete = new DBStoredProcedure(); sdDelete.ProcedureName = "bgtDeleteWPTimingAndInterco"; sdDelete.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, timingAndInterco.IdProject)); sdDelete.AddParameter(new DBParameter("@IdPhase", DbType.Int32, ParameterDirection.Input, timingAndInterco.IdPhase)); sdDelete.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, timingAndInterco.IdWP)); this.AddStoredProcedure("DeleteObject", sdDelete); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IAnnualImportDetails) { IAnnualImportDetails importDetails = (IAnnualImportDetails)ent; DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "impSelectAnnualImportDetails"; spSelect.AddParameter(new DBParameter("@IdImport", DbType.Int32, ParameterDirection.Input, importDetails.IdImport)); this.AddStoredProcedure("SelectAnnualImportDetails", spSelect); DBStoredProcedure spUpdateDetail = new DBStoredProcedure(); spUpdateDetail.ProcedureName = "impUpdateAnnualImportDetails"; spUpdateDetail.AddParameter(new DBParameter("@IdImport", DbType.Int32, ParameterDirection.Input, importDetails.IdImport)); spUpdateDetail.AddParameter(new DBParameter("@IdRow", DbType.Int32, ParameterDirection.Input, importDetails.IdRow)); spUpdateDetail.AddParameter(new DBParameter("@CostCenter", DbType.String, ParameterDirection.Input, importDetails.CostCenter)); spUpdateDetail.AddParameter(new DBParameter("@ProjectCode", DbType.String, ParameterDirection.Input, importDetails.ProjectCode)); spUpdateDetail.AddParameter(new DBParameter("@WPCode", DbType.String, ParameterDirection.Input, importDetails.WPCode)); spUpdateDetail.AddParameter(new DBParameter("@AccountNumber", DbType.String, ParameterDirection.Input, importDetails.AccountNumber)); if (importDetails.Quantity != ApplicationConstants.DECIMAL_NULL_VALUE) { spUpdateDetail.AddParameter(new DBParameter("@Quantity", DbType.Decimal, ParameterDirection.Input, importDetails.Quantity)); } else { spUpdateDetail.AddParameter(new DBParameter("@Quantity", DbType.Decimal, ParameterDirection.Input, DBNull.Value)); } if (importDetails.Value != ApplicationConstants.DECIMAL_NULL_VALUE) { spUpdateDetail.AddParameter(new DBParameter("@Value", DbType.Decimal, ParameterDirection.Input, importDetails.Value)); } else { spUpdateDetail.AddParameter(new DBParameter("@Value", DbType.Decimal, ParameterDirection.Input, DBNull.Value)); } spUpdateDetail.AddParameter(new DBParameter("@CurrencyCode", DbType.String, ParameterDirection.Input, importDetails.CurrencyCode)); spUpdateDetail.AddParameter(new DBParameter("@Date", DbType.DateTime, ParameterDirection.Input, importDetails.ImportDate)); this.AddStoredProcedure("UpdateAnnualImportDetails", spUpdateDetail); DBStoredProcedure spDelete = new DBStoredProcedure(); spDelete.ProcedureName = "impDeleteAnnualImportDetails"; spDelete.AddParameter(new DBParameter("@IdImport", DbType.Int32, ParameterDirection.Input, importDetails.IdImport)); this.AddStoredProcedure("DeleteObject", spDelete); DBStoredProcedure spSelectAnnualImportDetailsForExport = new DBStoredProcedure(); spSelectAnnualImportDetailsForExport.ProcedureName = "impSelectAnnualImportDetailsForExport"; spSelectAnnualImportDetailsForExport.AddParameter(new DBParameter("@IdImport", DbType.Int32, ParameterDirection.Input, importDetails.IdImport)); this.AddStoredProcedure("SelectAnnualImportDetailsForExport", spSelectAnnualImportDetailsForExport); DBStoredProcedure spSelectAnnualImportDetailsErrors = new DBStoredProcedure(); spSelectAnnualImportDetailsErrors.ProcedureName = "impSelectAnnualImportDetailsErrors"; spSelectAnnualImportDetailsErrors.AddParameter(new DBParameter("@IdImport", DbType.Int32, ParameterDirection.Input, importDetails.IdImport)); this.AddStoredProcedure("SelectAnnualImportDetailsErrors", spSelectAnnualImportDetailsErrors); DBStoredProcedure spSelectAnnualImportDetailsHeader = new DBStoredProcedure(); spSelectAnnualImportDetailsHeader.ProcedureName = "impSelectAnnualImportDetailsHeader"; spSelectAnnualImportDetailsHeader.AddParameter(new DBParameter("@IdImport", DbType.Int32, ParameterDirection.Input, importDetails.IdImport)); this.AddStoredProcedure("SelectAnnualImportDetailsHeader", spSelectAnnualImportDetailsHeader); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IOwner) { IOwner Owner = (IOwner)ent; DBStoredProcedure spInsert = new DBStoredProcedure(); spInsert.ProcedureName = "catInsertOwner"; spInsert.AddParameter(new DBParameter("@Code", DbType.String, ParameterDirection.Input, Owner.Code)); spInsert.AddParameter(new DBParameter("@Name", DbType.String, ParameterDirection.Input, Owner.Name)); spInsert.AddParameter(new DBParameter("@IdOwnerType", DbType.Int32, ParameterDirection.Input, Owner.IdOwnerType)); spInsert.AddParameter(new DBParameter("@Rank", DbType.Int32, ParameterDirection.Input, Owner.Rank)); DBStoredProcedure spUpdate = new DBStoredProcedure(); spUpdate.ProcedureName = "catUpdateOwner"; spUpdate.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Owner.Id)); spUpdate.AddParameter(new DBParameter("@Code", DbType.String, ParameterDirection.Input, Owner.Code)); spUpdate.AddParameter(new DBParameter("@Name", DbType.String, ParameterDirection.Input, Owner.Name)); spUpdate.AddParameter(new DBParameter("@IdOwnerType", DbType.Int32, ParameterDirection.Input, Owner.IdOwnerType)); spUpdate.AddParameter(new DBParameter("@Rank", DbType.Int32, ParameterDirection.Input, Owner.Rank)); DBStoredProcedure spDelete = new DBStoredProcedure(); spDelete.ProcedureName = "catDeleteOwner"; spDelete.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Owner.Id)); this.AddStoredProcedure("InsertObject", spInsert); this.AddStoredProcedure("UpdateObject", spUpdate); this.AddStoredProcedure("DeleteObject", spDelete); DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "catSelectOwner"; spSelect.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Owner.Id)); this.AddStoredProcedure("SelectObject", spSelect); } }
public DataSet SelectObjectForDisplay(IGenericEntity ent) { this.storedProcedures.Clear(); InitializeObject(ent); if (!storedProcedures.ContainsKey("SelectObjectForDisplay")) { throw new NotImplementedException(ApplicationMessages.EXCEPTION_IMPLEMENT_SELECTOBJECT); } DBStoredProcedure selectSP = storedProcedures["SelectObjectForDisplay"]; SqlCommand cmd = selectSP.GetSqlCommand(); DataSet returnDS = null; try { returnDS = CurrentConnectionManager.GetDataSet(cmd); } catch (SqlException exc) { throw new IndException(exc); } return(returnDS); }
protected override void InitializeObject(IGenericEntity ent) { if (ent is ICurrency) { ICurrency Currency = (ICurrency)ent; DBStoredProcedure spInsert = new DBStoredProcedure(); spInsert.ProcedureName = "catInsertCurrency"; spInsert.AddParameter(new DBParameter("@Code", DbType.String, ParameterDirection.Input, Currency.Code)); spInsert.AddParameter(new DBParameter("@Name", DbType.String, ParameterDirection.Input, Currency.Name)); DBStoredProcedure spUpdate = new DBStoredProcedure(); spUpdate.ProcedureName = "catUpdateCurrency"; spUpdate.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Currency.Id)); spUpdate.AddParameter(new DBParameter("@Code", DbType.String, ParameterDirection.Input, Currency.Code)); spUpdate.AddParameter(new DBParameter("@Name", DbType.String, ParameterDirection.Input, Currency.Name)); DBStoredProcedure spDelete = new DBStoredProcedure(); spDelete.ProcedureName = "catDeleteCurrency"; spDelete.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Currency.Id)); this.AddStoredProcedure("InsertObject", spInsert); this.AddStoredProcedure("UpdateObject", spUpdate); this.AddStoredProcedure("DeleteObject", spDelete); DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "catSelectCurrency"; spSelect.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Currency.Id)); this.AddStoredProcedure("SelectObject", spSelect); DBStoredProcedure spSelectForDisplay = new DBStoredProcedure(); spSelectForDisplay.ProcedureName = "catSelectCurrencyForDisplay"; this.AddStoredProcedure("SelectObjectForDisplay", spSelectForDisplay); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IExchangeRate) { IExchangeRate ExchangeRate = (IExchangeRate)ent; DBStoredProcedure spInsert = new DBStoredProcedure(); spInsert.ProcedureName = "catInsertExchangeRate"; spInsert.AddParameter(new DBParameter("Year", DbType.Int32, ParameterDirection.Input, ExchangeRate.Year)); spInsert.AddParameter(new DBParameter("Month", DbType.Int32, ParameterDirection.Input, ExchangeRate.Month)); spInsert.AddParameter(new DBParameter("IdCurrencyTo", DbType.Int32, ParameterDirection.Input, ExchangeRate.IdCurrencyTo)); spInsert.AddParameter(new DBParameter("ConversionRate", DbType.Decimal, ParameterDirection.Input, ExchangeRate.ConversionRate)); DBStoredProcedure spUpdate = new DBStoredProcedure(); spUpdate.ProcedureName = "catUpdateExchangeRate"; spUpdate.AddParameter(new DBParameter("Id", DbType.Int32, ParameterDirection.Input, ExchangeRate.Id)); spUpdate.AddParameter(new DBParameter("Year", DbType.Int32, ParameterDirection.Input, ExchangeRate.Year)); spUpdate.AddParameter(new DBParameter("Month", DbType.Int32, ParameterDirection.Input, ExchangeRate.Month)); spUpdate.AddParameter(new DBParameter("IdCurrencyTo", DbType.Int32, ParameterDirection.Input, ExchangeRate.IdCurrencyTo)); spUpdate.AddParameter(new DBParameter("ConversionRate", DbType.Decimal, ParameterDirection.Input, ExchangeRate.ConversionRate)); DBStoredProcedure spDelete = new DBStoredProcedure(); spDelete.ProcedureName = "catDeleteExchangeRate"; spDelete.AddParameter(new DBParameter("Id", DbType.Int32, ParameterDirection.Input, ExchangeRate.Id)); this.AddStoredProcedure("InsertObject", spInsert); this.AddStoredProcedure("UpdateObject", spUpdate); this.AddStoredProcedure("DeleteObject", spDelete); DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "catSelectExchangeRate"; spSelect.AddParameter(new DBParameter("Id", DbType.Int32, ParameterDirection.Input, ExchangeRate.Id)); this.AddStoredProcedure("SelectObject", spSelect); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is ICostCenterFilter) { ICostCenterFilter costCenterFilter = (ICostCenterFilter)ent; DBStoredProcedure spSelectCountry = new DBStoredProcedure(); spSelectCountry.ProcedureName = "fltCostCenterFilterCountries"; spSelectCountry.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, costCenterFilter.IdCountry)); this.AddStoredProcedure("SelectCountry", spSelectCountry); DBStoredProcedure spSelectInergyLocation = new DBStoredProcedure(); spSelectInergyLocation.ProcedureName = "fltCostCenterFilterInergyLocations"; spSelectInergyLocation.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, costCenterFilter.IdCountry)); this.AddStoredProcedure("SelectInergyLocation", spSelectInergyLocation); DBStoredProcedure spSelectFunction = new DBStoredProcedure(); spSelectFunction.ProcedureName = "fltCostCenterFilterFunctions"; this.AddStoredProcedure("SelectFunction", spSelectFunction); DBStoredProcedure spSelectCostCenter = new DBStoredProcedure(); spSelectCostCenter.ProcedureName = "fltCostCenterFilterCostCenters"; spSelectCostCenter.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, costCenterFilter.IdCountry)); spSelectCostCenter.AddParameter(new DBParameter("@IdInergyLocation", DbType.Int32, ParameterDirection.Input, costCenterFilter.IdInergyLocation)); spSelectCostCenter.AddParameter(new DBParameter("@IdFunction", DbType.Int32, ParameterDirection.Input, costCenterFilter.IdFunction)); this.AddStoredProcedure("SelectCostCenter", spSelectCostCenter); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IFollowUpCompletionBudget) { IFollowUpCompletionBudget followUpCompletionBudget = (IFollowUpCompletionBudget)ent; DBStoredProcedure spGetFollowUpCompletionBudget = new DBStoredProcedure(); spGetFollowUpCompletionBudget.ProcedureName = "bgtGetCompletionBudgetStates"; spGetFollowUpCompletionBudget.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, followUpCompletionBudget.IdProject)); spGetFollowUpCompletionBudget.AddParameter(new DBParameter("@BudVersion", DbType.String, ParameterDirection.Input, followUpCompletionBudget.BudVersion)); this.AddStoredProcedure("SelectObject", spGetFollowUpCompletionBudget); DBStoredProcedure spUpdateFollowUpCompletionBudget = new DBStoredProcedure(); spUpdateFollowUpCompletionBudget.ProcedureName = "bgtUpdateCompletionBudgetStates"; spUpdateFollowUpCompletionBudget.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, followUpCompletionBudget.IdProject)); spUpdateFollowUpCompletionBudget.AddParameter(new DBParameter("@BudVersion", DbType.String, ParameterDirection.Input, followUpCompletionBudget.BudVersion)); spUpdateFollowUpCompletionBudget.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, followUpCompletionBudget.IdAssociate)); spUpdateFollowUpCompletionBudget.AddParameter(new DBParameter("@State", DbType.String, ParameterDirection.Input, followUpCompletionBudget.StateCode)); this.AddStoredProcedure("UpdateObject", spUpdateFollowUpCompletionBudget); DBStoredProcedure spDeleteFollowUpCompletionBudget = new DBStoredProcedure(); spDeleteFollowUpCompletionBudget.ProcedureName = "bgtDeleteCompletionBudgetStates"; spDeleteFollowUpCompletionBudget.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, followUpCompletionBudget.IdProject)); spDeleteFollowUpCompletionBudget.AddParameter(new DBParameter("@BudVersion", DbType.String, ParameterDirection.Input, followUpCompletionBudget.BudVersion)); spDeleteFollowUpCompletionBudget.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, followUpCompletionBudget.IdAssociate)); this.AddStoredProcedure("DeleteObject", spDeleteFollowUpCompletionBudget); DBStoredProcedure spValidateCompletionBudget = new DBStoredProcedure(); spValidateCompletionBudget.ProcedureName = "bgtValidateCompletionBudget"; spValidateCompletionBudget.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, followUpCompletionBudget.IdProject)); spValidateCompletionBudget.AddParameter(new DBParameter("@BudVersion", DbType.String, ParameterDirection.Input, followUpCompletionBudget.BudVersion)); this.AddStoredProcedure("ValidateCompletionBudget", spValidateCompletionBudget); DBStoredProcedure spGetCompletionBudgetStateForEvidence = new DBStoredProcedure(); spGetCompletionBudgetStateForEvidence.ProcedureName = "bgtGetCompletionBudgetStateForEvidence"; spGetCompletionBudgetStateForEvidence.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, followUpCompletionBudget.IdProject)); spGetCompletionBudgetStateForEvidence.AddParameter(new DBParameter("@BudVersion", DbType.String, ParameterDirection.Input, followUpCompletionBudget.BudVersion)); spGetCompletionBudgetStateForEvidence.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, followUpCompletionBudget.IdAssociate)); this.AddStoredProcedure("GetCompletionBudgetStateForEvidence", spGetCompletionBudgetStateForEvidence); DBStoredProcedure spGetCompletionScalarValidState = new DBStoredProcedure(); spGetCompletionScalarValidState.ProcedureName = "bgtGetRevisedScalarValidState"; spGetCompletionScalarValidState.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, followUpCompletionBudget.IdProject)); spGetCompletionScalarValidState.AddParameter(new DBParameter("@BudVersion", DbType.String, ParameterDirection.Input, followUpCompletionBudget.BudVersion)); this.AddStoredProcedure("GetCompletionScalarValidState", spGetCompletionScalarValidState); DBStoredProcedure spGetCompletionBudgetValidState = new DBStoredProcedure(); spGetCompletionBudgetValidState.ProcedureName = "bgtGetInitialBudget_IsValidated"; spGetCompletionBudgetValidState.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, followUpCompletionBudget.IdProject)); spGetCompletionBudgetValidState.AddParameter(new DBParameter("@BudVersion", DbType.String, ParameterDirection.Input, followUpCompletionBudget.BudVersion)); this.AddStoredProcedure("GetCompletionBudgetValidState", spGetCompletionBudgetValidState); DBStoredProcedure spCopyCompletionBudget = new DBStoredProcedure(); spCopyCompletionBudget.ProcedureName = "bgtCopyToCompletionBudget"; spCopyCompletionBudget.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, followUpCompletionBudget.IdProject)); spCopyCompletionBudget.AddParameter(new DBParameter("@IdAssociateLM", DbType.Int32, ParameterDirection.Input, followUpCompletionBudget.IdAssociate)); spCopyCompletionBudget.AddParameter(new DBParameter("@IdAssociateNM", DbType.Int32, ParameterDirection.Input, followUpCompletionBudget.IdAssociateNM)); this.AddStoredProcedure("CopyCompletionBudget", spCopyCompletionBudget); } }
protected override void InitializeObject(IGenericEntity ent) { IGenericEntity CostIncomeType = ent; DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "catSelectCostIncomeType"; spSelect.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, CostIncomeType.Id)); this.AddStoredProcedure("SelectObject", spSelect); }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IAssociate) { IAssociate Associate = (IAssociate)ent; DBStoredProcedure spInsert = new DBStoredProcedure(); spInsert.ProcedureName = "catInsertAssociate"; spInsert.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, Associate.IdCountry)); spInsert.AddParameter(new DBParameter("@Name", DbType.String, ParameterDirection.Input, Associate.Name)); spInsert.AddParameter(new DBParameter("@EmployeeNumber", DbType.String, ParameterDirection.Input, Associate.EmployeeNumber)); spInsert.AddParameter(new DBParameter("@InergyLogin", DbType.String, ParameterDirection.Input, Associate.InergyLogin)); spInsert.AddParameter(new DBParameter("@IsActive", DbType.Boolean, ParameterDirection.Input, Associate.IsActive)); spInsert.AddParameter(new DBParameter("@IsSubcontractor", DbType.Boolean, ParameterDirection.Input, Associate.IsSubContractor)); spInsert.AddParameter(new DBParameter("@PercentageFullTime", DbType.Int32, ParameterDirection.Input, Associate.PercentageFullTime)); DBStoredProcedure spUpdate = new DBStoredProcedure(); spUpdate.ProcedureName = "catUpdateAssociate"; spUpdate.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Associate.Id)); spUpdate.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, Associate.IdCountry)); spUpdate.AddParameter(new DBParameter("@Name", DbType.String, ParameterDirection.Input, Associate.Name)); spUpdate.AddParameter(new DBParameter("@EmployeeNumber", DbType.String, ParameterDirection.Input, Associate.EmployeeNumber)); spUpdate.AddParameter(new DBParameter("@InergyLogin", DbType.String, ParameterDirection.Input, Associate.InergyLogin)); spUpdate.AddParameter(new DBParameter("@IsActive", DbType.Boolean, ParameterDirection.Input, Associate.IsActive)); spUpdate.AddParameter(new DBParameter("@IsSubcontractor", DbType.Boolean, ParameterDirection.Input, Associate.IsSubContractor)); spUpdate.AddParameter(new DBParameter("@PercentageFullTime", DbType.Int32, ParameterDirection.Input, Associate.PercentageFullTime)); DBStoredProcedure spDelete = new DBStoredProcedure(); spDelete.ProcedureName = "catDeleteAssociate"; spDelete.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Associate.Id)); spDelete.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, Associate.IdCountry)); this.AddStoredProcedure("InsertObject", spInsert); this.AddStoredProcedure("UpdateObject", spUpdate); this.AddStoredProcedure("DeleteObject", spDelete); DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "catSelectAssociate"; spSelect.AddParameter(new DBParameter("@Id", DbType.Int32, ParameterDirection.Input, Associate.Id)); spSelect.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, Associate.IdCountry)); this.AddStoredProcedure("SelectObject", spSelect); DBStoredProcedure spSelectActiveAssociates = new DBStoredProcedure(); spSelectActiveAssociates.ProcedureName = "catSelectActiveAssociates"; spSelectActiveAssociates.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, Associate.IdCountry)); this.AddStoredProcedure("SelectActiveAssociates", spSelectActiveAssociates); DBStoredProcedure spHasCurrentData = new DBStoredProcedure(); spHasCurrentData.ProcedureName = "bgtAssociateHasCurrentData"; spHasCurrentData.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, Associate.Id)); this.AddStoredProcedure("bgtAssociateHasCurrentData", spHasCurrentData); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IOlapHelper) { IOlapHelper olapHelper = (IOlapHelper)ent; DBStoredProcedure spUpdateEndYear = new DBStoredProcedure(); spUpdateEndYear.ProcedureName = "olapUpdateOlapPeriods"; this.AddStoredProcedure("UpdateOlapPeriods", spUpdateEndYear); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IAnnualDataStatus) { IAnnualDataStatus dataStatus = (IAnnualDataStatus)ent; DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "abgtSelectAnnualDataStatus"; this.AddStoredProcedure("SelectObject", spSelect); } }
public void AddParameterTest() { DBStoredProcedure storedProcedure = new DBStoredProcedure(); DBParameter parameter = new DBParameter("@Param", DbType.String, ParameterDirection.Input, "cici"); storedProcedure.AddParameter(parameter); Assert.AreEqual(1, storedProcedure.DBParameters.Count); Assert.AreEqual(true, storedProcedure.DBParameters.ContainsKey("@Param")); Assert.AreEqual(parameter, storedProcedure.DBParameters["@Param"]); }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IProjectFunction) { IProjectFunction projectFunction = (IProjectFunction)ent; DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "bgtSelectProjectFunctions"; this.AddStoredProcedure("SelectObject", spSelect); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is ICountry) { ICountry country = (ICountry)ent; DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "catSelectInergyCountry"; spSelect.AddParameter(new DBParameter("Id", DbType.Int32, ParameterDirection.Input, country.Id)); this.AddStoredProcedure("SelectObject", spSelect); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IHourlyRate) { IHourlyRate HourlyRate = (IHourlyRate)ent; DBStoredProcedure spInsert = new DBStoredProcedure(); spInsert.ProcedureName = "catInsertHourlyRate"; spInsert.AddParameter(new DBParameter("YearMonth", DbType.Int32, ParameterDirection.Input, (HourlyRate.YearMonth == ApplicationConstants.INT_NULL_VALUE) ? (object)DBNull.Value : (object)HourlyRate.YearMonth)); //spInsert.AddParameter(new DBParameter("IdCurrency", DbType.Int32, ParameterDirection.Input, HourlyRate.IdCurrency)); spInsert.AddParameter(new DBParameter("IdCostCenter", DbType.Int32, ParameterDirection.Input, HourlyRate.IdCostCenter)); spInsert.AddParameter(new DBParameter("Value", DbType.Decimal, ParameterDirection.Input, HourlyRate.Value)); DBStoredProcedure spUpdate = new DBStoredProcedure(); spUpdate.ProcedureName = "catUpdateHourlyRate"; spUpdate.AddParameter(new DBParameter("YearMonth", DbType.Int32, ParameterDirection.Input, (HourlyRate.YearMonth == ApplicationConstants.INT_NULL_VALUE) ? (object)DBNull.Value : (object)HourlyRate.YearMonth)); //spUpdate.AddParameter(new DBParameter("IdCurrency", DbType.Int32, ParameterDirection.Input, HourlyRate.IdCurrency)); spUpdate.AddParameter(new DBParameter("IdCostCenter", DbType.Int32, ParameterDirection.Input, HourlyRate.IdCostCenter)); spUpdate.AddParameter(new DBParameter("Value", DbType.Decimal, ParameterDirection.Input, HourlyRate.Value)); DBStoredProcedure spDelete = new DBStoredProcedure(); spDelete.ProcedureName = "catDeleteHourlyRate"; spDelete.AddParameter(new DBParameter("YearMonth", DbType.Int32, ParameterDirection.Input, (HourlyRate.YearMonth == ApplicationConstants.INT_NULL_VALUE) ? (object)DBNull.Value : (object)HourlyRate.YearMonth)); //spDelete.AddParameter(new DBParameter("IdCurrency", DbType.Int32, ParameterDirection.Input, HourlyRate.IdCurrency)); spDelete.AddParameter(new DBParameter("IdCostCenter", DbType.Int32, ParameterDirection.Input, HourlyRate.IdCostCenter)); this.AddStoredProcedure("InsertObject", spInsert); this.AddStoredProcedure("UpdateObject", spUpdate); this.AddStoredProcedure("DeleteObject", spDelete); DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "catSelectHourlyRate"; spSelect.AddParameter(new DBParameter("YearMonth", DbType.Int32, ParameterDirection.Input, (HourlyRate.YearMonth == ApplicationConstants.INT_NULL_VALUE) ? (object)DBNull.Value : (object)HourlyRate.YearMonth)); //spSelect.AddParameter(new DBParameter("IdCurrency", DbType.Int32, ParameterDirection.Input, HourlyRate.IdCurrency)); spSelect.AddParameter(new DBParameter("IdCostCenter", DbType.Int32, ParameterDirection.Input, HourlyRate.IdCostCenter)); spSelect.AddParameter(new DBParameter("IdCountry", DbType.Int32, ParameterDirection.Input, HourlyRate.IdCountry)); this.AddStoredProcedure("SelectObject", spSelect); DBStoredProcedure spMassAttribution = new DBStoredProcedure(); spMassAttribution.ProcedureName = "catMassInsertOrUpdateHourlyRate"; spMassAttribution.AddParameter(new DBParameter("IdInergyLocation", DbType.Int32, ParameterDirection.Input, HourlyRate.IdInergyLocation)); //spMassAttribution.AddParameter(new DBParameter("IdCurrency", DbType.Int32, ParameterDirection.Input, HourlyRate.IdCurrency)); spMassAttribution.AddParameter(new DBParameter("StartYearMonth", DbType.Int32, ParameterDirection.Input, (HourlyRate.StartYearMonth == ApplicationConstants.INT_NULL_VALUE) ? (object)DBNull.Value : (object)HourlyRate.StartYearMonth)); spMassAttribution.AddParameter(new DBParameter("EndYearMonth", DbType.Int32, ParameterDirection.Input, (HourlyRate.EndYearMonth == ApplicationConstants.INT_NULL_VALUE) ? (object)DBNull.Value : (object)HourlyRate.EndYearMonth)); spMassAttribution.AddParameter(new DBParameter("Value", DbType.Decimal, ParameterDirection.Input, HourlyRate.Value)); this.AddStoredProcedure("MassAttribution", spMassAttribution); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IExchangeRates) { IExchangeRates exchangeRates = (IExchangeRates)ent; DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "catSelectExchangeRates"; spSelect.AddParameter(new DBParameter("@Year", DbType.Int32, ParameterDirection.Input, exchangeRates.Year)); this.AddStoredProcedure("SelectObject", spSelect); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IConverter) { IConverter converter = (IConverter)ent; DBStoredProcedure spSelectExchangeRate = new DBStoredProcedure(); spSelectExchangeRate.ProcedureName = "bgtSelectExchangeRateForConverter"; spSelectExchangeRate.AddParameter(new DBParameter("@Currency", DbType.Int32, ParameterDirection.Input, converter.Currency)); spSelectExchangeRate.AddParameter(new DBParameter("@YearMonth", DbType.Int32, ParameterDirection.Input, converter.YearMonth)); this.AddStoredProcedure("bgtSelectExchangeRateForConverter", spSelectExchangeRate); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IDataStatus) { IDataStatus dataStatus = (IDataStatus)ent; DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "impSelectDataStatus"; spSelect.AddParameter(new DBParameter("@Year", DbType.Int32, ParameterDirection.Input, dataStatus.Year)); this.AddStoredProcedure("SelectObject", spSelect); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IAnnualDownload) { IAnnualDownload extract = (IAnnualDownload)ent; DBStoredProcedure spSelectData = new DBStoredProcedure(); spSelectData.ProcedureName = "abgtExtractFromReforcastAndActualData"; spSelectData.AddParameter(new DBParameter("@IdCountry", DbType.Int32, ParameterDirection.Input, extract.IdCountry)); spSelectData.AddParameter(new DBParameter("@IdInergyLocation", DbType.Int32, ParameterDirection.Input, extract.IdInergyLocation)); spSelectData.AddParameter(new DBParameter("@Year", DbType.Int32, ParameterDirection.Input, extract.Year)); this.AddStoredProcedure("ExtractFromReforcastAndActualData", spSelectData); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is ICurrentProject) { ICurrentProject currentProject = (ICurrentProject)ent; DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "fltProjectSelectorProjects"; spSelect.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, currentProject.IdAssociate)); spSelect.AddParameter(new DBParameter("@IdOwner", DbType.Int32, ParameterDirection.Input, currentProject.IdOwner)); spSelect.AddParameter(new DBParameter("@IdProgram", DbType.Int32, ParameterDirection.Input, currentProject.IdProgram)); spSelect.AddParameter(new DBParameter("@ShowOnly", DbType.String, ParameterDirection.Input, currentProject.ShowOnly)); this.AddStoredProcedure("SelectObject", spSelect); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is ICurrencyConverter) { ICurrencyConverter converter = (ICurrencyConverter)ent; DBStoredProcedure spFillExchangeRateCache = new DBStoredProcedure(); spFillExchangeRateCache.ProcedureName = "bgtFillExchangeRateCache"; spFillExchangeRateCache.AddParameter(new DBParameter("@CurrencyFrom", DbType.Int32, ParameterDirection.Input, converter.CurrencyFrom)); spFillExchangeRateCache.AddParameter(new DBParameter("@CurrencyTo", DbType.Int32, ParameterDirection.Input, converter.CurrencyTo)); spFillExchangeRateCache.AddParameter(new DBParameter("@StartYearMonth", DbType.Int32, ParameterDirection.Input, converter.StartYearMonth.Value)); spFillExchangeRateCache.AddParameter(new DBParameter("@EndYearMonth", DbType.Int32, ParameterDirection.Input, converter.EndYearMonth.Value)); this.AddStoredProcedure("FillExchangeRateCache", spFillExchangeRateCache); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IExchangeRate) { IExchangeRate exchangeRate = (IExchangeRate)ent; DBStoredProcedure spUpdate = new DBStoredProcedure(); spUpdate.ProcedureName = "catUpdateBudgetExchangeRate"; spUpdate.AddParameter(new DBParameter("@IdCategory", DbType.Int32, ParameterDirection.Input, exchangeRate.IdCategory)); spUpdate.AddParameter(new DBParameter("@Year", DbType.Int32, ParameterDirection.Input, exchangeRate.Year)); spUpdate.AddParameter(new DBParameter("@Rate", DbType.Decimal, ParameterDirection.Input, exchangeRate.Value)); spUpdate.AddParameter(new DBParameter("@IdCurrency", DbType.Decimal, ParameterDirection.Input, exchangeRate.IdCurrency)); this.AddStoredProcedure("UpdateObject", spUpdate); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IProjectCoreTeamMember) { IProjectCoreTeamMember projectCoreTeamMember = (IProjectCoreTeamMember)ent; DBStoredProcedure spInsert = new DBStoredProcedure(); spInsert.ProcedureName = "bgtInsertProjectCoreTeam"; spInsert.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdProject)); spInsert.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdAssociate)); spInsert.AddParameter(new DBParameter("@IdFunction", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdFunction)); spInsert.AddParameter(new DBParameter("@IsActive", DbType.Boolean, ParameterDirection.Input, projectCoreTeamMember.IsActive)); DBStoredProcedure spUpdate = new DBStoredProcedure(); spUpdate.ProcedureName = "bgtUpdateProjectCoreTeam"; spUpdate.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdProject)); spUpdate.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdAssociate)); spUpdate.AddParameter(new DBParameter("@IdFunction", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdFunction)); spUpdate.AddParameter(new DBParameter("@IsActive", DbType.Boolean, ParameterDirection.Input, projectCoreTeamMember.IsActive)); DBStoredProcedure spDelete = new DBStoredProcedure(); spDelete.ProcedureName = "bgtDeleteProjectCoreTeam"; spDelete.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdProject)); spDelete.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdAssociate)); spDelete.AddParameter(new DBParameter("@IdFunction", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdFunction)); this.AddStoredProcedure("InsertObject", spInsert); this.AddStoredProcedure("UpdateObject", spUpdate); this.AddStoredProcedure("DeleteObject", spDelete); DBStoredProcedure spSelect = new DBStoredProcedure(); spSelect.ProcedureName = "bgtSelectProjectCoreTeam"; spSelect.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdProject)); spSelect.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdAssociate)); this.AddStoredProcedure("SelectObject", spSelect); DBStoredProcedure spSelectOpenBudgets = new DBStoredProcedure(); spSelectOpenBudgets.ProcedureName = "bgtProjectCoreTeamSelectOpenBudgets"; spSelectOpenBudgets.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdProject)); spSelectOpenBudgets.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdAssociate)); this.AddStoredProcedure("GetOpenBudgets", spSelectOpenBudgets); DBStoredProcedure spIsAssociatePMOnProject = new DBStoredProcedure(); spIsAssociatePMOnProject.ProcedureName = "bgtIsAssociatePMOnProject"; spIsAssociatePMOnProject.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdProject)); spIsAssociatePMOnProject.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, projectCoreTeamMember.IdAssociate)); this.AddStoredProcedure("IsAssociatePMOnProject", spIsAssociatePMOnProject); } }
protected override void InitializeObject(IGenericEntity ent) { if (ent is IRevisedBudgetOtherCosts) { IRevisedBudgetOtherCosts budgetOtherCosts = (IRevisedBudgetOtherCosts)ent; DBStoredProcedure spGetBudgetRevisedOtherCosts = new DBStoredProcedure(); spGetBudgetRevisedOtherCosts.ProcedureName = "bgtGetRevisedBudgetOtherCosts"; spGetBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdProject)); spGetBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdPhase", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdPhase)); spGetBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdWP", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdWP)); spGetBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdCostCenter", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdCostCenter)); spGetBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdAssociate)); spGetBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdAssociateViewer", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdAssociateViewer)); spGetBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IsAssociateCurrency", DbType.Boolean, ParameterDirection.Input, budgetOtherCosts.IsAssociateCurrency)); this.AddStoredProcedure("SelectObject", spGetBudgetRevisedOtherCosts); DBStoredProcedure spInsertBudgetRevisedOtherCosts = new DBStoredProcedure(); spInsertBudgetRevisedOtherCosts.ProcedureName = "bgtInsertRevisedBudgetOtherCosts"; spInsertBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdProject)); spInsertBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdPhase", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdPhase)); spInsertBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdWP", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdWP)); spInsertBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdCostCenter", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdCostCenter)); spInsertBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdAssociate)); spInsertBudgetRevisedOtherCosts.AddParameter(new DBParameter("@YearMonth", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.YearMonth)); spInsertBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdCostType", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdCostType)); this.AddStoredProcedure("InsertObject", spInsertBudgetRevisedOtherCosts); DBStoredProcedure spUpdateBudgetRevisedOtherCosts = new DBStoredProcedure(); spUpdateBudgetRevisedOtherCosts.ProcedureName = "bgtUpdateRevisedBudgetOtherCosts"; spUpdateBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdProject", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdProject)); spUpdateBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdPhase", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdPhase)); spUpdateBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdWP", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdWP)); spUpdateBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdCostCenter", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdCostCenter)); spUpdateBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdAssociate", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdAssociate)); spUpdateBudgetRevisedOtherCosts.AddParameter(new DBParameter("@YearMonth", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.YearMonth)); spUpdateBudgetRevisedOtherCosts.AddParameter(new DBParameter("@IdCostType", DbType.Int32, ParameterDirection.Input, budgetOtherCosts.IdCostType)); if (budgetOtherCosts.CostVal != ApplicationConstants.DECIMAL_NULL_VALUE) { spUpdateBudgetRevisedOtherCosts.AddParameter(new DBParameter("@CostVal", DbType.Decimal, ParameterDirection.Input, budgetOtherCosts.CostVal)); } else { spUpdateBudgetRevisedOtherCosts.AddParameter(new DBParameter("@CostVal", DbType.Decimal, ParameterDirection.Input, DBNull.Value)); } this.AddStoredProcedure("UpdateObject", spUpdateBudgetRevisedOtherCosts); } }