public static int?NumberValidation(string empCode) { int?result = 0; using (var db = new MarkomApplicationDBEntities()) { //var result = db.m_employee.Any(u => u.employee_number.ToLower() == empCode.ToLower()); var res = db.spEmployeeCountCode(empCode).FirstOrDefault(); result = res; } return(result); }