c# - LINQ SQL Method not Filling Highcharts -


my goal create column highchart shows name of various salesman , how have sold. wrote code return sql database names , sum of sales each salesman:

 [httppost]     public jsonresult chartvendedores()     {         //retorna um json contendo o nome vendedor e o valor por ele vendido, usando inner join pelo id vendedor.         try         {             var resultado = (from ve in db.tblvendedor                              join vn in db.tblvenda on ve.vendedor_id equals vn.vendedor_id                              group vn new                              {                                  ve.vendedor_nome                              }into g                              select new {                                  vendedor_nome = g.key.vendedor_nome,                                  venda_valor = g.sum(x => x.venda_valor)                              }).tolist();              var jsonresult = new             {                 nomes = resultado.select(x => x.vendedor_nome),                 valores = resultado.select(x => x.venda_valor)             };              return json(resultado);         }catch(exception)         {             return null;         }     }

and chart created, method called , suposed fill chart database's return data:

<script> $(function () {     $.ajax({         url: '/vendedores/chartvendedores',         type: 'post',         async: false,         sucess: function (data) {             //constrói o gráfico com os valores retornados pelo banco.             highcharts.chart('container', {                 chart: {                     type: 'column'                 },                 title: {                     text: 'venda dos colaboradores'                 },                 xaxis: {                     categories: [                         data.nomes                     ],                     crosshair: true                 },                 yaxis: {                     min: 0,                     title: {                         text: 'valor (r$)'                     }                 },                 tooltip: {                     headerformat: '<span style="font-size:10px">{point.key}</span><table>',                     pointformat: '<tr><td style="color:{series.color};padding:0">{series.name}: </td>' +                     '<td style="padding:0"><b>{point.y:.1f} mm</b></td></tr>',                     footerformat: '</table>',                     shared: true,                     usehtml: true                 },                 plotoptions: {                     column: {                         pointpadding: 0.2,                         borderwidth: 0                     }                 },                 series: [{                     name: 'valores',                     data: data.valores                 }]             });         }     }) })

what i'm missing? long code goes, don't think wrote wrong code in method. calling wrong? manipulating wrong? tried remove ajax code, leaving chart on highchart.com , worked, problem not on container div or in chart code.

edit: commented bellow, looked @ console , i'm getting warning 1 of imports highcharts needs. waning follows is one. after seeing this, tried remove ajax , using highchart code. worked! reason when chart tries use this:

<script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>

it not find when chart code contained inside sucess: function(data){}

note: i'm importing @ beggining of code, meanwhile script containing ajax written last.

$.ajax({     url: '/vendedores/chartvendedores',     type: 'post',     async: false,     sucess: function (data) {

should changed to:

$.ajax({     url: '/vendedores/chartvendedores',     type: 'post',     async: false,     success: function (data) {

you have misspelt success.


Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more