protected Boolean ProcessIntersectionSet(String forStatement, Boolean outputStep)
{
Boolean success = true;
String procedureStatement = String.Empty;
Int32 currentPass = 0;
Int64 currentRowIndex = 0;
System.Data.DataTable memberServiceTable = new System.Data.DataTable();
System.Diagnostics.Debug.WriteLine("\r\n\r\n ----- " + Name + " -----");
try {
do
{
currentPass = currentPass + 1;
if (String.IsNullOrEmpty(forStatement))
{
procedureStatement = String.Empty;
procedureStatement = procedureStatement + IntersectionSetMemberServiceSql();
procedureStatement = procedureStatement + IntersectionSetMemberServiceSortedSql();
procedureStatement = procedureStatement + IntersectionSetMemberServiceFilteredSql();
}
else
{
procedureStatement = forStatement;
}
System.Diagnostics.Debug.WriteLine(procedureStatement);
if (outputStep)
{
base.ProcessStep_StartStep("Service Set", Name + ": " + currentPass, procedureStatement);
}
memberServiceTable = base.application.EnvironmentDatabase.SelectDataTable(procedureStatement, 86400);
if (base.application.EnvironmentDatabase.LastException != null)
{
throw base.application.EnvironmentDatabase.LastException;
}
currentRowIndex = 0;
foreach (System.Data.DataRow currentRow in memberServiceTable.Rows)
{
currentRowIndex = currentRowIndex + 1;
MemberService memberService = new MemberService(application);
memberService.MemberId = (Int64)currentRow["MemberId"];
memberService.ServiceId = Id;
memberService.EventDate = (DateTime)currentRow["EventDate"];
memberService.AddedManually = false;
success = memberService.Save(base.application);
if (success)
{
for (Int32 currentDefinition = 1; currentDefinition <= ActiveDefinitions.Count; currentDefinition++)
{
String fieldPrefix = "Service" + currentDefinition.ToString() + "_";
// THE BELOW SHOULD BE COLUMN "SetDefinitionId" VERSUS "ServiceSetDefinitionId" FROM DYNAMIC SQL
MemberServiceDetailSet memberServiceDetail = new MemberServiceDetailSet(memberService.Id, (Int64)currentRow[fieldPrefix + "SetDefinitionId"]);
memberServiceDetail.MemberId = memberService.MemberId;
memberServiceDetail.DetailMemberServiceId = (Int64)currentRow[fieldPrefix + "MemberServiceId"];
memberServiceDetail.EventDate = (DateTime)currentRow[fieldPrefix + "EventDate"];
memberServiceDetail.ParentServiceId = Id;
memberServiceDetail.ServiceId = (Int64)currentRow[fieldPrefix + "ServiceId"];
memberServiceDetail.ServiceName = (String)currentRow[fieldPrefix + "ServiceName"];
memberServiceDetail.ServiceType = (Mercury.Server.Core.MedicalServices.Enumerations.MedicalServiceType)(Int32) currentRow[fieldPrefix + "ServiceType"];
success = memberServiceDetail.Save(base.application);
if (!success)
{
break;
}
}
}
}
if (outputStep)
{
base.ProcessStep_StopStep((success) ? "Success: " + memberServiceTable.Rows.Count.ToString() : "Failure", "");
}
if (!success)
{
break;
}
} while (memberServiceTable.Rows.Count != 0);
}
catch (Exception executionException) {
success = false;
base.application.SetLastException(executionException);
if (outputStep)
{
base.ProcessStep_StopStep((success) ? "Success: " + memberServiceTable.Rows.Count.ToString() : "Failure", executionException.Message);
}
}
return(success);
}
public Boolean Process()
{
Boolean success = true;
String selectStatement = String.Empty;
System.Data.DataTable resultsTable;
Int64 memberServiceId;
MemberService memberService;
MemberServiceDetailSet memberServiceDetail;
if (!Enabled)
{
return(false);
}
base.ProcessLog_StartProcess();
switch (SetType)
{
case Mercury.Server.Core.MedicalServices.Enumerations.ServiceSetType.Union:
#region Union Set
foreach (MedicalServices.Definitions.ServiceSetDefinition currentDefinition in ActiveDefinitions)
{
if (currentDefinition.Enabled)
{
selectStatement = currentDefinition.SqlStatement;
if (!String.IsNullOrEmpty(selectStatement))
{
resultsTable = base.application.EnvironmentDatabase.SelectDataTable(selectStatement, 0);
foreach (System.Data.DataRow currentRow in resultsTable.Rows)
{
memberServiceId = base.application.MemberServiceGetId((Int64)currentRow["MemberId"], Id, (DateTime)currentRow["EventDate"]);
if (memberServiceId == 0)
{
memberService = new MemberService(application);
memberService.MemberId = (Int64)currentRow["MemberId"];
memberService.ServiceId = Id;
memberService.EventDate = (DateTime)currentRow["EventDate"];
memberService.AddedManually = false;
success = memberService.Save(base.application);
memberServiceId = memberService.Id;
}
if ((success) && (memberServiceId != 0))
{
memberServiceDetail = new MemberServiceDetailSet(memberServiceId, currentDefinition.Id);
memberServiceDetail.MapDataFields(currentRow);
success = memberServiceDetail.Save(base.application);
}
if (!success)
{
break;
}
}
}
}
if (!success)
{
break;
}
}
#endregion
break;
case Mercury.Server.Core.MedicalServices.Enumerations.ServiceSetType.Intersection:
if (definitions.Count >= 4)
{
success = ProcessIntersectionSetLarge();
}
else
{
success = ProcessIntersectionSet(String.Empty, true);
}
break;
}
base.ProcessLog_StopProcess((success) ? "Success" : "Failure", "");
return(success);
}
public List <MemberServiceDetailSet> Preview(Application application)
{
List <MemberServiceDetailSet> previewResults = new List <MemberServiceDetailSet> ();
MemberServiceDetailSet detailResult;
System.Data.DataTable resultsTable;
String sqlStatement = String.Empty;
String identifiedMemberServices = String.Empty;
switch (SetType)
{
case Mercury.Server.Core.MedicalServices.Enumerations.ServiceSetType.Union:
#region Union Set
foreach (MedicalServices.Definitions.ServiceSetDefinition currentDefinition in ActiveDefinitions)
{
if (currentDefinition.Enabled)
{
if (sqlStatement != String.Empty)
{
sqlStatement = sqlStatement + "\r\n UNION ";
}
sqlStatement = sqlStatement + currentDefinition.SqlStatement;
}
}
if (!String.IsNullOrEmpty(sqlStatement))
{
sqlStatement = sqlStatement.Replace("SELECT", "SELECT TOP 10");
sqlStatement = sqlStatement.Replace("LEFT JOIN MemberServiceDetailSet ON MemberService.MemberServiceId = MemberServiceDetailSet.MemberServiceId", "");
sqlStatement = sqlStatement.Replace("AND MemberServiceDetailSet.ParentServiceId = " + Id.ToString(), "");
sqlStatement = sqlStatement.Replace("AND MemberServiceDetailSet.MemberServiceId IS NULL", "");
resultsTable = base.application.EnvironmentDatabase.SelectDataTable(sqlStatement, 0);
foreach (System.Data.DataRow currentRow in resultsTable.Rows)
{
detailResult = new MemberServiceDetailSet(0, (Int64)currentRow ["ServiceSetDefinitionId"]);
detailResult.MapDataFields(currentRow);
previewResults.Add(detailResult);
}
}
#endregion
break;
case Mercury.Server.Core.MedicalServices.Enumerations.ServiceSetType.Intersection:
#region Intersection Set
String virtualJoinTables = String.Empty;
sqlStatement = IntersectionSqlStatement(out virtualJoinTables);
sqlStatement = "SELECT TOP 10 " + sqlStatement.Substring(6, sqlStatement.Length - 6);
resultsTable = base.application.EnvironmentDatabase.SelectDataTable(sqlStatement, 0);
foreach (System.Data.DataRow currentRow in resultsTable.Rows)
{
Int64 memberId = (Int64)currentRow ["MemberServiceMemberId"];
DateTime maxEventDate = new DateTime(1900, 1, 1);
String uniqueServiceKey;
foreach (String currentTable in virtualJoinTables.Split(';'))
{
if (maxEventDate < ((DateTime)currentRow [currentTable + "EventDate"]))
{
maxEventDate = (DateTime)currentRow [currentTable + "EventDate"];
}
}
uniqueServiceKey = memberId.ToString() + ":" + maxEventDate.ToString("MM/dd/yyyy");
if (!identifiedMemberServices.Contains(uniqueServiceKey))
{
identifiedMemberServices = identifiedMemberServices + uniqueServiceKey + "|";
foreach (String currentTable in virtualJoinTables.Split(';'))
{
detailResult = new MemberServiceDetailSet(memberId, (Int64)currentRow[currentTable + "ServiceSetDefinitionId"]);
detailResult.MemberId = memberId;
detailResult.DetailMemberServiceId = (Int64)currentRow[currentTable + "DetailMemberServiceId"];
detailResult.EventDate = (DateTime)currentRow[currentTable + "EventDate"];
detailResult.ServiceId = (Int64)currentRow[currentTable + "ServiceId"];
detailResult.ServiceName = (String)currentRow[currentTable + "ServiceName"];
detailResult.ServiceType = (Mercury.Server.Core.MedicalServices.Enumerations.MedicalServiceType)(Int32) currentRow[currentTable + "ServiceType"];
previewResults.Add(detailResult);
}
}
}
#endregion
break;
}
return(previewResults);
}