Posts by Danielle Arruda torres • 1,191 points
102 posts
-
0
votes2
answers210
viewsA: Error trying to access ASP NET MVC page C#: "HTTP 404. The Resource you are Looking for (or one of its dependencies) could have been Removed"
You can try using the Redirecttoaction, because from what I understand you are not returning the view to the current action but another view from another controller. (this is one of the…
-
2
votes1
answer39
viewsQ: How to convert 2,22292E+12 to 2222921601281
I have a method that returns a float (but I can change this return to the other if I need to) float mmc(int a, int b) { float num1, num2, x, y, mmc = 0; num1 = a; num2 =b; x = num1; y = num2; while…
-
0
votes1
answer89
viewsA: When publishing the project on IIS no script and css appears, what can it be?
I changed some Webconfig tags <?xml version="1.0" encoding="utf-8"?> <!-- Para obter mais informações sobre como configurar seu aplicativo ASP.NET, visite…
-
0
votes1
answer89
viewsQ: When publishing the project on IIS no script and css appears, what can it be?
When publishing the project to the server and configure the iis it does not recognize the css and script, it does not from the error, finds the address no longer loads the css and js code. I checked…
-
2
votes1
answer39
viewsA: I’m having trouble removing accents in the string
public static string removerAcentos(string texto) { string Acentos = "ÄÅÁÂÀÃäáâàãÉÊËÈéêëèÍÎÏÌíîïìÖÓÔÒÕöóôòõÜÚÛüúûùÇç"; string semAcentos =…
c#answered Danielle Arruda torres 1,191 -
1
votes1
answer44
viewsA: I cannot show database data with ajax,php and jquery
<script type="text/javascript"> $("#regua").click(function(){ if($('#regua').is(':checked')){ $.ajax({ url: "home_.php", // coloque aqui o endereço que vai buscar os dados…
-
2
votes2
answers44
viewsA: Function in onpaste
Or in the onkeyup (even if you stick it will treat): //Permite Ponto function somenteNumeros(num) { var er = /[^0-9.]/; er.lastIndex = 0; var campo = num; if (er.test(campo.value)) { campo.value =…
javascriptanswered Danielle Arruda torres 1,191 -
0
votes4
answers1899
viewsA: Insert comma automatically while typing
**Use the library jquery and jquery.maskMoney.min.js ** In your script you get : ** $("#valorPrimeiroPedido").maskMoney({ prefix: "R$:", decimal: ",", thousands: "." }); in Html <input…
-
1
votes5
answers835
viewsA: How to put the operation (sum, multiplication) within a variable
You can use if to check the operation, example: <script> var n1 = prompt('Digite um número'); n1 = parseInt(n1); var n2 = prompt('Digite outro número'); n2 = parseInt(n2); var operacao =…
-
1
votes1
answer61
viewsA: Use of jquery to pull records, but does not appear
$.ajax({ url: "/home.php", // coloque aqui o endereço que vai buscar os dados no banco success: function (data) { $('#conteudo').html(data); $('#conteudo').show(); // Mostrar…
-
2
votes1
answer48
viewsA: Remove characters 0 to left of a string c#
It can be Replace . Where you have 0000 replace with nothing example: item.CODESTAGIO.Replace("0000","") this.txtARQUIVO.Text = item.ALUNOID + "_" + item.CODESTAGIO.Replace("0000","") + ".jpg";…
c#answered Danielle Arruda torres 1,191 -
0
votes1
answer190
viewsQ: Show/ Hide table row
I create a table dynamically and that lists Nodes (with 'FATHER' and 'Sons'), I would like that when loading only the first nodes (FATHER) appear and when clicking the children were shown. The click…
-
3
votes2
answers43
viewsA: Search for missing records within the same table
You can tie it up primary key and use the operator NOT IN Example: SELECT r.Id FROM registro r WHERE competencia = '01/2019' AND r.id NOT IN (SELECT Id FROM registro WHERE competencia = '02/2019'…
-
0
votes2
answers519
viewsQ: SQL Query average time DO NOT take into account Weekends and holidays
I need to average the time it takes since creation (a. Date of creation) until completion (s. Data_status_finalized) field. Not able to count weekends and holidays. The following query is working,…
-
2
votes1
answer37
viewsA: Duplicity with JOIN
SELECT DISTINCT US.NOME AS PROFISSIONAL, AG.NOMEPACIENTE AS NOME_PACIENTE, CONV.NOME AS CONVENIO, AG.NUMEROPRONTUARIO, AG.DATA, P.CODIGOAMB AS DESCRICAO_ATENDIMENTO, P.TOTALTAXAS AS…
-
4
votes2
answers54
viewsQ: Mark Previous Check (Parent) to Node
What I need is that when selected Item "Ball" which is a child node of check "1031-HUBCAP ...", the Father node is selected as well. Or Do not let select the child node if the parent node is not…
-
0
votes2
answers72
viewsA: How do I pass the right string value to my controller? from the error when returning to Edit View
If your Alert(name) is returning the right name and you want to make a change, ie a 'PUT''. Your controller: [HttpPut] public JsonResult EditarInstrutor(string nome) { return Json("Dados alterado…
-
0
votes1
answer52
viewsA: How do I execute a scrip only after it is visible to the user?
Run it and see if it helps you $(document).ready(function(){ $(window).on('scroll', function() { $('.scroll-aparecer').stop(); if($(this).scrollTop() > 200) { // aqui ele vai executar o que você…
-
0
votes1
answer192
viewsA: date in javascript wrong format for controller c# (Asp net mvc)
Your model [Required(ErrorMessage = "informe sua data.")] [DataType(DataType.Date)] public DateTime IssueDate { get; set; } Razor Page @Html.TextBoxFor(model => model.IssueDate)…
-
0
votes2
answers115
viewsA: Assign database value to a variable c#
I hope it helps you, but I believe that just read the record with Mysqldatareader private void btnAbrirCaixa_Click(object sender, EventArgs e) { MySqlConnection con = new…
-
0
votes0
answers32
viewsQ: Take only the repeated value of an Array
I would like to take only names that repeat in an input array of type text. For example: ['Daniel', 'Sarah', 'Mary', 'Daniel', 'Philip'] Return the 'Daniel''. Follow the Assembly Code of the array…
-
0
votes1
answer43
viewsQ: JS or Jquery pass two array’s, input text and input check when checked
I need to pick up the text field when the input check is checked. I can already pick up my controller. But the text field is not. They are generated by the database and therefore need to be treated…
-
-1
votes1
answer184
viewsA: How to configure the credentials of a webRequest?
I HAVE SOMETHING SIMILAR var resultObjects = JObject.Parse(json);//Converto a string para o formato json var jsonSerializado = JsonConvert.SerializeObject(resultObjects);//Serializo meu json var…
-
0
votes3
answers50
viewsA: Count data from a table to sum
TRIES TO ADAPT DECLARE @nome nvarchar(MAX); DECLARE @valor nvarchar(MAX); DECLARE @query nvarchar(MAX); SELECT @nome = (SELECT COUNT('NOME') AS nome, @valor = (SELECT SUM('VALOR') AS valor FROM…
-
1
votes1
answer66
viewsA: Return record of each query as I click the button
var i = 0; $('#incrementa').click(function(){ if (i < 20 ) { i++; } else if (i = i++) { i = 0; } document.getElementById("display").innerHTML = i; }) $('#decrementa').click(function(){ if (i >…
-
1
votes1
answer68
viewsQ: Jquery fill <select>
I’m having trouble filling out a combo. On the return of JS the date comes the whole list, but the fill does not show. Meu Js : function CarregaCliente() { $.ajax({ url:…
-
0
votes3
answers459
viewsA: How to make two WHERE clauses inside a nested WITH
you can use passed as array: $query->where([ ['column_1', '=', 'value_1'], ['column_2', '<>', 'value_2'], [COLUMN, OPERATOR, VALUE], ... ]) Conditions using Array: $users = User::where([…
-
2
votes1
answer32
viewsQ: How do I leave the text at the center of the css3 ellipse?
How to leave this text in the middle ? css: <style> .bg-maroon, .bg-aqua, .bg-yellow, .bg-red, .bg-teal, .bg-purple, .bg-orange, .bg-green { text-align: center; height: 70px; border-radius:…
css3asked Danielle Arruda torres 1,191 -
-1
votes2
answers415
viewsA: Trigger automatically blocks the table (LOCK TABLE)?
"Triggers are used to perform tasks related to validations, access restrictions, security routines and data consistency ; in this way these controls cease to be executed by the application and are…
-
0
votes2
answers281
viewsA: Place animation in the Hide of a div
function myFunction() { var x = document.getElementById("myDIV"); if (x.style.display === "none") { x.style.display = "block"; } else…
-
3
votes1
answer132
viewsA: Decimal field displays a . 0 on the screen
You need to Convert to long. Because to convert to whole it can exceed the limit. Maximum value for a type int variable. 2147483647 decimal cpf = 79399965412; // vem do banco tipo decimal long…
-
0
votes3
answers78
viewsA: Questions about database modeling, ID duality
Suggestion : Tabela Processo Id Id_Pessoa -Traz a pessoa Id_TipoPessoa -Traz que tipo de participação ela terá nesse processo Tabela Pessoa Id Nome Tabela TipoPessoa Id Descricao (réu,cliente,autor)…
-
0
votes1
answer67
viewsQ: Asp.Net configure routes of multiple mvc projects
So I can understand how this multi-project MVC architecture works in a Solution. How to communicate (a link) from one project to another within the same project? For example, I would like in the…
-
0
votes1
answer67
viewsA: Ajax return files from a directory (Asp.net MVC)
JS: function CarregaArquivos(Id) { $("#tblAcao > tbody").empty(); $.ajax({ url: "/Qualidade/RiscoAcao/ListarArquivos", data: { IdAcao: Id }, async: false, success: function (data) { var caminho =…
-
0
votes1
answer67
viewsQ: Ajax return files from a directory (Asp.net MVC)
I would like to list the files in link form (to click to download). List the directory files below the upload input Ajax: function CarregaArquivos(Id) { $.ajax({ url:…
-
-2
votes3
answers65
viewsA: Link that opens the "content" in the next div
Fiz um exemplo simples, basta vc adaptar! Espero que Ajude! function EscondeElemento(id){ var elemento = document.getElementById(id);…
-
1
votes0
answers20
viewsQ: Place Progressbar inside a JQGRID cell
Como Coloco the Progressbar within the last column according to the Time Travelled? var grid1 = $("#jqGridRiscoAcao").jqGrid({ url: '/Qualidade/RiscoAcao/Listar', datatype: 'json', mtype: 'GET',…
-
0
votes1
answer161
viewsQ: Validate 2 or more emails in an input
I have a registration that validates the email event focusout in Input. That validation works perfectly. Now the need has arisen to validate multiple emails within the same Input, separating by ";"…
-
0
votes2
answers134
viewsQ: Error creating a Custom Exception
I’m trying to simulate a custom exception, but when compiling I get an error. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks;…
c#asked Danielle Arruda torres 1,191 -
2
votes4
answers19922
viewsA: Limit the number of SQL query lines
For this (postgresql) you can use the limit select * from bra_ocorrencias order by num_ocorrencia desc limit 5 If performance is important look for an index in the score. you can also use the…
-
-1
votes3
answers139
viewsA: Problems with Ajax in PHP MVC project
Check the Id or Name with care in your HTML and confirm that they are equal in the file and try to use this syntax in your controller json: jQuery.ajax({ type: "POST", url: "../perguntas/responder",…
-
0
votes3
answers84
viewsA: What are the good practices of MVC with Entity Framework?
Subdirectories are always an elegant way to organize your code. As with data, it is important to stay inside the Model, obeying the MVC architecture. In the example, I distinguish files that are…
-
1
votes3
answers7164
viewsA: LEFT JOIN SUBQUERY
Try using Isnull (when null replaces zero) if this does not work, put CASE SELECT a.id, a.nome, isnull(count(*),0) atualizacoes FROM postagens_categorias as a LEFT JOIN postagens_categorias_view as…
sqlanswered Danielle Arruda torres 1,191 -
3
votes4
answers19922
viewsA: Limit the number of SQL query lines
The TOP clause of the SQL language is used to limit the number of records returned by a query SELECT TOP 5 num_ocorrencia, estado FROM bra_ocorrencias WHERE nome like 'João' ORDER BY num_ocorrencia…
-
-1
votes1
answer244
viewsQ: Html and Css back a row in the table
There’s a For that goes line by line a list. This list returns me input and output of a process. The problem is that it does not return in the same row because it is either input or output. I would…
-
0
votes2
answers1521
viewsA: Query SQL - put result in a row only
I did so: SELECT DISTINCT pga.Titulo, UPPER ( SUBSTRING ( ISNULL ( STUFF ( ( SELECT convert(varchar(10), c.Codigo) + ',' codigo FROM Qualidade_Diagrama_Processo_Grupo_Acao a JOIN…
-
1
votes2
answers1521
viewsQ: Query SQL - put result in a row only
SELECT pga.Titulo, e.Codigo FROM Qualidade_Diagrama_Processo_Grupo_Acao pga JOIN Qualidade_Diagrama_Acao_Entidade ae on (ae.Id_Proc_Grupo_Acao = pga.Id) JOIN Qualidade_Diagrama_Entidade e on (e.Id =…
-
3
votes1
answer5032
viewsQ: JS or Jquery Decrease image size and not just resize
Is there any way to decrease the size of the photo before uploading? Note: It’s not just resize, because some test I did just resize and did not decrease the photo size. I would like to check if the…
-
0
votes4
answers1275
viewsA: Check file size (all) with Jquey
It follows as it turned out: $(document).ready(function () { var files; // Add events $('input[name=fileUploader]').on('change', prepareUpload); // Grab the files and set them to our variable…
-
3
votes4
answers1275
viewsQ: Check file size (all) with Jquey
I have a form that sends an email with an attachment. A client-side validation is required. It would have to do in the form Submit? type: if the sum of attachment sizes is greater than 5MB does not…