MVC SQL Error Exception encountered

Question

MVC SQL Error Exception encountered

I am encountering an issue with a SQL store procedure failure and trying to capture the exception being thrown. Although I am receiving the response in ajax using request.responseText, I am only interested in extracting the title from this responseText.

The Controller code snippet is shown below:

public ActionResult ReOrderSegment(string DocumentIDs, long DossierIDForReOrder) 
        {
            try
            {
                var TrimmedString = DocumentIDs.TrimEnd('#');

                var DocumentIDsWithInteger = Convert.ToInt64(DocumentIDs.Split('#').FirstOrDefault());

                long SelectedCompany = db.Documents.FirstOrDefault(x => x.ID == DocumentIDsWithInteger).CompanyID;

                var Message = db.PerformAutomatedSorting(SelectedCompany, DossierIDForReOrder, TrimmedString);

                return Json(Message, JsonRequestBehavior.AllowGet);

            }
            catch (SqlException ex)
            {
                Response.StatusCode = 500;
                Response.TrySkipIisCustomErrors = true;
                return Json(new { errorMessage = ex.Message }, JsonRequestBehavior.AllowGet);
            }

            return Json(0);
        }

and JS:

 $.ajax({
                    type: 'POST',
                    url: rootUrl("Dossier/ReOrderSegment"),
                    dataType: "json",
                    data: { DocumentIDs: DocumentIDs, DossierIDForReOrder: DossierIDForReOrder },
                    traditional: true,
                    success: function (rest)
                    {
                        alert(rest);

                    },
                    error: function (request, status, error)
                    {
                        //var all = JSON.parse(request.responseText);
                        alert(request.responseText);
                    }   
                });
            });

Attached are some images for reference.

In the alert message, I specifically want to display only "Please select only Air Product that are UnInvoiced".

javascript asp.net ajax asp.net-mvc-3

Answer 1

Answer №1

Below is a snippet of code that can be implemented in your error handling block:

var newTitle = $(request.responseText).filter('title').text(); // alternatively, try find('title').text();

The variable newTitle above will display the title for you.

However, it is recommended to create a custom ErrorDetails class with properties such as a Message string, or a Messages List to store all validation messages and return them to the client. This can be achieved in your controller catch block like so:

ErrorDetails errorDetails = new ErrorDetails();
errorDetails.Message = "Please select only Air Product that are UnInvoiced";
return Json(errorDetails, JsonRequestBehavior.AllowGet);

When accessing the error details in jQuery code, you can do the following:

error: function(xhr, status, error) {
  var obj = $.parseJSON(xhr.responseText); //you can also directly use xhr.responseJSON instead of parsing
  alert(obj.Message);
  //utilize this obj to retrieve message or list of messages through a loop
}

Answer 2

Below is a snippet of code that can be implemented in your error handling block:

var newTitle = $(request.responseText).filter('title').text(); // alternatively, try find('title').text();

The variable newTitle above will display the title for you.

However, it is recommended to create a custom ErrorDetails class with properties such as a Message string, or a Messages List to store all validation messages and return them to the client. This can be achieved in your controller catch block like so:

ErrorDetails errorDetails = new ErrorDetails();
errorDetails.Message = "Please select only Air Product that are UnInvoiced";
return Json(errorDetails, JsonRequestBehavior.AllowGet);

When accessing the error details in jQuery code, you can do the following:

error: function(xhr, status, error) {
  var obj = $.parseJSON(xhr.responseText); //you can also directly use xhr.responseJSON instead of parsing
  alert(obj.Message);
  //utilize this obj to retrieve message or list of messages through a loop
}

Answer 3

Answer №2

Here is my approach to handling errors which you might find useful.

