public void DeleteEmployee(int id)
{
using (var db = new CRUDDBEntities())
{
var empToDelete = db.Employees.FirstOrDefault(x => x.EmployeeID == id);
if (empToDelete != null)
{
db.Employees.Remove(empToDelete);
db.SaveChanges();
}
}
}
public void InsertEmployee(EmployeeModel model)
{
using (var db = new CRUDDBEntities())
{
var empToAdd = db.Employees.FirstOrDefault(x => x.EmployeeID == model.EmployeeID);
if (empToAdd != null)
{
empToAdd.EmployeeID = model.EmployeeID;
empToAdd.Age = model.Age;
empToAdd.Salary = model.Salary;
empToAdd.Name = model.Name;
empToAdd.Position = model.Position;
db.Entry(empToAdd).State = EntityState.Modified;
db.SaveChanges();
}
}
}
public void UpdateEmployee(EmployeeModel model)
{
using (var db = new CRUDDBEntities())
{
var EmpToEdit = db.Employees.FirstOrDefault(x => x.EmployeeID == model.EmployeeID);
if (EmpToEdit != null)
{
EmpToEdit.EmployeeID = model.EmployeeID;
EmpToEdit.Age = model.Age;
EmpToEdit.Salary = model.Salary;
EmpToEdit.Position = model.Position;
EmpToEdit.Name = model.Name;
db.Entry(EmpToEdit).State = EntityState.Modified;
db.SaveChanges();
}
}
}
