Question: Can you give me some idea about this?

  • (2 Pages)
  • +
  • 1
  • 2

24 Replies - 1945 Views - Last Post: 22 February 2012 - 04:56 AM Rate Topic: -----

#1 bry090911  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 112
  • Joined: 02-February 12

Question: Can you give me some idea about this?

Posted 19 February 2012 - 08:25 PM

Hi guys! it's me again! can you give me idea about the time keeping system? so i can code n' code n' code.. later. THANKS IN ADVANCE! :helpsmilie:

oohh.. i'm using vb.net
i don't need the codes.. i just want to know the IDEA AND TOOLS TO USE..


Is This A Good Question/Topic? 0
  • +

Replies To: Question: Can you give me some idea about this?

#2 nK0de  Icon User is offline

  • Catch me As Exception
  • member icon

Reputation: 206
  • View blog
  • Posts: 823
  • Joined: 21-December 11

Re: Question: Can you give me some idea about this?

Posted 19 February 2012 - 08:55 PM

what exactly do you mean by a time keeping system?? Please elaborate a little more.
Was This Post Helpful? 0
  • +
  • -

#3 bry090911  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 112
  • Joined: 02-February 12

Re: Question: Can you give me some idea about this?

Posted 19 February 2012 - 09:08 PM

ON HOW TO MAKE A TIME KEEPINGS SYSTEM...



on how to make a daily time record/time keeping system

that can record the time in and the time out of the employees..

This post has been edited by bry090911: 19 February 2012 - 09:20 PM

Was This Post Helpful? 0
  • +
  • -

#4 nK0de  Icon User is offline

  • Catch me As Exception
  • member icon

Reputation: 206
  • View blog
  • Posts: 823
  • Joined: 21-December 11

Re: Question: Can you give me some idea about this?

Posted 19 February 2012 - 09:33 PM

um...well, you have to start somewhere.
You can use a simple DateTimePicker with the format changed to show Time only to get the current Time. How you're thinking of recording is a bit confusing. You mean like a finger-print detecting machine in offices?
Was This Post Helpful? 0
  • +
  • -

#5 bry090911  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 112
  • Joined: 02-February 12

Re: Question: Can you give me some idea about this?

Posted 19 February 2012 - 09:40 PM

no i mean, if you type your employee number and click time in it will record the time when you time in. i`m just a noob i can't use finger print :(

i just want simple 1st just type it in a keyboard and thats it.

i want to know the flow.. and to compute for the time you rendered for 15 days for example.

ohh wait. just leave a post. i`ll reply later after 4 hours.. :) thank you!
Was This Post Helpful? 0
  • +
  • -

#6 nK0de  Icon User is offline

  • Catch me As Exception
  • member icon

Reputation: 206
  • View blog
  • Posts: 823
  • Joined: 21-December 11

Re: Question: Can you give me some idea about this?

Posted 19 February 2012 - 10:35 PM

in order to get the Time first you must save it somewhere. You'll have to have a front end interface for the user to enter their in-time and out-time. Make them save preferably in a database. a simple table structure would be something like this.

EmpID TimeIn TimeOut

001 08.30 05.30
002 09.00 06.24
003 08.34 07.00

Then you can retreieve data using SQL queries when you type in the EmpID.
Was This Post Helpful? 1
  • +
  • -

#7 bry090911  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 112
  • Joined: 02-February 12

Re: Question: Can you give me some idea about this?

Posted 20 February 2012 - 04:39 AM

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)


and then i don't know what is the next statement for this.

what tools should i use? to design it?
Was This Post Helpful? 0
  • +
  • -

#8 CharlieMay  Icon User is offline

  • This space intentionally left blank
  • member icon

Reputation: 1726
  • View blog
  • Posts: 5,704
  • Joined: 25-September 09

Re: Question: Can you give me some idea about this?

Posted 20 February 2012 - 05:28 AM

Isn't this the same thing we discussed here?
Was This Post Helpful? 0
  • +
  • -

#9 bry090911  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 112
  • Joined: 02-February 12

Re: Question: Can you give me some idea about this?

Posted 20 February 2012 - 05:44 AM

Yup. and i already solved that. but what i need is


i want to know the flow of the daily time record/time keeping system. so i will start program..code..code..code.. :bananaman:
Was This Post Helpful? 0
  • +
  • -

#10 CharlieMay  Icon User is offline

  • This space intentionally left blank
  • member icon

Reputation: 1726
  • View blog
  • Posts: 5,704
  • Joined: 25-September 09

