public IHttpActionResult getAmphurData(string province)
{
List <zipcodedata> result = new List <zipcodedata>();
DBConnector.DBConnector conn = new DBConnector.DBConnector();
string SQLString;
if (conn.OpenConnection())
{
MySqlCommand qExe = new MySqlCommand();
qExe.Connection = conn.connection;
SQLString = @"select distinct province, amphur from zip_data where province = '" + province + @"' order by amphur";
qExe.CommandText = SQLString;
MySqlDataReader dataReader = qExe.ExecuteReader();
while (dataReader.Read())
{
zipcodedata detail = new zipcodedata();
detail.province = dataReader["province"].ToString();
detail.amphur = dataReader["amphur"].ToString();
detail.tambon = "";
detail.zipcode = "";
result.Add(detail);
}
return(Json(result));
}
else
{
return(BadRequest("Database connect fail!"));
}
}
public IHttpActionResult getZipCodeData(string zipcode)
{
zipcodedata result = new zipcodedata();
DBConnector.DBConnector conn = new DBConnector.DBConnector();
string SQLString;
if (conn.OpenConnection())
{
if (!string.IsNullOrEmpty(zipcode))
{
MySqlCommand qExe = new MySqlCommand();
qExe.Connection = conn.connection;
SQLString = @"select * from zip_data where zipcode = '" + zipcode + "'";
qExe.CommandText = SQLString;
MySqlDataReader dataReader = qExe.ExecuteReader();
while (dataReader.Read())
{
result.province = dataReader["province"].ToString();
result.amphur = dataReader["amphur"].ToString();
result.tambon = dataReader["tambon"].ToString();
result.zipcode = dataReader["zipcode"].ToString();
}
}
return(Json(result));
}
else
{
return(BadRequest("Database connect fail!"));
}
}