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

Last Reply 2 months ago By dharmendr

Posted 2 months ago

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>
Posted 2 months ago

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)