Posts by Junior Torres • 427 points
28 posts
-
2
votes6
answers674
viewsA: Angular 6: Selected does not work with [(ngModel)] and (ngSubmit)="onsubmit()
I created a function to select the Selected item (maybe it’s not the right one) SelecionarCarroSelect(){ this.cliente.carros.forEach((item, index) => { if(item.selected) this.carro = item.modelo;…
-
3
votes6
answers674
viewsQ: Angular 6: Selected does not work with [(ngModel)] and (ngSubmit)="onsubmit()
I receive the Customer class in my form import { NgSelectOption } from '@angular/forms'; export class Cliente { nome: string = ''; carros: any [] = [ { id: 1, modelo: 'Gol',selected:false }, { id:…
-
0
votes1
answer83
viewsA: Join to Linq c#
That solves. var innerGroupJoinQuery2 = from p in unitOfw.PropriedadeRepository.Get() join pt in unitOfw.PropriedadeTopologiaRepository.Get() on p.Id equals pt.PropriedadeId from t in…
-
2
votes1
answer83
viewsQ: Join to Linq c#
I have the following query in Sql Sevrer SELECT PT.id, P.nome AS Codigo, PT.topologiaid, TE.id AS TipoEntidadeId FROM [dbo].[propriedade] P INNER JOIN [dbo].[propriedadetopologia] PT ON P.id =…
-
7
votes4
answers1976
viewsQ: Remove numbers at the end of a Regex string C#
I have a string that contains the name of some records. Examples : string nome = "MARIA APARECIDA DE SOUZA MOURA 636598241"; string nome = "MARIA APARECIDA DE SOUZA MOURA 2018"; I would like to…
-
0
votes2
answers259
viewsQ: Insert Select Sql Server
Connection and Historico_ligacao I have a script which copies all data from the table Ligacao for Historico_ligacao. When I compare the data between the theban, the table historico_ligacao is…
-
1
votes1
answer1012
viewsQ: Group objects and add values
I have a class ListaBid with several objects, in this class there are attributes Partnumber(Chave), Quantidade and SaldoPartnumber. I can have X objects with the partnumber Y and other X objects…
-
1
votes0
answers28
viewsQ: Return Datalayer value
Good afternoon. I have a precedent that makes some commands and returns 0 = success; 1 = without success; alter PROCEDURE [dbo].TesteRetorno ( @DS_NOME_ARQUIVO_SINCRONISMO AS VARCHAR(200) = null )…
-
0
votes0
answers37
viewsQ: OFFSET does not work on SQL Server
I developed the sql side paging in my SQL Server 2014, when I played in production gave the problem with the OFFSET because the server has sql 2008. I tried to implement otherwise but did not…
-
0
votes2
answers273
viewsQ: Condition in the trial
Good afternoon. I have a filter, I have several filters. one of these filters is @ST_TIPO -When I get by Parametro BSP I want to filter just by PT.ST_TIPO = 'BSP' -When I get by Parametro 'DIS' I…
-
1
votes0
answers37
viewsQ: Sql Pagination in the past
I’m trying to implement the sql pagination in my Procedure, I have already taken several examples but I did not get the desired result. I have a trial that makes Lead queries at my base. I would…
-
1
votes2
answers60
viewsQ: Search for inconsistency in a C#list
Good afternoon. I have a list of the Project class The Project class has the properties: public string ID { get; set; } public string Nome_Usuario { get; set; } public string Nome_Projeto { get;…
-
-1
votes2
answers2053
viewsA: Search Records that are not in another table
SELECT * FROM BCT_PESSOA p inner join BCT_PESSOATIPO pt on pt.ID_PESSOA = p.ID_PESSOA WHERE NOT EXISTS (SELECT * FROM BCS_USUARIO u WHERE p.ID_PESSOA = u.ID_PESSOA) and pt.ST_TIPO = 'FUN' I think…
-
0
votes2
answers2053
viewsQ: Search Records that are not in another table
Good morning.. I have the table [BCT_PESSOA] with PK [ID_PESSOA] this table has relationship with the table [BCS_USUARIO] with the column [ID_PESSOA] I would like to return all records to the table…
-
-1
votes2
answers642
viewsA: Problem sending file via FTP C#
The problem was the user running my process in Job, he did not have the credentials necessary to open a connection to the client’s FTP address
-
1
votes2
answers642
viewsQ: Problem sending file via FTP C#
I have an executable that sends a . CSV file via FTP to my client. Running on my local machine works smoothly but when runs on my client’s server does not work. Every time I fall in line…
-
2
votes1
answer61
viewsQ: Validate Streamreader twice
I get a. csv file in my Controller. This file may contain two templates, with 2 or 5 lines. First I have to do the validation to check if the file contains 5 lines: var arquivo = new…
-
1
votes1
answer49
viewsQ: Remove first character by Index
Good afternoon. I have a varchar with some numbers set @ID_CUSTOMERNUMBER = '01234567' I would remove the zero only if it is the first number of my variable, example: '0123456789' removing the zero…
-
0
votes2
answers950
viewsQ: Calculate Value of SQL columns
I have two tables BMV_PEDIDO and BMV_PEDIDOITEM and would like the total sum of the value of the orders made on a given date. I currently make this request per request, ie, I replicate this code…
-
1
votes3
answers106
viewsQ: Filter per parameter or all
I make an appointment at the bank. I would like to filter the column ID_LEAD by the filter value "if there is" int?(filter.code) or filter all over the world. follows the example of how this in the…
-
2
votes1
answer508
viewsQ: Picking up a specific file in an FTP directory
I have two methods, one sends a file by FTP and the other consumes a file by FTP. The files have the dynamic name DateTime.Now each day a new file. example: collections-04-04-2017 16_00_19.xlsx In…
-
0
votes3
answers123
viewsQ: Contains within a list
I have a list of Assets that contain a list of Accessories I would like to filter all Assets that accessories(ID_ACESSORIOS) are within a list of int. Follows the code; //Lista com todos os…
-
1
votes2
answers142
viewsQ: Popular Dropdownlist from another
Good morning, I have a Dropdownlist populated from a Model class. Example: Processor, Memory, HD After clicking "+" I have to add another Dropdownlist with all values less the value selected in the…
-
2
votes3
answers2033
viewsQ: SQL command inside a variable varchar - sql server
Good Afternoon I need to write a command inside a variable of the format varchar Set @STRING_SQL = 'update BCS_RESOURCE set DS_DESCRICAO = ''Gestão de Contratos - ''+ @DS_PERFIL + '' , [DS_pt-BR] =…
sql-serverasked Junior Torres 427 -
1
votes1
answer262
viewsQ: Validate CNPJ countries Latin America
I’m doing a CNPJ validation of Latin American countries. I don’t really understand the Regex and would like help to validate the following rule: 3 digits, 6 Numbers (YYMMDD), 3 digits (like P&G…
regexasked Junior Torres 427 -
2
votes1
answer57
viewsQ: Property instantiated by Castle being recorded in Database as Proxy
I have a Log system that compares two generic classes and writes the name of the property and its value in a column of my database. When the property is string, int, datetime, etc., it is saved to…
-
1
votes0
answers34
viewsQ: Invalid character when exporting to Flash CSV
When I export a DataGrid for .csv the characters of my header which contains invalid-formatted fictional accents. private function onExportToCSV():void { var fileReference:FileReference = new…
-
1
votes1
answer78
viewsQ: Export a search result to . Txt
I use Mysql Workbench. I would like to know how to save the result of a query in a txt file. and that is separated by tab, I have tried everything else of the right.