[SOLVED] DBS211-Assignment 1

In this assignment, you create a simple HR application using the C++ programming language and Oracle server. This assignment helps students learn a basic understanding of application development using C++ programming and an Oracle database.

Instruction:

In this assignment, we use the same database that you use for your labs.

Connecting to an Oracle database from a C++ Program

In your function main(), create a connection to your database.

You need to implement the following functions:

int menu(void);

The menu() function returns an integer value which is the selected option by the user from the menu. This function displays the following menu options:

• Find Employee
• Employees Report
• Add Employee
• Update Employee
• Remove Employee
• Exit

Before printing the menu, display the following title on the screen

********************* HR Menu *********************

Prompt the user to enter an option. If the user enters an incorrect option, the user is asked to enter an option again. When the user enters a correct option (0 to 5), the function returns the selected value.

If the user selects 0 (Exit), the program terminates.

int findEmployee(*conn,  int employeeNumber, struct Employee *emp);

This function receives a connection object, an integer number as the employee number, and a pointer to a variable of type Employee. The function returns 0 if the employee does not exist. It returns 1 if the employee exits.

To store the employee data from the findEmployee() function, we use a variable of type structure called Employee. The Employee structure has the following members:

struct Employee{

int employeeNumber;

char lastName[50];

char firstName[50];

char email[100]; 

char phone[50];

char extension[10];

char reportsTo[100];  

char jobTitle[50];

char city[50];

};

The ReportsTo member stores the first name and the last name of the employee who is the manager of the given employee number.

If the employee exists, store the employee data into the members of an Employee variable using the third parameter in the findEmployee() function which references to that variable of type Employee.

Note: For this report, you may need to query more than one table (join).

void displayEmployee(*conn, struct Employee emp);

If the user selects option 1, this function is called. First, prompt the user to enter a value for the employee number. Then, call function findEmployee() to check if the employee with the given employee number exists. If the returning value of function findEmployee() is 0, display a proper error message.

Sample error message:

Employee 1122 does not exist.

Otherwise, call the function displayEmployee() to display the employee information.

This function receives a connection pointer and values of a variable of type Employee and displays all members of the emp parameter.

Display the employee information as follows:

employeeNumber = 1002

lastName = Murphy

firstName = Diane

email = [email protected]

phone = +1 650 219 4782

extension = x5800

reportsTo =

jobTitle = President

city = San Francisco

void displayAllEmployees(*conn);

If the user selects option 2 (Employees Report), call function displayAllEmployees().

This function receives a connection pointer and displays all employees’ information if exists.

Write a query to select and display the following attributes for all employees.

E          Employee Name         Email                                       Phone              Ext            Manager
————————————————————————————————————————

1002           Diane Murphy                                  [email protected]                     +1 650 219 4782          x5800

1056           Mary Patterson                                [email protected]                   +1 650 219 4782          x4611         Diane Murphy

1076           Jeff Firrelli                                         [email protected]                         +1 650 219 4782          x9273         Diane Murphy

1143           Anthony Bow                                    [email protected]                            +1 650 219 4782          x5428         Mary Patterson

1165           Leslie Jennings                                  [email protected]                     +1 650 219 4782          x3291                    Anthony Bow

1166           Leslie Thompson                              [email protected]                  +1 650 219 4782          x4065                    Anthony Bow

1188           Julie Firrelli                                       [email protected]                         +1 215 837 0825          x2173                    Anthony Bow

1216           Steve Patterson                                [email protected]                  +1 215 837 0825          x4334                    Anthony Bow

1286           Foon Yue Tseng                                [email protected]                          +1 212 555 3000          x2248                    Anthony Bow

1323           George Vanauf                                 [email protected]                       +1 212 555 3000          x4102                    Anthony Bow

1102           Gerard Bondur                                 [email protected]                      +33 14 723 4404          x5408         Mary Patterson

1337           Loui Bondur                                      [email protected]                       +33 14 723 4404          x6493                    Gerard Bondur

1370           Gerard Hernandez                           [email protected]                  +33 14 723 4404          x2028                    Gerard Bondur

1401           Pamela Castillo                                 [email protected]                       +33 14 723 4404          x2759                    Gerard Bondur

1702           Martin Gerard                                  [email protected]                      +33 14 723 4404          x2312                    Gerard Bondur

1621           Mami Nishi                                        [email protected]                          +81 33 224 5000          x101           Mary Patterson

1625           Yoshimi Kato                                     [email protected]                            +81 33 224 5000          x102           Mami Nishi

1088           William Patterson                            [email protected]                 +61 2 9264 2451          x4871         Mary Patterson

1611           Andy Fixter                                       [email protected]                          +61 2 9264 2451          x101                    William Patterson

1612           Peter Marsh                                      [email protected]                        +61 2 9264 2451          x102                    William Patterson

1619           Tom King                                           [email protected]                             +61 2 9264 2451          x103                    William Patterson

1501           Larry Bott                                           [email protected]                             +44 20 7877 2041       x2311                    Gerard Bondur

1504           Barry Jones                                       [email protected]                         +44 20 7877 2041       x102                    Gerard Bondur

Note: For this report, you may need to query more than one table (join).

If the query does not return any rows, display a proper message:

There is no employees’ information to be displayed.

Note: For each query in your assignment, make sure you handle the errors and display the proper message including the error_code.

Error_code is a number returned if the query execution is not successful.