public void DeleteEmployee(int id) { Model.Practico1TSIEntities db = new Practico1TSIEntities(); var emp = db.EmployeesTPH.Find(id); db.Entry(emp).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); }
public Shared.Entities.PartTimeEmployee GetPartTimeEmployee(int id) { var db = new Practico1TSIEntities(); Model.PartTimeEmployee objEmp = db.EmployeesTPH.OfType <Model.PartTimeEmployee>().Where(e => e.EmployeeID == id).FirstOrDefault(); Shared.Entities.PartTimeEmployee emp = new Shared.Entities.PartTimeEmployee(); emp.Id = objEmp.EmployeeID; emp.Name = objEmp.Name; emp.StartDate = objEmp.StartDate; emp.HourlyRate = objEmp.HourlyRate; return(emp); }
public void AddPartTimeEmployee(Shared.Entities.PartTimeEmployee emp) { var context = new Practico1TSIEntities(); var t = new Model.PartTimeEmployee(); t.Name = emp.Name; //t.EmployeeID = emp.Id; t.StartDate = emp.StartDate; t.HourlyRate = emp.HourlyRate; context.EmployeesTPH.Add(t); context.SaveChanges(); }
public Shared.Entities.FullTimeEmployee GetFullTimeEmployee(int id) { var db = new Practico1TSIEntities(); Model.FullTimeEmployee objEmp = db.EmployeesTPH.OfType <Model.FullTimeEmployee>().Where(e => e.EmployeeID == id).FirstOrDefault(); var retorno = new Shared.Entities.FullTimeEmployee(); retorno.Id = objEmp.EmployeeID; retorno.Name = objEmp.Name; retorno.StartDate = objEmp.StartDate; retorno.Salary = objEmp.Salary; return(retorno); }
public List <Employee> GetAllEmployees() { Console.WriteLine("Entre a listar Empleados de DataAcces"); //creo lista vacia de tipo shared para retornar List <Employee> empList = new List <Employee>(); var db = new Practico1TSIEntities(); List <Model.PartTimeEmployee> empQuery = db.EmployeesTPH.OfType <Model.PartTimeEmployee>().ToList(); Console.WriteLine("Me conecte a la base"); foreach (var emp in empQuery) { Console.WriteLine("Entre al Foreach"); var objEmp = new Shared.Entities.PartTimeEmployee(); objEmp.Id = emp.EmployeeID; objEmp.Name = emp.Name; objEmp.StartDate = emp.StartDate; objEmp.HourlyRate = emp.HourlyRate; empList.Add(objEmp); } var empQueryF = from empF in db.EmployeesTPH.OfType <Model.FullTimeEmployee>() select empF; foreach (var empF in empQueryF) { var objEmp2 = new Shared.Entities.FullTimeEmployee(); objEmp2.Id = empF.EmployeeID; objEmp2.Name = empF.Name; objEmp2.StartDate = empF.StartDate; objEmp2.Salary = empF.Salary; empList.Add(objEmp2); } return(empList); }