public void InsertAirplaneTest()
{
AIRPLANE data = new AIRPLANE
{
MODELO = "MODELO 10",
QTDEPASSAGEIRO = 100
};
new AirplaneController().InsertAirplane(data);
}
public void InsertAirplane(AIRPLANE request)
{
string sql = "insert into [dbo].[AIRPLANE] "
+ " values("
+ "'" + request.MODELO.ToString() + "',"
+ request.QTDEPASSAGEIRO + ","
+ "getdate()"
+ ")";
new RepositorioGenerico <AIRPLANE>().ExecutaAtualizacao(sql);
}
public void Post(AIRPLANE airplane)
{
airplane.DATACRIACAO = DateTime.Now;
if (airplane.ID == 0)
{
new RepositorioGenerico <AIRPLANE>().Add(airplane);
}
else
{
new RepositorioGenerico <AIRPLANE>().Update(airplane);
}
}
public HttpResponseMessage PostAirplane([FromBody] AIRPLANE plane)
{
try
{
using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities())
{
entities.INSERT_AIRPLANE(plane.AIRPLANE_ID, plane.PILOT_ID);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, plane);
message.Headers.Location = new Uri(Request.RequestUri + plane.AIRPLANE_ID.ToString());
return message;
}
}
catch (Exception ex)
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex);
}
}
