private void edit_button_Click(object sender, EventArgs e)
{
if (edit)
{
UpdateOrder();
}
else
{
AddOrder();
}
DB_MAIN.Update();
this.Close();
}
private void AddOrder()
{
DataRow newrow = DB_MAIN.postgres.db_dataset.Tables["orders"].NewRow();
for (int i = 0; i < DB_MAIN.postgres.db_dataset.Tables["orders"].Columns.Count; i++)
{
string colname = DB_MAIN.postgres.db_dataset.Tables["orders"].Columns[i].ColumnName;
if (colname == "id")
{
continue;
}
newrow[colname] = Controls[colname].Text;
}
DB_MAIN.postgres.db_dataset.Tables["orders"].Rows.Add(newrow);
DB_MAIN.Update();
}
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();
}
void order_grid_UserDeletedRow(object sender, DataGridViewRowEventArgs e)
{
DB_MAIN.Update();
}
