public void Start()
{
var logResult = SSISLOGDBManager.LogPackageStart("eConciergeETL_Driver");
var BatchLogID = logResult["BatchLogID"];
var PackageLogID = logResult["PackageLogID"];
var EndBatchAudit = logResult["EndBatchAudit"];
CRMDBManager.UpdateRateTypeDictionary();
CRMDBManager.UpdateRoomTypeDictionary();
CRMDBManager.UpdateChannelCodeDictionary();
CRMDBManager.UpdateRoomCodeDictionary();
if ("1".Equals(CompanySettings.BringRateTypeDescFromCenRes) && CompanySettings.CompanyID == "7375")
{
DataDictionaryDataFlowTaskManager.DFT_MoveRateTypeDataForBiltmore();
DataDictionaryDataFlowTaskManager.DFT_UpdateShowAlphaCodeData();
CRMDBManager.UpdateNotesForRateType();
}
if (CompanySettings.CompanyID == "8012")
{
CRMDBManager.UpdateTargetTableName1AndTargetFieldName1ForRateType();
}
if (CompanySettings.CompanyID == "12960")
{
DataDictionaryDataFlowTaskManager.DFT_MoveRateTypeDataForSHGroup();
DataDictionaryDataFlowTaskManager.DFT_MoveRoomTypeDataForSHGroup();
}
if (CompanySettings.CompanyID == "12951")
{
DataDictionaryDataFlowTaskManager.DFT_MoveRateTypeDataFor12951();
}
if (CompanySettings.CompanyID == "8525")
{
DataDictionaryDataFlowTaskManager.DFT_MoveRateTypeDataForAquaAston();
}
SSISLOGDBManager.LogPackageEnd(PackageLogID, BatchLogID, EndBatchAudit);
}
public void start()
{
eContactDBManager.GetCompanySetting(requestSettings);
//!!
var logResult = SSISLOGDBManager.LogPackageStart("ETL_Driver");
var BatchLogID = logResult["BatchLogID"];
var PackageLogID = logResult["PackageLogID"];
var EndBatchAudit = logResult["EndBatchAudit"];
if ("1".Equals(CompanySettings.ETL_ECONCIERGEEXPORT) && "1.0".Equals(CompanySettings.ETL_ECONCIERGE_TYPE))
{
new eConciergeETLTask().Start();
}
if ("1".Equals(CompanySettings.ETL_HASNEWETL))
{
//DFT Driver Run ETL Packages !!
new DataDictionaryTask().Start();
new CustomerTask().Start();
if ("1".Equals(CompanySettings.ETL_HASVENGADATA))
{
new CustomerVengaTask().Start();
}
if ("1".Equals(CompanySettings.ETL_HASSIRIUSWAREDATA))
{
new CustomerSiriuswareTask().Start();
if ("1".Equals(CompanySettings.ETL_HASCENRESWEBFORMS))
{
new CustomerWebFormsTask().Start();
if ("1".Equals(CompanySettings.ETL_HASCENRESOMNI))
{
new CustomerOmniTask().Start();
}
}
}
new CustomerStayTask().Start();
if ("1".Equals(CompanySettings.HasStayOneToManyStayDetailHeader))
{
new CustomerStayHeaderTask().Start();
}
new CustomerStayRateTask().Start();
if ("1".Equals(CompanySettings.ETL_HASUNIFOCUSDATA))
{
new CustomerUnifocusTask().Start();
}
if ("1".Equals(CompanySettings.ETL_HASMDSDATA))
{
new CustomerMDSTask().Start();
}
if ("1".Equals(CompanySettings.ETL_HASCONDODATA))
{
new CustomerCondoTask().Start();
}
if ("1".Equals(CompanySettings.ETL_HASCLUBESSENTIALSDATA))
{
new CustomerClubEssentialsTask().Start();
}
if (new string[] { "8009", "6245", "10971", "11746" }.Contains(CompanySettings.CompanyID))
{
new CustomerLeadsTask().Start();
}
if ("1".Equals(CompanySettings.HasStayActivities))
{
new CustomerStayActivitiesTask().Start();
}
if ("1".Equals(CompanySettings.HasPropertyUnsubscribe) || "1".Equals(CompanySettings.HasBrandUnsubscribe) && !"10960".Equals(CompanySettings.CompanyID))
{
new UnsubscribePropertyEmailTask().Start();
}
//Data Flow Task !!
if ("1".Equals(CompanySettings.ETL_ECONCIERGEEXPORT) && !"1.0".Equals(CompanySettings.ETL_ECONCIERGE_TYPE))
{
new eConciergeETLTask().Start();
}
if ("7375".Equals(CompanySettings.CompanyID))
{
new MicrosTask().Start();
}
if ("1".Equals(CompanySettings.ETL_HASMEMBERSHIPS) || "1".Equals(CompanySettings.ETL_HASMEMBERSHIPSDATA) || "1".Equals(CompanySettings.HAS_PMSMemberships))
{
new MembershipsTask().Start();
if ("1".Equals(CompanySettings.HAS_PMSMemberships))
{
new PMSObjectsGlobalProfileMaintenanceTask().Start();
}
}
new PostETLUpdatesTask().Start();
//DFT Driver ALL CRM ETL TASKS !!
new RealTimeCampaignTask().Start();
}
else
{
//DFT Driver Legacy Systems !!
if ("isRealTime".Equals("1"))
{
new RealTimeCampaignTask().Start();
}
}
// !!
SSISLOGDBManager.LogPackageEnd(PackageLogID, BatchLogID, EndBatchAudit);
}
