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); }