private void button2_Click(object sender, EventArgs e)
{
if (txtIP.Text.ToString().Length == 0 &&
txtPort.Text.ToString().Length == 0 &&
txtUsername.Text.ToString().Length == 0 &&
txtPassword.Text.ToString().Length == 0 &&
cbxDatabaseList.Text.ToString().Length == 0 &&
adHocFilename.Length == 0)
{
MessageBox.Show("Fill the empty field(s).", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
saveFileDialog1.InitialDirectory = AppDefaultDir;
if (saveFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
String SaveFile = saveFileDialog1.FileName;
DBSP2ClassGen.dbhandler d = new DBSP2ClassGen.dbhandler();
d.BuildAllStoredProcedureInfo(txtIP.Text.ToString(), txtPort.Text.ToString(), txtUsername.Text.ToString(), txtPassword.Text.ToString(), cbxDatabaseList.Text.ToString());
d.LoadAllTemplate();
if (adHocFilename != null)
{
d.LoadAdHocQueryInfo(adHocFilename.ToString());
}
d.Build(saveFileDialog1.FileName.ToString());
MessageBox.Show("File generated.", "info", MessageBoxButtons.OK);
d.SaveConfig();
}
else
{
MessageBox.Show("You canceled.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void cbxDatabaseList_DropDown(object sender, EventArgs e)
{
if (txtIP.Text.ToString().Length != 0 &&
txtPort.Text.ToString().Length != 0 &&
txtUsername.Text.ToString().Length != 0 &&
txtPassword.Text.ToString().Length != 0) // implement visual studio's db selection feature.
{
List <string> dblist;
DBSP2ClassGen.dbhandler d = new DBSP2ClassGen.dbhandler();
dblist = d.GetDatabaseList(txtIP.Text.ToString(), txtPort.Text.ToString(), txtUsername.Text.ToString(), txtPassword.Text.ToString());
cbxDatabaseList.Items.Clear();
foreach (string dbname in dblist)
{
cbxDatabaseList.Items.Add(dbname);
}
}
}
public MainForm()
{
InitializeComponent();
if (File.Exists("./config.json")) // load config file if exists.
{
DBSP2ClassGen.dbhandler d = new DBSP2ClassGen.dbhandler();
ConfigInfo ci = new ConfigInfo();
d.GetConfigInfo(ref ci);
txtIP.Text = ci.IP.ToString();
txtPort.Text = ci.port.ToString();
txtUsername.Text = ci.Username.ToString();
txtPassword.Text = ci.password.ToString();
cbxDatabaseList.Text = ci.dbname.ToString();
if (ci.adHocFilename != null)
{
lblAdHoc.Text = ci.adHocFilename.ToString();
}
}
AppDefaultDir = System.Environment.CurrentDirectory;
}
