void GetFeaturedProperties()
{
try
{
DataTable dtIDs = new DataTable();
cls_Property objprp = new cls_Property();
dtIDs = objprp.GetFeturedIDsTop3();
if (dtIDs.Rows.Count > 0)
{
result = dtIDs.AsEnumerable()
.Select(row => row["MLSID"].ToString())
.Aggregate((s1, s2) => String.Concat(s1, "," + s2));
Property1.MLSDataWebServiceSoapClient mlsClient = new Property1.MLSDataWebServiceSoapClient();
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = "GetResidentialPropertiesByMlsId";
cmd.Parameters.AddWithValue("@mls", result);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.ExecuteNonQuery();
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
dlFeatured.DataSource = dt;
dlFeatured.DataBind();
Session["SearchType"] = "IDXImagesResidential";
mlsClient = null;
if (dt.Rows.Count > 0)
{
FeatureId.Visible = true;
}
//if(dtIDs.Rows.Count> 0)
//{
// ImageButton imgButton = (ImageButton)dlFeatured.FindControl("btnimg");
// imgButton.ImageUrl = ("../Featured_Properties.aspx");
//}
//else
//{
// ImageButton imgButton = (ImageButton)dlFeatured.FindControl("btnimg");
// imgButton.ImageUrl = ("../Default.aspx");
//}
}
else
{
Div1.Visible = true;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
void GetFeaturedProperties()
{
try
{
DataTable dtIDs = new DataTable();
cls_Property objprp = new cls_Property();
dtIDs = objprp.GetFeturedIDsTop3();
String result = dtIDs.AsEnumerable()
.Select(row => row["MLSID"].ToString())
.Aggregate((s1, s2) => String.Concat(s1, "," + s2));
Property1.MLSDataWebServiceSoapClient mlsClient = new Property1.MLSDataWebServiceSoapClient();
DataTable dt = mlsClient.FeatureListing(result);
dlFeatured.DataSource = dt;
dlFeatured.DataBind();
Session["SearchType"] = "IDXImagesResidential";
mlsClient = null;
if (dt.Rows.Count > 0)
{
FeatureId.Visible = true;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
}
}
