public AircraftModelBuilder() { _lastBuild = new AirCraftModel(); _lastAircraftBuild = new Aircraft(); _lastAircraftBuild.AirCraftModel = _lastBuild; }
public void AircraftBuild() { AircraftModelBuilder builder = new AircraftModelBuilder(); AirCraftModel model = builder.BuildAircraftModel(); model = builder.RandomValue(); aircraft = builder.BuildAircraft(); }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { textBox1.Visible = true; textBox1.Text = air[comboBox1.SelectedIndex].Model; textBox2.Visible = true; textBox2.Text = air[comboBox1.SelectedIndex].Color; textBox3.Visible = true; textBox3.Text = air[comboBox1.SelectedIndex].Capacity.ToString(); label2.Visible = true; label3.Visible = true; label4.Visible = true; button1.Visible = true; aircraft = air[comboBox1.SelectedIndex]; }
public bool AddNewAircraft(AirCraftModel NewAircraft) { String Query = "INSERT INTO [dbo].[AIRCRAFT]"; Query += " Values(" + "'" + NewAircraft.Model + "'" + "," + "'" + NewAircraft.Color + "'" + "," + "'" + NewAircraft.Capacity + "'" + ");"; Connection.Open(); Command.Connection = Connection; Command.CommandText = Query; Command.ExecuteNonQuery(); Connection.Close(); Message = "Added Suceesfully"; return(true); }
public IHttpActionResult Create(AirCraftModel airCraft) { if (!this.ModelState.IsValid) { return(BadRequest(ModelState)); } var newAirCraft = new AirCraft { Model = airCraft.Model }; this.data.AirCrafts.Add(newAirCraft); this.data.AirCrafts.SaveChanges(); airCraft.Id = newAirCraft.Id; return(Ok(newAirCraft)); }
public IHttpActionResult Update(int id, AirCraftModel airCraft) { if (!this.ModelState.IsValid) { return(BadRequest(ModelState)); } var existingAirCraft = this.data.AirCrafts.All().FirstOrDefault(a => a.Id == id); if (existingAirCraft == null) { return(BadRequest("Such aircraft does not exists!")); } existingAirCraft.Model = airCraft.Model; this.data.AirCrafts.SaveChanges(); return(Ok(airCraft)); }
public bool update_Aircraft(AirCraftModel aircraft) { String query = "update [AIRCRAFT] set " + " Model = " + "'" + aircraft.Model + "'" + " ,Color= " + "'" + aircraft.Color + "'" + " ,Capacity = " + aircraft.Capacity + " where AirCRAFT_ID= " + "" + aircraft.AirCraft_ID + ""; Connection.Open(); Command.Connection = Connection; Command.CommandText = query; Command.ExecuteNonQuery(); Connection.Close(); Message = "aircraft data Updated successfully"; return(true); }
public List <AirCraftModel> GetAll() { String Query = "Select * from [dbo].[aircraft] "; Connection.Open(); Command.Connection = Connection; Command.CommandText = Query; //Command.ExecuteNonQuery(); List <AirCraftModel> all = new List <AirCraftModel>(); using (SqlDataReader reader = Command.ExecuteReader()) { while (reader.Read()) { AirCraftModel air = new AirCraftModel(); air.AirCraft_ID = reader.GetInt32(0); air.Model = reader.GetString(1); air.Color = reader.GetString(2); air.Capacity = reader.GetInt32(3); all.Add(air); } } Connection.Close(); if (all.Count == 0) { Message = "Not Found"; return(null); } return(all); }