public bool Insert(BookedSeats b)
 {
     try
     {
         string             query = "INSERT into BookedSeats VALUES (" + b.FlightId + ", " + b.BookTicketId + " , '" + b.Seats + "')";
         DatabaseConnection dcc   = new DatabaseConnection();
         dcc.ConnectWithDB();
         int x = dcc.ExecuteSQL(query);
         dcc.CloseConnection();
         return(true);
     }
     catch (Exception e)
     {
         Console.WriteLine(e);
         return(false);
     }
 }
        public List <BookedSeats> getBookedTicket(int bId)
        {
            string             query = "SELECT * from BookedSeats WHERE BookTicketId  = " + bId + "";
            BookedSeats        b     = null;
            List <BookedSeats> bList = new List <BookedSeats>();
            DatabaseConnection dcc   = new DatabaseConnection();

            dcc.ConnectWithDB();
            SqlDataReader sdr = dcc.GetData(query);

            if (sdr.Read())
            {
                b = new BookedSeats();
                b.BookedSeatId = Convert.ToInt32(sdr["BookedSeatsId"]);
                b.Seats        = sdr["Seats"].ToString();
                b.BookTicketId = Convert.ToInt32(sdr["BookTicketId"]);
                b.FlightId     = Convert.ToInt32(sdr["FlightId"]);

                bList.Add(b);
            }
            dcc.CloseConnection();
            return(bList);
        }