public Domain.Employee GetEmployeeById(int id) { Domain.Employee employee = new Domain.Employee(); using (var context = new MVC_CRUDEntities()) { employee = context.Employees.Where(x => x.Id == id) .Select(x => new Domain.Employee { Address = x.Address, DepartmentId = x.DepartmentId, BirthDate = x.BirthDate, Email = x.Email, FirstName = x.FirstName, Gender = x.Gender, Id = x.Id, LastName = x.LastName, Phone = x.Phone, Department = new Domain.Department { DepartmentName = x.Department.DepartmentName, Id = x.Department.Id } }).FirstOrDefault(); } return(employee); }
public List <Domain.Employee> GetAllEmployees() { List <Domain.Employee> employees = new List <Domain.Employee>(); using (var context = new MVC_CRUDEntities()) { employees = context.Employees.Include(s => s.Department) .Select(x => new Domain.Employee { Address = x.Address, DepartmentId = x.DepartmentId, BirthDate = x.BirthDate, Email = x.Email, FirstName = x.FirstName, Gender = x.Gender, Id = x.Id, LastName = x.LastName, Phone = x.Phone, Department = new Domain.Department { DepartmentName = x.Department.DepartmentName, Id = x.Department.Id } }).ToList(); } return(employees); }
public bool DeleteEmployeeById(int id) { using (var context = new MVC_CRUDEntities()) { var employee = context.Employees.Where(x => x.Id == id).FirstOrDefault(); context.Employees.Remove(employee); context.SaveChanges(); } return(true); }
public List <Domain.Department> GetAllDepartments() { List <Domain.Department> departments = new List <Domain.Department>(); using (var context = new MVC_CRUDEntities()) { departments = context.Departments.Select(x => new Domain.Department { DepartmentName = x.DepartmentName, Id = x.Id }).ToList(); } return(departments); }
public int SaveEmployee(Domain.Employee employee) { Employee employeeData; using (var context = new MVC_CRUDEntities()) { //context.Entry(employee).State = employee.Id == 0 ? EntityState.Added : EntityState.Modified; if (employee.Id != 0) { employeeData = context.Employees.Where(x => x.Id == employee.Id).FirstOrDefault(); } else { employeeData = new Employee(); context.Employees.Add(employeeData); } if (employeeData != null) { employeeData.Address = employee.Address; employeeData.BirthDate = employee.BirthDate; employeeData.DepartmentId = employee.DepartmentId; employeeData.Email = employee.Email; employeeData.FirstName = employee.FirstName; employeeData.Gender = employee.Gender; employeeData.LastName = employee.LastName; employeeData.Phone = employee.Phone; } context.SaveChanges(); } return(employeeData.Id); }