asp.net mvc - TimeSpan Datatype in not getting correct time while exporting to Excel -


i create 1 small project using timespan datatype in project trying login , logout time while exporting excel time not displaying in excel column. please me.

this code there use timespan.

public timespan punchin { get; set; }         [notmapped]         public string month {                         {                 var in = timezoneinfo.converttimefromutc(punchdate.date + punchin,                     timezoneinfo.findsystemtimezonebyid(user.registeredtimezone));                 return in.tostring("mmmm");             }         }

and kendo grid code.

@(html.kendo().grid(model)       .name("timetrackinglogsgrid")       .columns(columns =>       {           columns.bound(c => c.id).hidden(true).htmlattributes(new {style="text-align:center;"});           columns.bound(c => c.isdeleted).hidden(true);           columns.bound(c => c.approvalrequired).visible((bool)viewbag.isadmin).clienttemplate("# if (approvalrequired == true && approved == false && '"+ (viewbag.isadmin).tostring() + "'=== 'true') {# yes: <a data-ajax='true' data-ajax-complete='refreshgrid' data-ajax-method='post' href='/punch/approve/#:id#' class='grid-link' >approve</a>#} else{# no #}#");           columns.bound(c => c.employeename).filterable(ftb => ftb.multi(true).search(true));           columns.bound(c => c.month).hidden(true).filterable(ftb => ftb.multi(true));           columns.bound(c => c.punchdate)               .clientfootertemplate("#= getformattddate(data.punchdate.min) # - #= getformattddate(data.punchdate.max) # ")               .clientgroupheadertemplate("#:convetutcdatetolocaldate(punchdate)#").htmlattributes(new { @class = "utc-date", utc_date_value = "#:punchdate#" });           columns.bound(c => c.punchinpic).hidden(true).visible((bool)viewbag.isadmin).clienttemplate("<img class='punchpic' width='100' src='data: image / png; base64,#:punchinpic#'/>").htmlattributes(new { style="text-align:center;"});           columns.bound(c => c.punchin).groupable(false).filterable(false).clienttemplate("#:punchin.hours#:#:punchin.minutes#").htmlattributes(new { @class = "utc-time", utc_time_value = "#:punchin.hours#:#:punchin.minutes#" });           columns.bound(c => c.punchoutpic).hidden(true).visible((bool)viewbag.isadmin).clienttemplate("<img class='punchpic' width='100' src='data: image / png; base64,#:punchoutpic#'/>").htmlattributes(new { style = "text-align:center;" });           columns.bound(c => c.punchout).groupable(false).filterable(false).clienttemplate("#:punchout == null ? 0 :punchout.hours #:#: punchout == null ? 0 : punchout.minutes  #").htmlattributes(new {@class= "utc-time", utc_time_value = "#: punchout == null ? 0 : punchout.hours#:#:punchout == null ? 0 : punchout.minutes #" });           columns.bound(c => c.duration).groupable(false).filterable(false)               .clientfootertemplate("#= secondstotime(data.durationinseconds.sum) # ")               .clienttemplate("#:formatduration(duration.hours,duration.minutes) #").htmlattributes(new { @class = "" });           columns.bound(c => c.comments).visible((bool)viewbag.isadmin).filterable(false).groupable(false).clienttemplate("# if (approvalrequired == true && approved == false && '" + (viewbag.isadmin).tostring() + "' !== 'true') {# please time log approved #} else{#<span class='comments' (#:comments# == null ? '' : title='<ul>  #:comments# </ul>')> view <span>#}#");           columns.command(command =>           {               //    command.edit().text(" ");               command.destroy().text(" ");           }).width(50);       })       .htmlattributes(new { @class = "full-screen-dashboard" })       //.scrollable()       .groupable()       .sortable()       .filterable()       .navigatable()       .columnmenu()       .toolbar(toolbar => {           //toolbar.create();           //toolbar.save();           toolbar.pdf();           toolbar.excel();           toolbar.custom().text("clear filter").htmlattributes(new { @class= "cleargridfilter"  });       })        .excel(exl=>exl.allpages(true).filterable(true).filename("timesheet.xlsx")           .proxyurl(url.action("exportsave", "punch")))


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