public List <Employee> GetAllEmployees()
{
List <Employee> lista = new List <Employee>();
using (Model.TESTEntities DB = new Model.TESTEntities())
{
var ListEmp = (from e in DB.Employees select e).ToList();
foreach (Model.Employee emp in ListEmp)
{
if (emp is Model.PartTimeEmployee)
{
Model.PartTimeEmployee empDB = (Model.PartTimeEmployee)emp;
PartTimeEmployee nuevo = new PartTimeEmployee();
nuevo.Id = empDB.EmployeeId;
nuevo.Name = empDB.Name;
nuevo.StartDate = empDB.StartDate;
nuevo.HourlyRate = (Double)empDB.HourlyRate;
lista.Add(nuevo);
}
else
{
Model.FullTimeEmployee empDB = (Model.FullTimeEmployee)emp;
FullTimeEmployee nuevo = new FullTimeEmployee();
nuevo.Id = empDB.EmployeeId;
nuevo.Name = empDB.Name;
nuevo.StartDate = empDB.StartDate;
nuevo.Salary = (int)empDB.Salary;
lista.Add(nuevo);
}
}
}
return(lista);
}
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 Employee GetEmployee(int id)
{
using (Model.TESTEntities DB = new Model.TESTEntities())
{
var ListEmp = (from e in DB.Employees where e.EmployeeId == id select e).ToList();
foreach (Model.Employee emp in ListEmp)
{
if (emp is Model.PartTimeEmployee)
{
Model.PartTimeEmployee empDB = (Model.PartTimeEmployee)emp;
PartTimeEmployee nuevo = new PartTimeEmployee();
nuevo.Id = empDB.EmployeeId;
nuevo.Name = empDB.Name;
nuevo.StartDate = empDB.StartDate;
nuevo.HourlyRate = (Double)empDB.HourlyRate;
return(nuevo);
}
else
{
Model.FullTimeEmployee empDB = (Model.FullTimeEmployee)emp;
FullTimeEmployee nuevo = new FullTimeEmployee();
nuevo.Id = empDB.EmployeeId;
nuevo.Name = empDB.Name;
nuevo.StartDate = empDB.StartDate;
nuevo.Salary = (int)empDB.Salary;
return(nuevo);
}
}
return(null);
}
}
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();
}
}