private void buttonAddFlat_Click(object sender, EventArgs e) { int number; float area; int room; try { number = Convert.ToInt32(textBoxNumber.Text); area = Convert.ToSingle(textBoxArea.Text); room = Convert.ToInt32(textBoxRoom.Text); if (flat > number) { string query = "insert into apartment values (" + number + "," + area + "," + room + "," + house + ")"; Ado.ExecuteNonQuery(query); Main.RefForm.fillFlats(house); MessageBox.Show("Добавлено!"); } else { MessageBox.Show("Количество квартир в доме превышено"); } } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void buttonDelHouse_Click(object sender, EventArgs e) { DialogResult dr = MessageBox.Show("Хотите удалить запись? Все другие записи, связанные с ней будут удалены", "Удаление", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (dr == DialogResult.Yes) { string query = "delete from house where id='" + textBoxId.Text + "'"; Ado.ExecuteNonQuery(query); Main.RefForm.fillBuilds(); MessageBox.Show("Удалено!"); } }
private void buttonAddDweller_Click(object sender, EventArgs e) { string surn, name, middle, phone; int age; try { surn = textBoxSurn.Text; name = textBoxName.Text; middle = textBoxMiddle.Text; phone = textBoxPhone.Text; age = Convert.ToInt32(textBoxAge.Text); string query = "insert into dwellers values ('" + surn + "','" + name + "','" + middle + "','" + phone + "'," + age + "," + flat + ")"; Ado.ExecuteNonQuery(query); Main.RefForm.fillDwellers(flat); MessageBox.Show("Добавлено!"); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void buttonUpdFlat_Click(object sender, EventArgs e) { int number; float area; int room; try { number = Convert.ToInt32(textBoxNumber.Text); room = Convert.ToInt32(textBoxFlat.Text); area = Convert.ToSingle(textBoxArea.Text); string query = "update apartment set number = " + number + ", area=" + area + ",numberofrooms=" + room + " where id = '" + textBoxId.Text + "'"; Ado.ExecuteNonQuery(query); Main.RefForm.fillFlats(house); MessageBox.Show("Изменено!"); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void buttonAddHouse_Click(object sender, EventArgs e) { int number, floor, entr, flat; string street; try { number = Convert.ToInt32(textBoxNumber.Text); floor = Convert.ToInt32(textBoxFloor.Text); entr = Convert.ToInt32(textBoxEntr.Text); flat = Convert.ToInt32(textBoxFlat.Text); street = textBoxStreet.Text; string query = "insert into house values ('" + number + "','" + street + "','" + floor + "','" + entr + "','" + flat + "')"; Ado.ExecuteNonQuery(query); Main.RefForm.fillBuilds(); MessageBox.Show("Добавлено!"); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void buttonUpdHouse_Click(object sender, EventArgs e) { int number, floor, entr, flat; string street; try { number = Convert.ToInt32(textBoxNumber.Text); floor = Convert.ToInt32(textBoxFloor.Text); entr = Convert.ToInt32(textBoxEntr.Text); flat = Convert.ToInt32(textBoxFlat.Text); street = textBoxStreet.Text; string query = "update house set number = '" + number + "', street='" + street + "',numberoffloors='" + floor + "',numberofentrances='" + entr + "',numberofflat='" + flat + "' where id = '" + textBoxId.Text + "'"; Ado.ExecuteNonQuery(query); Main.RefForm.fillBuilds(); MessageBox.Show("Изменено!"); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void buttonUpdFlat_Click(object sender, EventArgs e) { string surn, name, middle, phone; int age; try { surn = textBoxSurn.Text; name = textBoxName.Text; middle = textBoxMiddle.Text; phone = textBoxPhone.Text; age = Convert.ToInt32(textBoxAge.Text); string query = "update dwellers set surname='" + surn + "',name='" + name + "',middlename='" + middle + "',phone='" + phone + "',age=" + age + "where id='" + textBoxId.Text + "'"; Ado.ExecuteNonQuery(query); Main.RefForm.fillDwellers(flat); MessageBox.Show("Изменено!"); } catch (Exception exc) { MessageBox.Show(exc.Message); } }