public static CountryInfoWithCityID getCountryInfoCityID(int cityid)
{
CountryInfoWithCityID prop_set = new CountryInfoWithCityID();
// adapter.Fill(customers, "Customers");
try
{
using (SqlConnection con = new SqlConnection(connString))
{
/* @keyword nvarchar(200) ='',
* @proptype int= 0,
* @roomnum int= 0,
* @amenityid int= 0
*/
con.Open();
SqlCommand cmd = new SqlCommand("uspGetCountryInfoWithCityID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@cityid", SqlDbType.Int).Value = cityid;
// @pagenum int =0,
//@ratesort int= 0
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
PropertyInfo[] props = prop_set.GetType().GetProperties();
foreach (PropertyInfo prop_info in props)
{
prop_info.SetValue(prop_set, Convert.ChangeType(reader[prop_info.Name], prop_info.PropertyType), null);
}
break;
}
con.Close();
}
}
catch (Exception ex)
{
}
return(prop_set);
}
//live
protected void Page_Load(object sender, System.EventArgs e)
{
//Response.Clear();
//Response.StatusCode = 404;
//Response.End();
//HttpResponse.RemoveOutputCacheItem("/CityList.aspx");
//CommonFunctions.Connection.Open ();
if ((Request.Params["CityID"] != null) && (Request.Params["CityID"].Length > 0))
{
try
{
cityid = Convert.ToInt32(Request.Params["CityID"]);
}
catch (Exception)
{
}
}
//lblcity.Text = cityid.ToString();
//cityid = 3031;
if (cityid == -1)
{
Response.Redirect(CommonFunctions.PrepareURL("InternalError.aspx"));
}
// propertyset = SearchProvider.getPropertyListInfoSet(strkeyword, 0, 0, 0);
// propertylist.DataSource = propertyset;
// propertylist.DataBind();
// propertytypes = SearchProvider.getPropertyTypeListSet(strkeyword);
for (int i = 0; i < 4; i++)
{
bedroominfo[i] = SearchProvider.getNumbersOfCityID(cityid, 0, 0, i);
}
for (int i = 0; i < 5; i++)
{
amenity_nums[i] = SearchProvider.getNumbersOfCityID(cityid, 0, amenity_id[i], 0);
}
for (int i = 0; i < 3; i++)
{
prop_nums[i] = SearchProvider.getNumbersOfCityID(cityid, prop_typeval[i], 0, 0);
}
// ajax_proplist = SearchProvider.getAjaxPropListSet(strkeyword, 0, 0, 0, 0, 0);
countryinfo = SearchProvider.getCountryInfoCityID(cityid);
hyperRegion.NavigateUrl = "/" + countryinfo.Region.ToLower().Replace(" ", "_") + "/default.aspx";
hyplnkCountryBackLink.NavigateUrl = "/" + countryinfo.Region.ToLower().Replace(" ", "_") + "/" + countryinfo.Country.ToLower().Replace(" ", "_") + "/default.aspx";
hyplnkStateBackLink.NavigateUrl = "/" + countryinfo.Region.ToLower().Replace(" ", "_") + "/" + countryinfo.Country.ToLower().Replace(" ", "_") + "/" + countryinfo.StateProvince.ToLower().Replace(" ", "_") + "/default.aspx";
ltrH11.Text = countryinfo.City + " Vacations";
lblcity.Text = countryinfo.CityText;
if (!IsPostBack)
{
txtCityText.Text = countryinfo.CityText;
txtCityText2.Text = countryinfo.CityText2;
CityParam.Value = cityid.ToString();
}
// Response.Write(cityid);
}
protected void Page_Load(object sender, System.EventArgs e)
{
//Check the state province id;
if (!Int32.TryParse(Request["StateProvinceID"].ToString(), out stateprovinceid))
{
stateprovinceid = -1;
}
if (stateprovinceid == -1)
{
Response.Redirect("/internalerror.aspx");
}
List <SqlParameter> sparam = new List <SqlParameter>();
sparam.Add(new SqlParameter("@stateid", stateprovinceid));
countryinfo = CommonProvider.ConvertToClassFromDataSet <CountryInfoWithCityID>(BookDBProvider.getDataSet("uspGetCountryInfoWithStateID", sparam));
str_propcate[0] = String.Format("{0} {1}", countryinfo.StateProvince, str_propcate[0]);
str_propcate[1] = String.Format("{0} {1}", countryinfo.StateProvince, str_propcate[1]);
//For H1 title, state province text, links
hyperRegion.NavigateUrl = "/" + countryinfo.Region.ToLower().Replace(" ", "_") + "/default.aspx";
hyplnkCountryBackLink.NavigateUrl = "/" + countryinfo.Country.ToLower().Replace(" ", "_") + "/default.aspx";
ltrHeading.Text = String.Format("{0} Vacation Rentals and Boutique Hotels", countryinfo.StateProvince);
//For stepbox radio button value, description text
if (!IsPostBack)
{
txtCityText.Text = Server.HtmlDecode(countryinfo.CityText).Replace("<br />", Environment.NewLine);
txtCityText2.Text = Server.HtmlDecode(countryinfo.CityText2).Replace("<br />", Environment.NewLine);
//txtCityText2.Text = countryinfo.CityText2;
rproptype_id = 0;
rbedroom_id = 0;
ramenity_id = 0;
rsort_id = 0;
pagenum = 0;
}
else
{
rproptype_id = Int32.Parse(Request.Form["proptype"]);
rbedroom_id = Int32.Parse(Request.Form["roomnums"]);
ramenity_id = Int32.Parse(Request.Form["amenitytype"]);
rsort_id = Int32.Parse(Request.Form["pricesort"]);
pagenum = Int32.Parse(Request.Form["pagenums"]);
}
ltrH1.Text = countryinfo.StateProvince + " Vacations";
lblcityInfo.Text = Server.HtmlDecode(countryinfo.CityText).Replace(Environment.NewLine, "<br />");
if (countryinfo.CityText == null || countryinfo.CityText == "")
{
lblcityInfo.Text = String.Format("Vacations-abroad.com is a {0} {1} vacation rental directory of short term {0} vacation condos, privately owned {0} villas and {0} rentals by owner. Our unique and exotic boutique {0} hotels and luxury {0} resorts are perfect {0} {1} rentals for family and groups that are looking for vacation rentals in {0} {1}", countryinfo.City, countryinfo.Country);
txtCityText.Text = String.Format("Vacations-abroad.com is a {0} {1} vacation rental directory of short term {0} vacation condos, privately owned {0} villas and {0} rentals by owner. Our unique and exotic boutique {0} hotels and luxury {0} resorts are perfect {0} {1} rentals for family and groups that are looking for vacation rentals in {0} {1}", countryinfo.City, countryinfo.Country);
}
//Get the step box value
List <SqlParameter> numparam = new List <SqlParameter>();
for (int i = 0; i < 4; i++)
{
numparam.Clear();
numparam.Add(new SqlParameter("@stateid", stateprovinceid));
numparam.Add(new SqlParameter("@roomnum", i));
numparam.Add(new SqlParameter("@amenityid", ramenity_id));
numparam.Add(new SqlParameter("@proptype", rproptype_id));
bedroominfo[i] = CommonProvider.getScalarValueFromDB("uspGetStatePropNumsByCondition", numparam);
}
for (int i = 0; i < 5; i++)
{
numparam.Clear();
numparam.Add(new SqlParameter("@stateid", stateprovinceid));
numparam.Add(new SqlParameter("@roomnum", rbedroom_id));
numparam.Add(new SqlParameter("@proptype", rproptype_id));
numparam.Add(new SqlParameter("@amenityid", amenity_id[i]));
amenity_nums[i] = CommonProvider.getScalarValueFromDB("uspGetStatePropNumsByCondition", numparam);
}
for (int i = 0; i < 3; i++)
{
numparam.Clear();
numparam.Add(new SqlParameter("@stateid", stateprovinceid));
numparam.Add(new SqlParameter("@proptype", prop_typeval[i]));
// numparam.Add(new SqlParameter("@roomnum", rbedroom_id));
//numparam.Add(new SqlParameter("@proptype", rproptype_id));
// numparam.Add(new SqlParameter("@amenityid", ramenity_id));
prop_nums[i] = CommonProvider.getScalarValueFromDB("uspGetStatePropNumsByCondition", numparam);
}
//Get the property list for the state province
List <SqlParameter> dsparam = new List <SqlParameter>();
dsparam.Add(new SqlParameter("@stateid", stateprovinceid));
dsparam.Add(new SqlParameter("@proptype", rproptype_id));
dsparam.Add(new SqlParameter("@roomnum", rbedroom_id));
dsparam.Add(new SqlParameter("@amenityid", ramenity_id));
dsparam.Add(new SqlParameter("@ratesort", rsort_id));
ds_PropList = BookDBProvider.getDataSet("uspGetStatePropListByCondition", dsparam);
if (!IsPostBack)
{
if (ds_PropList.Tables[0].Rows.Count == 0)
{
Response.StatusCode = 404;
// Response.Status = "There is no state province";
Response.End();
}
}
//Get the city location info
List <SqlParameter> param = new List <SqlParameter>();
param.Clear();
param.Add(new SqlParameter("@stateid", stateprovinceid));
param.Add(new SqlParameter("@proptype", rproptype_id));
param.Add(new SqlParameter("@roomnum", rbedroom_id));
param.Add(new SqlParameter("@amenityid", ramenity_id));
ds_citylocations = BookDBProvider.getDataSet("uspGetCityLocationListbyCondition", param);
markers = CommonProvider.getMarkersJsonString(ds_citylocations);
sparam.Clear();
sparam.Add(new SqlParameter("@state", countryinfo.StateProvince));
ds_airports = BookDBProvider.getDataSet("usp_list_airports_bystate", sparam);
airport_markers = CommonProvider.getMarkersJsonString(ds_airports, "airport");
lblInfo2.Text = Server.HtmlDecode(countryinfo.CityText2).Replace(Environment.NewLine, "<br />");
param.Clear();
param.Add(new SqlParameter("@stateid", stateprovinceid));
//For state list
ds_statelist = BookDBProvider.getDataSet("uspGetStateNameListbyCondition", param);
int citycount = ds_citylocations.Tables[0].Rows.Count;
for (int stid = 0; stid < citycount; stid++)
{
DataRow drow = ds_citylocations.Tables[0].Rows[stid];
string comma = (stid == (citycount - 1)) ? "" : ", ";
city_lists += (drow["City"] + comma);
list_city.Add(drow["City"].ToString());
}
/*
*
* HtmlHead head = Page.Header;
*
*
*
*
* //FillCitiesColumn();
* /* HtmlMeta description = new HtmlMeta();
*
* description.Name = "description";
* description.Content = Description.Text.Replace("%country%", country).Replace("%stateprovince%", stateprovince).
* Replace("%cities%", cities);
* // Description OVER RIDE area
*
* string DescripReplacement = MainDataSet.Tables["Location"].Rows[0]["descriptionoverride"].ToString();
* if (DescripReplacement.Length > 0)
* description.Content = DescripReplacement;
* description.Content = "Plan your next " + stateprovince + " vacation: where to stay and places to visit!";
*
* head.Controls.Add(description);
* /////
* List<SqlParameter> param = new List<SqlParameter>();
* param.Add(new SqlParameter("@stid", stateprovinceid));
* ds_PTypeNum = BookDBProvider.getDataSet("uspGetPropNumListbyState", param);
*
* ///* if (!IsPostBack)
* // {
* List<SqlParameter> sparam = new List<SqlParameter>();
* sparam.Add(new SqlParameter("@stid", stateprovinceid));
* ds_PropList = BookDBProvider.getDataSet("uspGetStatePropList", sparam);
*
* sparam.Clear();
* sparam.Add(new SqlParameter("@stid", stateprovinceid));
* ds_citylocations = BookDBProvider.getDataSet("uspGetCityLocationListbyCondition", sparam);
*
* markers = CommonProvider.getMarkersJsonString(ds_citylocations);
* // }
*
* if (IsPostBack)
* {
* ptype = int.Parse(Request["ptypes"]);
* psleep = int.Parse(Request["psleep"]);
* }
*
* for (int i=0; i < 4; i++)
* {
* param.Clear();
* param.Add(new SqlParameter("@stid", stateprovinceid));
* param.Add(new SqlParameter("@sleep", i));
* param.Add(new SqlParameter("@ptype", ptype));
* DataSet ds_tmp = BookDBProvider.getDataSet("uspGetStatePropNumListbySleep",param);
* sleeps[i] = int.Parse(ds_tmp.Tables[0].Rows[0]["Num"].ToString());
* }
*
*
*
*
* Page page1 = (Page)HttpContext.Current.Handler;
*
*
* HtmlMeta newdescription = new HtmlMeta();
*
* int counts = AjaxProvider.getPropertyNumsbyState(stateprovinceid);
*
* string str_meta = "(%counts%) %state% vacation rentals and boutique hotels in %cities%.";
* newdescription.Name = "description";
* newdescription.Content = str_meta.Replace("%state%", stateprovince ).Replace("%cities%", str_cities).Replace("%counts%", ds_PropList.Tables[0].Rows.Count.ToString());
*
* head.Controls.Add(newdescription);
*
*
*
* HtmlMeta keywords = new HtmlMeta();
*
* keywords.Name = "keywords";
* keywords.Content = Keywords.Text.Replace("%country%", country).Replace("%stateprovince%", stateprovince).
* Replace("%cities%", cities);
* keywords.Content = page1.Title;
* head.Controls.Add(keywords);
* // ((System.Web.UI.WebControls.Image)Master.FindControl("Logo")).AlternateText = page1.Title;
* // Page.Header.Controls.Add(new LiteralControl("<link href='http://vacations-abroad.com/css/StyleSheetBig4.css' rel='stylesheet' type='text/css'></script>"));
*/
}
//live
protected void Page_Load(object sender, System.EventArgs e)
{
//Response.Clear();
//Response.StatusCode = 404;
//Response.End();
//HttpResponse.RemoveOutputCacheItem("/CityList.aspx");
//CommonFunctions.Connection.Open ();
if ((Request.Params["CityID"] != null) && (Request.Params["CityID"].Length > 0))
{
try
{
cityid = Convert.ToInt32(Request.Params["CityID"]);
}
catch (Exception)
{
}
}
//lblcity.Text = cityid.ToString();
//cityid = 3031;
if (cityid == -1)
{
Response.Redirect(CommonFunctions.PrepareURL("InternalError.aspx"));
}
// cityid = 3031;
// propertyset = SearchProvider.getPropertyListInfoSet(strkeyword, 0, 0, 0);
// propertylist.DataSource = propertyset;
// propertylist.DataBind();
// propertytypes = SearchProvider.getPropertyTypeListSet(strkeyword);
for (int i = 0; i < 4; i++)
{
bedroominfo[i] = SearchProvider.getNumbersOfCityID(cityid, 0, 0, i);
}
for (int i = 0; i < 5; i++)
{
amenity_nums[i] = SearchProvider.getNumbersOfCityID(cityid, 0, amenity_id[i], 0);
}
for (int i = 0; i < 3; i++)
{
prop_nums[i] = SearchProvider.getNumbersOfCityID(cityid, prop_typeval[i], 0, 0);
}
// ajax_proplist = SearchProvider.getAjaxPropListSet(strkeyword, 0, 0, 0, 0, 0);
// Response.Write(cityid + " City");
//Response.Write(cityid);
countryinfo = SearchProvider.getCountryInfoCityID(cityid);
hyperRegion.NavigateUrl = "/" + countryinfo.Region.ToLower().Replace(" ", "_") + "/default.aspx";
hyplnkCountryBackLink.NavigateUrl = "/" + countryinfo.Country.ToLower().Replace(" ", "_") + "/default.aspx";
hyplnkStateBackLink.NavigateUrl = "/" + countryinfo.Country.ToLower().Replace(" ", "_") + "/" + countryinfo.StateProvince.ToLower().Replace(" ", "_") + "/default.aspx";
ltrH11.Text = countryinfo.City + " Vacations";
lblcity.Text = Server.HtmlDecode(countryinfo.CityText);
if (countryinfo.CityText == null || countryinfo.CityText == "")
{
lblcity.Text = String.Format("Vacations-abroad.com is a {0} {1} vacation rental directory of short term {0} vacation condos, privately owned {0} villas and {0} rentals by owner. Our unique and exotic boutique {0} hotels and luxury {0} resorts are perfect {0} {1} rentals for family and groups that are looking for vacation rentals in {0} {1}", countryinfo.City, countryinfo.Country);
}
DataSet ds = AjaxProvider.getProCatNumsbyCity(cityid);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
meta_str += String.Format("{1}s ({0}), ", ds.Tables[0].Rows[i][0], ds.Tables[0].Rows[i][1]).Replace("&", " ");
}
int ind_last = meta_str.Length - 2;
meta_str = meta_str.Substring(0, (ind_last > 0)?ind_last:0);
if (!IsPostBack)
{
txtCityText.Text = Server.HtmlDecode(countryinfo.CityText).Replace("<br />", Environment.NewLine);
txtCityText2.Text = Server.HtmlDecode(countryinfo.CityText2).Replace("<br />", Environment.NewLine);
//txtCityText2.Text = countryinfo.CityText2;
CityParam.Value = cityid.ToString();
rproptype_id = 0;
rbedroom_id = 0;
ramenity_id = 0;
rsort_id = 1;
pagenum = 0;
}
else
{
rproptype_id = Int32.Parse(Request.Form["proptype"]);
rbedroom_id = Int32.Parse(Request.Form["roomnums"]);
ramenity_id = Int32.Parse(Request.Form["amenitytype"]);
rsort_id = Int32.Parse(Request.Form["pricesort"]);
pagenum = Int32.Parse(Request.Form["pagenums"]);
}
proplistset = SearchProvider.getAjaxAllPropListSetWithCityID(cityid, rproptype_id, ramenity_id, rbedroom_id, rsort_id);
for (int i = 0; i < proplistset.allnums; i++)
{
list_rating.Add(BookDBProvider.getRatingbyID(proplistset.propertyList[i].detail.ID));
}
// Response.Write(cityid);
//<meta name="description" content="<%=countryinfo.City %>, <%=countryinfo.StateProvince %> <%=meta_str %>" />
// HtmlMeta newdescription = new HtmlMeta();
// newdescription.Name = "description";
// newdescription.Content = Server.HtmlDecode(String.Format("Our {0}, {1} vacation rentals and boutique hotels include: {2} ", countryinfo.City, countryinfo.StateProvince,meta_str));
newdescription = String.Format("Our {0}, {1} vacation rentals and boutique hotels include: {2} ", countryinfo.City, countryinfo.StateProvince, meta_str);
city_ds = AjaxProvider.getCityListbyCityNum(cityid);
// Page.Header.Controls.Add(newdescription);
}
