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