private string GetEmployee(int employeeID)
{
if (employeeID > 0)
{
EmployeeProcess process = new EmployeeProcess();
Common.Employee employee = process.GetByID(employeeID);
return(String.Format("{0} , {1} {2}", employee.LastName, employee.FirstName, employee.MiddleName));
}
return(String.Empty);
}
/// <summary>
/// Obtiene un Persona de la base de datos
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static Common.Employee ObtenerEmpleado(Guid id)
{
Common.Employee persona = new Common.Employee();
SqlCommand cmd = null;
SqlDataReader dr = null;
string query = @"SELECT idPersona, idUsuario cedulaDeIdentidad, nombres, primerApellido, segundoApellido, correoElectronico, direccion, telefono, eliminado
FROM Persona
WHERE idPersona = @id and eliminado = 1";
try
{
cmd = OperationsSql.CreateBasicCommand(query);
cmd.Parameters.AddWithValue("@id", id);
dr = OperationsSql.ExecuteDataReaderCommand(cmd);
while (dr.Read())
{
persona = new Common.Employee()
{
IdPerson = dr.GetGuid(0),
User = UserDal.Obtener(dr.GetGuid(1)),
IdentityCard = dr.GetString(2),
Names = dr.GetString(3),
FirstSurname = dr.GetString(4),
SecondSurname = dr.GetString(5),
Email = dr.GetString(6),
Address = dr.GetString(7),
Phone = dr.GetInt32(8),
State = dr.GetByte(9)
};
}
}
catch (Exception ex)
{
OperationsLogs.WriteLogsRelease("PersonaDal", "ObtenerEmpleado(Get)", string.Format("{0} Error: {1}", DateTime.Now.ToString(), ex.Message));
throw ex;
}
finally
{
cmd.Connection.Close();
}
return(persona);
}
