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

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

Posted Date: 2/18/2013 3:16:54 AM | Location : United States







Related Discussions:- program for employees -ado.net framework , Assignment Help, Ask Question on program for employees -ado.net framework , Get Answer, Expert's Help, program for employees -ado.net framework Discussions

Write discussion on program for employees -ado.net framework
Your posts are moderated
Related Questions
Using a join on 3 tables, select 5 columns and 10 rows from the 3 tables without the use of a Cartesian product Query: SELECT E.LAST_NAME, E.FIRST_NAME, S.BUILDING, S.BRAN

Deriving Predicates from Predicates in SQL The corresponding section in the theory book describes how predicates can be derived from predicates using (a) the logical connectiv

Avoiding Collection Exceptions   In many cases, if you reference a nonexistent collection element, then PL/SQL raises a predefined exception. Consider the illustration shown b

The requirements as follows: Create a folder called "SECURITY" on the server and upload all your project files to that folder. Please note, the "SECURITY" folder is NOT to be IN

Great Plains (Microsoft Dynamics) Purchases Report Project Description: I want to build a purchases report that matches the General Ledger. presently, when I join the PM20

Calling Constructors: The Calls to a constructor are allowed wherever the function calls are allowed. Similarly to the functions, a constructor is called as a section of an ex

What are the rates for help in writing PL/SQL procedures and functions?

FORALL Statement The FORALL statements instruct the PL/SQL engine to bulk-bind the input collections before sending them to the SQL engine. Though the FORALL statement consists

MERGE and TRUNCATE in SQL SQL has two more table update operators, MERGE and TRUNCATE. MERGE, like INSERT, takes a source table s and uses it to update a target table t. Brief

Manipulating Local Collections Within PL/SQL, to manipulate the local collection, by using the  TABLE and CAST operators . The operands of CAST are a collection declared locally