private new void InitializeComponent()
{
panel.Controls.Add(panelChild);
panel.Dock = DockStyle.Right;
panel.Padding = new Padding(40, 0, 0, 20);
panel.BackColor = colors.White1;
// DAO
AirplaneDAO airplaneDAO = new AirplaneDAO(Enums.Server.MariaDB);
BindingSource bindingSource = new BindingSource
{
DataSource = airplaneDAO.GetAllAirplanes()
};
DataGridViewCellStyle dataGridViewCellStyle2 = new DataGridViewCellStyle();
dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
dataGridViewCellStyle2.BackColor = colors.White1;
dataGridViewCellStyle2.Font = new System.Drawing.Font("Microsoft YaHei UI", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
dataGridViewCellStyle2.ForeColor = System.Drawing.Color.Black;
dataGridViewCellStyle2.SelectionBackColor = System.Drawing.Color.WhiteSmoke;
dataGridViewCellStyle2.SelectionForeColor = System.Drawing.Color.Black;
dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
// main controls
AddElement(new FlatLabelTitle("Airplanes", 0, 0));
AddElement(new FlatButton("Create Airplane"));
panelChild.Controls[1].Click += new EventHandler(GoToCreate);
panelChild.Controls[1].Width = 200;
AddElement(new DataGridView
{
Name = "dgvAirplanes",
DataSource = bindingSource,
Width = 975,
ForeColor = colors.Black1,
DefaultCellStyle = dataGridViewCellStyle2,
ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2,
RowsDefaultCellStyle = dataGridViewCellStyle2,
RowHeadersDefaultCellStyle = dataGridViewCellStyle2,
AllowUserToAddRows = false,
AllowUserToDeleteRows = false,
AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.AllCells,
AutoSize = true,
BackgroundColor = colors.White1,
BorderStyle = System.Windows.Forms.BorderStyle.None,
ColumnHeadersBorderStyle = System.Windows.Forms.DataGridViewHeaderBorderStyle.Single,
ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize,
GridColor = System.Drawing.SystemColors.Control,
RowHeadersBorderStyle = System.Windows.Forms.DataGridViewHeaderBorderStyle.None,
MultiSelect = false,
RowHeadersVisible = false,
ReadOnly = true,
});
}
public static void BrisanjeAviona()
{
IspisiSveAvione();
Airplane avion = PronadjiAvionPoId();
if (avion != null)
{
AirplaneDAO.Delete(avion.Id);
}
}
//metode za unos i brisanje
public static void UnesiLiniju()
{
IspisiSveLetove();
Airline airline = new Airline();
airline.Id = 0;
Console.WriteLine("Enter the airline name: ");
string aName = Console.ReadLine();
airline.Name = aName;
AirplaneUI.IspisiSveAvione();
Console.WriteLine("Choose airplane id you want to fly:");
string aId = Console.ReadLine();
int idAviona;
bool provera = IOPomocnaKlasa.ProveraDaLiJeBr(aId);
if (provera == true)
{
idAviona = int.Parse(aId);
airline.Airplane = AirplaneDAO.GetAvionById(idAviona);
}
AirportUI.IspisiSveAerodrome();
Console.WriteLine("Choose id of departure airport:");
string aId1 = Console.ReadLine();
int idAerodromaPoletanje;
bool provera1 = IOPomocnaKlasa.ProveraDaLiJeBr(aId1);
if (provera1 == true)
{
idAerodromaPoletanje = int.Parse(aId1);
airline.AirportDeparture = AirportDAO.GetAerodromById(idAerodromaPoletanje);
}
AirportUI.IspisiSveAerodrome();
Console.WriteLine("Choose id of destination airport:");
string aId2 = Console.ReadLine();
int idAerodromaSletanje;
bool provera2 = IOPomocnaKlasa.ProveraDaLiJeBr(aId2);
if (provera2 == true)
{
idAerodromaSletanje = int.Parse(aId2);
airline.AirportDestination = AirportDAO.GetAerodromById(idAerodromaSletanje);
}
if (airline.AirportDeparture.Equals(airline.AirportDestination))
{
Console.WriteLine("You cannot take off and land at the same airport!");
}
else
{
AirlineDAO.Add(airline);
}
}
//METODA ZA ISPIS AVIONA
public static void IspisiSveAvione()
{
List <Airplane> airplanes = AirplaneDAO.GetAll();
Console.WriteLine("-----------------------------------------------------");
Console.WriteLine("\tAll airplanes:");
Console.WriteLine("-----------------------------------------------------");
foreach (Airplane avion in airplanes)
{
Console.WriteLine(avion);
Console.WriteLine("-----------------------------------------------------");
}
}
private void UpdateAirlineFromAirline(string name, ref ComboBox combo)
{
List <string> airplaneNames = new AirplaneDAO(Server.MariaDB).GetAllNamesFromAirline(name);
foreach (string item in airplaneNames)
{
combo.Items.Add(item);
}
if (combo.Items.Count > 1)
{
combo.SelectedIndex = 0;
}
}
private void Save(object sender, System.EventArgs e)
{
try
{
// Use trim for filelds names
RadioButton myRadio = (RadioButton)panelChild.Controls[9];
ComboBox myCombo = (ComboBox)panelChild.Controls[7];
int airlaineID = new AirlineDAO(Enums.Server.MariaDB).GetID(myCombo.SelectedItem.ToString());
Airplane avion = new Airplane
{
Model = panelChild.Controls[1].Controls[0].Text,
ICAO = panelChild.Controls[2].Controls[0].Text,
IATA = panelChild.Controls[3].Controls[0].Text,
MaxPASS = int.Parse(panelChild.Controls[4].Controls[0].Text),
MaxCargo = int.Parse(panelChild.Controls[5].Controls[0].Text),
Aircraft = panelChild.Controls[6].Controls[0].Text,
AirlineID = airlaineID,
Enabled = (myRadio.Checked) ? 1 : 0,
};
AirplaneDAO dao = new AirplaneDAO(Enums.Server.MariaDB);
dao.Save(avion);
// 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.Airplanes);
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.");
}
}
//METODE ZA UNOS I BIRSANJE AVIONA
public static void UnosNovogAviona()
{
Console.WriteLine("Enter plane name:");
string stName = IOPomocnaKlasa.OcitajTekst();
stName = stName.ToUpper();
while (PronajdiAvionPoNazivu(stName) != null)
{
Console.WriteLine("Airplane with name:" + stName + " already exist!");
stName = IOPomocnaKlasa.OcitajTekst();
}
Console.WriteLine("Enter plane capacity:");
int capacity = IOPomocnaKlasa.OcitajCeoBroj();
Console.WriteLine("Enter plane model:");
string stModel = IOPomocnaKlasa.OcitajTekst();
Airplane airplane = new Airplane(0, stModel, capacity, stName);
AirplaneDAO.Add(airplane);
}
private void Save(object sender, System.EventArgs e)
{
try
{
ComboBox myCombo = (ComboBox)panelChild.Controls[2];
ComboBox myCombo2 = (ComboBox)panelChild.Controls[12];
ComboBox myCombo3 = (ComboBox)panelChild.Controls[13];
ComboBox myCombo4 = (ComboBox)panelChild.Controls[16];
ComboBox myCombo5 = (ComboBox)panelChild.Controls[18];
ComboBox myCombo6 = (ComboBox)panelChild.Controls[20];
DateTime departureDate = DateTime.Parse(panelChild.Controls[6].Text);
DateTime arrivalDate = DateTime.Parse(panelChild.Controls[9].Text);
TimeSpan twentyFourHour = new TimeSpan(24, 0, 0);
TimeSpan departureHour = TimeSpan.Parse(panelChild.Controls[7].Controls[0].Text);
TimeSpan arrivalHour = TimeSpan.Parse(panelChild.Controls[10].Controls[0].Text);
TimeSpan flightHour = (departureHour > arrivalHour) ? (twentyFourHour - departureHour) + arrivalHour : arrivalHour - departureHour;
AirlineDAO airlineDAO = new AirlineDAO(Server.MariaDB);
AirplaneDAO airplaneDAO = new AirplaneDAO(Server.MariaDB);
PilotDAO pilotDAO = new PilotDAO(Server.MariaDB);
Flight flight = new Flight
{
Type = myCombo.SelectedItem.ToString(),
Origin = panelChild.Controls[3].Controls[0].Text,
Destiny = panelChild.Controls[4].Controls[0].Text,
DepartureDate = departureDate.ToString(),
DepartureHour = departureHour.ToString(),
ArrivalDate = arrivalDate.ToString(),
ArrivalHour = arrivalHour.ToString(),
FlightTime = flightHour.ToString(),
Pist = int.Parse(myCombo2.SelectedItem.ToString()),
FlightStatus = myCombo3.SelectedItem.ToString(),
AirlineID = airlineDAO.GetID(myCombo4.SelectedItem.ToString()),
AirplaneID = airplaneDAO.GetID(myCombo5.SelectedItem.ToString()),
PilotID = pilotDAO.GetID(myCombo6.SelectedItem.ToString()),
};
FlightDAO dao = new FlightDAO(Enums.Server.MariaDB);
dao.Save(flight);
// 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.Flight);
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 error)
{
MessageBox.Show(error.Message);
}
}
public static Airplane PronajdiAvionPoNazivu(string naziv)
{
Airplane airplane = AirplaneDAO.GetAvionByName(naziv);
return(airplane);
}
//METODE ZA PRETRAGU AVIONA
public static Airplane PronadjiAvionPoId(int id)
{
Airplane retVal = AirplaneDAO.GetAvionById(id);
return(retVal);
}
