public void ButtonClick() { DataRowView DRV = window.DevicesDataGrid.SelectedItem as DataRowView; if (DRV == null) { MessageBox.Show("Удаление прервано, Вы не выбрали запись для удаления."); return; } DataRow DR = DRV.Row; object[] arr = DR.ItemArray; MySqlDataReader reader = window.ex.returnResult("select idrepairorders from repairorders where iddevices=" + arr[0]); if (reader == null) { return; } if (reader.HasRows) { window.ex.closeCon(); MessageBox.Show("Невозможно удалить запись"); return; } window.ex.closeCon(); window.ex.ExecuteWithoutRedaer("delete from devices where iddevices=" + arr[0]); window.ex.ExecuteWithoutRedaer("delete from devices_details where iddevices=" + arr[0]); DataGridUpdater.DevicesDataGridUpdate(window); }
public void ButtonClick() { if (String.IsNullOrEmpty(window.AddDeviceTitle.Text)) { MessageBox.Show("Поля не заполнены"); return; } int idtype = 1; MySqlDataReader reader = window.ex.returnResult("select iddevices from devices where title='" + window.AddDeviceTitle.Text + "'"); if (reader == null) { return; } if (reader.HasRows) { MessageBox.Show("Такое устройство уже добавлено"); window.ex.closeCon(); return; } window.ex.closeCon(); reader = window.ex.returnResult("select idtypes from typeofdevices where title='" + window.AddDeviceTypeOfDevice.SelectedItem.ToString() + "'"); if (reader.HasRows) { while (reader.Read()) { idtype = reader.GetInt32(0); } } window.ex.closeCon(); window.ex.ExecuteWithoutRedaer("INSERT INTO devices(title,idtypes)VALUES('" + window.AddDeviceTitle.Text + "'," + idtype + ")"); window.hd.HideAll(); window.DevicesGrid.Visibility = Visibility.Visible; DataGridUpdater.DevicesDataGridUpdate(window); }
public void MenuClick() { window.hd.HideAll(); window.DevicesGrid.Visibility = Visibility.Visible; DataGridUpdater.DevicesDataGridUpdate(window); }