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();
}
}
}
