Hi,
I am displaying data on the ViewAllTasks page which has a delete, an edit and an add. They all work except for the update one. I do not get any errors and the program seems to run fine but the database is not updated and the view is not updated as well.
The add does something similar and it works: it inserts a record in the database and the view is updated via the loadData() javascript. What is it that I am doing wrong? Please help. Thank you
JAVASCRIPT:
//Load Data in Table when documents is ready$(document).ready(function () { loadData();});//Load Data functionfunction loadData() { $.ajax({ url: "/Tickets/ListITTasks", type: "GET", contentType: "application/json;charset=utf-8", dataType: "json", success: function (result) { var html = ''; $.each(result, function (key, item) { html += '<tr>'; html += '<td>' + item.ITNumber + '</td>'; html += '<td>' + item.ITDescription + '</td>'; html += '<td>' + item.ITEnterDate + '</td>'; html += '<td>' + item.ITAssignedTo + '</td>'; html += '<td>' + item.ITEstimatedCompletion + '</td>'; html += '<td>' + item.ITPriority + '</td>'; html += '<td>' + item.ITFrom + '</td>'; html += '<td>' + item.ITStatus + '</td>'; html += '<td><a href="#" onclick="return getbyTicketNumber(' + item.ITNumber + ')">Edit</a> | <a href="#" onclick="DeleteItTask(' + item.ITNumber + ')">Delete</a></td>'; html += '</tr>'; }); $('.tbody').html(html); }, error: function (errormessage) { alert(errormessage.responseText); } });}//Add IT Taskfunction AddItTask() { var res = validate(); if (res == false) { return false; } var taskObj = { ITDescription: $('#ITDescription').val(), ITEnterDate: $('#ITEnterDate').val(), ITAssignedTo: $('#ITAssignedTo').val(), ITEstimatedCompletion: $('#ITEstimatedCompletion').val(), ITPriority: $('#ITPriority').val(), ITFrom: $('#ITFrom').val(), ITStatus: $('#ITStatus').val() }; $.ajax({ type: "POST", url: "/Tickets/AddTask", data: JSON.stringify(taskObj), contentType: "application/json;charset=utf-8", dataType: "json", success: function (result) { loadData(); //$('#myModal').modal('hide'); clearTextBox(); }, error: function (errormessage) { alert(errormessage.responseText); } });}//Function for getting the data based upon Ticket Numberfunction getbyTicketNumber(TicketNumber) { $('#ITDescription').css('border-color', 'lightgrey'); $('#ITEnterDate').css('border-color', 'lightgrey'); $('#ITAssignedTo').css('border-color', 'lightgrey'); $('#ITEstimatedCompletion').css('border-color', 'lightgrey'); $('#ITPriority').css('border-color', 'lightgrey'); $('#ITFrom').css('border-color', 'lightgrey'); $('#ITStatus').css('border-color', 'lightgrey'); $.ajax({ url: "/Tickets/GetTaskByTicketNumber/" + TicketNumber, type: "GET", contentType: "application/json;charset=UTF-8", dataType: "json", success: function (result) { $('#ITNumber').val(result.ITNumber); $('#ITDescription').val(result.ITDescription); $('#ITEnterDate').val(result.ITEnterDate); $('#ITAssignedTo').val(result.ITAssignedTo); $('#ITEstimatedCompletion').val(result.ITEstimatedCompletion); $('#ITPriority').val(result.ITPriority); $('#ITFrom').val(result.ITFrom); $('#ITStatus').val(result.ITStatus); $('#myModal').modal('show'); $('#btnUpdate').show(); $('#btnAddItTask').hide(); }, error: function (errormessage) { alert(errormessage.responseText); } }); return false;}//Function for updating ticket numberfunction UpdateItTask() { var res = validate(); if (res == false) { return false; } var taskObj = { Number: $('#ITNumber').val(), ITDescription: $('#ITDescription').val(), ITEnterDate: $('#ITEnterDate').val(), ITAssignedTo: $('#ITAssignedTo').val(), ITEstimatedCompletion: $('#ITEstimatedCompletion').val(), ITPriority: $('#ITPriority').val(), ITFrom: $('#ITFrom').val(), ITStatus: $('#ITStatus').val() }; $.ajax({ url: "/Tickets/UpdateTask", data: JSON.stringify(taskObj), type: "POST", contentType: "application/json;charset=utf-8", dataType: "json", success: function (result) { loadData(); //clearTextBox(); $('#myModal').modal('hide'); $('#ITNumber').val(""); $('#ITDescription').val(""); $('#ITEnterDate').val(""); $('#ITAssignedTo').val(""); $('#ITEstimatedCompletion').val(""); $('#ITPriority').val(""); $('#ITFrom').val(""); $('#ITStatus').val(""); }, error: function (errormessage) { alert(errormessage.responseText); } });}