public HttpResponseMessage Put(int id, [FromBody] tbl_schedules schedules) { DbContextTransaction transaction = entities.Database.BeginTransaction(); try { tbl_schedules updateschedule = entities.tbl_schedules.Find(id); updateschedule.arrival_time = schedules.arrival_time; updateschedule.travel_date = schedules.travel_date; updateschedule.departure_time = schedules.departure_time; updateschedule.duration = schedules.duration; updateschedule.avail_economy_class = schedules.avail_economy_class; updateschedule.avail_business_class = schedules.avail_business_class; updateschedule.avail_first_class = schedules.avail_first_class; updateschedule.avail_premium_class = schedules.avail_premium_class; updateschedule.schedule_status = schedules.schedule_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_schedules schedules) { DbContextTransaction transaction = entities.Database.BeginTransaction(); try { entities.tbl_schedules.Add(schedules); entities.SaveChanges(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Details not entered properly")); } return(Request.CreateResponse(HttpStatusCode.OK, schedules)); }