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.");
}
}
