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