Need Help in C# Project

Question

0.00/5 (No votes)

See more:

Hello All There,

Can anyone help me in writing one method code of my project.

I am creating a POS system which runs 24 hours a day with 3 shifts(7AM-3PM,3PM-11PM,11PM-7AM). I want to handle all the sales of each POS operator daily.

I am confused on the sales of third shift. How i can manage third shift sales(coz it is coming in 2 days that is 1 hour of today and 7 hours of tomorrow).
All the POS operators are going to Finance Manager on the end of shift to hand over shift sale to him. Finance Manager has a module where he is receiving money and entering records in one table name Cash with Manager id, User id, date/time and money.

What are best steps to go through all this process. Either i have to make 2 queries to get today 's sales from sales table and today 's paid from Cash table to set balance amount of operator or anything else ???

Kindly help me in finding some easy way to get sale of third shift employees.

Best Wishes

Posted 15-Jun-13 12:10pm

Jaa Zaib

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Accepted Answer · 2013-06-15T21:45:00

This isn't a question with a single answer, it's closely related to what the company actually does as part of its procedures. If it counts a "day" as Shift 1 start to Shift 1 start (and some do) then it's a different problem to if it counts a day as midnight to midnight, because the basis for all records changes.

I would probably record all information as "ItemID, StaffId, DateTimeSale, Value" and work on reporting as a separate issue: getting info for a shift is a case of checking for a shift start time, plus a shift length.
So if you were using SQL:

SQL

SELECT * FROM myTable WHERE StaffId=1234 AND DateTimeSale BETWEEN '2013-06-15 23:00:00' AND DATEADD(hh, 8, '2013-06-15 23:00:00')