public JsonResult GetAllEmployee()
{
using (EmployeeConnection emp = new EmployeeConnection())
{
List <EMPLOYEE> objEmp = emp.EMPLOYEEs.ToList();
return(Json(objEmp, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetEmployeeById(string id)
{
using (EmployeeConnection emp = new EmployeeConnection())
{
var empid = int.Parse(id);
return(Json(emp.EMPLOYEEs.Find(empid), JsonRequestBehavior.AllowGet));
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Employee> getAllEmployees()
{
List <Employee> _lstEmployee = EmployeeConnection.readAllEmployees();
foreach (Employee _oEmployeeItem in _lstEmployee)
{
this.returnWithoutSpaces(_oEmployeeItem);
}
return(_lstEmployee);
}
//------- OTROS TIPOS DE CONSULTAS A LOS EMPLEADOS EN LA BASE DE DATOS ---------
/// <summary>
/// Metodo para consultar todos los empleados en la base de datos
/// </summary>
/// <returns>Envia una peticion a la capa DB para obtener todos los empleados en la DB</returns>
public static List <EmployeeModel> SelectAllEmployees()
{
try
{
return(EmployeeConnection.SelectAllEmployees());
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
///
/// </summary>
/// <param name="nif"></param>
/// <param name="name"></param>
/// <param name="surname"></param>
/// <param name="phone"></param>
/// <param name="email"></param>
/// <param name="adress"></param>
/// <returns></returns>
public bool updateEmployee(String pNif, String pName, String pSurname, String pPhone, String pEmail, String pAdress, String pUsername)
{
Employee newEmployee = new Employee
{
nif = pNif,
name = pName,
surname = pSurname,
phone = pPhone,
email = pEmail,
adress = pAdress,
username = pUsername
};
return(EmployeeConnection.updateEmployee(newEmployee));
}
/// <summary>
/// Este metodo se encarga de eliminar el empleado seleccionado por el ID
/// </summary>
/// <param name="id">Id del empleado seleccionado</param>
/// <returns>Envia una peticion a la capa DB para ver si puede empleado el empleado</returns>
public static bool DeleteEmployeeById(int id)
{
try
{
EmployeeModel employeeModel = new EmployeeModel()
{
Id_Employee = id
};
return(EmployeeConnection.DeleteEmployeeById(employeeModel));
}
catch (Exception ex)
{
throw;
}
}
public JsonResult InsertEmployee(EMPLOYEE objemp)
{
if (objemp != null)
{
using (EmployeeConnection emp = new EmployeeConnection())
{
emp.EMPLOYEEs.Add(objemp);
emp.SaveChanges();
return(Json("Inserted", JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("Employee Not Inserted! Try Again", JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// Method that creates a employee given it's atributes
/// </summary>
/// <param name="nif">Employee nif</param>
/// <param name="name">Employee name</param>
/// <param name="surname">Employee surname</param>
/// <param name="phone">Employee phone</param>
/// <param name="email">Employee email</param>
/// <param name="adress">Employee adress</param>
/// <returns>Whether if the employee has been correctly created or not</returns>
public bool createEmployee(String pNif, String pName, String pSurname, String pPhone, String pEmail, String pAdress)
{
Employee newEmployee = new Employee
{
nif = pNif,
name = pName,
surname = pSurname,
phone = pPhone,
email = pEmail,
adress = pAdress,
//Como los ponemos por default no con el nif i el email no hace falta pedirlos en los parametros
username = pNif, //Default initial username
password = pNif //Default initial password
};
return(EmployeeConnection.createEmployee(newEmployee));
}
/// <summary>
/// Este metodo se encarga de buscar un empleado por medio del texto ingresado
/// </summary>
/// <param name="text">Texto ingresado por el usuario, que puede ser el nombre, apellido o identificacion del empleado.</param>
/// <returns>Envia una peticion a la capa DB para ver si puede encontrar las similitudes del texto con los empleado.</returns>
public static List <EmployeeModel> SelectMultipleEmployees(string text)
{
try
{
EmployeeModel employeeModel = new EmployeeModel()
{
Name = text,
LastName = text,
Identification = text
};
return(EmployeeConnection.SelectMultipleEmployees(employeeModel));
}
catch (Exception ex)
{
return(null);
}
}
public string UpdateEmployee(EMPLOYEE Emp)
{
if (Emp != null)
{
using (EmployeeConnection Obj = new EmployeeConnection())
{
var Emp_ = Obj.Entry(Emp);
EMPLOYEE EmpObj = Obj.EMPLOYEEs.Where(x => x.Emp_Id == Emp.Emp_Id).FirstOrDefault();
EmpObj.Emp_Age = Emp.Emp_Age;
EmpObj.Emp_City = Emp.Emp_City;
EmpObj.Emp_Name = Emp.Emp_Name;
Obj.SaveChanges();
return("Employee Updated Successfully");
}
}
else
{
return("Employee Not Updated! Try Again");
}
}
public string DeleteEmployee(EMPLOYEE Emp)
{
if (Emp != null)
{
using (EmployeeConnection Obj = new EmployeeConnection())
{
var Emp_ = Obj.Entry(Emp);
if (Emp_.State == System.Data.EntityState.Detached)
{
Obj.EMPLOYEEs.Attach(Emp);
Obj.EMPLOYEEs.Remove(Emp);
}
Obj.SaveChanges();
return("Employee Deleted Successfully");
}
}
else
{
return("Employee Not Deleted! Try Again");
}
}
/// <summary>
/// Este metodo se encarga de modificar el empleado seleccionado por el ID
/// </summary>
/// <param name="id">Id del empleado seleccionado</param>
/// <param name="name">Nombre del empleado</param>
/// <param name="lastName">Apellido del empleado</param>
/// <param name="phoneNumber">Número de Teléfono del empleado</param>
/// <param name="idType">Tipo de identificación del empleado</param>
/// <param name="identification">Identificación del empleado</param>
/// <param name="email">Email del empleado</param>
/// <param name="bornDate">Fecha de nacimiento del empleado</param>
/// <returns>Envia una peticion a la capa DB para ver si puede modificar el empleado</returns>
public static bool UpdateEmployeeById(int id, string name, string lastName, string phoneNumber, string idType, string identification, DateTime bornDate)
{
try
{
EmployeeModel employeeModel = new EmployeeModel()
{
Id_Employee = id,
Name = name,
LastName = lastName,
Telephone = phoneNumber,
Identification_Type = idType,
Identification = identification,
Born_Date = bornDate
};
return(EmployeeConnection.UpdateEmployeeById(employeeModel));
}
catch (Exception ex)
{
throw;
}
}
//------- EMPLOYEE ACCIONS CREATE, MODIFY, DELETE ---------
/// <summary>
/// Este metodo se encarga de agregar los empleados
/// </summary>
/// <param name="name">Nombre del empleado</param>
/// <param name="lastName">Apellido del empleado</param>
/// <param name="phoneNumber">Número de Teléfono del empleado</param>
/// <param name="idType">Tipo de identificación del empleado</param>
/// <param name="identification">Identificación del empleado</param>
/// <param name="bornDate">Fecha de nacimiento del empleado</param>
/// <returns>Envia una peticion a la capa DB para ver si puede agregar el empleado</returns>
public static bool InsertEmployee(string name, string lastName, string phoneNumber, string idType, string identification, DateTime bornDate, DateTime fechaRegistro)
{
try
{
EmployeeModel employeeModel = new EmployeeModel()
{
Name = name,
LastName = lastName,
Telephone = phoneNumber,
Identification_Type = idType,
Identification = identification,
Born_Date = bornDate,
Registration_Date = fechaRegistro
};
return(EmployeeConnection.InsertEmployee(employeeModel));
}
catch (Exception ex)
{
}
return(false);
}
/// <summary>
/// Method that returns a Employee if it exists
/// </summary>
/// <param name="pCode"></param>
/// <returns></returns>
public Employee deleteEmployee(Employee pEmployee)
{
return(EmployeeConnection.deleteEmployee(pEmployee));
}
/// <summary>
/// Method that returns the Employee if it found
/// </summary>
/// <param name="pCode"></param>
/// <returns></returns>
public Employee readEmployee(String pCode)
{
return(this.returnWithoutSpaces(EmployeeConnection.readEmployee(pCode)));;
}
/// <summary>
/// Method that returns a boolean if the employee is updated
/// </summary>
/// <param name="pEmployee"></param>
/// <returns></returns>
public bool updateEmployee(Employee pEmployee)
{
return(EmployeeConnection.updateEmployee(pEmployee));
}
