public Entities.Employee GetEmployeeByID(Int32 employeeID)
{
try
{
using (CPDSEntities context = new CPDSEntities())
{
if (context.Employee.Any(emp => emp.EmployeeID == employeeID) == true)
{
return(this.ConvertToEntitiesEmployee(context.Employee.Where(emp => emp.EmployeeID == employeeID).First()));
}
return(new Entities.Employee());
}
}
catch (Exception ex)
{
throw;
}
}
public List <Entities.Employee> GetEmployees()
{
try
{
List <Entities.Employee> employees = new List <Entities.Employee>();
using (CPDSEntities context = new CPDSEntities())
{
context.Employee.ToList().ForEach((emp) =>
{
employees.Add(this.ConvertToEntitiesEmployee(emp));
});
}
return(employees);
}
catch (Exception ex)
{
throw;
}
}
public Entities.Employee DeleteEmployee(Int32 employeeID)
{
try
{
using (CPDSEntities context = new CPDSEntities())
{
if (context.Employee.Any(e => e.EmployeeID == employeeID) == true)
{
Employee modEmp = context.Employee.Where(e => e.EmployeeID == employeeID).First();
context.Employee.Remove(modEmp);
context.SaveChanges();
}
return(new Entities.Employee());
}
}
catch (Exception ex)
{
throw;
}
}
public Entities.Employee InsertEmployee(Entities.Employee emp)
{
try
{
using (CPDSEntities context = new CPDSEntities())
{
Employee newEmp = ConvertFromEntitiesEmployee(emp);
context.Employee.Add(newEmp);
context.SaveChanges();
emp.EmployeeNumber = newEmp.EmployeeID;
}
return(emp);
}
catch (Exception ex)
{
throw;
}
}
public Entities.Employee UpdateEmployee(Entities.Employee emp)
{
try
{
using (CPDSEntities context = new CPDSEntities())
{
if (context.Employee.Any(e => e.EmployeeID == emp.EmployeeNumber) == true)
{
Employee modEmp = context.Employee.Where(e => e.EmployeeID == emp.EmployeeNumber).First();
this.ConvertFromEntitiesEmployee(emp, ref modEmp);
context.SaveChanges();
return(emp);
}
return(new Entities.Employee());
}
}
catch (Exception ex)
{
throw;
}
}
