private Employee Casteo(Model.Employee emp)
{
if (emp == null)
{
return(null);
}
if (emp.GetType().Name == "FullTimeEmployee")
{
Model.FullTimeEmployee Memp = (Model.FullTimeEmployee)emp;
FullTimeEmployee employeeBase = new FullTimeEmployee()
{
Id = Memp.EmployeeId,
Name = Memp.Name,
StartDate = Memp.StartDate,
Salary = Memp.Salary
};
return(employeeBase);
}
else
{
Model.PartTimeEmployee Memp = (Model.PartTimeEmployee)emp;
PartTimeEmployee employeeBase = new PartTimeEmployee()
{
Id = Memp.EmployeeId,
Name = Memp.Name,
StartDate = Memp.StartDate,
HourlyRate = Memp.HourlyRate
};
return(employeeBase);
}
}
public Employee GetEmployee(int id)
{
using (Model.PracticoEntities en = new Model.PracticoEntities())
{
Model.Employee e = en.EmployeeTPH.Find(id);
if (e.GetType() == typeof(FullTimeEmployee))
{
Model.FullTimeEmployee fullTime = new Model.FullTimeEmployee();
fullTime = (Model.FullTimeEmployee)e;
return(new FullTimeEmployee()
{
Id = fullTime.EmployeeId,
Name = fullTime.Name,
Salary = fullTime.Salary,
StartDate = fullTime.StartDate,
});
}
else
{
Model.PartTimeEmployee partTime = new Model.PartTimeEmployee();
partTime = (Model.PartTimeEmployee)e;
return(new PartTimeEmployee()
{
Id = partTime.EmployeeId,
Name = partTime.Name,
HourlyRate = partTime.HourlyRate,
StartDate = partTime.StartDate,
});
}
}
}
private Employee casteo(Model.Employee emp)
{
if (emp != null)
{
if (emp.GetType().Name == "FullTimeEmployee")
{
Model.FullTimeEmployee x = (Model.FullTimeEmployee)emp;
FullTimeEmployee employeeBase = new FullTimeEmployee()
{
Id = x.EmployeeId,
Name = x.Name,
StartDate = x.StartDate,
Salary = x.Salary
};
return(employeeBase);
}
else
{
Model.PartTimeEmployee x = (Model.PartTimeEmployee)emp;
PartTimeEmployee employeeBase = new PartTimeEmployee()
{
Id = x.EmployeeId,
Name = x.Name,
StartDate = x.StartDate,
HourlyRate = x.HourlyRate
};
return(employeeBase);
}
}
return(null);
}
public void UpdateEmployee(Employee emp)
{
using (Model.PracticoObligatorioEntities1 en = new Model.PracticoObligatorioEntities1())
{
if (emp.GetType() == typeof(Shared.Entities.FullTimeEmployee))
{
FullTimeEmployee FullTimeEmp = (FullTimeEmployee)emp;
Model.Employee e = en.EmployeesTPH.Find(emp.EMP_ID);
if (e != null)
{
Model.FullTimeEmployee empFT = (Model.FullTimeEmployee)e;
empFT.NAME = FullTimeEmp.NAME;
empFT.SALARY = FullTimeEmp.SALARY;
empFT.START_DATE = FullTimeEmp.START_DATE;
en.SaveChanges();
}
}
else
{
PartTimeEmployee PartTimeEmp = (PartTimeEmployee)emp;
Model.Employee e = en.EmployeesTPH.Find(emp.EMP_ID);
if (e != null)
{
Model.PartTimeEmployee empFT = (Model.PartTimeEmployee)e;
empFT.NAME = PartTimeEmp.NAME;
empFT.SALARY = PartTimeEmp.SALARY;
empFT.START_DATE = PartTimeEmp.START_DATE;
en.SaveChanges();
}
}
}
}
public void AddEmployee(Employee emp)
{
using (Model.PracticoObligatorioEntities1 en = new Model.PracticoObligatorioEntities1())
{
Model.Employee empNuevo;
if (emp.GetType() == typeof(Shared.Entities.FullTimeEmployee))
{
FullTimeEmployee empFT = (FullTimeEmployee)emp;
empNuevo = new Model.FullTimeEmployee()
{
EMP_ID = empFT.EMP_ID,
NAME = empFT.NAME,
SALARY = empFT.SALARY,
START_DATE = empFT.START_DATE
};
en.EmployeesTPH.Add(empNuevo);
en.SaveChanges();
}
else
{
PartTimeEmployee empPT = (PartTimeEmployee)emp;
empNuevo = new Model.PartTimeEmployee()
{
EMP_ID = empPT.EMP_ID,
NAME = empPT.NAME,
SALARY = empPT.SALARY,
START_DATE = empPT.START_DATE
};
en.EmployeesTPH.Add(empNuevo);
en.SaveChanges();
}
}
}
public Employee GetEmployee(int id)
{
Model.ER1Entities context = new Model.ER1Entities();
// DataContext takes a connection string.
IQueryable <Model.Employee> query =
from employee in context.Employees
where employee.Id == id
select employee;
Model.Employee empR = query.First();
if (empR.GetType() == typeof(Model.FullTimeEmployee))
{
FullTimeEmployee result = new FullTimeEmployee();
result.Id = id;
result.Name = empR.Name;
result.Salary = ((Model.FullTimeEmployee)empR).Salary;
result.StartDate = empR.StartDate;
return(result);
}
else
{
PartTimeEmployee result = new PartTimeEmployee();
result.Id = id;
result.Name = empR.Name;
result.HourlyRate = ((Model.PartTimeEmployee)empR).HourlyRate;
result.StartDate = empR.StartDate;
return(result);
}
}
public Employee GetEmployee(int id)
{
using (Model.Entity en = new Model.Entity()) {
Model.Employee e = en.Employees.Find(id);
if (e.GetType() == typeof(Model.FullTimeEmployee))
{
Model.FullTimeEmployee em = (Model.FullTimeEmployee)e;
return(new FullTimeEmployee()
{
Id = em.EmployeeId,
Name = em.Name,
StartDate = em.StartDate,
Salary = em.Salary
});
}
else
{
Model.PartTimeEmployee em = (Model.PartTimeEmployee)e;
return(new PartTimeEmployee()
{
Id = em.EmployeeId,
Name = em.Name,
StartDate = em.StartDate,
HourlyRate = em.HourlyRate
});
}
}
}
public Employee GetEmployee(int id)
{
using (Model.ObligatorioEntities en = new Model.ObligatorioEntities())
{
Model.Employee emp = en.Employee.Find(id);
Employee retorno = null;
if (emp != null)
{
if (emp.GetType() == typeof(Model.FullTimeEmployee))
{
Model.FullTimeEmployee fullTime = (Model.FullTimeEmployee)emp;
retorno = new FullTimeEmployee()
{
Id = fullTime.EMP_ID,
Name = fullTime.NAME,
StartDate = fullTime.START_DATE,
Salary = (int)fullTime.SALARY
};
}
else
{
Model.PartTimeEmployee partTime = (Model.PartTimeEmployee)emp;
retorno = new PartTimeEmployee()
{
Id = partTime.EMP_ID,
Name = partTime.NAME,
StartDate = partTime.START_DATE,
HourlyRate = (double)partTime.RATE
};
}
}
return(retorno);
}
}
public void DeleteEmployee(int id)
{
using (var context = new Model.PracticoNetEntities())
{
Model.Employee emp = context.Employee.FirstOrDefault(x => x.EmployeeId == id);
if (emp != null)
{
if (emp.GetType().Name == "FullTimeEmployee")
{
Model.FullTimeEmployee fte = (Model.FullTimeEmployee)emp;
context.Employee.Remove(fte);
context.SaveChanges();
}
else
{
Model.PartTimeEmployee pte = (Model.PartTimeEmployee)emp;
context.Employee.Remove(pte);
context.SaveChanges();
}
}
}
}
