private void buttonTestConnect_Click(object sender, EventArgs ev)
{
try
{
OracleProvider oracleProvider = new OracleProvider();
string conString = oracleProvider.BuildConnectionString(comboBoxTNSname.SelectedValue.ToString(), textBoxUser.Text, textBoxPass.Text);
OracleConnection oracConnection = oracleProvider.GetConnection(conString);
if (oracConnection != null)
{
oracleConnection = oracConnection;
DBName = textBoxUser.Text;
labelTestConnect.Text = "SUCCESS!";
labelTestConnect.ForeColor = Color.Green;
char x = '"';
schemaName = x + textBoxUser.Text + x + ".";
}
else
{
labelTestConnect.Text = "FAIL!";
labelTestConnect.ForeColor = Color.Red;
}
}
catch (Exception e)
{
Logger.ShowMsg(e.Message);
Logger.Logging(e.Message, DateTime.Now.ToString());
labelTestConnect.Text = "FAIL!";
labelTestConnect.ForeColor = Color.Red;
}
}
private void buttonExpData_Click(object sender, EventArgs ev)
{
if (MessageBox.Show("The process take many times, Are you sure you want to continue?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
try
{
OracleProvider oracleProvider = new OracleProvider();
string conString = oracleProvider.BuildConnectionString(comboBoxTNSname.SelectedValue.ToString(), textBoxUser.Text, textBoxPass.Text);
OracleConnection oracConnection = oracleProvider.GetConnection(conString);
if (oracleConnection != null)
{
oracleConnection = oracConnection;
DBName = textBoxUser.Text;
}
progressBarExpDt.Maximum = 0;
if (checkBoxExpObj.Checked)
{
if (oracleConnection != null && oracleConnection.State == ConnectionState.Open)
{
// get list view
List <string> listViewName = getListObject("VIEW");
// get list trigger
List <string> listTriggerName = getListObject("TRIGGER");
// get list procedure
List <string> listProcedureName = getListObject("PROCEDURE");
// get list function
List <string> listFunctionName = getListObject("FUNCTION");
// get list package
List <string> listPackageName = getListObject("PACKAGE");
// get list type
List <string> listType = getListObject("TYPE");
progressBarExpDt.Maximum += listViewName.Count + listTriggerName.Count +
listProcedureName.Count + listFunctionName.Count +
+listPackageName.Count + listType.Count;
progressBarExpDt.Step = 1;
// gen view
genObject(listViewName, "VIEW", progressBarExpDt);
//gen trigger
genObject(listTriggerName, "TRIGGER", progressBarExpDt);
// gen procedure
genObject(listProcedureName, "PROCEDURE", progressBarExpDt);
// gen function
genObject(listFunctionName, "FUNCTION", progressBarExpDt);
// gen package
genObject(listPackageName, "PACKAGE", progressBarExpDt);
// gen type
genObject(listType, "TYPE", progressBarExpDt);
progressBarExpDt.Value = 0;
}
}
if (checkBoxExpTbl.Checked)
{
string[] lsTable = getListTableNameFromFile();
int progressSize = 0;
for (int index = 0; index < lsTable.Length; index++)
{
string[] tbl = lsTable[index].Split('_');
List <string> listObjKeyName = GenScript.getListObjKeyName(tbl[0], tbl[1], oracleConnection);
progressSize += listObjKeyName.Count;
}
progressSize += GenScript.getListObjKeyName("tltx", "tltxcd", oracleConnection).Count;
progressBarExpDt.Maximum = progressSize;
for (int index = 0; index < lsTable.Length; index++)
{
string[] tbl = lsTable[index].Split('_');
string tblName = tbl[0].ToLower();
if (tblName != "tltx" && tblName != "fldmaster" && tblName != "fldval" &&
tblName != "appchk" && tblName != "appmap")
{
GenScript.GenInsertCommand(tbl[0], tbl[1], oracConnection, pathMaster.ListPath, progressBarExpDt);
}
}
GenScript.GenInsertCommandForTransTable(oracConnection, pathMaster.ListPath, progressBarExpDt);
}
MessageBox.Show("Export completed!", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception e)
{
Logger.ShowMsg(e.Message);
Logger.Logging(e.Message, DateTime.Now.ToString());
}
progressBarExpDt.Value = 0;
oracleConnection.Close();
oracleConnection.Dispose();
}
}