public void fillcitydetails(Int32 cityid, string streetname, string parent_zip)
{
txtaddress.Text = streetname.ToString();
if (cityid != 0)
{
hdncityid.Value = cityid.ToString();
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
MasterData mdl = new MasterData();
dt = mdl.Getcitydetails(Convert.ToInt32(hdncityid.Value));
if (dt.Rows.Count > 0)
{
txtaddress.Text = streetname.ToString();
ddlcity.SelectedIndex = ddlcity.Items.IndexOf(ddlcity.Items.FindByValue(dt.Rows[0]["City_ID"].ToString()));
lblcountry.Text = dt.Rows[0]["COUNTRY_NAME"].ToString();
lblstate.Text = dt.Rows[0]["STATE_NAME"].ToString();
string[] zip = dt.Rows[0]["Zip"].ToString().Split(',');
dt1.Columns.Add("ZipCode", typeof(string));
dt1.Columns.Add("Zipid", typeof(Int32));
for (int i = 0; i < zip.Length; i++)
{
dt1.Rows.Add(zip[i],i);
}
objcf.FillDropDownList(ddlzip, dt1, "ZipCode", "Zipid");
if (parent_zip != "0")
ddlzip.SelectedIndex = ddlzip.Items.IndexOf(ddlzip.Items.FindByText(parent_zip));
}
}
else
{
clearall();
}
}
protected void txtcitynearby_TextChanged(object sender, EventArgs e)
{
TextBox txtcitynearby = (TextBox)Repnearbymetro.Controls[Repnearbymetro.Controls.Count - 1].FindControl("txtcitynearby");
TextBox txtstatenc = (TextBox)Repnearbymetro.Controls[Repnearbymetro.Controls.Count - 1].FindControl("txtstatenc");
TextBox txtZipCodenc = (TextBox)Repnearbymetro.Controls[Repnearbymetro.Controls.Count - 1].FindControl("txtZipCodenc");
Label lblnearbystate = (Label)Repnearbymetro.Controls[Repnearbymetro.Controls.Count - 1].FindControl("lblnearbystate");
Label lblcountrync = (Label)Repnearbymetro.Controls[Repnearbymetro.Controls.Count - 1].FindControl("lblcountrync");
Label lblzipcodenc = (Label)Repnearbymetro.Controls[Repnearbymetro.Controls.Count - 1].FindControl("lblzipcodenc");
DropDownList ddlstatenc = (DropDownList)Repnearbymetro.Controls[Repnearbymetro.Controls.Count - 1].FindControl("ddlstatenc");
DropDownList ddlcountrync = (DropDownList)Repnearbymetro.Controls[Repnearbymetro.Controls.Count - 1].FindControl("ddlcountrync");
MasterData edl = new MasterData();
List<string> CountryNames = edl.searchcity(txtcitynearby.Text.Trim(), "Y");
bool flg = false;
if (CountryNames.Count == 0)
{
flg = true;
hdnnearbycityid.Value = "0";
hdncountryidnc.Value = "0";
hdnstateidnc.Value = "0";
}
else
{
MasterData mdl = new MasterData();
DataTable dt1 = mdl.Getcitydetails(Convert.ToInt32(hdnnearbycityid.Value));
lblnearbystate.Text = dt1.Rows[0]["STATE_NAME"].ToString();
lblcountrync.Text = dt1.Rows[0]["Country_NAME"].ToString();
txtcitynearby.Text = dt1.Rows[0]["City_name"].ToString();
lblzipcodenc.Text = dt1.Rows[0]["Zip"].ToString();
hdncountryidnc.Value = dt1.Rows[0]["Country_ID"].ToString();
hdnstateidnc.Value = dt1.Rows[0]["State_ID"].ToString();
txtstatenc.Visible = flg;
ddlstatenc.ClearSelection();
ddlcountrync.ClearSelection();
}
ddlcountrync.Visible = flg;
ddlstatenc.Visible = flg;
lblnearbystate.Visible = !flg;
lblcountrync.Visible = !flg;
lblzipcodenc.Visible = !flg;
txtZipCodenc.Visible = flg;
}
protected void ddlcitynearby_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList ddlcitynearby = Repnearbymetro.Controls[Repnearbymetro.Controls.Count - 1].FindControl("ddlcitynearby") as DropDownList;
Label lblnearbystate = Repnearbymetro.Controls[Repnearbymetro.Controls.Count - 1].FindControl("lblnearbystate") as Label;
Label lblcountrync = Repnearbymetro.Controls[Repnearbymetro.Controls.Count - 1].FindControl("lblcountrync") as Label;
Label lblzipcodenc = Repnearbymetro.Controls[Repnearbymetro.Controls.Count - 1].FindControl("lblzipcodenc") as Label;
DataTable dt = new DataTable();
if (ddlcitynearby.SelectedItem.Value == hdnmetrocityid.Value)
{
lblerrmsg.Text = "Metro city and near by metro city should not be same!";
ddlcitynearby.ClearSelection();
return;
}
if (ddlcitynearby.SelectedIndex > 0)
{
if (cityexist(Convert.ToInt32(ddlcitynearby.SelectedItem.Value)) == false)
{
lblerrmsg.Text = "Near by city already exists!";
ddlcitynearby.ClearSelection();
return;
}
hdnnearbycityid.Value = ddlcitynearby.SelectedItem.Value;
MasterData mdl = new MasterData();
dt = mdl.Getcitydetails(Convert.ToInt32(ddlcitynearby.SelectedItem.Value));
lblcountrync.Text = dt.Rows[0]["COUNTRY_NAME"].ToString();
lblnearbystate.Text = dt.Rows[0]["STATE_NAME"].ToString();
lblzipcodenc.Text = dt.Rows[0]["Zip"].ToString();
}
else
{
lblcountrync.Text = string.Empty;
lblnearbystate.Text = string.Empty;
lblzipcodenc.Text = string.Empty;
}
ddlcitynearby.Focus();
}