ASP DOT NET

Thursday, July 20, 2023

How to Generate Alphanumeric Id using c# Linq


            var res = hrmsEntities.LeadGenerations.Select(x => x.LeadId.Substring(7)).ToList();

            int maxvalue = res.Select(int.Parse).DefaultIfEmpty(0).Max();

            int gen = Convert.ToInt32(maxvalue) + 1;

            var LeadId = "WRM/" + "LD" + "/" + gen;

            lvm.leadGeneration.LeadId = LeadId;

         

No comments:

Post a Comment

How to to select duplicate rows from sql server?

 SELECT * FROM Recruitment WHERE Email IN (SELECT Email FROM Recruitment GROUP BY Email HAVING COUNT(*) > 1); WITH CTE AS (     SELECT   ...