Explore BrainMass
Share

Need help Declaring an Array Object for Project and entering the loop structure for the calculations

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

First, I have not created the drArray object. I must do that before I can examine the Item collection within it.

The drArray object is created by calling the GetChildRows procedure I have not figured out how to do this.

Second, the accumulation statements must be inside the For...Next loop structure (between the For and Next statements) as follows:

For pintCount = 0 To drArray.GetUpperBound(0)

' I changed the argument to the Item collection. The argument "fldGrossPay" Will return the value

'in that index of the array.
pdlblTotalGrossPay += Convert.ToDouble(drArray_(pintCount).Item "fldGrossPay"))

Next

you can put the other two statements in this same loop instead of creating
'two more loops. Make sure to declare the variables before the loop begins.
******************************************************************

Here is the Original problem Requirments Which I have completed most all of the coding and GUI for. Just having a tough time with the Above Information. Please Help if you can. I have Saved the Payroll.MDB Data file in the bin file of the zipped Project so you can set the control instances to it on your computer. Thanks Tom
******************************************************************
For this project you will use the following database schema, which has two tables.
Table 1 -- Schema for the tblEmployees table
Column Name Data Type
fldEmployeeID Integer
fldName String
fldAddress String
fldCity String
fldState String
fldZipCode String
Table 2 -- Schema for table named tblPayroll
Column Name Data Type
fldEmployeeID Integer
fldPayrollID Integer
fldPayDate Date
fldGrossPay Single
fldWithholding Single
fldNetPay Single
In this exercise, you will create a solution that works with two tables having a master/detail relationship. The first table contains employee records and the second table contains payroll transaction records for each employee. The Figure shows the completed form for the solution.
? Save and execute the file named Ch09Ex1.exe. Set the drive designator as necessary. For the solution to run, the database Payroll.mdb, which can be downloaded in the following zip file named Pavroll.zip, must exist in the same folder as the executable file. (Download the zip and extract the database file to the folder) The input form contains a list box, and a DataGrid control instance. Select employee names in the ListBox control instance. The corresponding payroll information appears in the DataGrid. As you select different employees, the payroll totals are recalculated for the selected employee.
? Start VB .NET and create a new solution named YourName_Unit3.sln, setting the drive designator as necessary.
? Configure the form so that it appears on the center of the desktop when the solution is run. Also, configure the form so that the user cannot resize it.
? Using the OleDbConnection and OleDbDataAdapter controls, create a connection to the database. Use two OleDbDataAdapter control instances to get the data from the two respective tables. Generate one DataSet based on the two DataAdapters. Write the necessary statements in the frmMain_Load event handler to populate the DataSet.
? Using the XML Designer, define a DataRelation to link the field named fldEmployeelD between the two tables.
? Create an instance of the ListBox control. Set the necessary properties so that the ListBox control will display the field fldName in the table named tblEmplovees.
? Create an instance of the DataGrid control on the form. Configure the DataGrid control instance so that it displays records from the table named tblPavroll. Use the DataRelation object to accomplish this task. Make sure that the DataGrid control instance displays the payroll records for the currently selected employee.
? Format the DataGrid so that the column header names are the same as the ones shown in the Figure. Make the background color of the selected row light blue. Also, make sure that the rows have an alternating color.
? Write the necessary code to calculate the number of transaction, total gross pay, total withholding, and total net pay for the currently selected employee. Display the results in Label control instances at the bottom at the form. Format the output as currency. Right-justify the output in the Label control instances.
? Create an Exit button for the solution. In the Click event handler for the button, display a message box to get confirmation from the user before exiting the solution.
? Create an Update button that will allow the user to save any changes made to the DataGrid back to the database. Write the necessary code for the button. Allow the user to add, change, and delete records.

© BrainMass Inc. brainmass.com October 24, 2018, 6:47 pm ad1c9bdddf
https://brainmass.com/computer-science/control-structures/need-help-declaring-an-array-object-for-project-and-entering-the-loop-structure-for-the-calculations-49001

Attachments

$2.19
See Also This Related BrainMass Solution

Java Code to Calculate Mortgage Payments

I need help with a program that will calculate mortgage payments. The program must be written in Java that will calculate and display the monthly payment amount to fully amortize a $200,000.00 loan over a 30 year term at 5.75? interest.

Part 1: Complete Change Request #4 in Service Request SR-mf-003:

Part 2: Complete Change Request #5 in Service Request SR-mf-003

Part 3: Complete Change Request #6 in Service Request SR-mf-003:

Part 4: Complete Change Request #7 in Service Request SR-mf-003:

Description of Request:
Need a program that will calculate mortgage payments.

Background of Request:
Agents in the field offices will need to be able to calculate mortgage payment amounts. In the future, we may want to put a mortgage calculator on our Web site.

Expected Results/Impact when completed:
A program written in Java that will calculate and display the monthly payment amount to fully amortize a $200,000.00 loan over a 30 year term at 5.75‰ interest.

Part 1
Design a program using a graphical user interface that prompts the user to enter the mortgage principal, the mortgage term (in years), and annual interest rate (APR), then calculates and displays the mortgage payment amount. Allow the user to loop back and enter new data or quit. The code should follow the formatting and commenting standards posted in the Course Materials forum.
The Mortgage formulas are given at the end of this document.

