public List <Pist> GetAllPists() { List <Pist> list = new List <Pist>(); MySqlConnection connection = adapter.GetConection(); string sql = "SELECT * FROM `flujoaereo`.`pist` WHERE Status ='1';"; try { using (var command = new MySqlCommand(sql, connection)) using (var reader = command.ExecuteReader()) { while (reader.Read()) { Pist pist = new Pist() { ID = reader.GetInt32(0), Description = reader.GetString(1), Status = reader.GetInt32(2), }; list.Add(pist); } return(list); } } catch (Exception e) { MessageBox.Show(e.Message); return(list); } }
private void Save(object sender, System.EventArgs e) { try { // Use trim for filelds names RadioButton myRadio = (RadioButton)panelChild.Controls[3]; Pist pist = new Pist { Description = panelChild.Controls[1].Controls[0].Text, Status = (myRadio.Checked) ? 1 : 0, }; PistDAO dao = new PistDAO(Server.MariaDB); dao.Save(pist); // Button is the last child panelChild.Controls[panelChild.Controls.Count - 1].Enabled = false; FlatPanel parentPanel = (FlatPanel)panel.Parent; Control toolbar = parentPanel.Controls[0]; MenuSection menuController = new MenuSection(0); menuController.ShowPanel(ref parentPanel, Enums.ItemMenuType.Pists); PanelAdjustment(); void PanelAdjustment() { parentPanel.Controls[1].Dock = DockStyle.None; toolbar.Controls[0].Width = parentPanel.Width; parentPanel.Controls[1].Top = toolbar.Top + toolbar.Height; parentPanel.Controls[1].Width = parentPanel.Width; parentPanel.Controls[1].Height = parentPanel.Height - toolbar.Height; } } catch (Exception) { throw new OperationCanceledException("Wrong filed."); } }