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("Неверный ввод");
}
