private void button1_Click(object sender, EventArgs e) { string ID_Otdela = MySqlOperations.Select_ID_From_ComboBox(MySqlQueries.Select_ID_Otdela, comboBox1.Text); MySqlOperations.Insert_Update(MySqlQueries.Insert_Sotrudniki, null, textBox1.Text, textBox2.Text, textBox3.Text, ID_Otdela, textBox4.Text); this.Close(); }
private void button1_Click(object sender, EventArgs e) { if (comboBox1.Text != "" && comboBox2.Text != "" && textBox1.Text != "") { string date1 = dateTimePicker1.Value.Year.ToString() + '-' + dateTimePicker1.Value.Month.ToString() + '-' + dateTimePicker1.Value.Day.ToString(); string date2 = dateTimePicker2.Value.Year.ToString() + '-' + dateTimePicker2.Value.Month.ToString() + '-' + dateTimePicker2.Value.Day.ToString(); MySqlOperations.Insert_Update(MySqlQueries.Insert_Kartochka, null, MySqlOperations.Select_ID_From_ComboBox(MySqlQueries.Select_ID_Otdela, comboBox1.Text), MySqlOperations.Select_ID_From_ComboBox(MySqlQueries.Select_ID_Othoda, comboBox2.Text), date1, date2, textBox1.Text); button1.Visible = false; button3.Visible = false; button8.Visible = true; comboBox1.Enabled = false; comboBox2.Enabled = false; textBox1.Enabled = false; dateTimePicker1.Enabled = false; dateTimePicker2.Enabled = false; MySqlOperations.Select_Text(MySqlQueries.Last_Insert_ID, ref ID); button4.Visible = true; button5.Visible = true; button6.Visible = true; button7.Visible = true; label6.Visible = true; label7.Visible = true; dataGridView1.Visible = true; dataGridView2.Visible = true; } else { MessageBox.Show("Поля не заполнены.", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text != "" && comboBox1.Text != "") { textBox1.Text = textBox1.Text.Replace('.', ','); string date1 = dateTimePicker1.Value.Year.ToString() + '-' + dateTimePicker1.Value.Month.ToString() + '-' + dateTimePicker1.Value.Day.ToString(); MySqlOperations.Insert_Update(MySqlQueries.Insert_Ubytiya, ID, date1, textBox1.Text, MySqlOperations.Select_ID_From_ComboBox(MySqlQueries.Select_ID_Organizacii, comboBox1.Text)); this.Close(); } else { MessageBox.Show("Поле 'Количество' не заполнено.", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text != "") { string output = string.Empty; textBox1.Text = textBox1.Text.Replace('.', ','); MySqlOperations.Select_Text(MySqlQueries.Select_Kartochka_Ostatok, ref output, ID); if (output == "" || decimal.Parse(output) >= decimal.Parse(textBox1.Text)) { string date1 = dateTimePicker1.Value.Year.ToString() + '-' + dateTimePicker1.Value.Month.ToString() + '-' + dateTimePicker1.Value.Day.ToString(); MySqlOperations.Insert_Update(MySqlQueries.Insert_Pribytiya, ID, date1, textBox1.Text); this.Close(); } else { MessageBox.Show("Количество больше остатка." + '\n' + "Остаток: " + output, "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else { MessageBox.Show("Поле 'Количество' не заполнено.", "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void button1_Click(object sender, EventArgs e) { MySqlOperations.Insert_Update(MySqlQueries.Insert_Otdely, null, textBox1.Text); this.Close(); }