flight-ticket-automation

A flight ticket sales automation that compares and presents airline tickets from all airlines to the customer.

What you can do in the app is explained in the "Introduction" section.

• Note: If you want to examine it in detail (etc. which function/procedure does what) and more, you can take a look at the "Introduction.docx" file inside the repo.

Requirements for the demo:

• C# - A programming language.
• pgAdmin - A web-based GUI tool used to interact with the Postgres database sessions.
• Visual Studio - IDE from Microsoft.

Introduction

• Procedures

  • cancel_ticket
  • change_loginstatus
  • change_loginstatus_deactive
  • save_consumer
  • save_passenger
  • save_ticket
  • someone_ticket
  • update_consumer
  • encrypting_now
  • decrypting_now

• Functions

  • create_temp_creditcardno
  • encrypting
  • fill_temp_creditcardno
  • find_creditcardno
  • get_consumerinfo
  • get_consumerpw
  • get_loggedin_dob
  • get_loggedin_id
  • get_loggedin_idcardno
  • get_loggedin_mail
  • get_loggedin_phone
  • get_loggedin_pw
  • get_loggedin_sex
  • get_ticketno

• Trigger Functions

  • raise_planecapacity
  • reduce_planecapacity
  • set_count_male
  • set_count_female

• Views

  • someone_ticket

• Extensions

  • pgcrypto

• Interface

  • Main
    
    
    
  • Search Flight
    
    
    
  • Sign In
    
    
    
  • Sign Up
    
    
    
  • Booking1
    
    
    
  • Booking2
    
    
    
  • Manage Booking
    
    
    
  • Profile
    
    
    
  • Forgot
    
    
    
  • pgAdmin