<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;
}
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