private void menuItemWithAccessLevel3_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0 && dataGridView1.SelectedRows[0].Cells[0].Value.ToString() != "-1") { OrdersAddEditForm oaef = new OrdersAddEditForm(dataSet1, "Редактировать заказ", data:dataSet1.Tables["orders"].Select( "id=" + dataGridView1.SelectedRows[0].Cells[0].Value.ToString())[0].ItemArray, buttonCaption:"Редактировать"); if (oaef.ShowDialog() == DialogResult.OK) { dataSet1.Tables["orders"].Select( "id=" + dataGridView1.SelectedRows[0].Cells[0].Value.ToString())[0].ItemArray = oaef.Result; if(postgreConnection.UpdateDB("orders", dataSet1, 2)) RedrawSelectionDataGridView(); } } }
private void buttonWithAccessLevel11_Click(object sender, EventArgs e) { OrdersAddEditForm oaef = new OrdersAddEditForm(dataSet1, "Добавить заказ"); if(oaef.ShowDialog() == DialogResult.OK) { dataSet1.Tables["orders"].Rows.Add(oaef.Result); postgreConnection.UpdateDB("orders", dataSet1, 1); } }
private void ChangeOrderButton_Click(object sender, EventArgs e) { if (listBox1.SelectedIndex != -1) { OrdersAddEditForm oaef = new OrdersAddEditForm( dataSet1, "Добавить заказ", buttonCaption: "Редактировать", data: dataSet1.Tables["orders"].Select(String.Format("id={0}", listBox1.SelectedValue))[0].ItemArray ); if (oaef.ShowDialog() == DialogResult.OK) { dataSet1.Tables["orders"].Select(String.Format("id={0}", listBox1.SelectedValue))[0].ItemArray = oaef.Result; if (postgreConnection.UpdateDB("orders", dataSet1, 2)) listBox1_SelectedIndexChanged(null, null); } } }
private void ordersAddEditToolStripMenuItem_Click(object sender, EventArgs e) { OrdersAddEditForm oaef = new OrdersAddEditForm(globalDS,"Редактировать заказ",false,globalDS.Tables["orders"].Rows[0].ItemArray,"Редактировать"); oaef.Show(); }
private void menuItemWithAccessLevel16_Click(object sender, EventArgs e) { OrdersAddEditForm oaef = new OrdersAddEditForm(globalDS, "Добавить заказ"); if (oaef.ShowDialog() == DialogResult.OK) { globalDS.Tables["orders"].Rows.Add(oaef.Result); postgreConnection.UpdateDB("orders", globalDS, 1); } }
private void toolStripButton2_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { OrdersAddEditForm oaef = new OrdersAddEditForm( dataSet1, "Заказ", isEditable: false, data: dataSet1.Tables["orders"].Select("id=" + dataGridView1.SelectedRows[0].Cells["order_id"].Value.ToString())[0].ItemArray, buttonCaption: "Редактировать" ); if (oaef.ShowDialog() == DialogResult.OK) { dataSet1.Tables["orders"].Select("id=" + dataGridView1.SelectedRows[0].Cells["order_id"].Value.ToString())[0].ItemArray = oaef.Result; if (postgreConnection.UpdateDB("orders", dataSet1, 2)) DrawData(); } } }
private void buttonWithAccessLevel4_Click(object sender, EventArgs e) { object[] data = new object[11]; if(listBox1.SelectedIndex!=-1) data[2] = listBox1.SelectedValue; OrdersAddEditForm oaef = new OrdersAddEditForm(dataSet1, "Добавить заказ", data: data); if(oaef.ShowDialog()==DialogResult.OK) { dataSet1.Tables["orders"].Rows.Add(oaef.Result); if(postgreConnection.UpdateDB("orders", dataSet1, 1)) DrawData(); } }
private void редактироватьЭтотЗаказToolStripMenuItem_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count != 0) { OrdersAddEditForm oaef = new OrdersAddEditForm( gds, "Редактировать заказ", data: gds.Tables["orders"].Select("id=" + dataGridView1.SelectedRows[0].Cells["order_id"].Value.ToString())[0].ItemArray, buttonCaption: "Редактировать"); if (oaef.ShowDialog() == DialogResult.OK) { gds.Tables["orders"].Select("id=" + dataGridView1.SelectedRows[0].Cells["order_id"].Value.ToString())[0].ItemArray = oaef.Result; if (pgc.UpdateDB("orders", gds, 2)) ManageRadioButtons(currRB); } } else MessageBox.Show("Неверный ввод"); }