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