how to generate employee id automatically in Mvc5

Question

hi all  i want to store employee id in db without entering  it should generate automatically for ex :- Bics SFDC001 this is my requirement  please provide solution regarding this Thanks in advance

Sundar · Answer

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);