コード例 #1
0
        public List<Bookings> getBookings(Customer cust)
        {
            List<Bookings> bookingList = new List<Bookings>();
            try
            {
                SQLiteConnection connection = new SQLiteConnection("Data Source=tourismus.db");
                connection.Open();

                SQLiteCommand cmd = new SQLiteCommand("select * from bookings natural join accommodations where cust_id = " + cust.Custi_id, connection);
                SQLiteDataReader reader = cmd.ExecuteReader();

                if (reader.HasRows)
                {
                    while (reader.Read())
                    {

                        String acc_name = reader.GetString(reader.GetOrdinal("acc_name"));
                        int book_id = reader.GetInt32(reader.GetOrdinal("book_id"));
                        int acc_id = reader.GetInt32(reader.GetOrdinal("acc_id"));
                        int room_id = reader.GetInt32(reader.GetOrdinal("room_id"));
                        int room_number = reader.GetInt32(reader.GetOrdinal("room_number"));
                        String start_date = reader.GetString(reader.GetOrdinal("start_date"));
                        String end_date = reader.GetString(reader.GetOrdinal("end_date"));

                        Bookings b = new Bookings(cust,acc_name, book_id, acc_id, room_id, room_number, start_date, end_date);

                        bookingList.Add(b);

                    }

                }
                connection.Close();
            }
            catch (Exception e)
            {
                System.Console.WriteLine(e.ToString());
            }

            return bookingList;
        }
コード例 #2
0
        public void deleteBooking(Bookings b)
        {
            try
            {
                SQLiteConnection connection = new SQLiteConnection("Data Source=tourismus.db");
                connection.Open();
                SQLiteCommand command = new SQLiteCommand(connection);
                string myInsertQuery =
                     "DELETE FROM bookings where book_id="+b.Book_id;
                command.CommandText = myInsertQuery;
                command.ExecuteNonQuery();
                connection.Close();

                // 1 = Account created +
                // 2 = Account updated +
                // 3 = Account deleted +
                // 4 = Aquired accommodation information
                // 5 = Aquired facility information
                // 6 = Booked an accommodation +
                // 7 = Deleted a booking +
                // 8 = Gave feedback about accommodation
                // 9 = Gave feedback about facility
                // 10 = Start of session
                // 11 = End of session

                //log(string custname, int custId, int action)
                logger.log( b.C.Custi_id, 7); ////////////needs ids

            }
            catch(Exception){

            }
        }