public void Edit(Employee p)
{
if ( p != null ) {
accion = ETipoAccion.EDIT;
ValidateEmployeeProperty(p);
db.Entry(p).State = EntityState.Modified;
}
else
throw new ArgumentNullException("Employee");
}
public Employee Retrieve(Employee p)
{
Employee po = null;
if ( p.EmployeeID != null ) {
po = db.Employee.FirstOrDefault(x => x.EmployeeID == p.EmployeeID);
}
if ( p == null ) {
po = db.Employee.Find(p);
}
return po;
}
public ActionResult Create(Employee employee)
{
if (ModelState.IsValid)
{
db.Employee.Add(employee);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(employee);
}
public void Delete(Employee p)
{
if ( p != null ) {
accion = ETipoAccion.DELETE;
ValidateEmployeeProperty(p);
db.Employee.Remove(p); ;
db.SaveChanges();
}
else {
throw new ArgumentNullException("Employee");
}
}
public Employee Create(Employee p)
{
if ( p != null && p.Person!=null) {
accion = ETipoAccion.CREATE;
ValidateEmployeeProperty(p);
db.Employee.Add(p);
db.SaveChanges();
return db.Employee.FirstOrDefault(x => x.Person.ID == p.Person.ID);
}
else {
throw new ArgumentNullException("Employee");
}
}
public Employee RetrieveComplete(Employee p)
{
if ( p != null && p.EmployeeID!=null && p.EmployeeID>0) {
var po =(from e in db.Employee.Include("Person")
where e.EmployeeID==p.EmployeeID
select e).FirstOrDefault();
//var po = (from e in db.Employee
// join per in db.Person
// on e.Person.ID equals per.ID
// where e.EmployeeID == p.EmployeeID
// select new Employee {
// EmployeeID = e.EmployeeID,
// PayMent = e.PayMent,
// Position = e.Position,
// Person = per
// });
return po;
}
else {
return null;
}
}
private void ValidateEmployeeProperty(Employee p)
{
switch ( accion ) {
case ETipoAccion.CREATE:
if ( p == null || p.EmployeeID == null || p.Person == null || p.Person.ID == null ) {
throw new DbEntityValidationException("EmployeeID,PersonID");
}
break;
case ETipoAccion.EDIT:
if ( p == null || p.EmployeeID == null || p.Person == null || p.Person.ID == null ) {
throw new DbEntityValidationException("EmployeeID,PersonID");
}
break;
case ETipoAccion.DELETE:
if ( p == null || p.EmployeeID == null ) {
throw new DbEntityValidationException("EmployeeID,PersonID");
}
break;
default:
break;
}
return;
}
public List<Employee> RetrieveEmployees(Employee p)
{
if ( p != null ) {
long? eId = p.EmployeeID != null ? p.EmployeeID : null;
long? id = p.Person != null && p.Person.ID != null ? p.Person.ID : null;
List<Employee> ls = null;
if ( eId != null ) {
ls = db.Employee.Where(x => x.EmployeeID == eId).ToList<Employee>();
}
if ( id != null ) {
if ( ls != null && ls.Count >= 1 ) {
ls = ls.Where(x => x.Person.ID == p.Person.ID).ToList<Employee>();
}
else {
ls = db.Employee.Where(x => x.Person.ID == p.Person.ID).ToList<Employee>();
}
}
return ls.ToList<Employee>();
}
else {
return db.Employee.ToList<Employee>();
}
}
public List<Employee> RetrieveEmployees()
{
var em = db.Employee;
List<Employee> ls = new List<Employee>();
foreach (Employee item in em ) {
Employee emp = new Employee();
emp = RetrieveComplete(item);
ls.Add(emp);
}
return ls;
}
public ActionResult Edit(Employee employee)
{
if (ModelState.IsValid)
{
db.Entry(employee).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(employee);
}