public void DeleteEmployee(int id)
{
try
{
using (DataAccessLayer.Model.ObligEntities context = new Model.ObligEntities())
{
var result = from emp in context.Employee
where emp.EmployeeId == id
select emp;
var error = "";
if (result.Count() == 1)
{
Model.Employee EmpleadoB = result.First();
context.Employee.Remove(EmpleadoB);
context.SaveChanges();
}
else
{
throw new ArgumentNullException(error);
}
}
}catch (ArgumentNullException ex)
{
Console.WriteLine("Argumentos invalidos");
}
}
public List <Employee> GetAllEmployees()
{
try
{
List <Employee> employeesList = new List <Employee>();
using (Model.ObligEntities context = new Model.ObligEntities())
{
var employeeListModel = context.Employee.ToList();
foreach (var emp in employeeListModel)
{
if (emp is Model.FullTimeEmployee)
{
var fullTimeEmployeeModel = (Model.FullTimeEmployee)emp;
var fullTimeEmployee = new FullTimeEmployee()
{
Id = fullTimeEmployeeModel.EmployeeId,
Name = fullTimeEmployeeModel.Name,
Salary = Convert.ToInt32(fullTimeEmployeeModel.Salary),
StartDate = fullTimeEmployeeModel.StartDate
};
employeesList.Add(fullTimeEmployee);
}
else
{
var partTimeEmployeeModel = (Model.PartTimeEmployee)emp;
var partTimeEmployee = new PartTimeEmployee()
{
Id = partTimeEmployeeModel.EmployeeId,
HourlyRate = Convert.ToDouble(partTimeEmployeeModel.HourlyRate),
Name = partTimeEmployeeModel.Name,
StartDate = partTimeEmployeeModel.StartDate
};
employeesList.Add(partTimeEmployee);
}
}
}
return(employeesList);
}
catch (Exception ex)
{
throw ex;
}
}
public void UpdateEmployee(Employee emp)
{
try
{
using (Model.ObligEntities context = new Model.ObligEntities())
{
var employee = context.Employee.Find(emp.Id);
var error = "";
if (emp is PartTimeEmployee)
{
var partTimeEmployeeModel = (Model.PartTimeEmployee)employee;
var partTimeEmployee = (PartTimeEmployee)emp;
if (partTimeEmployee is null)
{
throw new ArgumentNullException(error);
}
else
{
partTimeEmployeeModel.Name = partTimeEmployee.Name;
partTimeEmployeeModel.StartDate = partTimeEmployee.StartDate;
partTimeEmployeeModel.HourlyRate = partTimeEmployee.HourlyRate;
}
}
else
{
var fullTimeEmployeeModel = (Model.FullTimeEmployee)employee;
var fullTimeEmployee = (FullTimeEmployee)emp;
fullTimeEmployeeModel.Name = fullTimeEmployee.Name;
fullTimeEmployeeModel.StartDate = fullTimeEmployee.StartDate;
fullTimeEmployeeModel.Salary = fullTimeEmployee.Salary;
}
context.SaveChanges();
}
}
catch (ArgumentNullException ex) // pasan emp null
{
Console.WriteLine("Argumentos invalidos");
}
}
public void AddEmployee(Employee emp)
{
try
{
string type = emp.GetType().BaseType.Name;
using (DataAccessLayer.Model.ObligEntities context = new Model.ObligEntities())
{
DataAccessLayer.Model.Employee employee = null;
if (emp is PartTimeEmployee)
{
PartTimeEmployee partTimeEmployee = (PartTimeEmployee)emp; // casteito
employee = new DataAccessLayer.Model.PartTimeEmployee()
{
Name = partTimeEmployee.Name,
StartDate = partTimeEmployee.StartDate,
HourlyRate = partTimeEmployee.HourlyRate
};
}
else
{
FullTimeEmployee fullTimeEmployee = (FullTimeEmployee)emp;
employee = new DataAccessLayer.Model.FullTimeEmployee()
{
Name = fullTimeEmployee.Name,
StartDate = fullTimeEmployee.StartDate,
Salary = fullTimeEmployee.Salary
};
}
context.Employee.Add(employee);
context.SaveChanges();
}
// check
}
catch (Exception e)
{
throw e;
}
//throw new NotImplementedException();
}
public Employee GetEmployee(int id)
{
try
{
using (Model.ObligEntities context = new Model.ObligEntities())
{
var employee = context.Employee.Find(id);
if (employee is Model.FullTimeEmployee)
{
var fullTimeEmployeeModel = (Model.FullTimeEmployee)employee;
var fullTimeEmployee = new FullTimeEmployee()
{
Id = fullTimeEmployeeModel.EmployeeId,
Name = fullTimeEmployeeModel.Name,
Salary = Convert.ToInt32(fullTimeEmployeeModel.Salary),
StartDate = fullTimeEmployeeModel.StartDate
};
return(fullTimeEmployee);
}
else
{
var partTimeEmployeeModel = (Model.PartTimeEmployee)employee;
var partTimeEmployee = new PartTimeEmployee()
{
Id = partTimeEmployeeModel.EmployeeId,
HourlyRate = Convert.ToDouble(partTimeEmployeeModel.HourlyRate),
Name = partTimeEmployeeModel.Name,
StartDate = partTimeEmployeeModel.StartDate
};
return(partTimeEmployee);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
