private void btnGenerate_Click(object sender, EventArgs e)
{
if (txtNamespace.Text == "")
{
MessageBox.Show("Please Enter Namespace");
return;
}
string nameSpace = txtNamespace.Text;
if (txtOutputPath.Text == "")
{
MessageBox.Show("Please Enter Output Path");
return;
}
string outputPath = txtOutputPath.Text;
if (clbList.CheckedItems.Count == 0)
{
MessageBox.Show("Please select at least one table");
return;
}
foreach (string tableName in clbList.CheckedItems)
{
if (cbModel.Checked)
{
SqlHelperController.CreateModel(tableName, nameSpace, outputPath);
txtStatus.AppendText("Model generating...");
}
if (cbBLL.Checked)
{
SqlHelperController.CreateBLL(tableName, nameSpace, outputPath);
txtStatus.AppendText("\r\nBLL generating...");
}
if (cbDAL.Checked)
{
SqlHelperController.CreateDAL(tableName, nameSpace, outputPath);
txtStatus.AppendText("\r\nDAL generating...");
}
}
txtStatus.AppendText("\r\nComplete...");
}
private void btnConnect_Click(object sender, EventArgs e)
{
if (txtDatabaseName.Text == "")
{
MessageBox.Show("Please enter the name of a database");
return;
}
clbList.Items.Clear();
if (txtDatabaseName.Text == null)
{
MessageBox.Show("Please enter database name");
}
GlobalParameters.DatabaseName = txtDatabaseName.Text;
DataTable dt = SqlHelperController.ShowTable();
if (dt == null)
{
MessageBox.Show("No table in the database");
}
foreach (DataRow dr in dt.Rows)
{
clbList.Items.Add(dr["table_name"].ToString());
}
}