Within the base controller:

 protected virtual JsonResult HandleError(Exception exception, string customMessage = null, int statusCode = 500)
        {
            JsonNetResult result = new JsonNetResult();
            result.ContentType = "application/json";
            result.ContentEncoding = System.Text.Encoding.UTF8;
            result.Data = new JsonErrorModel(){ error = exception, message = customMessage };

            if (exception != null)
                Log.Error(customMessage, exception);
            else if (!string.IsNullOrWhiteSpace(customMessage))
                Log.Error(customMessage);

            int updatedStatus = statusCode;
            if (exception != null)
            {
                if (exception is ArgumentException || exception is ArgumentNullException || exception is CustomException)
                    updatedStatus = 400;
                var aggException = exception as CustomAggregateException;
                if (aggException != null)
                {
                    updatedStatus = 400;
                    customMessage = customMessage ?? string.Join("; ", aggException.Messages);
                }
            }

            if (Response != null)
            {
                Response.StatusCode = updatedStatus;
                Response.StatusDescription = customMessage ?? (exception == null ? "An error occurred" : exception.Message);
            }

            return result;
        }

Within the HomeController, extending the basecontroller:

 public JsonResult HandleTestCase(Model model)
        {
            try
            {
            }
            catch (Exception ex)
            {
                return HandleError(ex);
            }
        }

Considering refactoring this process to create a reusable exception-handling attribute or potentially managing error logic in the global.asax.cs application_error method.

Answer 4

Here is my approach to handling errors which you might find useful.

Within the base controller:

 protected virtual JsonResult HandleError(Exception exception, string customMessage = null, int statusCode = 500)
        {
            JsonNetResult result = new JsonNetResult();
            result.ContentType = "application/json";
            result.ContentEncoding = System.Text.Encoding.UTF8;
            result.Data = new JsonErrorModel(){ error = exception, message = customMessage };

            if (exception != null)
                Log.Error(customMessage, exception);
            else if (!string.IsNullOrWhiteSpace(customMessage))
                Log.Error(customMessage);

            int updatedStatus = statusCode;
            if (exception != null)
            {
                if (exception is ArgumentException || exception is ArgumentNullException || exception is CustomException)
                    updatedStatus = 400;
                var aggException = exception as CustomAggregateException;
                if (aggException != null)
                {
                    updatedStatus = 400;
                    customMessage = customMessage ?? string.Join("; ", aggException.Messages);
                }
            }

            if (Response != null)
            {
                Response.StatusCode = updatedStatus;
                Response.StatusDescription = customMessage ?? (exception == null ? "An error occurred" : exception.Message);
            }

            return result;
        }

Within the HomeController, extending the basecontroller:

 public JsonResult HandleTestCase(Model model)
        {
            try
            {
            }
            catch (Exception ex)
            {
                return HandleError(ex);
            }
        }

Considering refactoring this process to create a reusable exception-handling attribute or potentially managing error logic in the global.asax.cs application_error method.

MVC SQL Error Exception encountered

Answer №1

Answer №2

Similar questions

The issue of asynchronous behavior causing malfunctioning of the PayPal button

Automated library that refreshes the webpage instantly upon any server modifications

What is the best method to retrieve the minimum and maximum values of a range slider in PHP and

Node.js POST request only executes successfully on the second attempt

What is the best way to create an IF statement that will execute only when a specific variable, "id," is included in the URL

Can one function be invoked from another function in Node.js?

How can you nest a map within a map in JavaScript?

Encountered an error while creating a PNG chart with node-export-server: Unexpected character '''

The Combobox event does not trigger properly on a change

Updating Model Property Value via AJAX Request

What is the best way to retrieve the current value of a header cell, including any nested headers?

Sending HTML data from jQuery via Ajax to PHP and receiving a response

Is it possible to trigger the execution of two functions simultaneously by using onClick in JavaScript?

Trouble with passing AJAX calls from JavaScript object to PHP

Youtube does not trigger injection scripts in Safari extensions

Error occurred in Flask due to request names being dynamically generated using JavaScript

javascript - convert a JSON string into an object without using quotation marks

Accessing User Input Data with JQuery

Is there a variation in IE6 versions depending on the operating system used?

Secure your password with Vue JS encryption techniques