private void OrderDeleteBtn_Click(object sender, EventArgs e)
{
string cell = OrderDGV.CurrentRow.Cells[4].Value.ToString();
DialogResult result = MessageBox.Show("Вы действительно хотите удалить эту запись?",
"Вопрос", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
DateTime onlyDate;
DataSet1 newDataSet1 = new DataSet1();
DataTable orderTable = newDataSet1.orders;
DataSet1TableAdapters.ordersTableAdapter orderTA = new DataSet1TableAdapters.ordersTableAdapter();
orderTA.Fill(newDataSet1.orders);
orderTA.DeleteQuery(Convert.ToInt32(cell));
orderTA.Fill(newDataSet1.orders);
orderTA.Adapter.SelectCommand.CommandText = "SELECT orders.order_num, customers.customer_FIO, resources.resources_name, orders.order_date, orders.order_id FROM orders INNER JOIN customers ON orders.customer_id = customers.customer_id INNER JOIN resources ON orders.resources_id = resources.resources_id ORDER BY orders.order_num DESC";
orderTA.Fill(newDataSet1.orders);
OrderDGV.Rows.Clear();
DataRow[] foundRowsOrders = orderTable.Select();
foreach (DataRow rowOrders in foundRowsOrders)
{
onlyDate = DateTime.Parse(rowOrders["order_date"].ToString());
OrderDGV.Rows.Add(rowOrders["order_num"].ToString(), rowOrders["customer_FIO"].ToString(),
rowOrders["resources_name"].ToString(), onlyDate.ToShortDateString(), rowOrders["order_id"].ToString());
}
}
}
private void OKBtn_Click(object sender, EventArgs e)
{
if (ONumtextBox.Text != "" && CustomerCombobox.Text != "" && ResourceCombobox.Text != "")
{
string FIO = "";
int i = 0, j = 0;
FIO = CustomerCombobox.Text;
DataSet1 newDataSet1 = new DataSet1();
DataSet1TableAdapters.customersTableAdapter customersTA = new DataSet1TableAdapters.customersTableAdapter();
customersTA.Fill(newDataSet1.customers);
DataSet1TableAdapters.resourcesTableAdapter resourcesTA = new DataSet1TableAdapters.resourcesTableAdapter();
resourcesTA.Fill(newDataSet1.resources);
DataSet1TableAdapters.ordersTableAdapter ordersTA = new DataSet1TableAdapters.ordersTableAdapter();
ordersTA.Fill(newDataSet1.orders);
DataTable CustomerTable = newDataSet1.customers;
DataRow[] foundRowsCustomers;
customersTA.Adapter.SelectCommand.CommandText = "SELECT customer_id FROM customers WHERE (customer_FIO='" + FIO + "')";
customersTA.Fill(newDataSet1.customers);
foundRowsCustomers = CustomerTable.Select();
i = Convert.ToInt32(foundRowsCustomers[0]["customer_id"].ToString());
DataTable ResourcesTable = newDataSet1.resources;
DataRow[] foundRowsDetails;
resourcesTA.Adapter.SelectCommand.CommandText = "SELECT resources_id FROM resources WHERE resources_name='" + ResourceCombobox.Text + "'";
resourcesTA.Fill(newDataSet1.resources);
foundRowsDetails = ResourcesTable.Select();
j = Convert.ToInt32(foundRowsDetails[0]["resources_id"].ToString());
if (EditFlag == false)
{
ordersTA.Insert(ONumtextBox.Text, OrderDTP.Value.Date.ToString(), i, j);
}
else
{
ordersTA.UpdateQuery(ONumtextBox.Text, OrderDTP.Value.Date.ToString(), i, j, EditID);
}
SuccessFlag = true;
OrdersAddForm.ActiveForm.Close();
}
else
{
MessageBox.Show("Должны быть заполнены все поля!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
ONumtextBox.Focus();
}
}
private void Form1_Activated(object sender, EventArgs e)
{
if (OrderShowFlag == true)
{
OrderDGV.Rows.Clear();
DateTime onlyDate;
DataSet1 newDataSet1 = new DataSet1();
DataTable orderTable = newDataSet1.orders;
DataSet1TableAdapters.ordersTableAdapter orderTA = new DataSet1TableAdapters.ordersTableAdapter();
orderTA.Fill(newDataSet1.orders);
orderTA.Adapter.SelectCommand.CommandText = "SELECT orders.order_num, customers.customer_FIO, resources.resources_name, orders.order_date, orders.order_id FROM orders INNER JOIN customers ON orders.customer_id = customers.customer_id INNER JOIN resources ON orders.resources_id = resources.resources_id ORDER BY orders.order_num DESC";
orderTA.Fill(newDataSet1.orders);
DataRow[] foundRowsOrders = orderTable.Select();
foreach (DataRow rowOrders in foundRowsOrders)
{
onlyDate = DateTime.Parse(rowOrders["order_date"].ToString());
OrderDGV.Rows.Add(rowOrders["order_num"].ToString(), rowOrders["customer_FIO"].ToString(),
rowOrders["resources_name"].ToString(), onlyDate.ToShortDateString(), rowOrders["order_id"].ToString());
}
}
}
private void pictureBox2_Click(object sender, EventArgs e)
{
OrderDGV.Width = Form1.ActiveForm.Width - 33;
OrderDGV.Height = Form1.ActiveForm.Height - 220;
OrderCloseBtn.Top = Form1.ActiveForm.Height - 70;
OrderEditBtn.Top = Form1.ActiveForm.Height - 70;
OrderDeleteBtn.Top = Form1.ActiveForm.Height - 70;
OrderEditBtn.Left = Form1.ActiveForm.Width / 2 - OrderDeleteBtn.Width / 2 - OrderEditBtn.Width - 70;
OrderDeleteBtn.Left = Form1.ActiveForm.Width / 2 - OrderDeleteBtn.Width / 2;
OrderCloseBtn.Left = Form1.ActiveForm.Width / 2 + OrderDeleteBtn.Width / 2 + OrderCloseBtn.Width;
OrderDGV.Columns[0].Width = 150;
OrderDGV.Columns[2].Width = OrderDGV.Width / 4 - 50;
OrderDGV.Columns[3].Width = OrderDGV.Width / 4 - 75;
OrderDGV.Columns[1].Width = OrderDGV.Width - (OrderDGV.Columns[0].Width +
OrderDGV.Columns[2].Width + OrderDGV.Columns[3].Width + 40);
OrderDGV.Rows.Clear();
DateTime onlyDate;
DataSet1 newDataSet1 = new DataSet1();
DataTable orderTable = newDataSet1.orders;
DataSet1TableAdapters.ordersTableAdapter orderTA = new DataSet1TableAdapters.ordersTableAdapter();
orderTA.Fill(newDataSet1.orders);
orderTA.Adapter.SelectCommand.CommandText = "SELECT orders.order_num, customers.customer_FIO, resources.resources_name, orders.order_date, orders.order_id FROM orders INNER JOIN customers ON orders.customer_id = customers.customer_id INNER JOIN resources ON orders.resources_id = resources.resources_id ORDER BY orders.order_num DESC";
orderTA.Fill(newDataSet1.orders);
DataRow[] foundRowsOrders = orderTable.Select();
foreach (DataRow rowOrders in foundRowsOrders)
{
onlyDate = DateTime.Parse(rowOrders["order_date"].ToString());
OrderDGV.Rows.Add(rowOrders["order_num"].ToString(), rowOrders["customer_FIO"].ToString(),
rowOrders["resources_name"].ToString(), onlyDate.ToShortDateString(), rowOrders["order_id"].ToString());
}
OrderDGV.Visible = true;
OrderCloseBtn.Visible = true;
OrderShowFlag = true;
OrderDeleteBtn.Visible = true;
OrderEditBtn.Visible = true;
}
