/// <summary>
/// Busqueda de datos a partir de parametros de entrada
/// </summary>
/// <param name="consulta"></param>
/// <returns></returns>
public List <IDimEmployeeDTO> GET(IDimEmployeeDTO consulta)
{
List <DimEmployee> respuesta = new List <DimEmployee>();
try
{
if (consulta != null)
{
IQueryable <DimEmployee> buscar = db.DimEmployee.Where(x =>
(x.EmployeeKey == consulta.EmployeeKey || consulta.EmployeeKey == 0) &&
(x.FirstName.Contains(consulta.FirstName) || consulta.FirstName == null) &&
(x.LastName.Contains(consulta.LastName) || consulta.LastName == null) &&
(x.MiddleName.Contains(consulta.MiddleName) || consulta.MiddleName == null) &&
(x.Title.Contains(consulta.Title) || consulta.Title == null) &&
(x.EmailAddress.Contains(consulta.EmailAddress) || consulta.EmailAddress == null)
);
respuesta = buscar.ToList();
}
else
{
respuesta = db.DimEmployee.ToList();
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(respuesta.MapperPruebasDetached(new List <IDimEmployeeDTO>()));
}
/// <summary>
/// Agregar registro
/// </summary>
/// <param name="datos"></param>
/// <returns></returns>
public IDimEmployeeDTO Create(IDimEmployeeDTO datos)
{
DimEmployee DimEmployeeParaGuardar = datos.MapperPruebas <IDimEmployeeDTO, DimEmployee>();
db.DimEmployee.Add(DimEmployeeParaGuardar);
db.SaveChanges();
return(DimEmployeeParaGuardar.MapperPruebas <IDimEmployeeDTO, DimEmployee>());
}
/// <summary>
/// Actualizar Registro
/// </summary>
/// <param name="datos"></param>
/// <returns></returns>
public IDimEmployeeDTO Update(IDimEmployeeDTO datos)
{
DimEmployee DimEmployeeEditar = db.DimEmployee.FirstOrDefault(c =>
c.EmployeeKey == datos.EmployeeKey);
DimEmployee parametros = datos.MapperPruebasDetached(new DimEmployee());
if (DimEmployeeEditar == null)
{
return(new DimEmployee());
}
//Mapeo para actualizar
DimEmployeeEditar.ParentEmployeeKey = parametros.ParentEmployeeKey;
DimEmployeeEditar.FirstName = parametros.FirstName;
DimEmployeeEditar.LastName = parametros.LastName;
DimEmployeeEditar.MiddleName = parametros.MiddleName;
DimEmployeeEditar.Title = parametros.Title;
DimEmployeeEditar.HireDate = parametros.HireDate;
DimEmployeeEditar.BirthDate = parametros.BirthDate;
DimEmployeeEditar.EmailAddress = parametros.EmailAddress;
DimEmployeeEditar.Phone = parametros.Phone;
DimEmployeeEditar.MaritalStatus = parametros.MaritalStatus;
DimEmployeeEditar.EmergencyContactName = parametros.EmergencyContactName;
DimEmployeeEditar.EmergencyContactPhone = parametros.EmergencyContactPhone;
DimEmployeeEditar.SalariedFlag = parametros.SalariedFlag;
DimEmployeeEditar.Gender = parametros.Gender;
DimEmployeeEditar.PayFrequency = parametros.PayFrequency;
DimEmployeeEditar.BaseRate = parametros.BaseRate;
DimEmployeeEditar.VacationHours = parametros.VacationHours;
DimEmployeeEditar.CurrentFlag = parametros.CurrentFlag;
DimEmployeeEditar.SalesPersonFlag = parametros.SalesPersonFlag;
DimEmployeeEditar.DepartmentName = parametros.DepartmentName;
DimEmployeeEditar.StartDate = parametros.StartDate;
DimEmployeeEditar.EndDate = parametros.EndDate;
DimEmployeeEditar.Status = parametros.Status;
DimEmployeeEditar.ImageUrl = parametros.ImageUrl;
DimEmployeeEditar.ProfileUrl = parametros.ProfileUrl;
DimEmployeeEditar.ETLLoadID = parametros.ETLLoadID;
DimEmployeeEditar.LoadDate = parametros.LoadDate;
DimEmployeeEditar.UpdateDate = parametros.UpdateDate;
if (db.SaveChanges() <= 0)
{
//error
}
return(DimEmployeeEditar);
}
/// <summary>
/// Eliminar un registro a partir del id de un empleado
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public IDimEmployeeDTO Update(IDimEmployeeDTO datos)
{
//Aqui irian las reglas de negocio
return(employee.Value.Update(datos));
}
/// <summary>
/// Busqueda de datos a partir de parametros de entrada
/// </summary>
/// <param name="consulta"></param>
/// <returns></returns>
public List <IDimEmployeeDTO> GET(IDimEmployeeDTO consulta)
{
//Aqui irian las reglas de negocio
return(employee.Value.GET(consulta));
}
