Posts by Sérgio Sereno • 1,008 points
49 posts
-
0
votes0
answers43
viewsQ: Error "Unable to resolve Ilogger from Microsoft.Extensions.Logging" when making a request to endpoint from Azure fucntion
I have an Azure Function that has an endpoint that questions a data repository and to have Traces of what the function does I used the ILogger<T>. The class in question has the implementation…
-
1
votes1
answer241
viewsA: How to initialize BSO and PSO variables from the Spring environment?
I understand the goal of creating the context class, and so be able to use throughout the project, but some important notes. All extensibility classes that inherit from the PRIMAVERA base classes…
c#answered Sérgio Sereno 1,008 -
4
votes1
answer279
viewsA: How to make a . dll in VBA?
It is not possible to create DLL’s with VBA, this is only possible with the basic visual (vb6) what I do not recommend to date. So your only solution to isolate your code is through a. NET project.…
-
-1
votes2
answers209
viewsA: Migration Imprimelistagem V9 - V10 in web application
Not knowing the type of report and with the lack of code, if you give more information it is easier to know and be able to analyze, but I still leave here this example that is working well. Also…
c#answered Sérgio Sereno 1,008 -
0
votes1
answer466
viewsA: How to change text within Text Box in Word using VBA
Hello. One way to do this is by accessing the collection of "shapes" objects that exist in the document, but note that there are some "shapes" that do not support this property, so you have to test…
-
0
votes1
answer97
viewsA: Invoice creation problem when using Github project
to create a webapi invoice in an billing application you have to comply with some requirements, see: Create a company (all transactions are within the ambit of a company) Create the entity for who…
c#answered Sérgio Sereno 1,008 -
0
votes1
answer363
viewsA: Spring V10 - Error in Abreempresa
If I understand correctly, you are making a web application. If so, I recommend that you do not use the API directly in your application, and the answer is simple. A web application is an…
-
-3
votes2
answers142
viewsA: Code in Employees After Saving Business Layer (V10)
Hello These types of events are not yet available for this module, at least for now. As far as I have been able to find out from the producer, this is a limitation without a resolution date.…
c#answered Sérgio Sereno 1,008 -
1
votes1
answer100
viewsA: V9 - Problems with the creation of the Gprbeofcomponent object - Production
Hello, I suppose this project is in VB.NET and they are using as reference the Interop’s made available by PRIMAVERA, so by the message it seems clear that the DLL’s that are registered in the…
vb.netanswered Sérgio Sereno 1,008 -
1
votes1
answer178
viewsA: How to drilldown to the customer data sheet and to the Article sheet (V10)?
Hello Daniel Vieira is right, no Github PRIMAVERABSS you have several examples on this subject, however here is the tip for the entities. internal static void drillDownEntidade(StdBSInterfPub PSO,…
c#answered Sérgio Sereno 1,008 -
1
votes1
answer197
viewsA: Extensibility V10 Event Error After Blackout When Opening Customform
Good afternoon As far as I have been able to ascertain, this is an error of the last SPRING ERP publication and a correction must be made available.
c#answered Sérgio Sereno 1,008 -
1
votes1
answer94
viewsA: Print settlement document
The only way to print the document is to initialize the print as in the case of sales documents. That is using the document printing API Plataforma.Mapas.ImprimeListagem(). Before that it is…
vb.netanswered Sérgio Sereno 1,008 -
2
votes1
answer198
viewsA: Assembley resolve is not called in a console application
The use of Assembly resolve assumes that before any call/use of external references, this is always instantiated in first place, that is, it has to be the first thing that the application does. In…
c#answered Sérgio Sereno 1,008 -
1
votes1
answer198
viewsQ: Assembley resolve is not called in a console application
Hello. I have a console application that runs in a different folder than the folder where the ERP PRIMAVERA core assemblies I need to use are located. The problem is that when you run my…
c#asked Sérgio Sereno 1,008 -
0
votes2
answers141
viewsA: Unable to regenerate a secret client in Jasmin
Hello John yes you can reset the client secret, as you can see in the image below.…
-
1
votes2
answers313
viewsA: Form Migration to V10
What you really want is something quite different. So to have access to the selected line in the user form the best is just to pass the object in question and not the whole class. In VBA all classes…
vb.netanswered Sérgio Sereno 1,008 -
1
votes2
answers313
viewsA: Form Migration to V10
Bruno, first of all start by creating a PEX project using the extension for the VS available on Markettplace, and that can be accessed here on network developers. This will always ensure all…
vb.netanswered Sérgio Sereno 1,008 -
0
votes2
answers1120
viewsA: I need to generate a pdf report from a div HTML
To work as text it is necessary to realize that you will not have printed the page with the same formatting and colors, this is only possible being an image. an alternative is to use the plugin…
-
4
votes1
answer86
viewsA: Why can’t I compare an object to another object?
Well objects are treated as reference, or memory pointer, so it is not possible to use === or == to compare the two. A quick way to compare the two objects is to see if they have the same value in…
javascriptanswered Sérgio Sereno 1,008 -
0
votes1
answer60
viewsA: Add Parameters query to url redirect in Implicit Flow authorization process
Implicit authentication flow serves to be used in client applications that typically cannot safely maintain the Client Secret because the code is all customer-friendly. This flow accepts as…
-
1
votes1
answer51
viewsA: Delete duplicate rows in a table
There’s some way to do this, what comes to mind in a simple way is something like: -- Obter apenas um ocorrencia de nome e guardar na temporaria. select distinct nome into #tmp From projeto --…
-
1
votes2
answers804
viewsA: SAVE VARBINARY IMAGE IN DATABASE
Before for an example of how to do this I leave a few considerations that you should take into account before moving to that approach. And as at everything in life it is not easy to decide. Choose…
-
0
votes1
answer35
viewsA: How to get the listed network drive name
You can use the property VolumeLabelas below. foreach (DriveInfo drv in DriveInfo.GetDrives()) { if (drv.IsReady) { TreeNode node = new TreeNode(); node.Tag = drv.RootDirectory;…
-
1
votes2
answers211
viewsA: How can I treat Interops with an Assemblyresolve for a Class Library (DLL) project
Caro José To João’s answer that is correct , I just add that in the reality of integration with the ERP V10 there is an article on the Network Developers that explains precisely with all the details…
.netanswered Sérgio Sereno 1,008 -
1
votes2
answers1259
viewsA: How to get the month or day of the week in Portuguese on C#?
You can do so, that you are free to control the date format and language. CultureInfo pt = new CultureInfo("pt-PT",false); string dateFormatString = pt.DateTimeFormat.LongDatePattern; string data =…
c#answered Sérgio Sereno 1,008 -
2
votes1
answer332
viewsA: Compare data from two SQL Server tables
Answering your scenario you can do something like this select ISNULL(A.codigo,B.codigo), ISNULL(A.produto, B.produto), (ISNULL(B.valor,0) - ISNULL(A.valor,0)) as Valor from produtos A with (nolock)…
-
2
votes2
answers750
viewsA: Formatting Date, Time and Time in PHP
Your question is not clear enough, but I think you want to format for a given time zone, if that’s it try using this way. <?php $date = new DateTime('2000-01-01', new…
-
-1
votes3
answers147
viewsA: Join between banks
To have the registers in Comun and the A SELECT a.pm_id, b.pm_id FROM sistema.tb_menus_perfil_params a WITH (NOLOCK) LEFT JOIN banco2.sistema.tb_menus_perfil_params b WITH (NOLOCK) ON a.pm_id =…
-
0
votes2
answers67
viewsA: Difference in performance when Duplicate a table
I agree with João, the only difference that affects performance is that you are using the * which will bring all the columns, which is a bad practice, and when bringing all the columns SQL has no…
-
1
votes3
answers3455
viewsA: Converting integer to string in C#
Hello There are several ways to treat the conversion and types in the . NET, the implicit and explicit, in this case the explicit is the recommended. int numero = 10: string explicitString1 =…
c#answered Sérgio Sereno 1,008 -
1
votes3
answers2862
viewsA: Changing data from a List<>
Just do so, create a list of products List<produto> p = new List<produto>() { new produto { codigo="produto 1",qtd=1}, new produto { codigo="produto 2",qtd=10} }; Then go to your index,…
-
2
votes2
answers95
viewsA: Read contents of ZIP file without writing to disk
Have you seen the Dotnetzip. using (ZipFile zip = ZipFile.Read("omeuzip")) { ZipEntry FicheiroZip = zip["documento.txt"]; FicheiroZip.Extract(OutputStream); }…
-
1
votes2
answers107
viewsA: Numericupdown lock down
I think this is what you want. numericUpDown.ReadOnly = true;
-
1
votes1
answer251
viewsA: Multi-line jsPDF header
Hello doing so is more complex, so I recommend using the jsPDF-Autotable plugin that deals with the printing of tables in a simple way. See here in Git jspdf & auto table…
-
1
votes1
answer196
viewsA: Get the result returned at Do F4
You have to associate a variable with the output of the function. In this case you will return the Name and Provider separated by space. Public Sub ListaFornecedores() Dim strSql As…
vbaanswered Sérgio Sereno 1,008 -
0
votes1
answer195
viewsA: Error using Dynamic in C#
Well the approach I follow is this: Create an interface that allows you to expose in the COM world the properties you want to pass to .NET. Import are the metatags that are at the beginning…
c#answered Sérgio Sereno 1,008 -
1
votes1
answer98
viewsA: Add Pricontext to the Crystal map
To know the context of the company just add this formula to your map. pso.Mapas.Inicializar("GCP"); var strFormula = new StringBuilder(); strFormula.Append($"StringVar…
crystal-reportsanswered Sérgio Sereno 1,008 -
1
votes1
answer166
viewsQ: Create an extension for visual studio that adds classes dynamically
I am creating an extension for the visual studio that aims to create a project based on the options that the programmer wants. In this case a Wizard will be created where it will choose the…
-
-1
votes2
answers1737
viewsA: Exporting HTML form to PDF with input field initialized by js does not appear in the PDF document
To generate PDF the best tool is jsPDF. With it you can print the section of your HTML you want. There are a number of plugins that can be mixed with jsPDF & autoTable that lets you print a full…
-
8
votes1
answer464
viewsQ: How to securely pass token after authentication to angular application
I am developing an Angular Addin for outlook - Office365 for a management application "Jasmin Software". The application is divided into two parts, A 1 is a javasscript application to handle…
-
1
votes1
answer226
viewsA: C# - Pass only numbers in a field formatted for currency
I use this code. I assume the reading value["Tuition"] is as shown below. private void Parse() { decimal x = 0; string mensalidade = string.Format("{0:C}", Convert.ToDouble("23,3")); x =…
-
1
votes2
answers796
viewsA: Error inserting a "SELECT" item into the Combobox
When Datasource cannot change the list items, it is not possible. With this code you’ll get it: private void PreencherCmbIndicacao() { try { string connectionString = @"Password=sasa;Persist…
-
0
votes1
answer522
viewsA: How can I repeat the page header with jsPDF
To do this you have to create a function with what you want to print from your page. Then pass the function to the Autotable plugin. This should do. Function printHTML() { var doc = new jsPDF('p',…
jspdfanswered Sérgio Sereno 1,008 -
0
votes1
answer182
viewsA: doubts with jsPdf - column definition
I assume you’re talking about the Autotable plugin for jsPDF. This feature is not supported by the Autotable plugin. The documentation describes the json format for columns and data and you can see…
-
1
votes3
answers262
viewsA: How to access Form1 members from Form2?
The shared example code. public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { //Nova instancia. Form2 frm = new…
c#answered Sérgio Sereno 1,008 -
1
votes3
answers262
viewsA: How to access Form1 members from Form2?
The controls you add to the form are not directly accessible because they do not represent properties of the object. For this is there is a "Controls" property in the form class for you to make…
c#answered Sérgio Sereno 1,008 -
2
votes1
answer4040
viewsA: jsPDF include css
jsPDF does not support reading the user’s CSS style as described in the documentation. The only alternative I started and used is to use html2Canvas. The $(document).ready(function(){ //pdf…
-
2
votes1
answer91
viewsA: SQL Constraints fits as DML or DDL?
Yes, contraints are part of that category. They are used to create tables to ensure rules about the fields you are creating, an example is primary key or null support.
-
0
votes1
answer200
viewsA: How to know the license of a given module in ERP SPRING V9
In ERP PRIMAVERA to know which module/sub-module is licensed you can use the API service of the business management module: "bso.Comercial.LicencaGcp.Bancos.Base” In this class "Licencagcp" you can…