private void button2_Click(object sender, EventArgs e)
{
try
{
string header = textBox2.Text;
int area = Convert.ToInt32(textBox1.Text);
int region = activeComboBox.SelectedIndex + 1;
int town = SQLConnectionDelete.townID(comboBoxTown.SelectedValue.ToString());
string address = textBoxAddress.Text;
string whoBuy = textBoxWho.Text;
int number = Convert.ToInt32(textBoxNumb.Text);
string comment = textBoxComment.Text;
int price = Convert.ToInt32(textBoxPrice.Text);
int active = 2;
int choose = comboBox1.SelectedIndex + 1;
SQLclassInsert.InsertOther(header, area, region, town, address, whoBuy, number, comment, price, active, choose);
}
catch (Exception ex)
{
MessageBox.Show("Заполняйте данные правильно!\n" + ex.ToString(), "Error!AddOther!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
textBox2.Text = null;
textBox1.Text = null;
textBoxPrice.Text = null;
textBoxAddress.Text = null;
textBoxWho.Text = null;
textBoxNumb.Text = null;
textBoxComment.Text = null;
MessageBox.Show("Добавлено!!!", "Добавить", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void button3_Click(object sender, EventArgs e)
{
SQLConnectionDelete.DeleteRegion(_idRegion);
SQLConnectionDelete.RefreshRegion(this.dataGridView1);
comboBox1.DataSource = SQLConnectionDelete.ComboRegion();
comboBox3.DataSource = SQLConnectionDelete.ComboRegion();
}
private void button4_Click(object sender, EventArgs e)
{
SQLConnectionDelete.DeleteTown(_id);
SQLConnectionDelete.RefreshTown(this.dataGridView2);
comboBox2.DataSource = SQLConnectionDelete.ComboTown();
comboBox4.DataSource = SQLConnectionDelete.ComboTown();
}
private void SettingsForms_Load(object sender, EventArgs e)
{
SQLConnectionDelete.RefreshTown(this.dataGridView2);
SQLConnectionDelete.RefreshRegion(this.dataGridView1);
comboBox1.DataSource = SQLConnectionDelete.ComboRegion();
comboBox2.DataSource = SQLConnectionDelete.ComboTown();
comboBox3.DataSource = SQLConnectionDelete.ComboRegion();
comboBox4.DataSource = SQLConnectionDelete.ComboTown();
SQLConnectionDelete.SelectTownRegion(this.dataGridView3);
SQLclassUpdateR.Registration(this.dataGridView4);
}
private void button8_Click(object sender, EventArgs e)
{
try
{
SQLConnectionDelete.UpdateTownRegion(_idTownRegion, comboBox4.Text, comboBox3.Text);
SQLConnectionDelete.RefreshRegion(this.dataGridView3);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Заполняйте данные правильно!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
MessageBox.Show("Отредактированно!", "Редактировать", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void button7_Click(object sender, EventArgs e)
{
try
{
SQLConnectionDelete.DeleteTownRegion(_idTownRegion);
SQLConnectionDelete.SelectTownRegion(this.dataGridView3);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Ошибка TOWN REGION!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
MessageBox.Show("Удалено!", "Удалить", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void button9_Click(object sender, EventArgs e)
{
try
{
SQLConnectionDelete.InsertTownRegion(comboBox2.Text, comboBox1.Text);
SQLConnectionDelete.SelectTownRegion(this.dataGridView3);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Ошибка TOWN REGION!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
MessageBox.Show("Добавлено!", "Добавить", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void button5_Click(object sender, EventArgs e)
{
try
{
string _text = textBox5.Text;
SQLConnectionDelete.UpdateTown(_id, _text);
SQLConnectionDelete.RefreshTown(this.dataGridView2);
comboBox2.DataSource = SQLConnectionDelete.ComboTown();
comboBox4.DataSource = SQLConnectionDelete.ComboTown();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Заполняйте данные правильно!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
MessageBox.Show("Отредактировано!", "Отредактировать", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
SQLConnectionDelete.InsertRegion(textBox1.Text);
SQLConnectionDelete.RefreshRegion(this.dataGridView1);
comboBox1.DataSource = SQLConnectionDelete.ComboRegion();
comboBox3.DataSource = SQLConnectionDelete.ComboRegion();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Заполняйте данные правильно!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
MessageBox.Show("Добавлено!", "Добавить", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox1.Text = null;
}
}
private void button6_Click(object sender, EventArgs e)
{
try
{
int i = dataGridView2.RowCount + 100;
string _town = textBox6.Text;
SQLConnectionDelete.InsertTown(i, _town);
SQLConnectionDelete.RefreshTown(this.dataGridView2);
comboBox2.DataSource = SQLConnectionDelete.ComboTown();
comboBox4.DataSource = SQLConnectionDelete.ComboTown();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Заполняйте данные правильно!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
MessageBox.Show("Добавлено!", "Добавить", MessageBoxButtons.OK, MessageBoxIcon.Information);
textBox6.Text = null;
}
}
private void activeComboBox_SelectedValueChanged(object sender, EventArgs e)
{
comboBoxTown.DataSource = SQLConnectionDelete.ComboTown(SQLConnectionDelete.RegionID(activeComboBox.SelectedValue.ToString()));
}
private void AddOther_Load(object sender, EventArgs e)
{
activeComboBox.DataSource = SQLConnectionDelete.ComboRegion();
}