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>")); */ }