Friday, 13 December 2013

Display State,Based on State City will be Displayed in Jquery(Without Postback)

 <asp:TextBox ID="UC8_AN_txtState" runat="server" CssClass="autosuggest input-style"
                                        Width="150px"></asp:TextBox>

 <asp:TextBox ID="UC8_AN_txtCity" runat="server" CssClass="autosuggest123 input-style"
                                        Width="150px" class="input-style" value="City"></asp:TextBox>

 function SearchState() {
        $(".autosuggest").autocomplete({
            source: function (request, response) {
                $.ajax({
                    type: "POST",
                    contentType: "application/json; charset=utf-8",
                    url: "Annuity.aspx/GetState", //Call C# Method Gupta
                    data: "{'STATE_Name':'" + document.getElementById('CPH1_ID_AN_AD_Proposal_UC8_AN_txtState').value + "'}",
                    dataType: "json",
                    success: function (data) {
                        response(data.d);
                    },
                    error: function (result) {
                        alert("Error");
                    }
                });
            }
        });
    }

    function Searchcity() {

        $(".autosuggest123").autocomplete({
            source: function (request, response) {
                $.ajax({
                    type: "POST",
                    contentType: "application/json; charset=utf-8",
                    url: "Annuity.aspx/Getcity", //Call C# Method Gupta
                    data: "{'STATE_Name':'" + document.getElementById('CPH1_ID_AN_AD_Proposal_UC8_AN_txtState').value + "','city_NAME':'" + document.getElementById('CPH1_ID_AN_AD_Proposal_UC8_AN_txtCity').value + "'}",
                    dataType: "json",
                    success: function (data) {
                        response(data.d);
                    },
                    error: function (result) {
                        alert("Errorcity");
                    }
                });
            }
        });
    }


 [WebMethod]
    public static List<string> GetState(string STATE_Name)
    {
        List<string> result = new List<string>();
        OracleConnection objConn = new OracleConnection();
        objConn.ConnectionString = ConfigurationManager.ConnectionStrings["ora"].ToString();
        OracleConnection connection = new OracleConnection(objConn.ConnectionString);
        OracleCommand cmd = new OracleCommand("select STATE_NAME FROM m_eion_state  where lower(STATE_NAME) like '" + STATE_Name.ToLower() + "%'");
        cmd.Connection = connection;
        connection.Open();
        cmd.ExecuteNonQuery();
        OracleDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            result.Add(dr["STATE_NAME"].ToString());
        }
        return result;
    }


    [WebMethod]
    public static List<string> Getcity(string STATE_Name, string city_NAME)
    {
        List<string> result = new List<string>();
        OracleConnection objConn = new OracleConnection();
        objConn.ConnectionString = ConfigurationManager.ConnectionStrings["ora"].ToString();
        OracleConnection connection = new OracleConnection(objConn.ConnectionString);
        OracleCommand stateid = new OracleCommand("select STATE_ID from m_eion_state where state_name = '" + STATE_Name + "'");
        stateid.Connection = connection;
        connection.Open();
        int stateId = Convert.ToInt32(stateid.ExecuteScalar());
        OracleCommand cmd = new OracleCommand("select CITY_NAME FROM m_eion_city  where Lower(CITY_NAME) like '" + city_NAME.ToLower() + "%' and STATE_ID = '" + stateId + "'");
        cmd.Connection = connection;
        cmd.ExecuteNonQuery();
        OracleDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            result.Add(dr["CITY_NAME"].ToString());
        }
        return result;
    }

No comments:

Post a Comment