protected void Page_Load(object sender, System.EventArgs e) { prop_category = BookDBProvider.getDataSet("uspGetPropertyCategory", new List <SqlParameter>()); all_amenities = BookDBProvider.getDataSet("uspGetAllAmenity", new List <SqlParameter>()); allfurnitures = BookDBProvider.getDataSet("uspGetAllFurniture", new List <SqlParameter>()); json_allfurnitures = CommonProvider.getJsonStringFromDs(allfurnitures); allattractions = BookDBProvider.getDataSet("uspGetAllAttraction", new List <SqlParameter>()); //For new property if (propertyid == -1) { } else if (propertyid > 0) { //For the existed property propinfo = AjaxProvider.getPropertyDetailInfo(propertyid); List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@propid", propertyid)); prop_amenities = BookDBProvider.getDataSet("uspGetPropertyAmenity", param); json_amenity = CommonProvider.getJsonStringFromDs(prop_amenities); json_propinfo = new JavaScriptSerializer().Serialize(propinfo); param.Clear(); param.Add(new SqlParameter("@propid", propertyid)); json_roomfurnitures = CommonProvider.getJsonStringFromDs(BookDBProvider.getDataSet("uspGetRoomFurnitures", param)); param.Clear(); param.Add(new SqlParameter("@propid", propertyid)); json_attractions = CommonProvider.getJsonStringFromDs(BookDBProvider.getDataSet("uspGetPropertyAttractionByID", param)); } }
protected void newcoupon_Click(object sender, EventArgs e) { string coupon = Request["n_coupon"], start_date = Request["n_start"], end_date = Request["n_end"]; int discount; if (!Int32.TryParse(Request["n_discount"].ToString(), out discount)) { discount = 0; } if (coupon == "" || start_date == "" || end_date == "") { return; } List <SqlParameter> param = new List <SqlParameter>(); SqlParameter p_coupon = new SqlParameter("@coupon", coupon); SqlParameter p_sd = new SqlParameter("@start", start_date); SqlParameter p_ed = new SqlParameter("@end", end_date); SqlParameter p_dis = new SqlParameter("@discount", discount); param.Add(p_coupon); param.Add(p_sd); param.Add(p_ed); param.Add(p_dis); BookDBProvider.getDataSet("uspAddCouponItem", param); ds_coupons = BookDBProvider.getDataSet("uspGetCouponItemList", new List <SqlParameter>()); }
protected void StateRename_Click(object sender, System.EventArgs e) { if (StateName.Text.Length < 1) { return; } foreach (DataRow datarow in StateProvincesSet.Tables["StateProvinces"].Rows) { if (datarow.RowState != DataRowState.Deleted) { if ((int)datarow["ID"] == Convert.ToInt32(StateList.SelectedValue)) { datarow["StateProvince"] = StateName.Text; break; } } } //lock (CommonFunctions.Connection) StateProvincesAdapter.Update(StateProvincesSet); Finish(); List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@country", CountryList.Text)); param.Add(new SqlParameter("@state", StateName.Text)); param.Add(new SqlParameter("@city", CityList.Text)); param.Add(new SqlParameter("@ocount", CountryList.Text)); param.Add(new SqlParameter("@ostate", StateList.Text)); param.Add(new SqlParameter("@ocity", CityList.Text)); BookDBProvider.getDataSet("uspUpdateLatLong", param); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ds_coupons = BookDBProvider.getDataSet("uspGetCouponItemList", new List <SqlParameter>()); } ds_use_coupons = BookDBProvider.getDataSet("uspGetPaymentCouponList", new List <SqlParameter>()); }
protected void Page_Load(object sender, EventArgs e) { if (!AuthenticationManager.IfAuthenticated) { FormsAuthentication.SignOut(); } // Response.Write("Uid" + userid); userinfo = BookDBProvider.getDetailedUserInfo(userid); property_set = BookDBProvider.getPropertySet(userid); if (property_set.Tables[0].Rows.Count == 0 && userinfo.Zip == "") { Response.Redirect("/ownerinformation.aspx?userid=" + userinfo.ID); } List <SqlParameter> param = new List <SqlParameter>(); SqlParameter puserid = new SqlParameter("@userid", SqlDbType.Int); puserid.Value = userid; param.Add(puserid); owner_ds = BookDBProvider.getDataSet("uspGetOwnerResponseList", param); //For Traveller /* param.Clear(); * SqlParameter pemail = new SqlParameter("@email", SqlDbType.NVarChar, 500); * pemail.Value = userinfo.Email; * param.Add(pemail); * * traveler_ds = BookDBProvider.getDataSet("uspGetTravelerResponseList", param); * */ if (owner_ds.Tables[0].Rows.Count != 0) { cssclass_tabs[1] = "active"; } else { cssclass_tabs[0] = "hidden"; if (property_set.Tables[0].Rows.Count == 0) { cssclass_tabs[1] = "hidden"; cssclass_tabs[2] = "active"; } else { cssclass_tabs[1] = "active"; } } //Displaying the tabs }
protected void Page_Load(object sender, EventArgs e) { bool vaild_session = true; string session; session = Request.QueryString["session"]; List <SqlParameter> sparams = new List <SqlParameter>(); sparams.Add(new SqlParameter("@session", session)); DataSet ds_session = BookDBProvider.getDataSet("uspGetEmailQuoteSession", sparams); //Get quote id from the url Int32.TryParse(Request.QueryString["quoteid"], out quoteid); if (ds_session.Tables.Count == 0 || ds_session.Tables[0].Rows.Count == 0) //Wrong request { vaild_session = false; } else { int qid = int.Parse(ds_session.Tables[0].Rows[0]["emailquoteid"].ToString()); if (qid != quoteid) //Wrong request { vaild_session = false; } } if (vaild_session == false) { if (!AuthenticationManager.IfAuthenticated || !User.Identity.IsAuthenticated) { FormsAuthentication.SignOut(); } } inquiryinfo = BookDBProvider.getQuoteInfo(quoteid); if (inquiryinfo.IfReplied == 1) { Response.Redirect("/Error.aspx?error=You've already responded."); } if (inquiryinfo.PropertyID == 0) { Response.Redirect("/Error.aspx?error=Wrong Inquiry number"); } if ((inquiryinfo.PropertyOwnerID != userid) && !AuthenticationManager.IfAdmin && vaild_session == false) { Response.Redirect("/Error.aspx?error=You try to see the other info"); } countryinfo = BookDBProvider.getCountryInfo(inquiryinfo.PropertyID); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { // Response.Write(userid); float hlat, hlng; string haddr, hcity; int hcityid, hpropid, hstateid; if (!float.TryParse(Request["hlat"], out hlat)) { hlat = 0; } if (!float.TryParse(Request["hlng"], out hlng)) { hlng = 0; } haddr = Request["haddr"]; hcity = Request["hcity"]; if (!int.TryParse(Request["hcityid"], out hcityid)) { hcityid = 0; } if (!int.TryParse(Request["hstateid"], out hstateid)) { hstateid = 0; } if (!int.TryParse(Request["hpropid"], out hpropid)) { hpropid = 0; } if (hcityid == 0) { List <SqlParameter> sparam = new List <SqlParameter>(); sparam.Add(new SqlParameter("@stateid", hstateid)); sparam.Add(new SqlParameter("@city", hcity)); DataSet ds = BookDBProvider.getDataSet("uspAddCity", sparam); hcityid = int.Parse(ds.Tables[0].Rows[0][0].ToString()); } List <SqlParameter> tparam = new List <SqlParameter>(); tparam.Add(new SqlParameter("@propid", hpropid)); tparam.Add(new SqlParameter("@lat", hlat)); tparam.Add(new SqlParameter("@lng", hlng)); tparam.Add(new SqlParameter("@cityid", hcityid)); tparam.Add(new SqlParameter("@addr", haddr)); BookDBProvider.getDataSet("uspAddPropLatLong", tparam); } // int userid = int.Parse(Request["userid"]); List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@userid", userid)); ds_proplocation = BookDBProvider.getDataSet("uspGetPropertyLocationsByUserID", param); }
protected void Page_Load(object sender, EventArgs e) { uid = Request["uid"]; string pwd = Request["upwd"]; if (uid == "") { Response.Redirect("/default.aspx"); } if (pwd == "") { errormsg = "You've not input password"; return; } if (IsPostBack) { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@link", uid)); DataSet ds = BookDBProvider.getDataSet("uspGetPwdReset", param); if (ds.Tables[0].Rows.Count == 0) { errormsg = "You've gotten wrong link."; return; } email = ds.Tables[0].Rows[0]["Email"].ToString(); byte[] salt = AuthenticationManager.GenerateSalt(); int repeats = AuthenticationManager.GenerateRepeats(); byte[] pwdhash = AuthenticationManager.HashPassword(pwd, salt, repeats); param.Clear(); param.Add(new SqlParameter("@email", email)); param.Add(new SqlParameter("@salt", salt)); param.Add(new SqlParameter("@repeat", repeats)); param.Add(new SqlParameter("@hash", pwdhash)); param.Add(new SqlParameter("@link", uid)); BookDBProvider.getDataSet("uspUpdateUserPwd", param); string msg_format = @"Notification from Vacations-abroad.com <br/> You've reset the password of the account at vacations-abroad.com <br/> If this is not your activity, please contact administrator of vacation-abroad.com , '*****@*****.**'! <br/> Vacations-Abroad.com "; BookDBProvider.SendEmail(email, "Password changed : Vacations-abroad.com", msg_format); triger_redirect = 1; } }
protected void CityRename_Click(object sender, System.EventArgs e) { if (CityName.Text.Length < 1) { return; } LatLongInfo latinfo = MainHelper.getCityLocation(CityName.Text, StateList.SelectedItem.Text, CountryList.SelectedItem.Text); if (latinfo.status == 0) //Fail to get location info { error_msg = String.Format("Fail to get {0} location.", NewCity.Text); } else if (latinfo.status == 1) //Fail to verify the address { error_msg = String.Format("Fail to verify the location of {0}.", NewCity.Text); } else //Success to get the latitude and longitude { try { //Update foreach (DataRow datarow in CitiesSet.Tables["Cities"].Rows) { if (datarow.RowState != DataRowState.Deleted) { if ((int)datarow["ID"] == Convert.ToInt32(CityList.SelectedValue)) { datarow["City"] = CityName.Text; break; } } } //lock (CommonFunctions.Connection) CitiesAdapter.Update(CitiesSet); List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@stateid", StateList.SelectedValue)); param.Add(new SqlParameter("@city", CityName.Text)); param.Add(new SqlParameter("@lat", latinfo.latitude)); param.Add(new SqlParameter("@lng", latinfo.longitude)); BookDBProvider.getDataSet("uspAddLatLong", param); Finish(); } catch { error_msg = "Something is wrong."; } } }
protected void btnSubmit_Click(object sender, EventArgs e) { string strCountryText = txtCountryText.Text.Replace(Environment.NewLine, "<br />"); List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@countryid", countryid));//[uspUpdateCountryText] param.Add(new SqlParameter("@text", strCountryText)); param.Add(new SqlParameter("@index", 0)); BookDBProvider.getDataSet("uspUpdateCountryText", param); //For country description lblCountryInfo.Text = txtCountryText.Text.Replace(Environment.NewLine, "<br />"); }
protected void DelCom_Click(object sender, EventArgs e) { int cid; if (!int.TryParse(Request["del_id"], out cid)) { cid = 0; } if (cid == 0) { return; } List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@id", cid)); ds_coupons = BookDBProvider.getDataSet("uspDelCouponItem", param); }
protected void Page_Load(object sender, EventArgs e) { DataSet ds_country = BookDBProvider.getDataSet("uspGetCityWithNoLoctionList", new List <SqlParameter>()); int count = ds_country.Tables[0].Rows.Count; for (int i = 0; i < count; i++) { // if (i > 100) return; DataRow row = ds_country.Tables[0].Rows[i]; string url = "https://maps.google.com/maps/api/geocode/json?address=" + String.Format("{0}, {1}", row["City"], row["StateProvince"]) + "&sensor=false&key=AIzaSyCLLZW2LVHAYTl-iwt4nm21EHWBjOZtA-M"; // Response.Write(url); // if (i > 10) break; WebRequest request = WebRequest.Create(url); using (WebResponse response = request.GetResponse()) { using (var reader = new StreamReader(response.GetResponseStream(), Encoding.UTF8)) { string resp = reader.ReadToEnd(); JObject jobj = JObject.Parse(resp); Response.Write(resp); if (jobj["status"].ToString() == "OK") { string latitude = jobj["results"][0]["geometry"]["location"]["lat"].ToString(); string longtitude = jobj["results"][0]["geometry"]["location"]["lng"].ToString(); List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@country", row["Country"])); param.Add(new SqlParameter("@state", row["StateProvince"])); param.Add(new SqlParameter("@city", row["City"])); param.Add(new SqlParameter("@lat", latitude)); param.Add(new SqlParameter("@lng", longtitude)); BookDBProvider.getDataSet("uspAddLatLong", param); } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { } else { email = Request["uemail"]; List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@email", email)); DataSet ds = BookDBProvider.getDataSet("uspGetUserInfo", param); if (ds.Tables[0].Rows.Count == 0) { errormsg = "You didn't input correct registered email!"; return; } else { List <SqlParameter> newparam = new List <SqlParameter>(); newparam.Add(new SqlParameter("@email", email)); string uid = generateID(); newparam.Add(new SqlParameter("@link", uid)); BookDBProvider.getDataSet("uspAddPwdReset", newparam); //Sending email to reset password string msg_format = @"Notification from Vacations-abroad.com <br/> To Reset Password of vacations-abroad account,please click <a href='{0}'>{0}</a> <br /> If this is not your activity, please contact administrator of vacation-abroad.com , '*****@*****.**'! <br/> Vacations-Abroad.com "; BookDBProvider.SendEmail(email, "Password Reset:Vacations-Abroad.com", String.Format(msg_format, String.Format("https://www.vacations-abroad.com/accounts/pwdreset.aspx?uid={0}", uid))); triger_redirect = 1; return; } } }
protected void payment_Click(object sender, EventArgs e) { string coupon = Request["coupon"]; if (coupon.Length == 13) { string start_date, end_date; int discount, id; List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@coupon", coupon)); DataSet ds_coupon = BookDBProvider.getDataSet("uspGetCouponItem", param); if (ds_coupon.Tables[0].Rows.Count > 0) { start_date = ds_coupon.Tables[0].Rows[0]["Start_date"].ToString(); end_date = ds_coupon.Tables[0].Rows[0]["End_date"].ToString(); if (!int.TryParse(ds_coupon.Tables[0].Rows[0]["Discount"].ToString(), out discount)) { discount = 0; } id = int.Parse(ds_coupon.Tables[0].Rows[0]["CID"].ToString()); DateTime s_date = DateTime.Parse(start_date); DateTime e_date = DateTime.Parse(end_date); DateTime now = DateTime.Now; if (DateTime.Compare(s_date, now) <= 0 && DateTime.Compare(now, e_date) <= 0) { _total = _total_sum * (100 - discount) / 100 + _balance; custom = coupon; } } } PaywithPaypal(); }
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) { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@country", "England")); DataSet airports = BookDBProvider.getDataSet("usp_list_allairports_bycountry", param); //For the english .... if (airports.Tables.Count > 0) { int rows = airports.Tables[0].Rows.Count; for (int i = 0; i < rows; i++) { DataRow row = airports.Tables[0].Rows[i]; string lat = row["latitude"].ToString(); string lan = row["longitude"].ToString(); //string requestUri = string.Format("http ://maps.googleapis.com/maps/api/geocode/json?address={0}&sensor=false", key=AIzaSyD5PJ9egY0xvdrEKU_MFSDqKKxTCT4vwJM&); string requestUri = string.Format("https://maps.googleapis.com/maps/api/geocode/json?latlng={0},{1}&key=AIzaSyD5PJ9egY0xvdrEKU_MFSDqKKxTCT4vwJM&sensor=false", lat, lan); WebRequest request = WebRequest.Create(requestUri); WebResponse response = request.GetResponse(); string result = ""; using (StreamReader reader = new StreamReader(response.GetResponseStream())) { result = reader.ReadToEnd(); //Response.Write(result); JObject json_result = JObject.Parse(result); JArray addr_results = (JArray)json_result["results"]; string country, state, city, addr; foreach (JObject address_obj in addr_results) { country = ""; state = ""; city = ""; addr = ""; JArray address_comp = (JArray)address_obj["address_components"]; foreach (JObject obj in address_comp) { JArray types = (JArray)obj["types"]; if (types.Count > 0) { if (types[0].ToString() == "administrative_area_level_1") { country = obj["long_name"].ToString(); } else if (types[0].ToString() == "administrative_area_level_2") { state = obj["long_name"].ToString(); } else if (types[0].ToString() == "locality") { city = obj["long_name"].ToString(); } } } addr = address_obj["formatted_address"].ToString(); Response.Write(String.Format("id:{3}==>{0}, {1}, {2} <br>", country, state, city, row["id"])); //usp_update_airport_withcityid param.Clear(); param.Add(new SqlParameter("@id", row["id"])); param.Add(new SqlParameter("@country", country)); param.Add(new SqlParameter("@state", state)); param.Add(new SqlParameter("@city", city)); BookDBProvider.getDataSet("usp_update_airport_withcityid", param); break; } } } } }
protected void CityAdd_Click(object sender, System.EventArgs e) { EnterCity.Validate(); InvalidCity.Validate(); if (!EnterCity.IsValid || !InvalidCity.IsValid) { return; } LatLongInfo latinfo = MainHelper.getCityLocation(NewCity.Text, StateList.SelectedItem.Text, CountryList.SelectedItem.Text); if (latinfo.status == 0) //Fail to get location info { error_msg = String.Format("Fail to get {0} location.", NewCity.Text); } else if (latinfo.status == 1) //Fail to verify the address { error_msg = String.Format("Fail to verify the location of {0}.", NewCity.Text); } else //Success to get the latitude and longitude { DataRow newrow = CitiesSet.Tables["Cities"].NewRow(); newrow["City"] = NewCity.Text; try { newrow["StateProvinceID"] = Convert.ToInt32(StateList.SelectedValue); CitiesSet.Tables["Cities"].Rows.Add(newrow); //lock (CommonFunctions.Connection) CitiesAdapter.Update(CitiesSet); List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@stateid", StateList.SelectedValue)); param.Add(new SqlParameter("@city", NewCity.Text)); param.Add(new SqlParameter("@lat", latinfo.latitude)); param.Add(new SqlParameter("@lng", latinfo.longitude)); BookDBProvider.getDataSet("uspAddLatLong", param); Finish(); } catch (Exception ex) { throw ex; } } /* * * * List<SqlParameter> param = new List<SqlParameter>(); * param.Add(new SqlParameter("@country", country)); * param.Add(new SqlParameter("@state", state)); * param.Add(new SqlParameter("@city", city)); * param.Add(new SqlParameter("@lat", latitude)); * param.Add(new SqlParameter("@lng", longtitude)); * BookDBProvider.getDataSet("uspAddLatLong", param); * */ }
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); }
protected void Page_Load(object sender, EventArgs e) { if (HttpContext.Current.Request.HttpMethod != "POST") { Response.Write("Wrong request"); return; } context = HttpContext.Current; parseTransaction(); PaymentHelper.addPaymentLog(transitem); email_resp = BookResponseEmail.getResponseInfo(transitem.item_number); //respid // if (email_resp.ID == 0 || email_resp.IsValid < 1) Response.Redirect("/Error.aspx?error=Wrong Response number or not valid"); inquiryinfo = BookDBProvider.getQuoteInfo(email_resp.QuoteID); owner_info = BookDBProvider.getDetailedUserInfo(inquiryinfo.PropertyOwnerID); // traveler_info = BookDBProvider.getUserInfo(inquiryinfo.UserID); prop_info = AjaxProvider.getPropertyDetailInfo(inquiryinfo.PropertyID); ServicePointManager.Expect100Continue = true; ServicePointManager.SecurityProtocol = (SecurityProtocolType)3072; // string requestUriString = "https://www.sandbox.paypal.com/cgi-bin/webscr"; string requestUriString = "https://www.paypal.com/cgi-bin/webscr"; HttpWebRequest request = (HttpWebRequest)WebRequest.Create(requestUriString); string strFormValues = Encoding.ASCII.GetString( context.Request.BinaryRead(context.Request.ContentLength)); // Set values for the request back request.Method = "POST"; request.ContentType = "application/x-www-form-urlencoded"; string obj2 = strFormValues + "&cmd=_notify-validate"; request.ContentLength = obj2.Length; /* * System.IO.StreamWriter file = new System.IO.StreamWriter(Server.MapPath("/logwrite.txt")); * file.Write(obj2); * file.Close(); */ // Write the request back IPN strings StreamWriter writer = new StreamWriter(request.GetRequestStream(), Encoding.ASCII); writer.Write(RuntimeHelpers.GetObjectValue(obj2)); writer.Close(); //send the request, read the response HttpWebResponse response = (HttpWebResponse)request.GetResponse(); Stream responseStream = response.GetResponseStream(); Encoding encoding = Encoding.GetEncoding("utf-8"); StreamReader reader = new StreamReader(responseStream, encoding); string resp = reader.ReadToEnd(); //_total_sum = email_resp.NightRate * inquiryinfo.Nights; _total_sum = email_resp.NightRate; _lodgingval = _total_sum * email_resp.LoadingTax / 100; _balance = _lodgingval + email_resp.CleaningFee + email_resp.SecurityDeposit; _total = _total_sum + _balance; /* * System.IO.StreamWriter sfile = new System.IO.StreamWriter(Server.MapPath("/log.txt")); * sfile.Write(resp); * sfile.Close(); */ int discount; if (transitem.custom.Length == 13) { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@coupon", transitem.custom)); DataSet ds_coupon = BookDBProvider.getDataSet("uspGetCouponItem", param); if (ds_coupon.Tables[0].Rows.Count > 0) { if (!int.TryParse(ds_coupon.Tables[0].Rows[0]["Discount"].ToString(), out discount)) { discount = 0; } _total = _total_sum * (100 - discount) / 100 + _balance; } } _total = Decimal.Parse(BookDBProvider.DoFormat(_total)); if (resp == "VERIFIED") { //if(transitem.business == ConfigurationManager.AppSettings["PaypalEmail"].ToString() && transitem.txn_type!= "reversal") /* System.IO.StreamWriter ssfile = new System.IO.StreamWriter(Server.MapPath("/logt.txt")); * ssfile.Write(resp); * ssfile.Close(); */ // if (transitem.business == "*****@*****.**" && transitem.txn_type != "reversal") if (transitem.business == ConfigurationManager.AppSettings["PaypalEmail"].ToString() && transitem.txn_type != "reversal") { if ((transitem.mc_gross == (_total)) && transitem.payment_status == "Completed" && transitem.mc_currency == currency_type[email_resp.CurrencyType]) { PaymentHelper.addPaymentHistory(transitem, inquiryinfo); BookResponseEmail.updateEmailResponseState(transitem.item_number); string format_traveler = @"This is your receipt for your reservation with Vacations-Abroad.com <br/> This email confirms that {0} has booked a reservation with {1}. <br/> Your Arrival Date is: {2} <br/> You paid: {3} {4} on {5} <br/> The owner’s cancellation policy is <br/> 90 days prior to arrival:{6}% <br/> 60 days prior to arrival:{7}% <br/> 30 days prior to arrival:{8}% <br/> Owner Contact Details <br/> Owner Name:{9} <br/> Owner Email:{10} <br/> Owner Telephone:{11} <br/> Name of Property:{1} <br/> Owner Website: {12} <br/> Please contact the owner to obtain the actual property address. <br/> If you do not cancel, the funds will be transferred to the owner on (7 days prior to your {13}) <br/> When you return, please write a review of the property and add photos. <br/>"; string msg_traveler = String.Format(format_traveler, inquiryinfo.ContactorName, prop_info.PropertyName, DateTime.Parse(inquiryinfo.ArrivalDate).ToString("MMM d, yyyy"), transitem.mc_gross, transitem.mc_currency, DateTime.Now.ToString("MMM d, yyyy"), email_resp.Cancel90, email_resp.Cancel60, email_resp.Cancel30 , String.Format("{0} {1}", owner_info.FirstName, owner_info.LastName), owner_info.Email, owner_info.MobileTelephone, owner_info.Website, DateTime.Parse(inquiryinfo.ArrivalDate).ToString("MMM d, yyyy")); string trv_subject = String.Format("Reservation Confirmation for {0}", DateTime.Now.ToString("MMM d, yyyy")); BookDBProvider.SendEmail(inquiryinfo.ContactorEmail, trv_subject, msg_traveler); string format_owner = @"This is a confirmation for the reservation completed through Vacations-Abroad.com <br/> This email confirms that {0} has booked a reservation with {1}. <br/> Arrival Date is: {2} <br/> They have paid: {3} {4} on {5} <br/> The owner’s cancellation policy is <br/> 90 days prior to arrival:{6}% <br/> 60 days prior to arrival:{7}% <br/> 30 days prior to arrival:{8}% <br/><br/> Traveler Contact Details <br/><br/> Traveler Name:{9} <br/> Traveler Email:{10} <br/> Traveler Telephone:{11} <br/><br/> Please contact the traveler to provide them with directions to your property and inform them of any check-in procedures. <br/> If the Traveler does not cancel, the funds will be transferred to your Paypal or bank account (7 days prior to your {2}) less a 10% commission fee. If any fees such as cleaning fees, security deposit or lodging taxes are to be collected by you at arrival. <br/> You have specified these additional fees are due at arrival. <br/> Cleaning:{12} {4} <br/> Security Deposit:{13} {4}<br/> Lodging Tax:{14} {4}<br/><br/> Let us know if we can be of further assistance. <br/> Linda Jenkins <br/> 770-687-6889 <br/>"; string owner_subject = String.Format("Reservation Confirmation for {0}", DateTime.Now.ToString("MMM d, yyyy")); string msg_owner = String.Format(format_owner, inquiryinfo.ContactorName, prop_info.PropertyName , DateTime.Parse(inquiryinfo.ArrivalDate).ToString("MMM d, yyyy"), transitem.mc_gross, transitem.mc_currency, DateTime.Now.ToString("MMM d, yyyy"), email_resp.Cancel90, email_resp.Cancel60, email_resp.Cancel30, inquiryinfo.ContactorName, inquiryinfo.ContactorEmail, inquiryinfo.Telephone, BookDBProvider.DoFormat(email_resp.CleaningFee), BookDBProvider.DoFormat(email_resp.SecurityDeposit), BookDBProvider.DoFormat(_lodgingval)); BookDBProvider.SendEmail(owner_info.Email, owner_subject, msg_owner); BookDBProvider.SendEmail("*****@*****.**", String.Format("{0} has paid for property {1} Transaction:{2}", inquiryinfo.ContactorName, transitem.item_number, transitem.txn_id), msg_owner); BookDBProvider.SendEmail("*****@*****.**", "Notification: Transaction:" + transitem.txn_id, msg_owner); } } } else { } }
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>")); */ }
public JsonResult processRequest() { JsonResult jsonresult = new JsonResult(); if (!AuthenticationManager.IfAuthenticated || !User.Identity.IsAuthenticated) { jsonresult.error = "Not Signed"; return(jsonresult); } else if (HttpContext.Current.Request.HttpMethod != "POST") { jsonresult.error = "The function works in POST method"; return(jsonresult); } //else{} //If the user is signed if (!Int32.TryParse(Request["propid"], out propid)) { propid = -1; } //Validate parameters from the request int wizard_step = -1; if (!Int32.TryParse(Request["wizardstep"], out wizard_step)) { wizard_step = -1; } if (wizard_step == -1) { jsonresult.error = "Wizard Step is not set."; return(jsonresult); } if (!ValdateWizardStep(wizard_step)) //Valdation for step parameters by step number { jsonresult.error = "Wizard Step is not set."; return(jsonresult); } if (wizard_step == 0 && (propid == -1 || propid == 0)) { propid = createNewProperty(); if (propid == -1) { jsonresult.error = "Server something wrong error: get new property id"; return(jsonresult); } } else //For the existed property { if (propid == -1 || propid == 0) { jsonresult.error = "Server something wrong error: step is not 0, and propid is -1"; return(jsonresult); } propinfo = AjaxProvider.getPropertyDetailInfo(propid); if (propinfo.UserID != userid && !AuthenticationManager.IfAdmin) { jsonresult.error = "You are trying to do malicious action. Property doesn't include to you."; return(jsonresult); } if (UpdatePropertyInfo(wizard_step) == -1) { jsonresult.error = "Server something wrong error: update property info step " + wizard_step; return(jsonresult); } } List <SqlParameter> param = new List <SqlParameter>(); if (propid > 0) { propinfo = AjaxProvider.getPropertyDetailInfo(propid); //Get the property id jsonresult.propinfo = propinfo; if (wizard_step == 1) { param.Add(new SqlParameter("@propid", propid)); amenity_list = MainHelper.getListFromDB <AmenityInfo>("uspGetPropertyAmenity", param); jsonresult.amenity_list = amenity_list; param.Clear(); param.Add(new SqlParameter("@propid", propid)); jsonresult.room_furniture = CommonProvider.getJsonStringFromDs(BookDBProvider.getDataSet("uspGetRoomFurnitures", param)); } else if (wizard_step == 2) { param.Clear(); param.Add(new SqlParameter("@propid", propid)); jsonresult.attractions = CommonProvider.getJsonStringFromDs(BookDBProvider.getDataSet("uspGetPropertyAttractionByID", param)); } } jsonresult.propid = propid; if (propid == propinfo.ID) { jsonresult.status = 0; } return(jsonresult); }
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); }
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 SendButton_Click(object sender, System.EventArgs e) { EmailRequired.Validate(); bool toall = false; if (!EmailRequired.IsValid) { return; } PropertiesSet.Clear(); if (SendProperty.Checked) { PropertyNumberRequired.Validate(); PropertyNumberValid.Validate(); if (!PropertyNumberRequired.IsValid || !PropertyNumberValid.IsValid) { return; } GetIDsByNumber.SelectCommand.Parameters["@PropertyID"].Value = Convert.ToInt32(PropertyNumber.Text); //lock (CommonFunctions.Connection) GetIDsByNumber.Fill(PropertiesSet); } else if (SendOwner.Checked) { OwnerUsernameRequired.Validate(); OwnerUsernameValid.Validate(); if (!OwnerUsernameRequired.IsValid || !OwnerUsernameValid.IsValid) { return; } GetIDsByUsername.SelectCommand.Parameters["@Username"].Value = OwnerUsername.Text; //lock (CommonFunctions.Connection) GetIDsByUsername.Fill(PropertiesSet); } else if (SendAll.Checked) { toall = true; List <SqlParameter> sparam = new List <SqlParameter>(); ds_owners = BookDBProvider.getDataSet("usp_get_all_owners_proved_properties", sparam); } //lock (CommonFunctions.Connection) if (toall) { if (ds_owners.Tables.Count > 0) { string emails = ""; foreach (DataRow datarow in ds_owners.Tables[0].Rows) { System.Text.RegularExpressions.Regex regex = new System.Text.RegularExpressions.Regex("^\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*$"); if ((datarow["Email"] is string) && regex.Match((string)datarow["Email"]).Success) { SmtpClient smtpclient = new SmtpClient("mail.vacations-abroad.com", 25); MailMessage message = new MailMessage("noreply@" + CommonFunctions.GetDomainName(), (string)datarow["Email"]); message.Subject = CommonFunctions.GetSiteAddress() + CommonFunctions.PrepareURL(((string)datarow["Country"]).Replace(" ", "_").ToLower() + "/" + ((string)datarow["StateProvince"]).Replace(" ", "_").ToLower() + "/" + ((string)datarow["City"]).Replace(" ", "_").ToLower() + "/" + ((int)datarow["ID"]).ToString() + "/default.aspx"); message.Body = "Dear " + (string)datarow["FirstName"] + " " + (string)datarow["LastName"] + "!\n\n" + "You received a new message from " + CommonFunctions.GetSiteName() + " administration:\n\n" + EmailBody.Text; message.IsBodyHtml = false; message.Body = message.Body.Replace("\r", "").Replace("\n", Environment.NewLine); message.Headers["Content-Type"] = "text/plain; charset = \"iso-8859-1\""; BookDBProvider.SendEmail((string)datarow["Email"], message.Subject, message.Body); } DataRow newrow = EmailsSet.Tables["Emails"].NewRow(); newrow["PropertyID"] = datarow["ID"]; newrow["DateTime"] = DateTime.Now; newrow["Email"] = EmailBody.Text; newrow["IfCustom"] = true; EmailsSet.Tables["Emails"].Rows.Add(newrow); } EmailsAdapter.Update(EmailsSet); EmailsSent.Text = ds_owners.Tables[0].Rows.Count.ToString() + " e-mails sent"; } else { EmailsSent.Text = "0 e-mails sent"; } //lock (CommonFunctions.Connection) EmailsSent.Visible = true; } else { foreach (DataRow datarow in PropertiesSet.Tables["Properties"].Rows) { System.Text.RegularExpressions.Regex regex = new System.Text.RegularExpressions.Regex("^\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*$"); if ((datarow["Email"] is string) && regex.Match((string)datarow["Email"]).Success) { SmtpClient smtpclient = new SmtpClient("mail.vacations-abroad.com", 25); MailMessage message = new MailMessage("noreply@" + CommonFunctions.GetDomainName(), (string)datarow["Email"]); message.Subject = CommonFunctions.GetSiteAddress() + CommonFunctions.PrepareURL(((string)datarow["Country"]).Replace(" ", "_").ToLower() + "/" + ((string)datarow["StateProvince"]).Replace(" ", "_").ToLower() + "/" + ((string)datarow["City"]).Replace(" ", "_").ToLower() + "/" + ((int)datarow["ID"]).ToString() + "/default.aspx"); message.Body = "Dear " + (string)datarow["FirstName"] + " " + (string)datarow["LastName"] + "!\n\n" + "You received a new message from " + CommonFunctions.GetSiteName() + " administration:\n\n" + EmailBody.Text; message.IsBodyHtml = false; message.Body = message.Body.Replace("\r", "").Replace("\n", Environment.NewLine); message.Headers["Content-Type"] = "text/plain; charset = \"iso-8859-1\""; try { smtpclient.Send(message); } catch (Exception ex) { } } DataRow newrow = EmailsSet.Tables["Emails"].NewRow(); newrow["PropertyID"] = datarow["ID"]; newrow["DateTime"] = DateTime.Now; newrow["Email"] = EmailBody.Text; newrow["IfCustom"] = true; EmailsSet.Tables["Emails"].Rows.Add(newrow); } //lock (CommonFunctions.Connection) EmailsAdapter.Update(EmailsSet); EmailsSent.Text = PropertiesSet.Tables["Properties"].Rows.Count.ToString() + " e-mails sent"; EmailsSent.Visible = true; } }
public List <SqlParameter> getParamListBasicInfo(int newid) { List <SqlParameter> param = new List <SqlParameter>(); try { if (Request["citylist"].ToString() == "0") { string newcity = Request["additionalcity"]; int stateid = int.Parse(Request["statelist"]); int newcityid = createNewCity(stateid, newcity); if (newcityid == -1) { return(null); } param.Add(new SqlParameter("@CityID", newcityid)); if (Request["statename"] != null && Request["countryname"] != null) { LatLongInfo latinfo = MainHelper.getCityLocation(newcity, Request["statename"].ToString(), Request["countryname"].ToString()); if (latinfo.status == 0) //Fail to get location info { error_msg = String.Format("Fail to get {0} location.", newcity); } else if (latinfo.status == 1) //Fail to verify the address { error_msg = String.Format("Fail to verify the location of {0}.", newcity); } else //Success to get the latitude and longitude { try { //Update List <SqlParameter> tmpparam = new List <SqlParameter>(); tmpparam.Add(new SqlParameter("@stateid", stateid)); tmpparam.Add(new SqlParameter("@city", newcity)); tmpparam.Add(new SqlParameter("@lat", latinfo.latitude)); tmpparam.Add(new SqlParameter("@lng", latinfo.longitude)); BookDBProvider.getDataSet("uspAddLatLong", tmpparam); } catch { error_msg = "Something is wrong."; } } } } else { param.Add(new SqlParameter("@CityID", Request["citylist"])); } param.Add(new SqlParameter("@ID", newid)); param.Add(new SqlParameter("@UserID", userid)); // param.Add(new SqlParameter("@UserID", 7332)); param.Add(new SqlParameter("@Name", Request["_propname"])); param.Add(new SqlParameter("@Name2", Request["_propname2"])); param.Add(new SqlParameter("@VirtualTour", Request["_virttour"])); param.Add(new SqlParameter("@Address", Request["_propaddr"])); param.Add(new SqlParameter("@IfShowAddress", Request["_propdisplay"])); param.Add(new SqlParameter("@NumBedrooms", Request["_propbedroom"])); param.Add(new SqlParameter("@NumBaths", Request["_propbathrooms"])); param.Add(new SqlParameter("@NumSleeps", Request["_propsleep"])); param.Add(new SqlParameter("@MinimumNightlyRentalID", Request["_propminrental"])); param.Add(new SqlParameter("@NumTVs", Request["_proptv"])); param.Add(new SqlParameter("@NumVCRs", 0)); param.Add(new SqlParameter("@NumCDPlayers", Request["_propcd"])); param.Add(new SqlParameter("@DateAdded", DateTime.Now)); param.Add(new SqlParameter("@DateStartViewed", DateTime.Now)); string newtype = Request["additional_type"]; int categorytype = int.Parse(Request["propcategory"]); int newtypeid = createNewPropertyType(categorytype, newtype); if (newtypeid == -1) { return(null); } param.Add(new SqlParameter("@TypeID", newtypeid)); } catch (Exception ex) { throw ex; return(null); } return(param); }