Databases
StackOverflow2013
Postsdbo
POdelete function never gets called in aspx.cs from .aspx
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POdelete function never gets called in aspx.cs from .aspx
    text
    copied!<p>i have a problem. I am trying to delete something from a list but it never calls my delete function from the .aspx.cs</p> <p>here is my javascript code:</p> <pre><code>function doTheDelete(doIDeleteExpenses) { if (selectedExpensesList.length &gt; 0) { $.ajax({ type: "POST", //url: "/Tasks/ViewTasks.aspx/deleteTasksAndLinkedItems", url: '&lt;%=ResolveUrl("~/Expenses/ViewExpenses.aspx/deleteSelectedExpense")%&gt;', data: "{'DeleteExpenses' : " + "'" + doIDeleteExpenses + " '}", //dataaaaaa contentType: "application/json; charset=utf-8", dataType: "json", success: function (data) { var ss = data.d; if (ss.length &gt; 0) { for (var i = 0; i &lt; ss.length; ++i) { $.noty.consumeAlert({ layout: 'center', type: 'error', dismissQueue: true }); alert(ss[i]); } } $("#viewTasksGrid").flexReload(); }, error: function (data) { $.noty.consumeAlert({ layout: 'center', type: 'error', dismissQueue: true, modal: true }); alert('Error Deleting Expense'); if (window.console) { console.log(data); } } }); } else { showMessage('No expenses are selected.'); } } function getSelectedExpenseIDs() { var selectedExpensesList = new Array; var i = 0; $('.expenseCheckBox:checked').each(function () { if ($(this)[0].id !== "checkAllExpenses") { selectedExpensesList[i] = $(this)[0].id.split('_')[1]; ++i; } }); return selectedExpensesList; } </code></pre> <p>and here is my method in the aspx.cs that never gets called:</p> <pre><code>[WebMethod] public static string[] deleteSelectedExpense(bool DeleteExpenses, String[] ExpID) { var rList = new List&lt;string&gt;(); //var canDeleteTasks = false; //var canDeleteTrackers = false; var canDeleteExpenses = false; var investigatorID = (int)HttpContext.Current.Session["InvestigatorID"]; var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["OSCIDConnectionString"].ToString()); var cmd = new SqlCommand("p_Admin_Permissions_CanDeleteExpenses", conn); cmd.Parameters.Add(new SqlParameter("@InvestigatorID", SqlDbType.Int)); cmd.Parameters["@InvestigatorID"].Value = investigatorID; cmd.CommandType = CommandType.StoredProcedure; try { conn.Open(); canDeleteExpenses = (bool)cmd.ExecuteScalar(); } catch (SqlException sql) { if (!rList.Contains("Can not connect to the database. Please try again.")) rList.Add("Can not connect to the database. Please try again."); } catch (Exception ex) { if (!rList.Contains("An Error Occured")) rList.Add("An Error Occured"); } finally { if (conn.State == ConnectionState.Open) conn.Close(); } if (canDeleteExpenses) { foreach (var expense in ExpID) { if (canDeleteExpenses &amp;&amp; DeleteExpenses) { conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString()); cmd = new SqlCommand("p_DeleteExpenses", conn); cmd.Parameters.Add(new SqlParameter("@TaskID", SqlDbType.Int)); cmd.Parameters["@ExpID"].Value = int.Parse(expense); cmd.Parameters.Add("@Message", SqlDbType.NVarChar, 50); cmd.Parameters["@Message"].Direction = ParameterDirection.Output; cmd.CommandType = CommandType.StoredProcedure; try { conn.Open(); cmd.ExecuteNonQuery(); } catch (SqlException sql) { if (!rList.Contains("Error Connecting to the Database. Unable To Delete Expense(s).")) rList.Add("Error Connecting to the Database. Unable To Delete Expense(s)."); } catch (Exception ex) { if (!rList.Contains("An Error Occured")) rList.Add("An Error Occured"); } finally { if (conn.State == ConnectionState.Open) conn.Close(); } } else if (!canDeleteExpenses &amp;&amp; DeleteExpenses) { rList.Add("You do not have permission to delete Expenses"); } else { if (!rList.Contains("You do not have permission to delete the task(s).")) rList.Add("You do not have permission to delete the task(s)."); } } } //var serializer = new JavaScriptSerializer(); //var re = serializer.Serialize(rList.ToArray()); return rList.ToArray(); } </code></pre> <p>When I am in the browser console, it tells gives me an internal error(500). Well for obvious reasons.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload