public Employee SaveEmployee(Employee e)
 {
     SalesERPDAL salesDal = new SalesERPDAL();
     salesDal.Employees.Add(e);
     salesDal.SaveChanges();
     return e;
 }
 public void UploadEmployees(List<Employee> employees)
 {
     SalesERPDAL salesDal = new SalesERPDAL();
     salesDal.Employees.AddRange(employees);
     salesDal.SaveChanges();
 }
 public List<Employee> GetEmployees()
 {
     SalesERPDAL salesDal = new SalesERPDAL();
     return salesDal.Employees.ToList();
 }
 public Employee GetEmployeeById(int pId)
 {
     SalesERPDAL salesDal = new SalesERPDAL();
     return salesDal.Employees.Where(employee => employee.EmployeeId == pId).ToList().FirstOrDefault();
 }