private static int CalculateAge(int empid)
{
EmployeeEntities _repo = new EmployeeEntities();
EMP emp = new EMP();
int age = 0;
emp.EID = empid;
var query = _repo.EMPs.Where(s => s.EID == emp.EID).Select(s => s.DOB).Single();
//Console.WriteLine(query.DOB);
System.DateTime dateOfBirth = Convert.ToDateTime(query);
age = DateTime.Now.Year - dateOfBirth.Year;
if (DateTime.Now.DayOfYear < dateOfBirth.DayOfYear)
{
age = age - 1;
}
return(age);
}