Customize Auto-increment ID number... in csharp

Hello, I just want to know how i will auto generate ID number of student using the following format: 1300001 (wherein 06 is the 2 digit year format followed by the ID number.. which start with 00001) ... The scenario is this: I have a textbox named as txtIDNbe o... then lets say the database is ready for saving record (meaning no record is still existing..) then If the user add the first student record... we should see first if there is existing record, if no record exist then we create the id number of the 1st record to start with 1300001... otherwise, if record is already existing database (assuming there is 2 record that is already inserted(1300001 & 1300002)) then we count the number of record and increment the ID number by 1... so the next id number will be 1300003 and so on....
My problem is What is the csharp code of this?..... i am using SQL Server 2008..... Thanks and God Bless Us All..... :-) I do hope you can help me with is one...

Funnily enough, Jignesh and I have just answered a very similar question in this thread:

http://www.c-sharpcorner.com/Forums/Thread/240140/how-to-manage-this-digit.aspx

except that the ID was 10 digits long instead of 7.

I've modified my own method so that it now produces 7 digit IDs and, if you pass it a null or empty string, produces an ID of 00001 for the current year:

using System;

class Program

{

static void Main()

{

string currentID = "1200009";

string nextID = GetNextID(currentID);

Console.WriteLine("{0} -> {1}", currentID, nextID);

currentID = nextID;

nextID = GetNextID(currentID);

Console.WriteLine("{0} -> {1}", currentID, nextID);

currentID = "1300100";

nextID = GetNextID(currentID);

Console.WriteLine("{0} -> {1}", currentID, nextID);

Console.WriteLine("The first ID this year is {0}", GetNextID(""));

Console.ReadKey();

}

static string GetNextID (string currentID)

{

if(String.IsNullOrEmpty(currentID)) currentID = "0000000";

string nextID;

int year = 2000 + int.Parse(currentID.Substring(0, 2));

int currentYear = DateTime.Today.Year;

if (year == currentYear)

{

int number = 1 + int.Parse(currentID.Substring(3));

nextID = currentID.Substring(0, 2) + number.ToString("D5");

}

else

{

nextID = (currentYear - 2000).ToString("D2") + "00001";

}

return nextID;

}

}

The output is:

1200009 -> 1300001

1300001 -> 1300002

1300100 -> 1300101

The first ID this year is 1300001

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Funnily enough, Jignesh and I have just answered a very similar question in this thread:

http://www.c-sharpcorner.com/Forums/Thread/240140/how-to-manage-this-digit.aspx

except that the ID was 10 digits long instead of 7.

I've modified my own method so that it now produces 7 digit IDs and, if you pass it a null or empty string, produces an ID of 00001 for the current year:

using System;

class Program
{
static void Main()
{
string currentID = "1200009";
string nextID = GetNextID(currentID);
Console.WriteLine("{0} -> {1}", currentID, nextID);
currentID = nextID;
nextID = GetNextID(currentID);
Console.WriteLine("{0} -> {1}", currentID, nextID);
currentID = "1300100";
nextID = GetNextID(currentID);
Console.WriteLine("{0} -> {1}", currentID, nextID);
Console.WriteLine("The first ID this year is {0}", GetNextID(""));
Console.ReadKey();
}

static string GetNextID (string currentID)
{
if(String.IsNullOrEmpty(currentID)) currentID = "0000000";
string nextID;
int year = 2000 + int.Parse(currentID.Substring(0, 2));
int currentYear = DateTime.Today.Year;
if (year == currentYear)
{
int number = 1 + int.Parse(currentID.Substring(3));
nextID = currentID.Substring(0, 2) + number.ToString("D5");
}
else
{
nextID = (currentYear - 2000).ToString("D2") + "00001";
}
return nextID;
}
}

The output is:

1200009 -> 1300001
1300001 -> 1300002
1300100 -> 1300101
The first ID this year is 1300001