//***************************
//BEGIN CONNECT BUTTON METHOD
//***************************
private void ConnectButton_Click(object sender, System.EventArgs e)
{
try
{
//*******************************************************
//Define list to hold the tables of database being used
//*******************************************************
ArrayList TableList = new ArrayList();
//**********************************************************
//Create connection string from values entered in text boxes
//**********************************************************
string CONN_STRING = "Server=" + ServerNameBox.Text + ";" +
"Database=" + DatabaseBox.Text + ";" +
"User ID=" + UserNameBox.Text + ";" +
"Password="******";";
//**********************************************************
//Create DataBaseReader object using above connection string
//**********************************************************
DataBaseReader dbreader = new DataBaseReader(CONN_STRING);
//*****************************
//Send messages to message box
//*****************************
OutputBox.AppendText("Connected to SERVER:" + ServerNameBox.Text + "\r\n");
OutputBox.AppendText("Using DATABASE:" + DatabaseBox.Text + "\r\n");
//********************************************************************************
//Reinitialize table combo box, read tables from database and assign to local list
//********************************************************************************
TableBox.Items.Clear();
dbreader.GetTableList();
TableList = dbreader.GetTableListArray();
//***********************************
//Populate combobox with new tables
//***********************************
for (int z = 0; z < TableList.Count; z++)
{
TableBox.Items.Add(TableList[z]);
}
//***************************************************************************************
//Close DataBaseReader object, disable connection controls, give focus to table combobox
//***************************************************************************************
dbreader.CloseDBConnection();
ConnectionGroup.Enabled = false;
TableGroup.Enabled = true;
TableBox.Focus();
}
catch (System.Exception caught)
{
MessageBox.Show(caught.Message);
}
}
//***************************
//BEGIN GenerateSource METHOD
//***************************
private void GenerateSource_Click(object sender, System.EventArgs e)
{
try
{
//************************************************************
//Create connection string from values entered in text boxes
//************************************************************
string CONN_STRING = "Server="+ServerNameBox.Text+";"+
"Database="+DatabaseBox.Text+";"+
"User ID="+UserNameBox.Text+";"+
"Password="******";";
//**********************************************************
//Create DataBaseReader object using above connection string
//**********************************************************
DataBaseReader dbreader1 = new DataBaseReader(CONN_STRING);
dbreader1.ReadDataBase(TableBox.GetItemText(TableBox.Text));
//*****************************
//Send messages to message box
//*****************************
TableLabel.Text = "Table:"+TableBox.Text;
SourceLabel.Text = "Source:"+TableBox.Text+".cs";
OutputBox.AppendText("Parsed Table:"+TableBox.Text+"\r\n");
//**************************
//Clear out both View boxes
//**************************
TableViewBox.Text = "";
ViewBox.Text = "";
ViewGroup.Enabled = true;
//*************************************************************************
//Create GenertaeSourceObject for creating the source file *
//*************************************************************************
GenerateSourceObject gen_source1 = new //source filename = selected table
GenerateSourceObject(TableBox.GetItemText(TableBox.Text));
//*******************************
//Create the source file
//*******************************
gen_source1.WriteStream_const1();
gen_source1.WriteStream_const2();
gen_source1.WriteVariableDeclarations
(dbreader1.GetTypeArray(),dbreader1.GetFieldArray());
gen_source1.WriteStream_const3();
gen_source1.WriteMemberFunctions
(dbreader1.GetTypeArray(),dbreader1.GetFieldArray(),dbreader1.GetNullListArray(),dbreader1.GetKeyNameArray(),dbreader1.GetIsUniqueArray(),dbreader1.GetColNameArray());
gen_source1.CloseStream();
//*******************************
//Close DataBaseReader connection
//*******************************
dbreader1.CloseDBConnection();
//*************************************************************************
//Ouput generated source to Source View Box *
//*************************************************************************
StreamReader Instrm = new StreamReader("sources\\"+TableBox.GetItemText(TableBox.Text)+".cs");
string line;
do
{
line = Instrm.ReadLine();
ViewBox.AppendText(line+"\r\n");
}
while (line != null);
Instrm.Close();
//**************************************************************************
//Output table in TableViewBox *
//**************************************************************************
ArrayList TypeList = new ArrayList();
ArrayList FieldList = new ArrayList();
TypeList = dbreader1.GetMysqlTypeArray();
FieldList = dbreader1.GetMysqlFieldArray();
for (int ct = 0; ct < TypeList.Count; ct++)
{
TableViewBox.AppendText(TypeList[ct].ToString().PadRight(15)+"\t\t"+FieldList[ct]+"\r\n");
}
//**************************************************************************
//**************************************************************************
}
catch (System.Exception caught)
{
MessageBox.Show(caught.Message);
}
}
//***************************
//BEGIN CONNECT BUTTON METHOD
//***************************
private void ConnectButton_Click(object sender, System.EventArgs e)
{
try
{
//*******************************************************
//Define list to hold the tables of database being used
//*******************************************************
ArrayList TableList = new ArrayList();
//**********************************************************
//Create connection string from values entered in text boxes
//**********************************************************
string CONN_STRING = "Server="+ServerNameBox.Text+";"+
"Database="+DatabaseBox.Text+";"+
"User ID="+UserNameBox.Text+";"+
"Password="******";";
//**********************************************************
//Create DataBaseReader object using above connection string
//**********************************************************
DataBaseReader dbreader = new DataBaseReader(CONN_STRING);
//*****************************
//Send messages to message box
//*****************************
OutputBox.AppendText("Connected to SERVER:"+ServerNameBox.Text+"\r\n");
OutputBox.AppendText("Using DATABASE:"+DatabaseBox.Text+"\r\n");
//********************************************************************************
//Reinitialize table combo box, read tables from database and assign to local list
//********************************************************************************
TableBox.Items.Clear();
dbreader.GetTableList();
TableList = dbreader.GetTableListArray();
//***********************************
//Populate combobox with new tables
//***********************************
for (int z = 0; z < TableList.Count; z++)
{
TableBox.Items.Add(TableList[z]);
}
//***************************************************************************************
//Close DataBaseReader object, disable connection controls, give focus to table combobox
//***************************************************************************************
dbreader.CloseDBConnection();
ConnectionGroup.Enabled = false;
TableGroup.Enabled = true;
TableBox.Focus();
}
catch (System.Exception caught)
{
MessageBox.Show(caught.Message);
}
}
//***************************
//BEGIN GenerateSource METHOD
//***************************
private void GenerateSource_Click(object sender, System.EventArgs e)
{
try
{
//************************************************************
//Create connection string from values entered in text boxes
//************************************************************
string CONN_STRING = "Server=" + ServerNameBox.Text + ";" +
"Database=" + DatabaseBox.Text + ";" +
"User ID=" + UserNameBox.Text + ";" +
"Password="******";";
//**********************************************************
//Create DataBaseReader object using above connection string
//**********************************************************
DataBaseReader dbreader1 = new DataBaseReader(CONN_STRING);
dbreader1.ReadDataBase(TableBox.GetItemText(TableBox.Text));
//*****************************
//Send messages to message box
//*****************************
TableLabel.Text = "Table:" + TableBox.Text;
SourceLabel.Text = "Source:" + TableBox.Text + ".cs";
OutputBox.AppendText("Parsed Table:" + TableBox.Text + "\r\n");
//**************************
//Clear out both View boxes
//**************************
TableViewBox.Text = "";
ViewBox.Text = "";
ViewGroup.Enabled = true;
//*************************************************************************
//Create GenertaeSourceObject for creating the source file *
//*************************************************************************
GenerateSourceObject gen_source1 = new //source filename = selected table
GenerateSourceObject(TableBox.GetItemText(TableBox.Text));
//*******************************
//Create the source file
//*******************************
gen_source1.WriteStream_const1();
gen_source1.WriteStream_const2();
gen_source1.WriteVariableDeclarations
(dbreader1.GetTypeArray(), dbreader1.GetFieldArray());
gen_source1.WriteStream_const3();
gen_source1.WriteMemberFunctions
(dbreader1.GetTypeArray(), dbreader1.GetFieldArray(), dbreader1.GetNullListArray(), dbreader1.GetKeyNameArray(), dbreader1.GetIsUniqueArray(), dbreader1.GetColNameArray());
gen_source1.CloseStream();
//*******************************
//Close DataBaseReader connection
//*******************************
dbreader1.CloseDBConnection();
//*************************************************************************
//Ouput generated source to Source View Box *
//*************************************************************************
StreamReader Instrm = new StreamReader("sources\\" + TableBox.GetItemText(TableBox.Text) + ".cs");
string line;
do
{
line = Instrm.ReadLine();
ViewBox.AppendText(line + "\r\n");
}while (line != null);
Instrm.Close();
//**************************************************************************
//Output table in TableViewBox *
//**************************************************************************
ArrayList TypeList = new ArrayList();
ArrayList FieldList = new ArrayList();
TypeList = dbreader1.GetMysqlTypeArray();
FieldList = dbreader1.GetMysqlFieldArray();
for (int ct = 0; ct < TypeList.Count; ct++)
{
TableViewBox.AppendText(TypeList[ct].ToString().PadRight(15) + "\t\t" + FieldList[ct] + "\r\n");
}
//**************************************************************************
//**************************************************************************
}
catch (System.Exception caught)
{
MessageBox.Show(caught.Message);
}
}
