Click here to Skip to main content
16,023,339 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear team,
I want to develope software to calculate distance travelled by employees during site visit and paid travelling expences according to its.Paid per kilometer according employee designation , this criteria follow on food expences also.Employee categories in three group, one group take 75 Rupees for food per lunch or diner,second on 100 Rs and third one 125 rs.Per kilometer paid in two categories one for bike and second for car.
I want to develope software in-
Source code in visual c#,
Fronted window based,
Database in MS access.
How to design project,How many table i create,source code to calculate distance travelled by employee and paid travelling expences.
Posted

1 solution

Start by looking at the data - you need three types of employee, each with its own food expense rate (criminal to my mind...), and two types of vehicle, each with its own per-kilometer rate. You could code these simple choices into listboxes, but since the rates may change you'll be happier with the result if you create a small table for each and use a lookup linked to each table in your data entry form.

You'll also need a table for trips, probably containing the traveler's name, employee type, vehicle type, starting odometer reading, and ending odometer reading. If you have a lot of travelers, consider making this a separate table so that you can look up the name (and possibly the employee class and vehicle type) using a listbox.

Create your database with these tables using Access, then create a Windows Forms application in Visual Studio. On the Data Sources menu, Add a Datasource and point the wizard to your Access database to add a connection to the database and import all the tables and fields to your project.

With these in place, you're ready to start coding. When you've made some progress post again with code samples and we can offer more specific guidance.

By the way, if this is a project to help you learn C#, it's a good one - hard enough to do some teaching, but simple enough not to be frustrating. But if you just need to bang something out for work that just gets the job done, you can easily do all that you require using Access alone and save yourself a lot of work. It's not a great database system, but for something this simple it's more than adequate.
 
Share this answer
 
Comments
Dalek Dave 21-Aug-10 3:12am    
A comprehensive answer, and something that, as anaccountant, I am doing all the time.(On a spreadsheet).

However I must comment on your dislike of different rates for subsistance.
The oiks get less money because they are lower down the food chain, whereas I am management and stay in a better class of hotel, and directors get considerably more. It is the natural order.
Roger Wright 21-Aug-10 4:00am    
It's still bloody wrong! To paraphrase Robert Townsend, "If you're that damned important, bring your own lunch!"

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900