year changes how to change the count

Question

0.00/5 (No votes)

See more:

Hi
I need a help

Doid I am getting by counting number of records in database.
My requirement is if it is a new year the count must start again from 1

Example(2011)

2011scl001-D0
2011scl002-DO
2011scl003_Do

(2012)

VB

2012scl001-D0
        2012scl002-DO
        2012scl003_Do

Could u pls advice

if (count < 10)
            {
                if (month == 1)
                {
                    DoId = (DateTime.Now.Year + cusId + ("00") + (count + 1) + "-DO").ToString();

                }
                else 
                {
                    DoId = (DateTime.Now.Year + cusId + ("00") + (count + 1) + "-DO").ToString();

                }
                }

Thanks

Posted 11-Feb-12 4:47am

Lancy.net

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)

Abhinav S · Answer 1 · 2012-02-11T05:07:00

Solution 1

I would just reset count to 1 in the if clause.

C#

if (month == 1)
               {
                   count=1;
                   DoId = (DateTime.Now.Year + cusId + ("00") + (count + 1) + "-DO").ToString();

               }
               else
               {
                   DoId = (DateTime.Now.Year + cusId + ("00") + (count + 1) + "-DO").ToString();

               }

Posted 11-Feb-12 5:07am

Abhinav S

Comments

Aniket Yadav 12-Feb-12 0:21am

Hello Abhinav,

Your solution is okay but there is one flaw in it.

If I set the count to 1 then for the 1st month, my DoId will be 2012scl002-DO. And if it continues then for the 12th Month the DoId will be 2012scl0013-DO

Abhinav S 12-Feb-12 1:40am

Try by setting count=0 instead of 1.

Lancy.net 12-Feb-12 1:30am

sorry may be my question is not clear
what i need is count value should reset every year...
for example if i have 10 dos in jan starts with 2012scl001-Do--2012scl010-Do
feb one 2012scl011.........
2013 jan first do must 2013scl001