public int UpdateFurnitureID(string req_room_str, string req_roomid)
{
List <SqlParameter> param = new List <SqlParameter>();
string[] req_room_furnitures = req_room_str.Split(new char[] { ',' });
foreach (string req_room_furnitureid in req_room_furnitures)
{
int index = 0;
foreach (RoomInfoFurniture tmp_fur in room_furniture_list)
{
if (tmp_fur.RoomID == req_roomid && tmp_fur.FurnitureItemID == req_room_furnitureid)
{
room_furniture_list.RemoveAt(index);
break;
}
index++;
}
if (index == room_furniture_list.Count)//New furniture
{
if (req_room_furnitureid != "")
{
param.Clear();
param.Add(new SqlParameter("@roomid", req_roomid));
param.Add(new SqlParameter("@furid", req_room_furnitureid));
CommonProvider.getScalarValueFromDB("uspUpdatePropertyFurnitureID", param); //if return value = -1 error
}
}
}
return(0);
}
public int createNewCity(int stateid, string newcity)
{
int res = -1;
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@stateid", stateid));
param.Add(new SqlParameter("@city", newcity));
res = CommonProvider.getScalarValueFromDB("uspAddCity", param);
return(res);
}
public int createNewPropertyType(int catetype, string newtype)
{
int res = -1;
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@catid", catetype));
param.Add(new SqlParameter("@type", newtype));
res = CommonProvider.getScalarValueFromDB("uspAddPropertyType", param);
return(res);
}
public int UpdateAmenityInfo()
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@propid", propid));
List <AmenityInfo> amenity_list = MainHelper.getListFromDB <AmenityInfo>("uspGetPropertyAmenity", param);
List <string> amenity_arr = new List <string>();
foreach (AmenityInfo amenity in amenity_list)
{
amenity_arr.Add(amenity.AmenityID.ToString());
}
char[] spliter = { ',' };
if (Request["propamenity"] != null && Request["propamenity"].ToString() != "")
{
string[] amenityval = Request["propamenity"].ToString().Split(spliter);
//Check updated amenity id
foreach (string req_amenity in amenityval)
{
if (!amenity_arr.Contains(req_amenity)) //New amenity id
{
param.Clear();
param.Add(new SqlParameter("@propid", propid));
param.Add(new SqlParameter("@amenityid", req_amenity));
CommonProvider.getScalarValueFromDB("uspUpdatePropertyAmenityID", param); //if return value = -1 error
}
else //Existed amenity
{
amenity_arr.Remove(req_amenity);
}
}
}
//For removed amenity id
foreach (string removed_amenity in amenity_arr)
{
param.Clear();
param.Add(new SqlParameter("@propid", propid));
param.Add(new SqlParameter("@amenityid", removed_amenity));
param.Add(new SqlParameter("@method", 1));
CommonProvider.getScalarValueFromDB("uspUpdatePropertyAmenityID", param); //if return value = -1 error
}
return(0);
}
public int createNewProperty()
{
int newid = CommonProvider.getScalarValueFromDB("uspGetPropertyMaxID", new List <SqlParameter>()) + 1;
if (newid == 0)
{
return(-1);
}
try
{
List <SqlParameter> param = getParamListBasicInfo(newid);
if (param == null || CommonProvider.getScalarValueFromDB("uspAddPropertyBasic", param) == -1)
{
return(-1);
}
} catch (Exception ex) {
throw ex;
return(-1);
}
return(newid);
}
public int UpdateLocalAttraction()
{
List <_AttractionInfo> list_attractionobjects = new List <_AttractionInfo>();
List <string> list_cur_attracts = new List <string>();
List <SqlParameter> param = new List <SqlParameter>();
param.Clear();
param.Add(new SqlParameter("@propid", propid));
DataSet ds_attraction = BookDBProvider.getDataSet("uspGetPropertyAttractionByID", param);
if (ds_attraction.Tables.Count > 0)
{
foreach (DataRow row in ds_attraction.Tables[0].Rows)
{
_AttractionInfo tmp = new _AttractionInfo();
tmp.attrid = row["AttractionID"].ToString();
tmp.distanceid = row["DistanceID"].ToString();
list_attractionobjects.Add(tmp);
list_cur_attracts.Add(tmp.attrid);
}
}
ds_allattraction = BookDBProvider.getDataSet("uspGetAllAttraction", new List <SqlParameter>());
List <string> list_attraction = new List <string>();
foreach (DataRow row in ds_allattraction.Tables[0].Rows)
{
list_attraction.Add(row["ID"].ToString());
}
if (Request["attractids"] != null && Request["attractids"].ToString() != "")
{
string[] req_attractionids = Request["attractids"].ToString().Split(new char[] { ',' });
string[] req_attractnear = Request["attract_near"].ToString().Split(new char[] { ',' });
foreach (string req_attractid in req_attractionids)
{
int index = list_attraction.IndexOf(req_attractid);
if (index >= req_attractnear.Length)
{
return(-1);
}
string attract_distanceid = req_attractnear[index];
if (list_cur_attracts.Contains(req_attractid)) //Current attract
{
foreach (_AttractionInfo tmp in list_attractionobjects)
{
if (tmp.attrid == req_attractid && tmp.distanceid != attract_distanceid) //Modified
{
param.Clear();
param.Add(new SqlParameter("@propid", propid));
param.Add(new SqlParameter("@attrid", req_attractid));
param.Add(new SqlParameter("@distanceid", attract_distanceid));
param.Add(new SqlParameter("@method", 2));
CommonProvider.getScalarValueFromDB("uspUpdatePropertyAttractionByID", param); //if return value = -1 error
break;
}
}
list_cur_attracts.Remove(req_attractid);
}
else //New attract
{
param.Clear();
param.Add(new SqlParameter("@propid", propid));
param.Add(new SqlParameter("@attrid", req_attractid));
param.Add(new SqlParameter("@distanceid", attract_distanceid));
param.Add(new SqlParameter("@method", 0));
CommonProvider.getScalarValueFromDB("uspUpdatePropertyAttractionByID", param); //if return value = -1 error
}
}
}
foreach (string removed_attract in list_cur_attracts)
{
param.Clear();
param.Add(new SqlParameter("@propid", propid));
param.Add(new SqlParameter("@attrid", removed_attract));
param.Add(new SqlParameter("@method", 1));
CommonProvider.getScalarValueFromDB("uspUpdatePropertyAttractionByID", param); //if return value = -1 error
}
return(0);
}
public int UpdateRoomInfo()
{ //Get Current room info
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@propid", propid));
DataSet ds_roomfurniture = BookDBProvider.getDataSet("uspGetRoomFurnitures", param);
roomid_list.Clear();
room_furniture_list.Clear();
if (ds_roomfurniture.Tables.Count > 0)
{
foreach (DataRow row in ds_roomfurniture.Tables[0].Rows)
{
if (!roomid_list.Contains(row["RoomID"].ToString())) //if existed roomid
{
roomid_list.Add(row["RoomID"].ToString());
}
RoomInfoFurniture tmp = new RoomInfoFurniture();
tmp.RoomID = row["RoomID"].ToString();
tmp.FurnitureItemID = row["FurnitureItemID"].ToString();
if (!room_furniture_list.Contains(tmp))
{
room_furniture_list.Add(tmp);
}
}
}
//For requested room infos
char[] spliter = { ',' };
if (Request["_roomids"] != null && Request["_roomids"].ToString() != "")
{
string[] req_roomid_list = Request["_roomids"].ToString().Split(spliter);
string[] req_roomnames = Request["_roomnames"].ToString().Split(new char[] { ',' });
int index = 0;
foreach (string req_roomid in req_roomid_list)
{
string req_roomname = req_roomnames[index++];
if (roomid_list.Contains(req_roomid))//For existed room , furniture changes
{
//Update RoomTitle
param.Clear();
param.Add(new SqlParameter("@id", req_roomid));
param.Add(new SqlParameter("@title", req_roomname));
param.Add(new SqlParameter("@method", 2)); //update method
CommonProvider.getScalarValueFromDB("uspUpdateRoomInfo", param); //if return value = -1 error
UpdateFurnitureID(Request["room" + req_roomid].ToString(), req_roomid);
roomid_list.Remove(req_roomid);
}
else // New Room Info
{
param.Clear();
param.Add(new SqlParameter("@title", req_roomname));
param.Add(new SqlParameter("@propid", propid));
param.Add(new SqlParameter("@method", 0)); //add method
string newroomid = CommonProvider.getScalarValueFromDB("uspUpdateRoomInfo", param).ToString(); //if return value = -1 error
UpdateFurnitureID(Request["room" + req_roomid].ToString(), newroomid);
}
}
}
//For removed room info and furniture changes;
foreach (string removed_roomid in roomid_list)
{
param.Clear();
param.Add(new SqlParameter("@id", removed_roomid));
param.Add(new SqlParameter("@method", 1)); //delete method
string newroomid = CommonProvider.getScalarValueFromDB("uspUpdateRoomInfo", param).ToString();
}
foreach (RoomInfoFurniture removed_furniture in room_furniture_list)//Removed furniture changes;
{
if (removed_furniture.FurnitureItemID != null && removed_furniture.FurnitureItemID != "")
{
param.Clear();
param.Add(new SqlParameter("@roomid", removed_furniture.RoomID));
param.Add(new SqlParameter("@furid", removed_furniture.FurnitureItemID));
param.Add(new SqlParameter("@method", 1));
CommonProvider.getScalarValueFromDB("uspUpdatePropertyFurnitureID", param); //if return value = -1 error
}
}
return(0);
}
public int UpdatePropertyInfo(int step)
{
if (step == 0)
{
try
{
List <SqlParameter> param = getParamListBasicInfo(propid);
if (param == null || CommonProvider.getScalarValueFromDB("uspUpdatePropertyBasic", param) == -1)
{
return(-1);
}
}
catch (Exception ex)
{
throw ex;
return(-1);
}
}
else if (step == 1) //Amenities
{
try
{
List <SqlParameter> param = getParamListDescriptionInfo(propid);
if (param == null || CommonProvider.getScalarValueFromDB("uspUpdatePropertyDescriptionAmenity", param) == -1)
{
return(-1);
}
if (UpdateAmenityInfo() == -1)
{
return(-1);
}
if (!hotel_type.Contains(propinfo.CategoryID)) //If the rental type
{
if (UpdateRoomInfo() == -1)
{
}
}
}
catch (Exception ex)
{
throw ex;
return(-1);
}
}
else if (step == 2)
{
try
{
List <SqlParameter> param = getParamListLocalAttraction(propid);
CommonProvider.getScalarValueFromDB("uspUpdatePropertyAttraction", param);
if (UpdateLocalAttraction() == -1)
{
return(-1);
}
}
catch (Exception ex)
{
throw ex;
}
}
else if (step == 3)
{
try
{
List <SqlParameter> param = getParamRates(propid);
CommonProvider.getScalarValueFromDB("uspUpdatePropertyRates", param);
}
catch (Exception ex)
{
throw ex;
}
}
return(0);
}
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>"));
*/
}
