public static AjaxPropListSet getAjaxAllPropListSetWithCityID(int cityid, int proptype, int amenitytype, int roomnum, int sorttype)
{
AjaxPropListSet prop_set = new AjaxPropListSet();
//prop_set.allnums = getNumbersOfCityID(cityid, proptype, amenitytype, roomnum);
List <PropertyAmenityInfo> propertyList = new List <PropertyAmenityInfo>();
List <PropertyDetailInfo> prop_detail = new List <PropertyDetailInfo>();
// 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("uspGetAllPropertiesWithCityID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@cityid", SqlDbType.Int).Value = cityid;
cmd.Parameters.Add("@proptype", SqlDbType.Int).Value = proptype;
cmd.Parameters.Add("@roomnum", SqlDbType.Int).Value = roomnum;
cmd.Parameters.Add("@amenityid", SqlDbType.Int).Value = amenitytype;
cmd.Parameters.Add("@ratesort", SqlDbType.Int).Value = sorttype;
// @pagenum int =0,
//@ratesort int= 0
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
PropertyDetailInfo tmp = new PropertyDetailInfo();
PropertyInfo[] props = tmp.GetType().GetProperties();
foreach (PropertyInfo prop_info in props)
{
prop_info.SetValue(tmp, Convert.ChangeType(reader[prop_info.Name], prop_info.PropertyType), null);
}
prop_detail.Add(tmp);
}
con.Close();
}
}
catch (Exception ex)
{
}
foreach (PropertyDetailInfo propinfo in prop_detail)
{
PropertyAmenityInfo propamenity = new PropertyAmenityInfo();
propamenity.detail = propinfo;
try
{
using (SqlConnection con = new SqlConnection(connString))
{
con.Open();
SqlCommand cmd = new SqlCommand("uspGetAmenity", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@propid", SqlDbType.Int).Value = propinfo.ID;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
AmenityInfo tmp = new AmenityInfo();
tmp.ID = Convert.ToInt32(reader["ID"]);
tmp.Amenity = reader["Amenity"].ToString();
propamenity.amenity.Add(tmp);
}
con.Close();
}
}
catch (Exception ex)
{
}
propertyList.Add(propamenity);
}
prop_set.propertyList = propertyList;
prop_set.allnums = propertyList.Count;
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"));
}
// 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);
}
