Random Employee Id

Question

I want to generate random employee id like EMP + joined year+#### for example EMP201410000 using C# joined year take from dropdown list

Kunal Patel · Answer

Hi vaibhav You can do this stuff from sql server using after insert trigger. Add one extra field EmployeeId in your table and apply this trigger(inside attachment) on your table For example download this attachment. Or paste below code. CREATE TRIGGER [dbo].[employeeid_after_insert] ON [dbo].[ YourTableName ] AFTER INSERT AS BEGIN SET NOCOUNT ON; DECLARE @lastInsertedid INT SET @lastInsertedid = ( SELECT IDENT_CURRENT(' YourTableName ') ) --update employeeid field after value insert into table UPDATE YourTableName SET EmployeeId = 'EMP' + CONVERT(VARCHAR(50) YEAR(GETDATE())) + CONVERT(VARCHAR(50) @lastInsertedid) WHERE Id = @lastInsertedid END;

Naveenkumar Tholkappian · Answer

Hi Vaibhav Better you need to store the id after year in a separate column . why because then only you can generate a sequence number or id eg: EMP201410000 10001 Next no EMP2014 10001 10002 Next No EMP2014 10002 10003 Next No increase +1 in the same column

ali tuncer · Answer

You can use Random class but you should check if it is unique before saving.. http://www.c-sharpcorner.com/UploadFile/mahesh/RandomNumber11232005010428AM/RandomNumber.aspx