Example #1
0
        private void metroButton3_Click(object sender, EventArgs e)
        {
            //при нажатии на кнопку "Поставки" сайдпанель пермещается на нее
            SidePanel.Height = metroButton3.Height;
            SidePanel.Top    = metroButton3.Top;
            //при нажатитии на кнопку "Поставки" выходит контрол с дата-гридом где находистся вся информация о поставках в которой можно редактировать поставки, удалять и добавлять новые
            PControl pc = new PControl();

            MainControlClass.showControl(pc, Content);
        }
Example #2
0
        private void metroButton3_Click_1(object sender, EventArgs e)
        {
            string          ConnStr = " server = osp74.ru ; port = 33333; user = st_2_4; database = st_2_4; password = 90337436; ";
            MySqlConnection conn    = new MySqlConnection(ConnStr);
            //Новые параметры из полей формы
            DateTime dt_db;

            dt_db = Convert.ToDateTime(dateTimePicker1.Value);
            dateTimePicker1.Value = dt_db;
            string new_ID_procurment           = metroTextBox1.Text;
            string new_name_of_procurment      = metroTextBox2.Text;
            string new_amount_of_medication    = metroTextBox3.Text;
            string new_the_cost_of_procurement = metroTextBox4.Text;
            string new_order_date = dateTimePicker1.Value.ToString("yyyy-MM-dd");

            if (metroTextBox1.Text.Length > 0)
            {
                //Формируем строку запроса на добавление строк
                string sql_update_procur = "UPDATE procurements SET " +
                                           "ID_procurment = '" + new_ID_procurment + "', " +
                                           "name_of_procurment = '" + new_name_of_procurment + "', " +
                                           "amount_of_medication = '" + new_amount_of_medication + "', " +
                                           "the_cost_of_procurement = '" + new_the_cost_of_procurement + "', " +
                                           "order_date = '" + new_order_date + "' " +
                                           "WHERE ID_procurment = " + metroTextBox1.Text;
                //Посылаем запрос на обновление данных
                MySqlCommand update_procur = new MySqlCommand(sql_update_procur, conn);
                try
                {
                    conn.Open();
                    update_procur.ExecuteNonQuery();
                    MessageBox.Show("Изменение прошло успешно", "Информация", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Ошибка изменения строки \n\n" + ex, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    //Application.Exit();
                }
                finally
                {
                    conn.Close();
                }
            }
            PControl pc = new PControl();

            MainControlClass.showControl(pc, metroPanel1);
        }
Example #3
0
        private void metroButton3_Click(object sender, EventArgs e)
        {
            string          ConnStr = " server = osp74.ru ; port = 33333; user = st_2_4; database = st_2_4; password = 90337436; ";
            MySqlConnection conn    = new MySqlConnection(ConnStr);

            //Получение новых параметров пользователя
            DateTime dt_db;

            dt_db = Convert.ToDateTime(dateTimePicker1.Value);
            dateTimePicker1.Value = dt_db;
            string new_ID_procurment           = metroTextBox1.Text;
            string new_name_of_procurment      = metroTextBox2.Text;
            string new_amount_of_medication    = metroTextBox3.Text;
            string new_the_cost_of_procurement = metroTextBox4.Text;
            string new_order_date = dateTimePicker1.Value.ToString("yyyy-MM-dd");
            {
                string sql_insert_post = " INSERT INTO `procurements` (`ID_procurment`, `name_of_procurment`, `amount_of_medication`, `the_cost_of_procurement`, `order_date`) " +
                                         "VALUES ('" + new_ID_procurment + "', '" + new_name_of_procurment + "', '" + new_amount_of_medication + "', '" + new_the_cost_of_procurement + "', '" + new_order_date + "')";

                MySqlCommand insert_post = new MySqlCommand(sql_insert_post, conn);
                try
                {
                    conn.Open();
                    insert_post.ExecuteNonQuery();
                    MessageBox.Show("Добавление поставки прошло успешно", "Информация", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Ошибка добавления поставки \n\n" + ex, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    Application.Exit();
                }
                finally
                {
                    conn.Close();
                }

                PControl pc = new PControl();
                MainControlClass.showControl(pc, metroPanel1);
            }
        }
Example #4
0
        private void metroButton2_Click(object sender, EventArgs e)
        {
            PControl pc = new PControl();

            MainControlClass.showControl(pc, metroPanel1);
        }