void GetPropertyDetails() { try { Property1.MLSDataWebServiceSoapClient mlsClient = new Property1.MLSDataWebServiceSoapClient(); DataTable dt = new DataTable(); if (Session["PropertySearchType"].ToString().Contains("Residential")) { dt = mlsClient.GetResidentialProperties(Convert.ToString(Request.QueryString["MLSID"]), "0", "0", "0", "0", "0", "0"); } else if (Session["PropertySearchType"].ToString().Contains("Commercial")) { dt = mlsClient.GetAllCommercialProperties(Request.QueryString["MLSID"].ToString(), "0", "0", "0", "0", "0"); } else if (Session["PropertySearchType"].ToString().Contains("Condo")) { dt = mlsClient.GetProperties_Condo(Convert.ToString(Request.QueryString["MLSID"]), "0", "0", "0", "0", "0", "0"); } lblListBrokerage.Text = "Listing Contracted with: " + Convert.ToString(dt.Rows[0]["ListBrokerage"]); if ((Convert.ToString(dt.Rows[0]["PImage"])) == "images/no-image.gif") { imgge.Visible = false; img.Visible = true; } imgge.ImageUrl = Convert.ToString(dt.Rows[0]["PImage"]); lblPrice.Text = "$" + CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["ListPrice"])); lblListPrice.Text = "$" + CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["ListPrice"])); try { lblStyle.Text = Convert.ToString(dt.Rows[0]["TypeOwn1Out"]) + " " + Convert.ToString(dt.Rows[0]["Style"]); } catch { lblStyle.Text = Convert.ToString(dt.Rows[0]["TypeOwn1Out"]) + " " + Convert.ToString(dt.Rows[0]["Category"]); } lblMLS.Text = Convert.ToString(dt.Rows[0]["MLS"]); string PostalCode = Convert.ToString(dt.Rows[0]["PostalCode"]); PostalCode = PostalCode.Insert(3, " "); Session["Address"] = (CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["address"])) + ", " + CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Municipality"])) + " , " + CheckNullOrEmptyvalue(PostalCode)); lblAddressBar1.Text = (CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["address"])) + ", " + CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Municipality"])) + ", " + CheckNullOrEmptyvalue(PostalCode) + " , " + CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["province"]))); lblPropertyDescription.Text = Convert.ToString(dt.Rows[0]["remarksforclients"]); string extras; if (dt.Rows[0]["extras"].ToString().Length > 5) { extras = "<b style='float:left; width:80px;'>Extras :</b>" + "<div style='margin:0 0 0 96px;'>" + Convert.ToString(dt.Rows[0]["extras"]) + "</div>"; } else { extras = ""; } lblCommunity.Text = Convert.ToString(dt.Rows[0]["Community"]); lblprovince.Text = CheckNullOrEmptyvalue(dt.Rows[0]["Municipality"].ToString()); try { lblStorey.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Style"])); } catch { lblStorey.Text = ""; } lblSubTypeofhome.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["typeown1out"])); string frontONNsew = ""; try { frontONNsew = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["FrontingOnNSEW"])); } catch { } if (frontONNsew.ToString() == "E") { lblfronting.Text = "<b>Fronting On: </b>" + "East"; } else if (frontONNsew.ToString() == "W") { lblfronting.Text = "<b>Fronting On: </b>" + "West"; } else if (frontONNsew.ToString() == "N") { lblfronting.Text = "<b>Fronting On: </b>" + "North"; } else if (frontONNsew.ToString() == "S") { lblfronting.Text = "<b>Fronting On: </b>" + "South"; } try { lbltype.Text = Convert.ToString(dt.Rows[0]["TypeOwn1Out"]) + " " + Convert.ToString(dt.Rows[0]["Style"]); } catch { lbltype.Text = Convert.ToString(dt.Rows[0]["TypeOwn1Out"]); } lblgarage.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["GarageType"])); try { lblbasement122.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Basement1"])); lblroom.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Rooms"])); lblbed.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Bedrooms"])); lblBedroom.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Bedrooms"])); lblbath.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Washrooms"])); lblWashRooms.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Washrooms"])); lblDirCrossSt.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["DirectionsCrossStreets"])); lblAreaLabel.Text = "Area"; // lblAreaLabel.Text = CheckNullOrEmptyvalue(dt.Rows[0]["areacode"].ToString()); lblAreaValue.Text = CheckNullOrEmptyvalue(dt.Rows[0]["area"].ToString()); lblKitchen.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Kitchens"])) + "+" + CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["KitchensPlus"])); lblfamilyrm.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["FamilyRoom"])); lblExterior.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Exterior1"])); } catch { lblbasement122.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Basement1"])); lblAreaLabel.Text = "Office Area"; lblAreaValue.Text = CheckNullOrEmptyvalue(dt.Rows[0]["OfficeAptarea"].ToString()) + " " + CheckNullOrEmptyvalue(dt.Rows[0]["officeaptareacode"].ToString()); lblBedLabel.Text = "Total Area"; lblbed.Text = CheckNullOrEmptyvalue(dt.Rows[0]["totalarea"].ToString()) + " " + CheckNullOrEmptyvalue(dt.Rows[0]["totalareacode"].ToString()); lblBathLabel.Text = "Water"; lblbath.Text = CheckNullOrEmptyvalue(dt.Rows[0]["Water"].ToString()); } lblMLS1.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["MLS"])); lbltx.Text = dt.Rows[0]["TotalTaxes"].ToString(); lblBasement.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Basement1"])); lblGarageType.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["GarageType"])); lblParking.Text = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["ParkingSpaces"])); Adress adrs = new Adress(); adrs.Address = lblAddressBar1.Text; adrs.GeoCode(); string lat = adrs.Latitude; string lng = adrs.Longitude; StringBuilder sb = new StringBuilder(); DataSet ds = GetWalkingScore1(lblAddressBar1.Text, lat, lng); if (ds.Tables.Count > 0) { imgg.ImageUrl = ds.Tables[0].Rows[0]["logo_url"].ToString(); lblwalk.Text = ds.Tables[0].Rows[0]["walkscore"].ToString(); lblwalk.PostBackUrl = "http://www.walkscore.com/score/loc/lat=" + lat + "/lng=" + lng + "/?utm_source=http://roccobuyandsell.com&utm_medium=ws_api&utm_campaign=ws_api"; //lblwalk.PostBackUrl = "https://www.walkscore.com/score/loc/lat=" + lat + "/lng=" + lng + "/?utm_source=surjitpabley.only4agents.com%20%28Canadian%20Real%20Estate%20Association%29&utm_medium=ws_api&utm_campaign=ws_api"; //lblwalk.PostBackUrl = "http://www.walkscore.com/score/loc/lat=" + lat + "/lng=" + lng + " /?utm_source=http://surjitpabley.only4agents.com&utm_medium=ws_api&utm_campaign=ws_api"; //sb.Append(""); //sb.Append("<div>"); //sb.Append("<div>"); //sb.Append("<div id='walkscore-div-1'><p><a href='https://www.walkscore.com/' target='_blank'>"); //sb.Append("<img src='" + ds.Tables[0].Rows[0]["logo_url"].ToString() + "'><span class='walkscore-scoretext'>" + ds.Tables[0].Rows[0]["walkscore"].ToString() + "</span></a><span id='ws_info'>"); //sb.Append("<a target='_blank' href='https://www.redfin.com/how-walk-score-works'></a></span></p></div>"); //sb.Append("</div>"); //sb.Append("</div>"); } Response.Write(sb); int NoOfRoom = Convert.ToInt32("0" + lblroom.Text); DataTable dtRooms = new DataTable(); dtRooms.Columns.Add("Room", typeof(string)); dtRooms.Columns.Add("Level", typeof(string)); dtRooms.Columns.Add("RoomDim", typeof(string)); dtRooms.Columns.Add("RoomDesc", typeof(string)); for (int i = 0; i < NoOfRoom; i++) { int RowIndex = i + 1; string vRoom = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Room" + RowIndex + ""])); string vLevel = CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Level" + RowIndex + ""])) != "" ? Convert.ToString(dt.Rows[0]["Level" + RowIndex + ""]) : "0"; string vRoomDim = (CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Room" + RowIndex + "Length"])) != "" ? (Convert.ToString(dt.Rows[0]["Room" + RowIndex + "Length"])) : "0") + CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Room" + RowIndex + "Width"]) != "" ? ("x" + Convert.ToString(dt.Rows[0]["Room" + RowIndex + "Width"])) : "");// Convert.ToString(dt.Rows[0]["Room1Length"]) + "x" + Convert.ToString(dt.Rows[0]["Room1Width"]); string vRoomDesc = (CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Room" + RowIndex + "Desc1"])) != "" ? (Convert.ToString(dt.Rows[0]["Room" + RowIndex + "Desc1"])) : "----") + CheckNullOrEmptyvalue(Convert.ToString(dt.Rows[0]["Room" + RowIndex + "Desc2"]) != "" ? ("," + Convert.ToString(dt.Rows[0]["Room" + RowIndex + "Desc2"])) : ""); DataRow dr = dtRooms.NewRow(); dr["Room"] = vRoom; dr["Level"] = vLevel; dr["RoomDim"] = vRoomDim; dr["RoomDesc"] = vRoomDesc; dtRooms.Rows.Add(dr); LVroom.DataSource = dtRooms; LVroom.DataBind(); } } catch (Exception ex) { } }
//public string GetText(string txtDescription) //{ // if (txtDescription.Length > 200) // { // int i = txtDescription.IndexOf(" ", 185); // if (i > 0) // txtDescription = txtDescription.Substring(0, i).Trim(); // else // return txtDescription; // } // else // { // return txtDescription; // } // return txtDescription; //} //public string GetAddress(string address) //{ // DataTable dt = new DataTable(); // dt = (DataTable)ViewState["dts"]; // if (dt.Rows.Count > 0) // { // address = ((Convert.ToString(dt.Rows[0]["address"]) != "" && Convert.ToString(dt.Rows[0]["address"]) != "null" ? Convert.ToString(dt.Rows[0]["address"]) : "") + (Convert.ToString(dt.Rows[0]["Municipality"]) != "" && Convert.ToString(dt.Rows[0]["Municipality"]) != "null" ? "," + Convert.ToString(dt.Rows[0]["Municipality"]) : "") + (Convert.ToString(dt.Rows[0]["PostalCode"]) != "" && Convert.ToString(dt.Rows[0]["PostalCode"]) != "null" ? (", " + Convert.ToString(dt.Rows[0]["PostalCode"])) : "") + (Convert.ToString(dt.Rows[0]["province"]) != "null" && Convert.ToString(dt.Rows[0]["province"]) != "" ? (", " + Convert.ToString(dt.Rows[0]["province"])) : "")); // } // return address; //} public void SearchResidentialProperties() { try { //Session["QueryString112 "] = "Residential"; Property1.MLSDataWebServiceSoapClient mlsClient = new Property1.MLSDataWebServiceSoapClient(); DataTable dt = new DataTable(); //if (Convert.ToString(Session["QueryString112"]) == "Residential" || Convert.ToString(Session["QueryString"]) == "IDXImagesResidential") dt = mlsClient.GetResidentialPropertiesTop3("0", "0", "0", "0", "0", "0", "0"); //else // dt = mlsClient.GetResidentialPropertiesTop3(Session["SearchText"].ToString(), Session["HomeType"].ToString(), Session["MinPrice"].ToString(), Session["MaxPrice"].ToString(), Session["Beds"].ToString(), Session["Baths"].ToString(), Session["SaleLease"].ToString()); if (dt.Rows.Count > 0) { // imgresi.ImageUrl = dt.Rows[2]["pImage"].ToString(); DataTable dts = new DataTable("MyTab"); dts.Columns.Add("MLS", typeof(System.String)); dts.Columns.Add("address", typeof(System.String)); dts.Columns.Add("RemarksForClients", typeof(System.String)); dts.Columns.Add("ListPrice", typeof(System.String)); dts.Columns.Add("style", typeof(System.String)); dts.Columns.Add("Municipality", typeof(System.String)); dts.Columns.Add("PostalCode", typeof(System.String)); dts.Columns.Add("Province", typeof(System.String)); dts.Columns.Add("TypeOwn1Out", typeof(System.String)); dts.Columns.Add("bimage", typeof(System.String)); int i = 1; foreach (DataRow drow in dt.Rows) { DataRow d = dts.NewRow(); d["mls"] = drow["mls"]; d["address"] = drow["address"]; d["remarksForClients"] = drow["remarksforclients"]; d["listprice"] = drow["listprice"]; d["typeown1out"] = drow["typeown1out"]; d["style"] = drow["style"]; d["bImage"] = "images/Banner" + i + ".png"; d["Municipality"] = drow["Municipality"]; d["PostalCode"] = drow["postalcode"]; d["Province"] = drow["province"]; dts.Rows.Add(d); i += 1; } dts.AcceptChanges(); ViewState["dts"] = dts; //repeater1.DataSource = dts; //repeater1.DataBind(); } else { //resultSearch.Visible = true; //pagesLink.Visible = false; //resultSearch.Text = "Property is not available "; } } catch (Exception ex) { } finally { } }