Example #1
0
        public void editGuest()
        {
            String id = MainPage.currentrow();

            string[] guest = EditGuest.Edit();

            string query = "UPDATE `гость` SET `ФИО` = '" + guest[0] + "',`Дата рождения` = '" + guest[1] + "',`Паспортные данные` = '" + guest[2] + "',`Информация о прошлых заездах` = '" + guest[3] + "',`Привилегии` = '" + guest[4] + "',`Номер телефона` = '" + guest[5] + "' WHERE(`idГость` = '" + id + "')";

            MySqlCommand command = new MySqlCommand(query, connection);

            command.CommandTimeout = 60;
            MySqlDataReader reader;

            try
            {
                connection.Open();
                reader = command.ExecuteReader();
                // Succesfully deleted
                connection.Close();
            }
            catch (Exception ex)
            {
                // Ops, maybe the id doesn't exists ?
                MessageBox.Show(ex.Message);
            }
        }
Example #2
0
        private void ChangeBtn_Click(object sender, EventArgs e)
        {
            refresh_method();
            EditGuest EditGuestForm = new EditGuest();
            EditRoom  EditRoomForm  = new EditRoom();

            if (dataGridView1.Visible)
            {
                EditGuestForm.Show();
            }

            if (dataGridView2.Visible)
            {
                EditRoomForm.Show();
            }
        }