public HttpResponseMessage Put(int id, tbl_flights flight)
{
DbContextTransaction transaction = entities.Database.BeginTransaction();
try
{
tbl_flights updateflight = entities.tbl_flights.Find(id);
updateflight.flight_name = flight.flight_name;
updateflight.source_destination = flight.source_destination;
updateflight.target_destination = flight.target_destination;
updateflight.economy_class_fare = flight.economy_class_fare;
updateflight.business_class_fare = flight.business_class_fare;
updateflight.first_class_fare = flight.first_class_fare;
updateflight.premium_class_fare = flight.premium_class_fare;
updateflight.capacity_economy_class = flight.capacity_economy_class;
updateflight.capacity_business_class = flight.capacity_business_class;
updateflight.capacity_first_class = flight.capacity_first_class;
updateflight.capacity_premium_class = flight.capacity_premium_class;
updateflight.status = flight.status;
entities.SaveChanges();
transaction.Commit();
return(Request.CreateResponse(HttpStatusCode.OK, "Successfully updated"));
}
catch (Exception)
{
transaction.Rollback();
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Updation can't be performed"));
}
}
public HttpResponseMessage Post(tbl_flights flight)
{
try
{
entities.tbl_flights.Add(flight);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, flight));
}
catch (Exception)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Invalid details entered"));
}
}
