public override Int32 Execute()
{
Int32 rowCount = 0;
System.Data.IDbCommand sqlCommand = application.EnvironmentDatabase.CreateCommand("dal.DataExplorerNodeEvaluation_MemberService_Execute");
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@nodeInstanceId", NodeInstanceId);
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@serviceId", ServiceId);
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@countOf", CountOf);
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@useAgeCriteria", ageCriteria.UseAgeCriteria);
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@ageMinimum", ageCriteria.AgeMinimum);
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@ageMaximum", ageCriteria.AgeMaximum);
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@ageQualifier", ((Int32)ageCriteria.AgeQualifier));
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@startDate", dateCriteria.CalculateStartDate());
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@endDate", dateCriteria.CalculateEndDate());
// RETURNED ROWS AFFECTED
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@rowCount", ((Int32)0));
((System.Data.IDbDataParameter)sqlCommand.Parameters["@rowCount"]).Direction = System.Data.ParameterDirection.Output;
sqlCommand.CommandTimeout = 0;
sqlCommand.ExecuteNonQuery();
rowCount = Convert.ToInt32(((System.Data.IDbDataParameter)sqlCommand.Parameters["@rowCount"]).Value);
return(rowCount);
}
public override Int32 Execute()
{
Int32 rowCount = 0;
System.Data.IDbCommand sqlCommand = application.EnvironmentDatabase.CreateCommand("dal.DataExplorerNodeEvaluation_MemberEnrollment_Execute");
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@nodeInstanceId", NodeInstanceId);
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@insurerId", InsurerId);
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@programId", ProgramId);
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@benefitPlanId", BenefitPlanId);
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@continuousEnrollment", ContinuousEnrollment);
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@continuousAllowedGaps", ContinuousAllowedGaps);
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@continuousAllowedGapDays", ContinuousAllowedGapDays);
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@startDate", dateCriteria.CalculateStartDate());
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@endDate", dateCriteria.CalculateEndDate());
// RETURNED ROWS AFFECTED
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@rowCount", ((Int32)0));
((System.Data.IDbDataParameter)sqlCommand.Parameters["@rowCount"]).Direction = System.Data.ParameterDirection.Output;
sqlCommand.CommandTimeout = 0;
sqlCommand.ExecuteNonQuery();
rowCount = Convert.ToInt32(((System.Data.IDbDataParameter)sqlCommand.Parameters["@rowCount"]).Value);
return(rowCount);
}
public override Int32 Execute()
{
Int32 rowCount = 0;
System.Data.IDbCommand sqlCommand = application.EnvironmentDatabase.CreateCommand("dal.DataExplorerNodeEvaluation_PopulationMembership_Execute");
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@nodeInstanceId", NodeInstanceId);
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@populationId", ((populationEvaluationType == Enumerations.DataExplorerNodeEvaluationPopulationEvaluationType.Population) ? populationId : 0));
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@populationTypeId", ((populationEvaluationType == Enumerations.DataExplorerNodeEvaluationPopulationEvaluationType.PopulationType) ? populationTypeId : 0));
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@startDate", dateCriteria.CalculateStartDate());
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@endDate", dateCriteria.CalculateEndDate());
// RETURNED ROWS AFFECTED
application.EnvironmentDatabase.AppendCommandParameter(sqlCommand, "@rowCount", ((Int32)0));
((System.Data.IDbDataParameter)sqlCommand.Parameters["@rowCount"]).Direction = System.Data.ParameterDirection.Output;
sqlCommand.CommandTimeout = 0;
sqlCommand.ExecuteNonQuery();
rowCount = Convert.ToInt32(((System.Data.IDbDataParameter)sqlCommand.Parameters["@rowCount"]).Value);
return(rowCount);
}