void GetImages()
{
Property1.MLSDataWebServiceSoapClient mlsClient = new Property1.MLSDataWebServiceSoapClient();
DataTable dt = mlsClient.GetImageByMLSID(Convert.ToString(Request.QueryString["MLSID"]));
if (dt.Rows.Count > 0)
{
img1.ImageUrl = Convert.ToString(dt.Rows[0]["MLSImage"]);
img2.ImageUrl = Convert.ToString(dt.Rows[0]["MLSImage"]);
Image1.ImageUrl = Convert.ToString(dt.Rows[1]["MLSImage"]);
Image2.ImageUrl = Convert.ToString(dt.Rows[2]["MLSImage"]);
Image3.ImageUrl = Convert.ToString(dt.Rows[3]["MLSImage"]);
Image4.ImageUrl = Convert.ToString(dt.Rows[4]["MLSImage"]);
Image5.ImageUrl = Convert.ToString(dt.Rows[5]["MLSImage"]);
}
else
{
}
mlsClient = null;
}
void GetImages()
{
Property1.MLSDataWebServiceSoapClient mlsClient = new Property1.MLSDataWebServiceSoapClient();
DataTable dt = mlsClient.GetImageByMLSID(Convert.ToString(Request.QueryString["MLSID"]));
if (dt.Rows.Count > 0)
{
img1.ImageUrl = Convert.ToString(dt.Rows[0]["MLSImage"]);
Image1.ImageUrl = Convert.ToString(dt.Rows[1]["MLSImage"]);
Image2.ImageUrl = Convert.ToString(dt.Rows[2]["MLSImage"]);
Image3.ImageUrl = Convert.ToString(dt.Rows[3]["MLSImage"]);
//rptImages.DataSource = dt;
//rptImages.DataBind();
//sliderDiv.Visible = true;
//sliderImageEmpty.Visible = false;
}
else
{
//sliderDiv.Visible = false;
//sliderImageEmpty.Visible = true;
}
mlsClient = null;
}
public string GetPropertyDetails()
{
Session["QueryString"] = Request.QueryString["PropertyType"];
StringBuilder html = new StringBuilder();
DataTable dt = new DataTable();
DataTable dtimages = new DataTable();
Property1.MLSDataWebServiceSoapClient mlsClient = new Property1.MLSDataWebServiceSoapClient();
Property1.MLSDataWebServiceSoapClient mlsClientimages = new Property1.MLSDataWebServiceSoapClient();
if (Convert.ToString(Session["QueryString"]) == "IDXImagesResidential" || Convert.ToString(Session["QueryString"]) == "VoxResidential")
{
dt = mlsClient.GetResidentialProperties(Convert.ToString(Request.QueryString["MLSID"]), "0", "0", "0", "0", "0", "0");
}
else if (Convert.ToString(Session["QueryString"]) == "IDXImagesCommercial" || Convert.ToString(Session["QueryString"]) == "VoxCommercial")
{
dt = mlsClient.GetAllCommercialProperties(Request.QueryString["MLSID"].ToString(), "0", "0", "0", "0", "0");
}
else if (Convert.ToString(Session["QueryString"]) == "IDXImagesCondo" || Convert.ToString(Session["QueryString"]) == "VoxCondo")
{
dt = mlsClient.GetProperties_Condo(Convert.ToString(Request.QueryString["MLSID"]), "0", "0", "0", "0", "0", "0");
}
if (Convert.ToString(Session["QueryString"]) == "IDXImagesResidential")
{
dtimages = mlsClientimages.GetImageByMLSID(Convert.ToString(Request.QueryString["MLSID"]));
}
else if (Convert.ToString(Session["QueryString"]) == "IDXImagesCommercial" || Convert.ToString(Session["QueryString"]) == "VoxCommercial")
{
dtimages = mlsClientimages.GetCommercialPropertiesByMLSID(Convert.ToString(Request.QueryString["MLSID"]));
}
else if (Convert.ToString(Session["QueryString"]) == "IDXImagesCondo")
{
dtimages = mlsClientimages.GetPropertiesByMLSID_Condo(Convert.ToString(Request.QueryString["MLSID"]));
}
if (dt.Rows.Count > 0)
{
html.AppendLine("<div id='divEmail' style='width:100%; float:left;'>");
html.AppendLine("<h2 style='font-weight:bold; font-size:16px;'>Pavan Sharma for Property ID " + dt.Rows[0]["MLS"].ToString() + ";</h2>");
html.AppendLine("<h2 style='font-weight: bold; font-size: 16px;'>Message Received From:</h2>");
html.AppendLine("<p style='float: left; margin: 0 40px 0 0;'>Phone Number:</p><span style='float:left;'>519-500-5729</span><br/>");
html.AppendLine("<h2 style='font-weight: bold; font-size: 16px;'>Message:</h2>");
html.AppendLine("<p>Please take a look at Property ID# " + dt.Rows[0]["MLS"].ToString() + " located at " + dt.Rows[0]["Address"].ToString() + "</p>");
html.AppendLine("<h2 style='font-weight:bold; font-size:16px;'>Referring Page:</h2>");
html.AppendLine("<p>http://pavansharma.ca///</p>");
html.AppendLine("<h2 style='font-weight:bold; font-size:16px;'>Property Information:</h2>");
html.AppendLine("<div style='float:left; width:30%;'>");
html.AppendLine("<h2 style='font-weight:bold; font-size:13px; margin:0px;'>" + dt.Rows[0]["ListPrice"].ToString() + "<br />");
//html.AppendLine("366 Hespeler Road, Unit 13 B, Cambridge, Ontario, N1R 6J6<br/>Property ID: " + dt.Rows[0]["MLS"].ToString() + "</h2>");
html.AppendLine("</div>");
html.AppendLine("<div style='float:left;'>");
html.AppendLine("<p style='float:left; margin:0 12px 0 0; font-weight:bold;'>Beds:</p><span style='float:left; margin:0 30px 0 0;'>" + dt.Rows[0]["BedRooms"].ToString() + "</span>");
html.AppendLine("<p style='float:left; margin:0 12px 0 0; font-weight:bold;'>Bath:</p><span style='float:left;'>" + dt.Rows[0]["WashRooms"].ToString() + "</span><br/>");
//html.AppendLine("<p style='float:left; margin:0 12px 0 0; font-weight:bold;'>Square Feet:</p><span style='float:left;'>" + dt.Rows[0]["Maintenance"].ToString() + "</span><br/>");
//html.AppendLine("<p style='float:left; margin:0 12px 0 0; font-weight:bold;'>Year Built:</p><span style='float:left;'>" + dt.Rows[0]["Maintenance"].ToString() + "</span><br/>");
html.AppendLine("<p style='float:left; margin:0 12px 0 0; font-weight:bold;'>Style:</p><span style='float:left;'>" + dt.Rows[0]["PType"].ToString() + "</span><br/>");
html.AppendLine("</div>");
html.AppendLine("<p style='float:left; width:100%;'>For more information on this property, <a href='#'>click HERE.</a></p>");
html.AppendLine("<div style='float:left; width:100%;'>");
html.AppendLine("<div style='float:left; margin:0 0 0 250px; border-right:1px solid grey; padding-right:7px; width:400px;'>");
html.AppendLine("<div style='float:left; margin:0 56px 0 0;'>");
html.AppendLine("<p style='margin:0px;'>16 Bretton Circle<br/>" + dt.Rows[0]["Address"].ToString() + "</p></div>");
html.AppendLine("<div style='float:left;'>");
html.AppendLine("<p style='margin:0px;'>" + dt.Rows[0]["ListPrice"].ToString() + "</p>");
html.AppendLine("<p style='float:left; margin:0 40px 0 0; font-size:12px;'>Property ID:</p><span style='float:left; font-size:12px;'>" + dt.Rows[0]["MLS"].ToString() + "</span><br/></div>");
html.AppendLine("<p style='float:left; width:100%;'>ELEGANT EXECUTIVE GREENPARK HOME IN PRESTIGIOUS ROUGE FAIRWAYS</p>");
html.AppendLine("" + dt.Rows[0]["RemarksForClients"].ToString() + "");
html.AppendLine("<p>For more information visit <a href='#'>http://pavansharma.ca///</a> </p></div>");
html.AppendLine("<div style='float:left; padding-left:12px;'>");
html.AppendLine("<p style='margin:0px;'>Listed By</p><br/><p>Pavan Sharma<br/>Sales Representative</p>");
//html.AppendLine(" <h2 style='font-size:16px;'>Leading Edge Realty Inc.</h2>");
//html.AppendLine("<p style='margin:0px;'>2250 BOVAIRD DRIVE EAST UNIT # 502 BRAMPTON ON L6R 0W3 </p>");
html.AppendLine("<p style='float:left; margin:0 40px 0 0; font-weight:bold;'>Cell::</p><span style='float:left;'>519-500-5729</span><br/>'");
//html.AppendLine("<p style='float:left; margin:0 40px 0 0; font-weight:bold;'>Office:</p><span style='float:left;'>905-497-2300</span><br/>");
//html.AppendLine("<p style='float:left; margin:0 40px 0 0; font-weight:bold;'>Office Fax:</p><span style='float:left;'>905-497-0400</span><br/>'");
html.AppendLine("<p style='float:left; margin:0 40px 0 0; font-weight:bold;'>E-mail:</p><span style='float:left;'>[email protected]</span><br/>");
html.AppendLine("<p style='float:left; margin:0 40px 0 0; font-weight:bold;'>Website:</p><span style='float:left;'>http://pavansharma.ca///</span><br/></div></div>");
html.AppendLine("<div style='float:left; width:100%;'>");
html.AppendLine("<div style='float:left; margin:0 0 0 250px; border-right:1px solid grey; padding-right:7px; width:400px; border-top:1px solid grey;>");
html.AppendLine("<h2 style='font-size:16px;'>Property Details</h2>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>ID:</p><span style='float:left;'>" + dt.Rows[0]["MLS"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Style:</p><span style='float:left;'>" + dt.Rows[0]["PType"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Beds:</p><span style='float:left;'>" + dt.Rows[0]["BedRooms"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Baths:</p><span style='float:left;'>" + dt.Rows[0]["WashRooms"].ToString() + " (Full: 2 3/4: 1 1/2: 1 Other: 0)</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Washrooms:</p><span style='float:left;'>" + dt.Rows[0]["WashRooms"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Status:</p><span style='float:left;'>Active</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Total Rooms:</p><span style='float:left;'>" + dt.Rows[0]["Rooms"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Storeys:</p><span style='float:left;>" + dt.Rows[0]["TypeOwn1Out"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Fireplaces:</p><span style='float:left;>1</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>New Construction:</p><span style='float:left;>No</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Financial Considerations Estimated Annual Taxes:</p><span style='float:left;>$5,663</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Locale County:</p><span style='float:left;>York</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>High School:</p><span style='float:left;>Markham District Highschool</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Elementary School:</p><span style='float:left;>Boxwood Public School</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Neighbourhood:</p><span style='float:left;>Rouge Fairways Community</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>School District:</p><span style='float:left;>York Region</span></div>");
html.AppendLine("<h2 style='font-size:16px;'>Property Details</h2>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Bedroom 5</p><span style='float:left;'>" + dt.Rows[0]["Room5Length"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Kitchen </p><span style='float:left;'>" + dt.Rows[0]["Room3Length"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Living / Dining Room </p><span style='float:left;'>" + dt.Rows[0]["Room1Length"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Den / Office</p><span style='float:left;'>" + dt.Rows[0]["Room5Length"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Dining Room</p><span style='float:left;'>" + dt.Rows[0]["Room2Length"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Family Room</p><span style='float:left;'>" + dt.Rows[0]["Room5Length"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Kitchen</p><span style='float:left;'>" + dt.Rows[0]["Room5Length"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Living Room</p><span style='float:left;'>" + dt.Rows[0]["Room5Length"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Bathroom 2</p><span style='float:left;'>" + dt.Rows[0]["Room5Length"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Bathroom 3</p><span style='float:left;'>" + dt.Rows[0]["Room5Length"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Bathroom 4</p><span style='float:left;'>" + dt.Rows[0]["Room5Length"].ToString() + "</span></div>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Master Bedroom</p><span style='float:left;'>" + dt.Rows[0]["Room5Length"].ToString() + "</span></div> </div>");
html.AppendLine("<div style='float:left; padding-left:12px; width:500px; border-top:1px solid grey;'>");
html.AppendLine("<h2 style='font-size:16px;'>Features</h2>");
html.AppendLine("<p style='float:left; width:100%; margin:0px;'>Air Conditioning</p>");
html.AppendLine("<p style='float:left; width:100%;' margin:0px;>Central Air</p>");
html.AppendLine("<p style='float:left; width:100%; margin:0px;'>Basement</p>");
html.AppendLine("<div style='float:left; width:100%;'><p style='float:left; margin:0 80px 0 0; width:20%;'>Full</p><span style='float:left;'>Finished</span></div>");
html.AppendLine("<p style='float:left; width:100%; margin:0px;'>Shingle - Newer Roof 2009 (40 Year Shingles)Other - Wrap Around</p>");
html.AppendLine("<p style='float:left; width:100%; margin:0px;'>Brick</p>");
html.AppendLine("<p style='float:left; width:100%; margin:0px;'>Family Room</p>");
html.AppendLine("<p style='float:left; width:100%; margin:0px;'>Y - Main Floor Family Room With</p>");
html.AppendLine("<p style='float:left; width:100%; margin:0px;'>Fireplace</p>");
html.AppendLine("<p style='float:left; width:100%; margin:0px;'>Garage Type</p>");
html.AppendLine("<p style='float:left; width:100%; margin:0px;'>Attached</p>");
html.AppendLine(" <p style='float:left; width:100%; margin:0px;'>Laundry Access</p>");
html.AppendLine("<p style='float:left; width:100%; margin:0px;'>In Area - Main Floor Laundry</p>");
html.AppendLine("<p style='float:left; width:100%; margin:0px;'>Parking/Drive</p>");
html.AppendLine("<p style='float:left; width:100%; margin:0px;'>Private - Parking For 4 Cars on </p>");
html.AppendLine(" <p style='float:left; width:100%; margin:0px;'>Driveway</p> </div> </div> </div>");
}
//literal.Text = html.ToString();
return(html.ToString());
}
void GetImages()
{
Property1.MLSDataWebServiceSoapClient mlsClient = new Property1.MLSDataWebServiceSoapClient();
DataTable dt = mlsClient.GetImageByMLSID(Convert.ToString(Request.QueryString["MLSID"]));
if (dt.Rows.Count > 0)
{
string var = Convert.ToString(dt.Rows[0]["MLSImage"]);
if (var != "")
{
img1.ImageUrl = Convert.ToString(dt.Rows[0]["MLSImage"]);
img2.ImageUrl = Convert.ToString(dt.Rows[0]["MLSImage"]);
}
else
{
img1.ImageUrl = "images\no-image.gif";
img2.ImageUrl = "images\no-image.gif";
}
string var1 = Convert.ToString(dt.Rows[1]["MLSImage"]);
if (var1 != "")
{
Image1.ImageUrl = Convert.ToString(dt.Rows[1]["MLSImage"]);
}
else
{
Image1.ImageUrl = "images\no-image.gif";
}
string var2 = Convert.ToString(dt.Rows[2]["MLSImage"]);
if (var2 != "")
{
Image2.ImageUrl = Convert.ToString(dt.Rows[2]["MLSImage"]);
}
else
{
Image2.ImageUrl = "images\no-image.gif";
}
string var3 = Convert.ToString(dt.Rows[3]["MLSImage"]);
if (var3 != "")
{
Image3.ImageUrl = Convert.ToString(dt.Rows[3]["MLSImage"]);
}
else
{
Image3.ImageUrl = "images\no-image.gif";
}
string var4 = Convert.ToString(dt.Rows[4]["MLSImage"]);
if (var4 != "")
{
Image4.ImageUrl = Convert.ToString(dt.Rows[4]["MLSImage"]);
}
else
{
Image4.ImageUrl = "images\no-image.gif";
}
string var5 = Convert.ToString(dt.Rows[5]["MLSImage"]);
if (var5 != "")
{
Image5.ImageUrl = Convert.ToString(dt.Rows[5]["MLSImage"]);
}
else
{
Image5.ImageUrl = "images\no-image.gif";
}
}
else
{
}
mlsClient = null;
}
