Example #1
0
        private void Generate()
        {
            PSA_TYPE2.LoadMetaAttribute();

            rtbT2TableSTG.Text    = PSA_TYPE2.GenerateTableSTG();
            rtbT2ViewMETA.Text    = PSA_TYPE2.GenerateVIEWMTA();
            rtbT2USPCDC.Text      = PSA_TYPE2.GenerateUSPCDC();
            rtbT2TableCDC.Text    = PSA_TYPE2.GenerateTableCDC();
            rtbT2TableLOG.Text    = PSA_TYPE2.GenerateTableLOG();
            rtbT2USPLOG.Text      = PSA_TYPE2.GenerateUSPLOG();
            rtbT2ViewCurrent.Text = PSA_TYPE2.GenerateVIEWCURRENT();


            DATAVAULT.LoadMetaAttribute();

            rtbDVTSAT.Text  = DATAVAULT.GenerateTableSAT();
            rtbDVTHUB.Text  = DATAVAULT.GenerateTableHUB();
            rtbDVTLINK.Text = DATAVAULT.GenerateTableLINK();
            rtbDVUHUB.Text  = DATAVAULT.GenerateUSPHUB();
            rtbDVULINK.Text = DATAVAULT.GenerateUSPLINK();
            rtbDVUSAT.Text  = DATAVAULT.GenerateUSPSAT();

            //rtbT1TableLanding.Text = PSA_TYPE1.GenerateLandingZone();
            //rtbT1TableStage.Text = PSA_TYPE1.GenerateSTG();
            //rtbT1USPStage.Text = PSA_TYPE1.GenerateUSPSTG();
            //rtbT1TableHIS.Text = PSA_TYPE1.GenerateHIS();
            //rtbT1USPHIS.Text = PSA_TYPE1.GenerateUSPHIS();
        }
Example #2
0
        private void pSAType2FlowToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("Confirm to deploy PSA Type 2 data flow?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                try
                {
                    //Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateTableSTG());
                    Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateVIEWMTA());
                    Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateTableCDC());
                    Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateUSPCDC());
                    Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateTableLOG());
                    Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateVIEWCURRENT());
                    Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateUSPLOG());

                    MessageBox.Show("PSA type 2 Data flow deploy done.");
                }
                catch (Exception ex)
                {
                    MessageBox.Show("PSA type 2 Data flow deploy Failed!\n" + ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }