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();
}
private void executePSA2DataFlowToolStripMenuItem_Click(object sender, EventArgs e)
{
//string strContent = PSA_TYPE2.GenerateExecuteFlow();
//rtbContent.Text = strContent;
WF_METAScript frmScript = new WF_METAScript();
frmScript.Script = PSA_TYPE2.GenerateExecuteFlow();
frmScript.ShowDialog();
}
private void deployToolStripMenuItem_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Start to deploy META database?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
Common.ExecuteNonQueryWithGo(PSA_TYPE2.GenerateUSPLOG());
MessageBox.Show("META database deploy done!");
}
catch (Exception ex)
{
MessageBox.Show("META databse deploy Failed!\n" + ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
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);
}
}
}
