private void button_Save_Click(object sender, EventArgs e)
{
Model.Flight flight = new Model.Flight(
textBox1.Text, textBox10.Text, textBox2.Text, textBox3.Text,
dateTimePicker1.Value, dateTimePicker2.Value,
float.Parse(textBox4.Text), int.Parse(textBox5.Text),
float.Parse(textBox6.Text), int.Parse(textBox7.Text),
float.Parse(textBox8.Text), int.Parse(textBox9.Text)
);
if (fno != "")
{
if (flight.Update())
{
MessageBox.Show("Successful!", "Information", MessageBoxButtons.OK);
Log.Add(Program.user.ID, "Update flight " + fno + ".");
this.Close();
}
}
else
{
if (flight.Add())
{
MessageBox.Show("Successful!", "Information", MessageBoxButtons.OK);
Log.Add(Program.user.ID, "Add a flight.");
this.Close();
}
}
}
private void FlightInfo_Load(object sender, EventArgs e)
{
if (fno != "")
{
textBox1.ReadOnly = true;
this.Text = " Edit flight " + fno;
Model.Flight flight = new Model.Flight(fno);
flight.Fetch();
textBox1.Text = flight.FlightNo;
textBox2.Text = flight.Start;
textBox3.Text = flight.Destination;
textBox4.Text = flight.EconomyPrice.ToString();
textBox5.Text = flight.EconomyCount.ToString();
textBox6.Text = flight.EconomyPlusPrice.ToString();
textBox7.Text = flight.EconomyPlusCount.ToString();
textBox8.Text = flight.BusinessPrice.ToString();
textBox9.Text = flight.BusinessCount.ToString();
textBox10.Text = flight.CarrierNo;
dateTimePicker1.Value = flight.LeavingAt;
dateTimePicker2.Value = flight.ArrivalAt;
}
}
// delete rows
private void button_Delete_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count == 0)
{
return;
}
// collect ids to delete
string flightNos = "(";
for (int i = 0; i < dataGridView1.SelectedRows.Count; i++)
{
flightNos += "'" + dataGridView1.SelectedRows[i].Cells[0].Value.ToString() + "'";
if (i != dataGridView1.SelectedRows.Count - 1)
{
flightNos += ",";
}
}
flightNos += ")";
if (MessageBox.Show("Sure to delete flights whose no. in " + flightNos + "?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No)
{
return;
}
// call the model's delete method
Model.Flight flight = new Model.Flight();
if (flight.Delete(flightNos))
{
Log.Add(Program.user.ID, "Delete flight " + flightNos + ".");
// delete from datagridview
foreach (DataGridViewRow dataGridView1Row in dataGridView1.SelectedRows)
{
dataGridView1.Rows.Remove(dataGridView1Row);
}
}
}