how to generate employee id automatically in Mvc5

1) Create a database column like UserUniqueId.

2) Secondly pick last UserUniqueId from database.

First Time:

-----------

string uniqueId = "On first time, table is empty so unique Id will be 000000"

Call method

this.GetUniqueId(uniqueId);

Second Time:

------------

string uniqueId = "Pick last insert uniqueId from database"

Call method

this.GetUniqueId(uniqueId);

private string GetUniqueId(string uniqueId)

{

int newNumber = Convert.ToInt32(uniqueId) + 1;

return uniqueId = newNumber.ToString("000000");

}

Now pick this Id like

string newUniqueId = GetUniqueId(uniqueId);