public DB_MAIN()
{
if (postgres != null)
postgres = null;
postgres = this;
gen_dataset();
if (Settings.get_setting("db_type").ToString() == "psql")
DB_PSQL.Start_PSQL();
else if (Settings.get_setting("db_type").ToString() == "xml")
DB_XML.Start_XML();
}
//init and connect to db
//TODO: Make DB info readable from config file
#region Initialization
public DB_MAIN()
{
if (postgres != null)
{
postgres = null;
}
postgres = this;
gen_dataset();
if (Settings.get_setting("db_type").ToString() == "psql")
{
DB_PSQL.Start_PSQL();
}
else if (Settings.get_setting("db_type").ToString() == "xml")
{
DB_XML.Start_XML();
}
}
private void MainWindow_Load(object sender, EventArgs e)
{
check_config();
database = new DB_MAIN();
//Setting up events
database.db_dataset.Tables[table].RowChanged += db_changed;
database.db_dataset.Tables[table].RowDeleted += db_changed;
name_combo.SelectedIndexChanged += selected_changed;
name_combo.TextUpdate += text_changed;
name_combo.AutoCompleteSource = AutoCompleteSource.ListItems;
name_combo.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
//Init grid
client_grid.DataSource = database.db_dataset.Tables[table];
client_grid.Columns["id"].Visible = false;
client_grid.Columns["name"].HeaderText = "Name";
client_grid.Columns["phone_number"].HeaderText = "Phone #";
client_grid.Columns["street_address"].HeaderText = "Address";
client_grid.Columns["postal_code"].HeaderText = "Postal";
client_grid.Columns["city"].HeaderText = "City";
client_grid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
client_grid.ClearSelection();
client_grid.Sort(client_grid.Columns["name"], ListSortDirection.Ascending);
client_grid.CellClick += client_grid_changed;
viewToolStripMenuItem.DropDownOpening += viewToolStripMenuItem_Click;
update_textbox();
}
