public List <Country> GetList()
{
using (var db = new EmployeesDBContext())
{
return(db.Countries.ToList());
}
}
public Employee GetById(int id)
{
using (var db = new EmployeesDBContext())
{
return(db.Employees.FirstOrDefault(e => e.Id == id));
}
}
public List <CityVM> GetListByCountryId(int countryId)
{
using (var db = new EmployeesDBContext())
{
return(db.Cities.Where(c => c.CountryId == countryId).Select(c => new CityVM
{
Id = c.Id,
Name = c.Name
}).ToList());
}
}
public bool Create(Employee employee)
{
using (var db = new EmployeesDBContext())
{
try
{
db.Employees.Add(employee);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public List <EmployeeListVM> GetList()
{
using (var db = new EmployeesDBContext())
{
var employees = db.Employees.Select(e => new EmployeeListVM
{
Id = e.Id,
Name = e.Name,
Gender = e.Gender,
Birthdate = e.Birthdate,
CityId = e.CityId,
CiyName = e.CityId != null?e.City.Name:null
}).ToList();
return(employees);
}
}
public bool Delete(int id)
{
using (var db = new EmployeesDBContext())
{
try
{
var q = db.Employees.FirstOrDefault(x => x.Id == id);
if (q != null)
{
db.Employees.Remove(q);
db.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
}
public bool Update(Employee employee)
{
using (var db = new EmployeesDBContext())
{
try
{
var q = db.Employees.FirstOrDefault(e => e.Id == employee.Id);
if (q != null)
{
q.Id = employee.Id;
q.Name = employee.Name;
q.Gender = employee.Gender;
q.Birthdate = employee.Birthdate;
q.CityId = employee.CityId;
db.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
}
public AccountController(EmployeesDBContext context)
{
_context = context;
}
public ManagerService(EmployeesDBContext db)
: base(db)
{
}
protected Service(EmployeesDBContext db)
{
this.db = db;
}
public EmployeeService(EmployeesDBContext db)
: base(db)
{
}
public PeopleController(EmployeesDBContext context)
{
_context = context;
}
public EmployeesController(EmployeesDBContext context)
{
_context = context;
}
public DBInitializeService(EmployeesDBContext db)
: base(db)
{
}