Re: Question: Can you give me some idea about this?

Posted 20 February 2012 - 06:32 AM

What I did in mine is create a panel. I then query the database for a list of employees and create a button in that panel for each user. The text of the button is the users name. The button.Tag property holds the user's ID. So when a user clicks their name the ID is sent to the next form which is Clock IN or Clock Out buttons. I then log the event to the database

DataBase Receives

EmpID, ClockType, DateTime
1001,..ClockIN....02/20/2012 07:59:00 AM
1002,..ClockIN....02/20/2012 08:00:00 AM
1001,..ClockOUT...02/20/2012 12:00:00 PM


etc...
This gives me enough info to parse through the records and calculate times.

Here's a tutorial on how to add controls at run-time.

This post has been edited by CharlieMay: 20 February 2012 - 06:41 AM

Was This Post Helpful? 1
  • +
  • -

#11 bry090911  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 112
  • Joined: 02-February 12

Re: Question: Can you give me some idea about this?

Posted 20 February 2012 - 06:43 AM

Can you give me some screen shots? in the database and in the system? :lol:
Was This Post Helpful? 0
  • +
  • -

#12 CharlieMay  Icon User is offline

  • This space intentionally left blank
  • member icon

Reputation: 1726
  • View blog
  • Posts: 5,704
  • Joined: 25-September 09

Re: Question: Can you give me some idea about this?

Posted 20 February 2012 - 07:27 AM

OK not that it will help much but here is a screen shot
Attached Image

The buttons on the left are created at runtime from the database of employees that use the timeclock.

Your database should contain at least what I listed above. Mine has a few more items like UsesClock that informs this program that the user should be listed.

I really don't know much more of what you would need.

Just keep in mind. Give the user the ability to Clock In or Clock Out and save that information. How you pull it up for your use in calculating time is irrelevant to what the user needs.

When you start trying to do things like check for the last entry and disable the button that they shouldn't click you will end up causing yourself more grief.

When I first started this, I thought. Hey, I'll make it to where the only option a user can do in the morning is ClockIn. That's great until you have a user forget to clock in and then they're bugging you when you're going to lunch because they can't clock out to go themselves. Just keep it simple and log the entry.
Was This Post Helpful? 1
  • +
  • -

#13 bry090911  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 112
  • Joined: 02-February 12

Re: Question: Can you give me some idea about this?

Posted 20 February 2012 - 07:37 AM

Okay thanks for that. after i clock in and clock out where did the clock in and clock out goes on the system? i know that the record will go on the database but

E.G.

[USER]: if i want to check the full clock in and clock out of each employees where should i go?

This post has been edited by bry090911: 20 February 2012 - 07:43 AM

Was This Post Helpful? 0
  • +
  • -

#14 bry090911  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 112
  • Joined: 02-February 12

Re: Question: Can you give me some idea about this?

Posted 20 February 2012 - 09:03 AM

Please reply CharlieMay ^_^
Was This Post Helpful? 0
  • +
  • -

#15 CharlieMay  Icon User is offline

  • This space intentionally left blank
  • member icon

Reputation: 1726
  • View blog
  • Posts: 5,704
  • Joined: 25-September 09

Re: Question: Can you give me some idea about this?

Posted 20 February 2012 - 09:13 AM

You would build your gui with some grid or list that shows this information. Other than writing this program for you, you will have to do some research on the controls made available and design and populate them as you see fit. I can only say that the clocking in and out is stored in the database. That part is done once you achieve that step.

Next you create a form that will allow you to set the dates you want to retrieve and populate a grid or list with that information to view it.

You will also create code to perform the necessary calculations to convert to a time standard you want to use (ie, total hours per day, total hours per week, etc...) Again. This is all the help I can give you without just writing a bunch of code and producing you a working timeclock. It appears that you haven't gotten the basic concepts of how to design and use a GUI so I would start there and once you know what you need to populate, learn the database aspect of it to retrieve the records. At the top of this forum is a VB.Net FAQ & Resources Blog created by AdamSpeight2008. I think you need to begin there and get up to speed. If you're wanting to hire someone to create you a timeclock we also have a forum for that too called Post A Job.

Good luck in whichever path you choose, but if you are determined to write this yourself, then post the code where you are stuck and give as much information as possible as to why something isn't working along with any errors your receive and someone here will do their best to help you move forward.

This post has been edited by CharlieMay: 20 February 2012 - 09:13 AM

Was This Post Helpful? 2
  • +
  • -

  • (2 Pages)
  • +
  • 1
  • 2