protected void Page_Load(object sender, System.EventArgs e)
{
if ((Request.Params["CountryID"] != null) && (Request.Params["CountryID"].Length > 0))
{
try
{
countryid = Convert.ToInt32(Request.Params["CountryID"]);
}
catch (Exception)
{
}
}
if (countryid == -1)
{
Response.Redirect(CommonFunctions.PrepareURL("InternalError.aspx"));
}
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@countryid", countryid));//[uspGetCountry_Prop_StateInfo]
ds_allinfo = BookDBProvider.getDataSet("uspGetCountry_Prop_StateInfo", param);
if (ds_allinfo.Tables.Count != 4)
{
Response.Redirect(CommonFunctions.PrepareURL("InternalError.aspx"));
}
region = ds_allinfo.Tables[0].Rows[0]["Region"].ToString();
country = ds_allinfo.Tables[0].Rows[0]["Country"].ToString();
string vText = "Vacations-abroad.com is a " + country + " accommodation directory of " + country + " rentals by owner and privately owned " + country + " holiday accommodation. Our short term " + country + " rentals include luxury " +
country + " holiday homes, " + country + " vacation homes and " + country + " vacation home rentals which are perfect for group or family vacation rentals in " + country + " " + region;
if (!IsPostBack)
{
//For country description
lblCountryInfo.Text = ds_allinfo.Tables[0].Rows[0]["countryText"].ToString().Replace(Environment.NewLine, "<br />");
txtCountryText.Text = ds_allinfo.Tables[0].Rows[0]["countryText"].ToString().Replace("<br />", Environment.NewLine);
if (lblCountryInfo.Text == null || lblCountryInfo.Text == "")
{
lblCountryInfo.Text = vText;
txtCountryText.Text = vText;
}
lblInfo2.Text = ds_allinfo.Tables[0].Rows[0]["countryText2"].ToString().Replace(Environment.NewLine, "<br />");
if (string.IsNullOrEmpty(lblInfo2.Text) || lblInfo2.Text == "")
{
OrangeTitle.Visible = false;
}
txtCountryText2.Text = ds_allinfo.Tables[0].Rows[0]["countryText2"].ToString().Replace("<br />", Environment.NewLine);
}
/* /////// common for postback and ! postback
* List<string> vList = new List<string>();
* DataTable dt = new DataTable();
* DataFunctions obj = new DataFunctions();
* DataTable dtCategories = new DataTable();
* DBConnection obj1 = new DBConnection();
*
* try
* {
* if (!IsPostBack)
* {
* dt = obj.PropertiesByCase(vList, countryid, "Country");
* DataView dv = dt.DefaultView;
* dv.Sort = "category asc";
* dt = dv.ToTable();
* Session["dt"] = dt;
* int[] i = new int[4];
* i = FindNumAmenities(dt);
*
* dtCategories = obj.FindNumCategories(dt);
* DataView dvMax = dtCategories.DefaultView;
* dvMax.Sort = "count desc";
* DataTable dtMax = dvMax.ToTable();
* int vCategoryCount = 0;
* string firstCategory = "";
* string subCategory = "";
* foreach (DataRow row in dtMax.Rows)
* {
* int index = dtMax.Rows.IndexOf(row);
* if (index == 0)
* {
* firstCategory = row["category"].ToString();
* subCategory = dt.Rows[0]["SubCategory"].ToString();
* }
* string vTemp = row["category"].ToString() + " (" + row["count"].ToString() + ")";
* vTemp = vTemp.Replace(" ", " ");
* vCategoryCount = vCategoryCount + Convert.ToInt32(row["count"].ToString());
* }
*
* if (!IsPostBack)
* {
*
* //dtlStates.DataSource = dtCategories;
* //dtlStates.DataBind();
* }
* //numbedrooms filter
* dtCategories = obj.FindNumBedrooms(dt);
* int vBedCount = 0;
* foreach (DataRow row in dtCategories.Rows)
* {
* vBedCount += Convert.ToInt32(row["count"]);
* }
*
* Page page = (Page)HttpContext.Current.Handler;
* if (Request.QueryString["category"] != null)
* {
* Response.Clear();
* Response.StatusCode = 404;
* Response.End();
* }
* if (dt.Rows.Count <= 10)
* {
* //Implement 404 logic less then 10 property with Prorerty in URL - Develop By Nimesh Sapovadiya
* if(Request.QueryString["category"] != null)
* {
* Response.Clear();
* Response.StatusCode = 404;
* Response.End();
* }
* string dispString = "";
* string dispString2 = "";
* if (subCategory.Contains("_"))
* {
* string[] strSplit = subCategory.Split('_');
* dispString = UppercaseFirst(strSplit[0]) + " " + UppercaseFirst(strSplit[1]) + "s";
* }
* else
* {
* dispString = UppercaseFirst(subCategory) + "s";
* }
* firstCategory = dt.Rows[0]["category"].ToString();
* if (firstCategory.Contains("_"))
* {
* string[] strSplit = firstCategory.Split('_');
* dispString2 = UppercaseFirst(strSplit[0]) + " " + UppercaseFirst(strSplit[1]) + "s";
* }
* else
* {
* dispString2 = UppercaseFirst(firstCategory) + "s";
* }
*
* altTag = char.ToUpper(country[0]) + country.Substring(1) + " Vacation Rentals";
* ltrH11.Text = char.ToUpper(country[0]) + country.Substring(1) + " Vacations";
* hyplnkBackLink.NavigateUrl = "/" + region.ToLower().Replace(" ", "_")+"/default.aspx";
* ltrBackText.Text = region + "<<";
* hyplnkAllProps.NavigateUrl = "/" + country.ToLower().Replace(" ", "_") + "/countryproperties.aspx";
* ltrAllProps.Text = " View all " + char.ToUpper(country[0]) + country.Substring(1) + " properties";
* string scountry=char.ToUpper(country[0]) + country.Substring(1);
* country = scountry;
* ltrHeading.Text = scountry + " Vacation Rentals and Boutique Hotels";
*
* page.Title = char.ToUpper(country[0]) + country.Substring(1) + " Vacation Rentals, Boutique Hotels | Vacations Abroad";
*
* string tempcountry1 = CommonFunctions.GetSiteAddress() + "/" + country.ToLower().Replace(" ", "_") +
* "/default.aspx";
*
* /* HtmlMeta description = new HtmlMeta();
* description.Name = "description";
* description.Content = "Plan your next " + char.ToUpper(country[0]) + country.Substring(1) + " vacation: where to stay and places to visit ";
* head.Controls.Add(description);
*
* }
* else
* {
*
* if (Request.QueryString["category"] != null)
* {
* firstCategory = Convert.ToString(Request.QueryString["category"]);
* }
* {
* string dispString = "";
* string dispString2 = "";
* if (subCategory.Contains("_"))
* {
* string[] strSplit = subCategory.Split('_');
* dispString = UppercaseFirst(strSplit[0]) + " " + UppercaseFirst(strSplit[1])+"s";
* }
* else
* {
* dispString = UppercaseFirst(subCategory) + "s";
* }
* if (firstCategory.Contains("_"))
* {
* string[] strSplit = firstCategory.Split('_');
* dispString2 = UppercaseFirst(strSplit[0]) + " " + UppercaseFirst(strSplit[1]) + "s";
* }
* else
* {
* dispString2 = UppercaseFirst(firstCategory) + "s";
* }
* altTag = char.ToUpper(country[0]) + country.Substring(1) + " Vacation Rentals";
* ltrH11.Text = char.ToUpper(country[0]) + country.Substring(1) + " Vacations";
* hyplnkBackLink.NavigateUrl = "/" + region.ToLower().Replace(" ", "_")+"/default.aspx";
* ltrBackText.Text = region + " Vacations <<";
* hyplnkAllProps.NavigateUrl = "/" + country.ToLower().Replace(" ", "_") + "/countryproperties.aspx";
* ltrAllProps.Text = " View all " + char.ToUpper(country[0]) + country.Substring(1) + " properties";
* string scountry = char.ToUpper(country[0]) + country.Substring(1);
* country = scountry;
* ltrHeading.Text = scountry + " Vacation Rentals and Boutique Hotels";
*
* //ltrCountryThing.Text = char.ToUpper(country[0]) + country.Substring(1);
* page.Title = char.ToUpper(country[0]) + country.Substring(1) + " Vacation Rentals, Boutique Hotels | Vacations Abroad";
*
* }
* if (firstCategory == "bandb")
* {
* firstCategory = "B&B";
* }
*
*
* DataTable dtCategory = dt.Clone();
* foreach (DataRow dr in dt.Rows)
* {
* string vTemp = dr["Category"].ToString();
* if (vTemp.ToLower().Replace(" ", "").Trim() == firstCategory.ToLower().Replace("_", " ").Replace(" ", ""))
* {
* subCategory = dr["SubCategory"].ToString();
* dtCategory.ImportRow(dr);
* }
* }
* DataView dv1 = dtCategory.DefaultView;
* dv1.Sort = "MinNightRate desc";
*
* if (Request.QueryString["category"] != null)
* {
* string dispString = "";
* if (firstCategory.Contains("_"))
* {
* string[] strSplit = firstCategory.Split('_');
* dispString = UppercaseFirst(strSplit[0]) + " " + UppercaseFirst(strSplit[1])+"s";
* }
* else
* {
* dispString = UppercaseFirst(firstCategory) + "s";
* }
* ltrH11.Text = char.ToUpper(country[0]) + country.Substring(1) + " Vacations";
* page.Title = char.ToUpper(country[0]) + country.Substring(1) + "Vacation Rentals, Boutique Hotels | Vacations Abroad";
* altTag = subCategory + " in " + country;
* Label3.Text = altTag;
* }
* else
* {
* string dispString = "";
* string dispString2 = "";
* if (subCategory.Contains("_"))
* {
* string[] strSplit = subCategory.Split('_');
* dispString = UppercaseFirst(strSplit[0]) + " " + UppercaseFirst(strSplit[1]) + "s";
* }
* else
* {
* dispString = UppercaseFirst(subCategory) + "s";
* }
* if (firstCategory.Contains("_"))
* {
* string[] strSplit = firstCategory.Split('_');
* dispString2 = UppercaseFirst(strSplit[0]) + " " + UppercaseFirst(strSplit[1]) + "s";
* }
* else
* {
* dispString2 = UppercaseFirst(firstCategory) + "s";
* }
* altTag = char.ToUpper(country[0]) + country.Substring(1) + " Vacation Rentals";
* ltrH11.Text = char.ToUpper(country[0]) + country.Substring(1) + " Vacations";
* page.Title = char.ToUpper(country[0]) + country.Substring(1) + " Vacation Rentals, Boutique Hotels | Vacations Abroad";
*
* }
* string tempcountry = CommonFunctions.GetSiteAddress() + "/" + country.ToLower().Replace(" ", "_") +
* "/default.aspx";
*
*
* }
*
* ViewState["firstCategory"] = firstCategory;
* DataTable dt1 = new DataTable();
* try
* {
* dt1 = VADBCommander.CountryTextInd(countryid.ToString(), firstCategory);
* }
* catch (Exception ex) { lblInfo.Text = ex.Message; }
*
* string vText = "Vacations-abroad.com is a " + country + " accommodation directory of " + country + " rentals by owner and privately owned " + country + " holiday accommodation. Our short term " + country + " rentals include luxury " +
* country + " holiday homes, " + country + " vacation homes and " + country + " vacation home rentals which are perfect for group or family vacation rentals in " + country + " " + region;
*
* if (dt1.Rows.Count > 0)
* {
*
* if (dt1.Rows[0]["countryText"] != null)
* {
* if (!IsPostBack)
* {
* lblCountryInfo.Text = dt1.Rows[0]["countryText"].ToString();
* txtCountryText.Text = dt1.Rows[0]["countryText"].ToString().Replace("<br />", Environment.NewLine);
* }
* ////Editor.Value = dt.Rows[0]["cityText"].ToString();
* }
* else
* {
* lblCountryInfo.Text = vText;
* txtCountryText.Text = vText;
* }
* if (dt1.Rows[0]["countryText2"] != null)
* {
* if (!IsPostBack)
* {
* lblInfo2.Text = dt1.Rows[0]["countryText2"].ToString();
* if (string.IsNullOrEmpty(lblInfo2.Text) || lblInfo2.Text == "")
* {
* OrangeTitle.Visible = false;
* }
* txtCountryText2.Text = dt1.Rows[0]["countryText2"].ToString().Replace("<br />", Environment.NewLine);
* }
* }
* else
* {
* OrangeTitle.Visible = false;
* }
* }
* else
* {
* lblCountryInfo.Text = vText;
* txtCountryText.Text = vText;
* OrangeTitle.Visible = false;
* }
* }
* }
* catch (Exception ex) { lblInfo.Text = ex.Message; }
*
* DBConnection obj3 = new DBConnection();
* SqlDataReader reader = obj3.ExecuteRecordSetArtificial("SELECT Cities.* FROM Cities WHERE (Cities.StateProvinceID = " + stateprovinceid + ") " + "AND EXISTS ( SELECT * FROM Properties WHERE (Properties.IfFinished = 1) AND (Properties.IfApproved = 1) AND " + "(Properties.CityID = Cities.ID) AND NOT EXISTS (SELECT * FROM Auctions WHERE PropertyID = Properties.ID)) ORDER " + "BY City");
* string states1 = "";
* string regionCountry = "";
* foreach (DataRow dr in MainDataSet.Tables["CountriesRegion"].Rows)
* {
* string temp = "/" + dr["Country"].ToString().ToLower().Replace(" ", "_") + "/default.aspx";
* temp = temp.ToLower();
* temp = temp.Replace(' ', '_');
* rtLow3.Text += "<li><a href=\"" + temp + "\"><span class=\"tdNoSleeps\">" + dr["Country"].ToString().Replace(" ", " ") + ", </span></a></li>";
* states1 += "<a href=\"" + temp + "\"><span class=\"tdNoSleeps\" style=\"font-weight:normal;font-style:normal\">" + dr["Country"].ToString().Replace(" ", " ") + "</span></a>, ";
* regionCountry = dr["Region"].ToString();
* }
* states1 = "";
* foreach (DataRow dr in MainDataSet.Tables["StateProvinces"].Rows)
* {
* string temp = "/" + country.ToLower().Replace(" ", "_") + "/" + dr["StateProvince"].ToString().ToLower().Replace(" ", "_") + "/default.aspx";
* states1 += "<a href=\"" + temp + "\"><span class=\"tdNoSleeps\" style=\"font-weight:normal;font-style:normal\">" + dr["StateProvince"].ToString().Replace(" ", " ") + "</span></a>, ";
* }
*
* states1 = "";
* string str_states = "";
*
* int ind = 0;
* // string cls = " class='borderright' ";
* string cls = "border-right:1px solid #0094ff;";
* string li = "";
* foreach (DataRow dr in MainDataSet.Tables["StateProvinces"].Rows)
* {
* DataFunctions objcate = new DataFunctions();
* DataTable dt1 = new DataTable();
* dt = obj.PropertiesByCase(vList, Convert.ToInt32(dr["id"]), "State");
*
* //li =" style='"+ ((ind > 4) ? "border-top:0px;" : "")+ (((ind++ % 5) == 4) ? cls : "")+"'";
*
* string temp = "/" + country.ToLower().Replace(" ", "_") + "/" + dr["StateProvince"].ToString().ToLower().Replace(" ", "_") + "/default.aspx";
* states1 += "<li"+li +"><a href='" + temp + "' class='StateTitle'>" + dr["StateProvince"].ToString().Replace(" ", " ") + "</a><br/> ";
* states1 += "<a href=\"" + temp + "\"><div class='drop-shadow effect4'><img width='160' height='125' src='/images/" + Convert.ToString(dt.Rows[0]["PhotoImage"]) + "' alt='" + Convert.ToString(dr["StateProvince"]) +" ' title='" + Convert.ToString(dr["StateProvince"]) + "' /></div></a></li>";
* //states1 += "<a href=\"" + temp + "\"><div class='drop-shadow effect4'><img width='160' height='125' src='/images/" + Convert.ToString(dt.Rows[0]["PhotoImage"]) + "' alt='" + Convert.ToString(dr["StateProvince"]) + " vacation rentals and boutique hotels in "+country+"' title='" + Convert.ToString(dr["StateProvince"]) + " vacation rentals and boutique hotels in " + country + "' /></div></a></li>";
* // states1 += "<a href=\"" + temp + "\"><div class='drop-shadow effect4'><img width='160' height='125' src='/images/" + Convert.ToString(dt.Rows[0]["PhotoImage"]) + "' alt='" + Convert.ToString(dr["propnum"]) + " properties in " + Convert.ToString(dr["StateProvince"]) + "' title='" + Convert.ToString(dr["propnum"]) + " properties in " + Convert.ToString(dr["StateProvince"]) + "' /></div></a></li>";
* //states1 += "<a href=\"" + temp + "\"><div class='drop-shadow effect4'><img width='160' height='125' src='/images/" + Convert.ToString(dt.Rows[0]["PhotoImage"]) + "' alt='" + Convert.ToString(dr["propnum"]) + " properties in " + Convert.ToString(dr["StateProvince"]) + "' title='" + Convert.ToString(dr["propnum"]) + " properties in " + Convert.ToString(dr["StateProvince"]) + "' /></div></a></li>";
* str_states += Convert.ToString(dr["StateProvince"]) + ", ";
* str_keyword += Convert.ToString(dr["StateProvince"]) + " " + country + ", ";
* }
* //rtLow3.Text = rtLow3.Text.Remove(rtLow3.Text.Length - 1, 1);
* rtHd3.InnerHtml = regionCountry + " Countries: ";
*
*
*
*
*
* Statesul.InnerHtml = states1;
* //Page.Header.Controls.Add(new LiteralControl("<link href='http://vacations-abroad.com/css/StyleSheetBig4.css' rel='stylesheet' type='text/css'></script>"));
*
*
*
* //For the meta tag
* str_meta = "(%number%) %country% vacation rentals and boutique hotels in %states% etc.";
* str_meta = str_meta.Replace("%country%", country).Replace("%states%", str_states).Replace("%number%", Convert.ToString(num_properties));
* str_keyword = str_keyword + "etc.";
*/
//For meta tag
int num_states = ds_allinfo.Tables[1].Rows.Count;
string str_states = "";
for (int ind_state = 0; ind_state < num_states; ind_state++)
{
string comma = (ind_state == (num_states - 1)) ? "" : ", ";
DataRow row = ds_allinfo.Tables[1].Rows[ind_state];
str_states += (row["StateProvince"].ToString() + comma);
str_keyword += String.Format("{0} {1}{2}", row["StateProvince"].ToString(), country, comma);
}
string num_properties = ds_allinfo.Tables[3].Rows[0][0].ToString();
if (num_states == 0)
{
Response.Redirect("/default.aspx");
}
// str_meta = String.Format("({0}) {1} vacation rentals and boutique hotels in {2} etc.", num_properties, country, str_states);
str_meta = String.Format("Explore {0} while staying in our vacation rentals and boutique hotels.", country);
str_keyword = str_keyword + " etc.";
//For google map
List <SqlParameter> sparam = new List <SqlParameter>();
sparam.Add(new SqlParameter("@countryid", countryid));
ds_citylocations = BookDBProvider.getDataSet("uspGetCityLocationListbyCountry", sparam);
markers = CommonProvider.getMarkersJsonString(ds_citylocations);
sparam.Clear();
sparam.Add(new SqlParameter("@country", country));
ds_airports = BookDBProvider.getDataSet("usp_list_airports_bycountry", sparam);
airports_markers = CommonProvider.getMarkersJsonString(ds_airports, "airport");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!int.TryParse(Request["CountryID"].ToString(), out countryid))
{
countryid = 0;
}
if (countryid == 0)
{
return;
}
List <SqlParameter> sparam = new List <SqlParameter>();
sparam.Add(new SqlParameter("@countryid", countryid));
ds_citylocations = BookDBProvider.getDataSet("uspGetCityLocationListbyCountry", sparam);
markers = CommonProvider.getMarkersJsonString(ds_citylocations);
/*
* ClientScriptManager cs = Page.ClientScript;
* string url = Request.Url.AbsoluteUri;
* string[] token = url.Split('/');
*
* //cs.RegisterStartupScript(Page.GetType(), "JSON", "alert(" + token.Length + ");", true);
* if (Convert.ToInt32(Request.QueryString["StateProvinceID"]) != null && Convert.ToInt32(Request.QueryString["StateProvinceID"]) > 0)
* {
* SqlConnection con = CommonFunctions.GetConnection();
* CitiesAdapter = new SqlDataAdapter(STR_SELECTCitiesFROMCitiesWHERECitiesStateProvinceID, con);//CommonFunctions.PrepareAdapter(CommonFunctions.GetConnection(), String.Format(STR_SELECTCitiesFROMCitiesWHERECitiesStateProvinceID), SqlDbType.Int);
* CitiesAdapter.SelectCommand.Parameters.Add("@StateId", SqlDbType.Int);
* CitiesAdapter.SelectCommand.Parameters["@StateId"].Value = Convert.ToInt32(Request.QueryString["StateProvinceID"]);
*
*
* //cs.RegisterStartupScript(Page.GetType(), "JSON", "alert(" + Convert.ToInt32(Request.QueryString["StateProvinceID"]) + ");", true);
*
* DataTable dt = new DataTable();
* CitiesAdapter.Fill(dt);
* List<Location> eList = new List<Location>();
* string maxLat = "";
* string maxLong = "";
* foreach (DataRow dr in dt.Rows)
* {
* try
* {
* Location e1 = new Location();
* e1.title = dr["City"].ToString();
* e1.lat = Convert.ToDouble(dr["Latitude"]);
* e1.lng = Convert.ToDouble(dr["Longitude"]); ;
* e1.description = dr["City"].ToString();
* string temp = "/" + dr["Country"].ToString().ToLower().Replace(" ", "_") +
* "/" + dr["StateProvince"].ToString().ToLower().Replace(" ", "_") + "/" + dr["City"].ToString().ToLower().Replace(" ", "_") + "/default.aspx";
* e1.URL = temp;
* eList.Add(e1);
* }
* catch { }
* }
* // Response.Write(CitiesAdapter.SelectCommand.CommandText);
* string ans = JsonConvert.SerializeObject(eList, Formatting.Indented);
*
*
*
* // ClientScriptManager cs = Page.ClientScript;
* cs.RegisterStartupScript(Page.GetType(), "JSON", "initialize(" + ans + ");", true);
* }
* else
* if (token.Length == 4)
* {
* SqlConnection con = CommonFunctions.GetConnection();
* CitiesAdapter = new SqlDataAdapter(STR_SELECTCitiesFROMCitiesWHERECitiesCountryId, con);//CommonFunctions.PrepareAdapter(CommonFunctions.GetConnection(), String.Format(STR_SELECTCitiesFROMCitiesWHERECitiesStateProvinceID), SqlDbType.Int);
* CitiesAdapter.SelectCommand.Parameters.Add("@CountryID", SqlDbType.Int);
* CitiesAdapter.SelectCommand.Parameters["@CountryID"].Value = Convert.ToInt32(Request.QueryString["CountryID"]);
*
* DataTable dt = new DataTable();
* CitiesAdapter.Fill(dt);
* List<Location> eList = new List<Location>();
* string maxLat = "";
* string maxLong = "";
* foreach (DataRow dr in dt.Rows)
* {
* try
* {
* Location e1 = new Location();
* e1.title = dr["City"].ToString();
* e1.lat = Convert.ToDouble(dr["Latitude"]);
* e1.lng = Convert.ToDouble(dr["Longitude"]); ;
* e1.description = dr["City"].ToString();
* string temp = "/" + dr["Country"].ToString().ToLower().Replace(" ", "_") +
* "/" + dr["StateProvince"].ToString().ToLower().Replace(" ", "_") + "/" + dr["City"].ToString().ToLower().Replace(" ", "_") + "/default.aspx";
* e1.URL = temp;
* eList.Add(e1);
* }
* catch { }
* }
* // Response.Write(CitiesAdapter.SelectCommand.CommandText);
* string ans = JsonConvert.SerializeObject(eList, Formatting.Indented);
*
*
*
*
* cs.RegisterStartupScript(Page.GetType(), "JSON", "initialize(" + ans + ");", true);
* }
*/
}
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>"));
*/
}
