Example #1
0
        public void RunSync()
        {
            this.InitializeProvider();

            //TODO: move to the KSHEMA_PNC sync since it runs first
            //base.Reset_Sync_Steps();
            this.LogMessage("PNC to Kshema Sync Started", "INFO");

            //1. run the epec sync
            this.ProcessEntityFlow <Epec>("EPEC_Query.sql");
            this.Update_Sync_Step("Processing Epec Log");

            // process the Subscriber Queue
            Epec.Process_Epec_Stage_Queue();
            this.Update_Sync_Step("Processing Epec Stage Queue");

            //2. run the resident sync
            this.ProcessEntityFlow <Resident>("Get_Resident_Log.sql");
            this.Update_Sync_Step("Processing Resident Log");

            //3. Process the subscriber queue
            Epec.Process_Epec_Stage_Queue();
            this.Update_Sync_Step("Processing Epec Stage Queue");

            //4. Process Contacts
            this.ProcessEntityFlow <Contact>("Get_Contact_Log.sql");
            this.Update_Sync_Step("Processing Contact Log");

            Contact.Process_Contact_Temp_Queue();
            this.Update_Sync_Step("Processing Contact Stage Queue");


            //5. Language
            this.ProcessEntityFlow <Language>("Get_Language_Log.sql");
            this.Update_Sync_Step("Processing Language Log");

            //6. Keywords
            this.ProcessEntityFlow <Keyword>("Get_Keyword_Log.sql");
            this.Update_Sync_Step("Processing Keyword Log");

            Keyword.Delete_KS_SubscriberMedicalInfo_2();
            this.Update_Sync_Step("Deleting Subscriber Medical Info");

            Keyword.Process_SubscriberMedicalInfo();
            this.Update_Sync_Step("Processing Subscriber Medical Info");

            //7. Notes
            this.ProcessEntityFlow <Note>("Get_Notes_Log.sql");
            this.Update_Sync_Step("Processing Notes Log");

            //8. Contact Relation
            this.ProcessEntityFlow <ContactRelation>("Get_ContactRelation_Log.sql");
            this.Update_Sync_Step("Processing Contact Relation Log");

            //9. Responder Call Order
            Contact.Update_Responder_Call_Order();
            this.Update_Sync_Step("Updating Responder Call Order");

            //10. Contact Delete
            this.ProcessEntityDelete <Contact>("Contact_Delete_Log.sql");
            this.Update_Sync_Step("Processing Contact Delete Log");

            //11. Note Delete
            this.ProcessEntityDelete <Note>("Note_Delete_Log.sql");
            this.Update_Sync_Step("Processing Note Delete Log");

            this.Update_Sync_Step("Deleting duplicate contacts");
            Contact.Delete_Duplicate_Contacts();

            this.LogMessage("PNC to Kshema Sync Completed", "INFO");

            this.DisposeProvider();
        }