public int Cancel_Ticket(int id, string status)
 {
     TicketsBAL ticketsdal = new TicketsBAL();
     return ticketsdal.Cancel_TicketBAL(id, status);
 }
 public IEnumerable<get_Ticket_By_TrainID_Result> Get_Ticket_By_Train_ID(int trainid, string ct)
 {
     TicketsBAL ticketsbal = new TicketsBAL();
     return ticketsbal.Get_Ticket_By_Train_IDBAL(trainid, ct);
 }
        //public get_Timetable_By_ID_Result get_Timetable_By_ID(int id)
        //{
        //    TimetablesBAL timetablesBal = new TimetablesBAL();
        //    return timetablesBal.get_Timetable_By_IDBAL(id);
        //}

        public get_Ticket_By_ID_Result get_Ticket_By_ID(int id)
        {
            TicketsBAL ticketsBal = new TicketsBAL();
            return ticketsBal.get_Ticket_By_IDBAL(id);
        }
 public IEnumerable<get_Ticket_By_PNR_Result> get_Ticket_By_PNR(string pnr)
 {
     TicketsBAL ticketsdal = new TicketsBAL();
     return ticketsdal.get_Ticket_By_PNRBAL(pnr);
 }
 public Get_Ticket_By_ID_v2_Result get_Ticket_By_ID2(int id)
 {
     TicketsBAL ticketsBal = new TicketsBAL();
     return ticketsBal.get_Ticket_By_ID2BAL(id);
 }
 public int Update_Tickets(Ticket t)
 {
     TicketsBAL ticketsBal = new TicketsBAL();
     return ticketsBal.Update_TicketsBAL(t);
 }
 public int Delete_Tickets(int id)
 {
     TicketsBAL ticketsBal = new TicketsBAL();
     return ticketsBal.Delete_TicketsBAL(id);
 }
 public int Add_Tickets(Ticket t)
 {
     TicketsBAL ticketsBal = new TicketsBAL();
     return ticketsBal.Add_TicketsBAL(t);
 }
 public IEnumerable<getAll_Tickets_Result> GetAll_Tickets()
 {
     TicketsBAL ticketsBal = new TicketsBAL();
     return ticketsBal.GetAll_TicketsBAL();
 }