public void AddEmployee_sp(EmpDTO Emp)
 {
     using (var empEntities = new EmployeeDBEntities())
     {
         var employee = Emp.ToEntity();
         empEntities.spAddEmployee(employee.Name,employee.JoinDate,employee.Salary,employee.DepartmentID);
     }
 }
 public int AddEmployee(EmpDTO Emp)
 {
     using (var empEntities = new EmployeeDBEntities())
     {
         var employee = Emp.ToEntity();
         empEntities.Employees.Add(employee);
         empEntities.SaveChanges();
         return employee.ID;
     }
 }