/// <summary>
/// Builds the new Entity from the data entered by the user
/// </summary>
/// <returns></returns>
private IGenericEntity BuildUpdatedEntity()
{
IGenericEntity newEntity = _Entity;
IGenericCatWebControl ctl;
foreach (PropertyInfo entityProperty in PropertyToControlDictionary.Keys)
{
ctl = PropertyToControlDictionary[entityProperty];
if (String.IsNullOrEmpty(ctl.GetValue().ToString()) && entityProperty.PropertyType == typeof(DateTime))
{
entityProperty.SetValue(newEntity, DateTime.Now, null);
continue;
}
entityProperty.SetValue(newEntity,
Convert.ChangeType(ctl.GetValue(), entityProperty.PropertyType),
null);
}
//HACK
if (newEntity is ProjectCoreTeamMember && ((ProjectCoreTeamMember)newEntity).IdAssociate == ApplicationConstants.INT_NULL_VALUE)
{
Associate associate = (Associate)SessionManager.GetSessionValueRedirect(ParentPage, SessionStrings.CORE_TEAM_ASSOCIATE);
((ProjectCoreTeamMember)newEntity).IdAssociate = (associate == null) ? ApplicationConstants.INT_NULL_VALUE : associate.Id;
}
if (newEntity is Project && ((Project)newEntity).IdAssociate == ApplicationConstants.INT_NULL_VALUE)
{
CurrentUser currentUser = (CurrentUser)SessionManager.GetSessionValueRedirect((IndBasePage)this.Page, SessionStrings.CURRENT_USER);
((Project)newEntity).IdAssociate = (currentUser == null) ? ApplicationConstants.INT_NULL_VALUE : currentUser.IdAssociate;
}
_ParentGenericUserControl.SetAdditionalProperties(newEntity);
return(newEntity);
}
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 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 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);
}
}
public void SetDataSource(object[] attributes)
{
try
{
ReferenceMappingAttribute attribute = attributes[0] as ReferenceMappingAttribute;
if (attribute == null)
{
throw new IndException(ApplicationMessages.EXCEPTION_WRONG_ATTRIBUTE_RECEIVED);
}
IGenericEntity referencedEntity = EntityFactory.GetEntityInstance(attribute.ReferencedEntity, SessionManager.GetSessionValueNoRedirect((IndBasePage)this.Page, SessionStrings.CONNECTION_MANAGER));
//Call the GetAll() method of the referenced object
DataSet referencedDataSet = referencedEntity.GetAll();
DSUtils.AddEmptyRecord(referencedDataSet.Tables[0]);
//Set the DataSource, DataMember, DataValueField and DataTextField of the combobox
this.DataSource = referencedDataSet;
this.DataMember = referencedDataSet.Tables[0].TableName;
this.DataBind();
this.SelectedValue = ApplicationConstants.INT_NULL_VALUE.ToString();
}
catch (IndException ex)
{
ControlHierarchyManager.ReportError(ex);
return;
}
catch (Exception ex)
{
ControlHierarchyManager.ReportError(new IndException(ex));
return;
}
}
public void SaveEntity()
{
try
{
//Get the new entity (based on the data entered by the user) which will be saved
IGenericEntity newEntity = BuildUpdatedEntity();
if (_EditMode)
{
newEntity.SetModified();
}
else
{
newEntity.SetNew();
}
newEntity.Save();
if (!Page.ClientScript.IsClientScriptBlockRegistered(this.GetType(), "ButtonClickScript"))
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "ButtonClickScript", "window.returnValue = 1; window.close();", true);
}
}
catch (IndException exc)
{
ShouldContinue = false;
_ParentGenericUserControl.ReportControlError(exc);
return;
}
catch (Exception ex)
{
ShouldContinue = false;
_ParentGenericUserControl.ReportControlError(new IndException(ex));
return;
}
}
/// <summary>
/// xecutes a custom stored procedure and returns the number of rows affected
/// </summary>
/// <param name="procedureName"></param>
/// <param name="ent"></param>
/// <returns>the number of rows affected</returns>
public int ExecuteCustomProcedure(string procedureName, IGenericEntity ent)
{
int rowsAffected;
storedProcedures.Clear();
InitializeObject(ent);
if (!storedProcedures.ContainsKey(procedureName))
{
throw new NotImplementedException(ApplicationMessages.MessageWithParameters(ApplicationMessages.EXCEPTION_IMPLEMENT, procedureName));
}
DBStoredProcedure insertSP = storedProcedures[procedureName];
SqlCommand cmd = insertSP.GetSqlCommand();
try
{
rowsAffected = CurrentConnectionManager.ExecuteStoredProcedure(cmd);
}
catch (SqlException exc)
{
throw new IndException(exc);
}
return(rowsAffected);
}
public virtual DataSet SelectObject(IGenericEntity ent)
{
storedProcedures.Clear();
InitializeObject(ent);
if (!storedProcedures.ContainsKey("SelectObject"))
{
throw new NotImplementedException(ApplicationMessages.EXCEPTION_IMPLEMENT_SELECTOBJECT);
}
DBStoredProcedure selectSP = storedProcedures["SelectObject"];
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 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)
{
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);
}
}
public virtual int DeleteObject(IGenericEntity ent)
{
storedProcedures.Clear();
InitializeObject(ent);
if (!storedProcedures.ContainsKey("DeleteObject"))
{
throw new NotImplementedException(ApplicationMessages.EXCEPTION_IMPLEMENT_DELETEOBJECT);
}
DBStoredProcedure deleteSP = storedProcedures["DeleteObject"];
SqlCommand cmd = deleteSP.GetSqlCommand();
SqlParameter returnParameter = cmd.Parameters.Add("RETURN_VALUE", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
try
{
CurrentConnectionManager.ExecuteStoredProcedure(cmd);
}
catch (SqlException exc)
{
throw new IndException(exc);
}
return((int)cmd.Parameters["RETURN_VALUE"].Value);
}
/// <summary>
/// Generic method used to insert an IGenericEntity to the database
/// </summary>
/// <param name="ent">the entity to be inserted</param>
/// <returns>the return value from the stored procedure</returns>
public virtual int InsertObject(IGenericEntity ent)
{
//Clear the stored procedures dictionary
storedProcedures.Clear();
InitializeObject(ent);
//If the insert stpred procedure does not exist, throw exception
if (!storedProcedures.ContainsKey("InsertObject"))
{
throw new NotImplementedException(ApplicationMessages.EXCEPTION_IMPLEMENT_INSERTOBJECT);
}
DBStoredProcedure insertSP = storedProcedures["InsertObject"];
SqlCommand cmd = insertSP.GetSqlCommand();
SqlParameter returnParameter = cmd.Parameters.Add("RETURN_VALUE", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
try
{
CurrentConnectionManager.ExecuteStoredProcedure(cmd);
}
catch (SqlException exc)
{
throw new IndException(exc);
}
return((int)cmd.Parameters["RETURN_VALUE"].Value);
}
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);
}
}
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 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 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 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);
}
}
public override void SetAdditionalProperties(IGenericEntity entity)
{
try
{
IWorkPackageTemplate WorkPackageTemplate = (IWorkPackageTemplate)entity;
//read from session the needed values
CurrentUser currentUser = (CurrentUser)SessionManager.GetSessionValueNoRedirect((IndBasePage)this.Page, SessionStrings.CURRENT_USER);
ApplicationSettings appSettings = (ApplicationSettings)SessionManager.GetSessionValueNoRedirect((IndBasePage)this.Page, SessionStrings.APPLICATION_SETTINGS);
base.SetViewEntityProperties(entity);
WorkPackageTemplate.IdLastUserUpdate = currentUser.IdAssociate;
WorkPackageTemplate.LastUserUpdate = currentUser.AssociateName;
WorkPackageTemplate.SetSettings(appSettings);
}
catch (IndException ex)
{
ReportControlError(ex);
return;
}
catch (Exception ex)
{
ReportControlError(new IndException(ex));
return;
}
}
public DataSet GetCustomDataSet(string procedureName, IGenericEntity ent)
{
storedProcedures.Clear();
InitializeObject(ent);
if (!storedProcedures.ContainsKey(procedureName))
{
throw new NotImplementedException(ApplicationMessages.MessageWithParameters(ApplicationMessages.EXCEPTION_IMPLEMENT, procedureName));
}
DBStoredProcedure insertSP = storedProcedures[procedureName];
SqlCommand cmd = insertSP.GetSqlCommand();
DataSet returnDS = null;
try
{
returnDS = CurrentConnectionManager.GetDataSet(cmd);
}
catch (SqlException exc)
{
throw new IndException(exc);
}
return(returnDS);
}
/// <summary>
/// Executes a custom stored procedure and returns the SP return value
/// </summary>
/// <param name="procedureName"></param>
/// <param name="ent"></param>
/// <returns>the stored procedure returned value</returns>
public int ExecuteCustomProcedureWithReturnValue(string procedureName, IGenericEntity ent)
{
storedProcedures.Clear();
InitializeObject(ent);
if (!storedProcedures.ContainsKey(procedureName))
{
throw new NotImplementedException(ApplicationMessages.MessageWithParameters(ApplicationMessages.EXCEPTION_IMPLEMENT, procedureName));
}
DBStoredProcedure insertSP = storedProcedures[procedureName];
SqlCommand cmd = insertSP.GetSqlCommand();
SqlParameter returnParameter = cmd.Parameters.Add("RETURN_VALUE", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
try
{
CurrentConnectionManager.ExecuteStoredProcedure(cmd);
}
catch (SqlException exc)
{
throw new IndException(exc);
}
return((int)cmd.Parameters["RETURN_VALUE"].Value);
}
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);
}
}
public void SetDataSource(object[] attributes)
{
try
{
if (attributes.Length == 0)
{
return;
}
ReferenceMappingAttribute attribute = attributes[0] as ReferenceMappingAttribute;
if (attribute == null)
{
return;
}
IGenericEntity referencedEntity = EntityFactory.GetEntityInstance(attribute.ReferencedEntity, SessionManager.GetSessionValueNoRedirect((IndBasePage)this.Page, SessionStrings.CONNECTION_MANAGER));
DataRow referencedDataRow = referencedEntity.SelectNew();
this.SetValue(referencedDataRow["Rank"]);
}
catch (IndException ex)
{
ControlHierarchyManager.ReportError(ex);
return;
}
catch (Exception ex)
{
ControlHierarchyManager.ReportError(new IndException(ex));
return;
}
}
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);
}
}
private void FillEntityDataFromDB()
{
if (_EditMode)
{
DataRow row = _Entity.SelectEntity();
this._Entity = EntityFactory.GetEntityInstance(_Entity.GetType(), row, SessionManager.GetSessionValueNoRedirect((IndPopUpBasePage)this.Page, SessionStrings.CONNECTION_MANAGER));
}
}
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);
}
public void Retain(IGenericEntity genericEntity)
{
if (!ReferenceCountMap.ContainsKey(genericEntity))
{
ReferenceCountMap[genericEntity] = 0;
}
ReferenceCountMap[genericEntity]++;
}
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 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 IAnnualDataStatus)
{
IAnnualDataStatus dataStatus = (IAnnualDataStatus)ent;
DBStoredProcedure spSelect = new DBStoredProcedure();
spSelect.ProcedureName = "abgtSelectAnnualDataStatus";
this.AddStoredProcedure("SelectObject", spSelect);
}
}
