public int? GetEmployeeIdByName(string name) { var firstLastName = new List<string>(); if (string.IsNullOrEmpty(name)) return null; firstLastName.AddRange(name.Split(' ')); if (firstLastName.Count < 2) return null; string firstName = firstLastName[0]; string lastName = firstLastName[1]; if (!string.IsNullOrEmpty(firstName) && !string.IsNullOrEmpty(lastName)) { using (var context = new HRServiceContext()) { var employee = (from p in context.Employees where p.FirstName.ToLower().Equals(firstName.ToLower()) && p.LastName.ToLower().Equals(lastName.ToLower()) select p).FirstOrDefault(); if (employee != null) return employee.EmployeeId; return null; } } return null; }
public bool InsertEmployee(EmployeeSalary employeeSalary) { using (var db = new HRServiceContext()) { db.Employees.Add(MapToEmployee(employeeSalary)); db.SaveChanges(); return true; } }
public Employee GetEmployee(int id) { using (var context = new HRServiceContext()) { var employee = (from p in context.Employees where p.EmployeeId == id select p).FirstOrDefault(); if (employee != null) return employee; throw new Exception("Invalid employee id"); } }
public List<EmployeeSalary> GetAllEmployees() { using (var context = new HRServiceContext()) { var employeeSalary = from p in context.Employees join t in context.Salaries on p.EmployeeId equals t.EmployeeId select new EmployeeSalary { EmployeeId = p.EmployeeId, EmailAddress = p.EmailAddress, FirstName = p.FirstName, LastName = p.LastName, SupervisorId = p.SupervisorId, Salary = t.SalaryValue }; return employeeSalary.ToList(); } }