Calling ASP.Net Web Service using jQuery AJAX Error: Internal Server Error 500

RohitSingh
 
on Nov 15, 2018 10:33 PM
7264 Views

I'm getting an error Internal Server Error 500. For this problem I've tried everything but still unable to figure it out what is the real problem

My Web Service Code: 

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
[System.Web.Script.Services.ScriptService]
public class CustomerDetails : System.Web.Services.WebService
{  

    [WebMethod]
    public static List<CustomerDetailsEnity> fetchCustomerDetails(string branchCode, string customerCode)
    {
        operationMySql mysql = new operationMySql();
        DataSet ds = new DataSet();
        List<CustomerDetailsEnity> customerDetails = new List<CustomerDetailsEnity>();
        try
        {
            string query = @"select Distinct ifnull(consignor_customer_code,consignor_code)
                            consinr_code, Concat(consignor_city,'-',consignor_name) consignor_name,
                            consignor_address_1, consignor_address_2, consignor_city, pincode, email, 
                            , consignor_contact_person, GST_No from table1 where
                            branch_code='" + branchCode + "' and customer_code='" + customerCode + "' "+@"
                            Order by consignor_city,consignor_name";

            string constr = mysql.ConnectionString;
            using (MySqlConnection con = new MySqlConnection(constr))
            {
                using (MySqlDataAdapter ad = new MySqlDataAdapter(query, con))
                {
                    ad.Fill(ds);
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        foreach (DataRow dr in ds.Tables[0].Rows)
                        {
                            customerDetails.Add(new CustomerDetailsEnity
                            {
                                consignorCode = dr["consinr_code"].ToString(),
                                customerName = dr["consignor_name"].ToString(),
                                address1 = dr["consignor_address_1"].ToString(),
                                address2 = dr["consignor_address_2"].ToString(),
                                City = dr["consignor_city"].ToString(),
                                email = dr["email"].ToString(),
                                mobile = dr["consignor_contact_person"].ToString(),
                                contactPerson = dr["consignor_contact_person"].ToString(),
                                GSTN = dr["GST_No"].ToString()
                            });
                        }
                    }
                }
            }
        }
        catch(Exception ex)
        { 
            
        }
        return customerDetails;    
    }

    public class CustomerDetailsEnity
    {
        public string consignorCode { get; set; }
        public string customerName { get; set; }
        public string address1 { get; set; }
        public string address2 { get; set; }
        public string City { get; set; }
        public string pinCode { get; set; }
        public string email { get; set; }
        public string mobile { get; set; }
        public string contactPerson { get; set; }
        public string GSTN { get; set; }
    }
}

My Ajax call: 

    <script type="text/javascript">
        $(function () {
            $("#ddl_CodeNameCust").change(function () {               
                $.ajax({
                    type: "POST",
                    url: "Services/CustomerDetails.asmx/fetchCustomerDetails",
                    dataType: "Json",
                    contentType: "application/json; charset=utf-8",
                    data: JSON.stringify({ branchCode: "PTPC", customerCode: "1000001" }),
                    success: function (Result) {
                        Result = Result.d;
                    },
                    error: function (Result) {
                        alert(Result.statusText);
                    }
                })
            });
        }); 
    </script>
Download FREE API for Word, Excel and PDF in ASP.Net: Download
dharmendr
 
on Nov 15, 2018 11:06 PM

Hi RohitSingh,

RohitSingh says:
public static List<CustomerDetailsEnity> fetchCustomerDetails(string branchCode, string customerCode)

 Remove static key word from the WebMethod.

public List<CustomerDetailsEnity> fetchCustomerDetails(string branchCode, string customerCode)