how create empids using C#

You want to add the employee ids like EMP001,EMP002 ...etc
First you have to store the EMP string as constant then whenever you add the employee that time you want to generate the employee id like EMP001 so that you have to get the last employee id from the sql server then you have to the +1 to the employee id you are getting new id then you have to save it.

Example
public const string EmployeePrefix = "EMP";
select the last employee id from sql server for example EMP005
select the last 3 charector from the string you got like 005
then convert the string to int and add one you will get 6 then convert the int to char that time you have to check the whether the string as single digit or 2 digit or 3 digit if single digid you have to 2 zero before the string like 006 then already we have const EMP then you will get finally EMP006 then save it to database.

MuthuKumaran.R
Senior Software Engineer
Techcello
India.

reddysankark-13471, if this helps please login to Mark As Answer. | Alert Moderator

hi

i can understand some what could you please give me coding for this

sankarreddy

reddysankark-13471, if this helps please login to Mark As Answer. | Alert Moderator

public const string EmployeePrefix="EMP";

For Sql Server

Select Top(1) EmployeeId from Employees OrderBy EmployeeId Desc

here you are getting EMP010

Then
string returnEmployeeid = from query(EMP010);
returnemployeeId = returnemployeeid.substring(3,5).ToString();

so you got 010 the convertt into int
int count = convert.toint32(returnemployeeid);
count=count+1;
if(count.length >=3)
{
returnemployeeid = EmployeePrefix + count;
}
else if(count.length == 2)
{
returnemployeeid = EmployeePrefix + "0" + count;
}
else
{
returnemployeeid = EmployeePrefix + "00" + count;
}

then save the returnemployeeid to database for a new record.

MuthuKumaran.R
Senior Software Engineer
Techcello
India.

reddysankark-13471, if this helps please login to Mark As Answer. | Alert Moderator