public HttpResponseMessage cancelTicket(sp_getBookingHistory_Result tick)
{
DbContextTransaction transaction = entities.Database.BeginTransaction();
try
{
tbl_tickets ticket = entities.tbl_tickets.Where(u => u.ticket_id == tick.ticket_id).FirstOrDefault();
ticket.status = "cancelled";
entities.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Could not cancel the ticket"));
}
return(Request.CreateResponse(HttpStatusCode.Accepted, "Ticket Cancelled"));
}
public HttpResponseMessage addticket(tbl_tickets ticket)
{
DbContextTransaction transaction = entities.Database.BeginTransaction();
try
{
ticket.status = "upcoming";
ticket.gate = 2;
entities.tbl_tickets.Add(ticket);
entities.SaveChanges();
transaction.Commit();
return(Request.CreateResponse(HttpStatusCode.OK, ticket));
}
catch (Exception)
{
transaction.Rollback();
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Invalid data entered"));
}
}
