public HttpResponseMessage GetPilotByid(int id)
        {
            using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities())
            {
                var ent = entities.GET_PILOT_BYID(id).ToList();

                if (ent != null)
                {
                    return(Request.CreateResponse(HttpStatusCode.OK, ent));
                }
                else
                {
                    return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
                                                       "EL piloto con identificación " + id + "no existe."));
                }
            }
        }