program for employees -ado.net framework , PL-SQL Programming

Assignment Help:

Challenge 1

You are required to do the project and write a test plan for it.

Demo 4 is a check writer program for employees. In it, the user enters all information about the employees. You are to modify it so that the information comes from the Danco database (I have given you both a SQL Server and an Access version)

When the program starts, the user chooses between Salaried and Hourly

If the user picks Salaried, a combo box with all Salaried employees appears Employees are sorted in alphabetical order by last name.

Salary initially displayed is retrieved from the database. User can change the Salary and then write the check. (Unless you are working for extra credit, there is no need to write changes back to the database.)

If the user picks Hourly, a combo box with all Hourly employees appears Employees are sorted in alphabetical order by last name.

Hours and Rate are initially displayed is retrieved from the database.

User can change Hours and Rate and then write the check. (Unless you are working for extra credit, there is no need to write changes back to the database.)

Assume that an Employee in the database is Salaried if the Salary field is greater than 0; otherwise, they are Hourly.

You must use ADO.NET. 

You can data bind if you want (I did), but it's not required.

My advice: Just work on Salaried employees first.

Then comment out the code and just work on Hourly employees.

Then get the program to work together.

Challenge 2

Roll your own

Create an application that uses a 2 or 3 tier application,

Using a database and the ADO.NET framework

(either DataReader or DataAdapter)

Create the SQL Server or access database

Create a UML diagram

Create a test plan.

What it does is up to you.

Points given for originality. 

(It can't just be a slight rehash of a prior week's assignment.)

If you want to do this part, please run your idea by me first so I can:

-   Tell you if it's sufficient for the assignment

-    Advise you if it's way too much to accomplish in a week.

You can earn up to 25 points extra credit for this lab, provided the idea is original enough


Related Discussions:- program for employees -ado.net framework

Parameter and keyword description - loop statements, Parameter and Keyword ...

Parameter and Keyword Description: label_name: This is an undeclared identifier which optionally labels a loop. When used, the label_name should be enclosed by double ang

Procedure, 1. Create a procedure called TAX_COST_SP to accomplish the tax c...

1. Create a procedure called TAX_COST_SP to accomplish the tax calculation task. Keep in mind that the state and subtotal values are inputs into the procedure and the procedure is

Defining ref cursor types, Defining REF CURSOR Types To make cursor va...

Defining REF CURSOR Types To make cursor variables, you take 2 steps. At first, you define a REF CURSOR type, and then declare the cursor variables of that type. You can defin

Aggregate operators sql, Aggregate Operators SQL Supports all of the a...

Aggregate Operators SQL Supports all of the aggregate operators mentioned in the theory book and many more besides. The syntax, however, involves an unusual trick that SQL cal

Need to change mysql query to pdo, Need to change mysql query to PDO Pro...

Need to change mysql query to PDO Project Description: I want someone to convert me 1 .php file that includes some sql/mysql stuff to PDO is a very small file. Skills requ

Triggers, At times, customers make mistakes in submitting their orders and ...

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

Multiset types - sql, Multiset types - SQL An SQL multiset is what in ...

Multiset types - SQL An SQL multiset is what in mathematics is also known as a bag-something like a set except that the same element can appear more than once. The body of an

Mysql developer/programmer, Project Description: I want somebody who can...

Project Description: I want somebody who can help me with an idea that I have been working on for a few months now. The person will require extensive knowledge of warcraft 3 PvP

Definition of cross join - sql, Definition of CROSS JOIN - SQL Let s ...

Definition of CROSS JOIN - SQL Let s = t1 CROSS JOIN t2, where t1 and t2 are table expressions optionally accompanied by range variables. Then: Note: Here T denotes Table

Rowid - sql pseudocolumns, ROWID The ROWID returns the rowid (binary a...

ROWID The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the il

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd