public void UpdateEmployee(Employee emp) { using (Model.TESTEntities DB = new Model.TESTEntities()) { if (emp != null) { if (emp != null) { Model.Employee EmpDB = DB.Employees.Find(emp.Id); if (EmpDB is Model.PartTimeEmployee) { PartTimeEmployee empLP = (PartTimeEmployee)emp; Model.PartTimeEmployee nuevo = (Model.PartTimeEmployee)EmpDB; nuevo.Name = empLP.Name; nuevo.StartDate = empLP.StartDate; nuevo.HourlyRate = empLP.HourlyRate; DB.Employees.Attach(nuevo); } else { FullTimeEmployee empLP = (FullTimeEmployee)emp; Model.FullTimeEmployee nuevo = (Model.FullTimeEmployee)EmpDB; nuevo.Name = empLP.Name; nuevo.StartDate = empLP.StartDate; nuevo.Salary = empLP.Salary; DB.Employees.Attach(nuevo); } DB.SaveChanges(); } } } }
public void AddEmployee(Employee emp) { using (Model.TESTEntities DB = new Model.TESTEntities()) { if (emp is PartTimeEmployee) { PartTimeEmployee empLP = new PartTimeEmployee(); Model.PartTimeEmployee nuevo = new Model.PartTimeEmployee(); nuevo.EmployeeId = empLP.Id; nuevo.Name = empLP.Name; nuevo.StartDate = empLP.StartDate; nuevo.HourlyRate = empLP.HourlyRate; DB.Employees.Add(nuevo); } else { FullTimeEmployee empLP = new FullTimeEmployee(); Model.FullTimeEmployee nuevo = new Model.FullTimeEmployee(); nuevo.EmployeeId = empLP.Id; nuevo.Name = empLP.Name; nuevo.StartDate = empLP.StartDate; nuevo.Salary = empLP.Salary; DB.Employees.Add(nuevo); } DB.SaveChanges(); } }
public void DeleteEmployee(int id) { using (Model.TESTEntities DB = new Model.TESTEntities()) { DB.Employees.Remove(DB.Employees.Find(id)); DB.SaveChanges(); } }