private void Insert_String()
{
if (identify == "kartochka")
{
Kartochka kartochka = new Kartochka(MySqlQueries, MySqlOperations, null);
string output = string.Empty;
kartochka.button1.Visible = true;
kartochka.button3.Visible = false;
kartochka.button4.Visible = false;
kartochka.button5.Visible = false;
kartochka.button6.Visible = false;
kartochka.button7.Visible = false;
kartochka.button8.Visible = false;
kartochka.label6.Visible = false;
kartochka.label7.Visible = false;
kartochka.dataGridView1.Visible = false;
kartochka.dataGridView2.Visible = false;
MySqlOperations.Select_Text(MySqlQueries.Select_Otdely_ComboBox_by_ID, ref output, ID);
MySqlOperations.Search_In_ComboBox(output, kartochka.comboBox1);
kartochka.comboBox1.DropDownStyle = ComboBoxStyle.Simple;
kartochka.comboBox1.Enabled = false;
kartochka.ShowDialog();
MySqlOperations.Select_DataGridView(MySqlQueries.Select_Kartochka_Otdela, dataGridView1, ID);
}
}
public Ubytiya(MySqlQueries mySqlQueries, MySqlOperations mySqlOperations, string iD)
{
InitializeComponent();
MySqlQueries = mySqlQueries;
MySqlOperations = mySqlOperations;
ID = iD;
MySqlOperations.Select_ComboBox(MySqlQueries.Select_Organizacii_ComboBox, comboBox1);
string output = string.Empty;
MySqlOperations.Select_Text(MySqlQueries.Select_Sum_Pribytiya, ref output, ID);
textBox1.Text = output;
}
private void button1_Click(object sender, EventArgs e)
{
MySqlOperations.OpenConnection();
MySqlOperations.Select_Text(MySqlQueries.Select_Avtorizacia, ref ID, null, textBox1.Text, textBox2.Text);
if (ID == "1")
{
MySqlOperations.Select_Text(MySqlQueries.Select_SignIn, ref ID, null, textBox1.Text);
if (ID == "0")
{
this.DialogResult = DialogResult.Yes;
}
else
{
this.DialogResult = DialogResult.No;
}
this.Close();
}
else
{
MessageBox.Show("Неверный пароль или логин.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
MySqlOperations.CloseConnection();
}
private void Proverka_Ostatka()
{
string output = string.Empty;
MySqlOperations.Select_Text(MySqlQueries.Select_Kartochka_Ostatok, ref output, ID);
if (decimal.Parse(output) == decimal.Parse("0,00"))
{
if (MessageBox.Show("Необходимое количество отходов уже собрано." + '\n' + "Желаете отправить собранные отходы на утилизацию?", "Вопрос", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
Ubytiya ubytiya = new Ubytiya(MySqlQueries, MySqlOperations, ID);
ubytiya.button1.Visible = true;
ubytiya.button3.Visible = false;
ubytiya.dateTimePicker1.MinDate = DateTime.Parse(dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[2].Value.ToString());
ubytiya.dateTimePicker1.MaxDate = dateTimePicker2.Value;
ubytiya.ShowDialog();
MySqlOperations.Select_DataGridView(MySqlQueries.Select_Ubytiya_Kartochki, dataGridView2, ID);
button4.Enabled = false;
button5.Enabled = false;
button6.Enabled = false;
button7.Enabled = false;
button8.Enabled = false;
}
}
}
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);
}
}
