public void AddEmployee(Employee emp)
{
using (KPITEmployeeTestEntities _dbContext = new KPITEmployeeTestEntities())
{
_dbContext.Employees.Add(emp);
_dbContext.SaveChanges();
}
}
public void AddLocation(Location location)
{
using (KPITEmployeeTestEntities _dbContext = new KPITEmployeeTestEntities())
{
_dbContext.Locations.Add(location);
_dbContext.SaveChanges();
}
}
public void Delete(int id)
{
using (KPITEmployeeTestEntities _dbContext = new KPITEmployeeTestEntities())
{
Employee emp = _dbContext.Employees.Find(id);
_dbContext.Employees.Remove(emp);
_dbContext.SaveChanges();
}
}
public void Delete(int empId)
{
using (KPITEmployeeTestEntities _dbContext = new KPITEmployeeTestEntities())
{
Location location = _dbContext.Locations.Where(p => p.EmployeeId == empId).FirstOrDefault();
_dbContext.Locations.Remove(location);
_dbContext.SaveChanges();
}
}