public Employee Upsert(Employee source) { if (source != null) { using (var context = new Viajett()) { var employee = context.Employees.Where(x => x.EmployeeId == source.EmployeeId).FirstOrDefault(); if (employee != null) { //update employee.EmailAddress = source.EmailAddress; employee.FirstName = source.FirstName; employee.IsActive = source.IsActive; employee.LastName = source.LastName; employee.TeamId = source.TeamId; context.SaveChanges(); return(employee); } else { //insert context.Employees.Add(source); context.SaveChanges(); return(employee); } } } return(null); }
public IEnumerable <Employee> GetAll() { using (var context = new Viajett()) { return(context.Employees.ToList()); } }
public Team Upsert(Team source) { if (source != null) { using (var context = new Viajett()) { var team = context.Teams.Where(x => x.TeamId == source.TeamId).FirstOrDefault(); if (team != null) { //update team.TeamName = source.TeamName; team.ManagerId = source.ManagerId; context.SaveChanges(); return(team); } else { //insert context.Teams.Add(source); context.SaveChanges(); return(team); } } } return(null); }
public IEnumerable <Team> GetAll() { using (var context = new Viajett()) { return(context.Teams.ToList()); } }
public Employee GetById(Guid employeeId) { using (var context = new Viajett()) { var employee = context.Employees.Where(x => x.EmployeeId == employeeId).FirstOrDefault(); return(employee); } }
public Team GetById(Guid teamId) { using (var context = new Viajett()) { var team = context.Teams.Where(x => x.TeamId == teamId).FirstOrDefault(); return(team); } }
public void Delete(Guid employeeId) { using (var context = new Viajett()) { var employee = context.Employees.Where(x => x.EmployeeId == employeeId).FirstOrDefault(); if (employee != null) { context.Employees.Remove(employee); context.SaveChanges(); } } }
public void Delete(Guid teamId) { using (var context = new Viajett()) { var team = context.Teams.Where(x => x.TeamId == teamId).FirstOrDefault(); if (team != null) { context.Teams.Remove(team); context.SaveChanges(); } } }