c# - Adding a new row to jQuery datatable and posting data -


i've got datatable adding row this:

function addrow(controller) {     var table = $('#' + controller + '_data_table').datatable();      var index = table.rows()[0].length;      var previousrowdate = $("input[name='[" + (index - 1) + "].date']").val();     var userid = $("input[name='[" + (index - 1) + "].userid']").val();          var date = new date(previousrowdate.replace('-', ''));     date.setdate(date.getdate() + 1);      if (isnan(date)) {         date.setdate(new date());     }      var rownode = table         .row.add(["<input type='text' class='form-control daterangepicker' name='[" + index + "].date' value='" + moment(date).format("d-mmm-yyyy") + "'/>",             "<input type='text' class='form-control' name='[" + index + "].min'/>",             "<input type='text' class='form-control' name='[" + index + "].max'/>",                         "<input type='hidden' name='[" + index + "].userid' value='" + userid + "'/>"          ])         .draw()         .node();      $(rownode)         .css('color', 'red')         .animate({ color: 'black' });      $(".daterangepicker").datepicker(         {             dateformat: "dd-m-yy",             changemonth: true,             changeyear: true,             mindate: 0         }); }

this adds row, on button click post data datatable save db, this:

function update(controller) {     var table = $('#' + controller + '_data_table').datatable();      var model = table.$('*').serializearray();     $.each(model, function (i, fd) {         var value = fd.value;         value = value.replace(/\</g, "&lt;");  //for <         value = value.replace(/\>/g, "&gt;");   //for >          fd.value = value;     });      $.post("/" + controller + "/update", model)         .done(             function (data) {                  if (data.erroroccurred) {                     bootbox.alert(data.message);                 }                 else if (data.success) {                     bootbox.alert(data.message);                     $('#' + controller + '_update').prop('disabled', true);                 }                 $('#' + controller + '_details').html(data.view);             }); }

server side code:

[httppost]         public actionresult update(list<viewmodel> effort)         {             try             {                 effort.foreach(item =>                 {                     var effortindb = _context.targets.singleordefault(t => t.id == item.id);                     if (effortindb == null) return;                     effortindb.date = item.date;                     effortindb.min = item.min;                     effortindb.max = item.max;                 });                 _context.savechanges();                  return json(new                 {                     erroroccurred = false,                     message = ""                 });              }             catch (exception exception)             {                 return json(new                 {                     erroroccurred = true,                     message =                     $"an error occurred: {system.environment.newline}{exception.message}"                 });             }         }

the issue having userid 0 on server side code, event though i've created hidden field value of it.

i need id save in db


Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more