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);
}
