//private void btnDeploy_Click(object sender, EventArgs e)
//{
// try
// {
// Common.ExecuteNonQueryWithGo(rtbContent.Text);
// MessageBox.Show("Script deployed successfully");
// }
// catch (Exception ex)
// {
// MessageBox.Show("Deploy Failed!\n" + ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
// }
//}
//private void LbDV_SelectedIndexChanged(object sender, EventArgs e)
//{
// try
// {
// switch (lbDV.SelectedIndex)
// {
// case 0:
// rtbContent.Text = DATAVAULT.GenerateTableSAT();
// break;
// case 1:
// rtbContent.Text = DATAVAULT.GenerateUSPSAT();
// break;
// case 2:
// rtbContent.Text = DATAVAULT.GenerateTableHUB();
// break;
// case 3:
// rtbContent.Text = DATAVAULT.GenerateUSPHUB();
// break;
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
// }
//}
private void BtnGenList_Click(object sender, EventArgs e)
{
DataClassesDataContext dc = new DataClassesDataContext();
try
{
dc.ExecuteCommand("EXEC META.dbo.USP_INIT_LIST");
MessageBox.Show("Done.\n");
}
catch (Exception ex)
{
MessageBox.Show("Failed!\n" + ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void FULLToolStripMenuItem_Click(object sender, EventArgs e)
{
if (MessageBox.Show("This will make all new and existing table to be configed, are you sure?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
DataClassesDataContext dc = new DataClassesDataContext();
try
{
dc.ExecuteCommand("EXEC META.dbo.USP_INIT_LIST");
MessageBox.Show("Done.\n");
}
catch (Exception ex)
{
MessageBox.Show("Failed!\n" + ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}