Change Request #4
Requestor: Ninfa Pendleton - Rapid City, SD
Write the program in Java (with a graphical user interface) and have it calculate and display the mortgage payment amount from user input of the amount of the mortgage, the term of the mortgage, and the interest rate of the mortgage. Allow the user to loop back and enter new data or quit. Please insert comments in the program to document the program.

Part 2
Modify your program to allow the user to enter the amount of the mortgage and then allow the user to select from a list of mortgage loans: 7 years at 5.35%, 15 years at 5.5%, and 30 years at 5.75%. Use an array of objects for the different loans. The program should calculate and display the mortgage payment amount, then display the loan balance and interest paid for each payment over the term of the loan in a scrolling pane. Allow the user to loop back and enter new data or quit.
The code should follow the formatting and commenting standards posted in the Course Materials forum.

Change Request #5
Requestor: Ninfa Pendleton - Rapid City, SD
Write the program in Java (with a graphical user interface) and have it calculate and display the mortgage payment amount from user input of the amount of the mortgage and the user's selection from a menu of available mortgage loans:

- 7 years at 5.35%
- 15 years at 5.5%
- 30 years at 5.75%

Use an array for the mortgage data for the different loans. Display the mortgage payment amount followed by the loan balance and interest paid for each payment over the term of the loan. Allow the user to loop back and enter a new amount and make a new selection or quit. Please insert comments in the program to document the program.

Part 3
Modify your program to allow the user to choose whether to enter the term and APR, or to select from the list of mortgage loans.
The code should follow the formatting and commenting standards posted in the Course-Materials forum.

Change Request #6
Requestor: Ninfa Pendleton - Rapid City, SD
Write the program in Java (with a graphical user interface) so that it will allow the user to select which way they want to calculate a mortgage: by input of the amount of the mortgage, the term of the mortgage, and the interest rate of the mortgage payment or by input of the amount of a mortgage and then select from a menu of mortgage loans:

- 7 year at 5.35%
- 15 year at 5.5 %
- 30 year at 5.75%

In either case, display the mortgage payment amount and then, list the loan balance and interest paid for each payment over the term of the loan. Allow the user to loop back and enter a new amount and make a new selection, or quit. Insert comments in the program to document the program.

Part 4

Modify your program to read the interest rates and terms for the array from a text file. Add graphics in the form of a chart that displays the change in principal balance over the life of the loan.
The code should follow the formatting and commenting standards posted in the Course-Materials forum.

Change Request #7
Requestor: Ninfa Pendleton - Rapid City, SD
Write the program in Java (with a graphical user interface) and have it calculate and display the mortgage payment amount from user input of the amount of the mortgage and the user's selection from a menu of available mortgage loans:

- 7 years at 5.35%
- 15 years at 5.5%
- 30 years at 5.75%

Use an array for the mortgage data for the different loans. Read the interest rates to fill the array from a sequential file. Display the mortgage payment amount followed by the loan balance and interest paid for each payment over the term of the loan. Add graphics in the form of a chart. Allow the user to loop back and enter a new amount and make a new selection or quit. Please insert comments in the program to document the program.

Mortgage Formulas
1. Basic payment formula
To calculate the mortgage payment, use the following formula:

PMT = (PV x IR) / (1 - (1 + IR)-NP)
Java implementation: PMT = (PV * IR) / (1 - Math.pow(1 + IR, -NP))

Where:
PMT = Monthly Payment
PV = Principle Value (amount of loan)
IR = Interest Rate, by month
NP = Note Period, or mortgage term in months

IR = APR / 100 / 12
NP = Years * 12 (for example, 5 years means NP = 60)
APR = Annual Percentage Rate (for example 6.25)

Use the formula above when APR > 0.
If APR = 0 (an interest-free loan), then PMT = PV / NP.
2. Amortization Table
Pseudocode for the calculation process
/** initialize the balances **/
loanBalance = NP * payment
principalBalance = PV
interestBalance = loanBalance - principalBalance
totalPrincipalPaid = 0
totalInterestPaid = 0

/** step through all the payment periods */
For paymentNumber from 1 to NP:

/**
The portion of the payment that goes to interest is based on
the remaining principal balance.
**/
interestPaidThisMonth = interestRate * principalBalance

/**
The rest of the payment goes to principal.
**/
principalPaidThisMonth = payment - interestPaidThisMonth

/**
Update the remaining balances and total paid values
**/
loanBalance = loanBalance - payment
principalBalance = principalBalance - principalPaidThisMonth
totalPrincipalPaid = totalPrincipalPaid + principalPaidThisMonth
interestBalance = interestBalance - interestPaidThisMonth
totalInterestPaid = totalInterestPaid + interestPaidThisMonth
End For

Design Checklist

Check Description Comments
Does the design follow good Object Oriented principals?
Are the objects and their relationships described clearly?
Are the methods described clearly?
Does the design make sense and satisfy the requirements?

Code Checklist

Check Description Comments
Are classes and methods described comments?
Are comments clear, concise, and explanatory?
Is indentation used to illustrate the structure of the program and control structures?
Is white spaced used to improve readability?
Do identifiers logically describe use?
Do identifiers follow capitalization standards?
Are all variables and constant declared?

Execution Checklist

Check Description Comments
Does the project compile?
Does the project execute?
Do the input and output match the requirements?
Is the input and output logical and clear to the user?
Does the program perform the required actions correctly?
Does the program handle incorrect and invalid input in a sensible manner?

View Full Posting Details