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