public string PropertyListI(string buyorrent, string type, string address, string neighborhood, string startArea, string startRate, string endArea, string endRate) { try { PropertyBAL oPropertyBAL = new PropertyBAL(); PropertyBO oPropertyBO = new PropertyBO(); PropertyBO oIPropertyBO = new PropertyBO(); oPropertyBO.address = address; oPropertyBO.type = type; oPropertyBO.buyorrent = buyorrent; oPropertyBO.neighborhood = neighborhood; oPropertyBO.size = long.Parse(startArea); oPropertyBO.rate = long.Parse(startRate); oIPropertyBO.size = long.Parse(endArea); oIPropertyBO.rate = long.Parse(endRate); DataTable dt = new DataTable(); dt = oPropertyBAL.FindProperty(oPropertyBO, oIPropertyBO); JSONClass objJSONClass = new JSONClass(); return objJSONClass.CreateJSONParameters(dt); } catch { throw; } }
public string PropertyList(string buyorrent, string type, string address) { try { PropertyBAL oPropertyBAL = new PropertyBAL(); PropertyBO oPropertyBO = new PropertyBO(); oPropertyBO.buyorrent = buyorrent; oPropertyBO.type = type; oPropertyBO.address = address; DataTable dt = new DataTable(); dt = oPropertyBAL.FindProperty(oPropertyBO); System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>(); Dictionary<string, object> row = null; foreach (DataRow dr in dt.Rows) { row = new Dictionary<string, object>(); foreach (DataColumn col in dt.Columns) { row.Add(col.ColumnName.Trim(), dr[col]); } rows.Add(row); } return serializer.Serialize(rows); } catch { return "Time Out"; } }
public DataTable FindProperty(PropertyBO oPropertyBO) { try { cmd = new SqlCommand("SearchProperty", con); cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Parameters.AddWithValue("@type", oPropertyBO.type); cmd.Parameters.AddWithValue("@buyorrent", oPropertyBO.buyorrent); cmd.Parameters.AddWithValue("@address", oPropertyBO.address); SqlParameter message = cmd.Parameters.Add("@message", SqlDbType.VarChar, 500); message.Direction = ParameterDirection.Output; dad = new SqlDataAdapter(cmd); dt = new DataTable(); dad.Fill(dt); return dt; } catch { throw; } finally { con.Close(); } }
public DataTable FindImagesByPropertyID(PropertyBO oPropertyBO) { try { query = "SELECT * FROM PropertyImage WHERE propertyID = @propertyID"; cmd = new SqlCommand(query, con); if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Parameters.AddWithValue("@propertyID", oPropertyBO.propertyID); dad = new SqlDataAdapter(cmd); dt = new DataTable(); dad.Fill(dt); return dt; } catch { throw; } finally { con.Close(); } }
public DataTable FindSimilarPropertyByAddress(PropertyBO oPropertyBO) { try { return oPropertyDAL.FindSimilarPropertyByAddress(oPropertyBO); } catch { throw; } }
public DataTable FindPropertyByID(PropertyBO oPropertyBO) { try { return oPropertyDAL.FindPropertyByID(oPropertyBO); } catch { throw; } }
public string PropertyList(string buyorrent, string type, string address) { try { PropertyBAL oPropertyBAL = new PropertyBAL(); PropertyBO oPropertyBO = new PropertyBO(); oPropertyBO.address = address; oPropertyBO.type = type; oPropertyBO.buyorrent = buyorrent; DataTable dt = new DataTable(); dt = oPropertyBAL.FindProperty(oPropertyBO); JSONClass objJSONClass = new JSONClass(); return objJSONClass.CreateJSONParameters(dt); } catch { throw; } }
public DataTable InsertProperty(PropertyBO oPropertyBO, PropertyImageBO oPropertyImageBO, AgentBO oAgentBO) { try { return oPropertyDAL.InsertProperty(oPropertyBO, oPropertyImageBO, oAgentBO); } catch { throw; } }
public DataTable InsertProperty(PropertyBO oPropertyBO, PropertyImageBO oPropertyImageBO, AgentBO oAgentBO) { try { cmd = new SqlCommand("InsertProperty", con); cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Parameters.AddWithValue("@pName", oPropertyBO.name); cmd.Parameters.AddWithValue("@description", oPropertyBO.description); cmd.Parameters.AddWithValue("@address", oPropertyBO.address); cmd.Parameters.AddWithValue("@city", oPropertyBO.city); cmd.Parameters.AddWithValue("@neighborhood", oPropertyBO.neighborhood); cmd.Parameters.AddWithValue("@latitude", oPropertyBO.latitude); cmd.Parameters.AddWithValue("@longitude", oPropertyBO.longitude); cmd.Parameters.AddWithValue("@zipCode", oPropertyBO.zipCode); cmd.Parameters.AddWithValue("@type", oPropertyBO.type); cmd.Parameters.AddWithValue("@buyorrent", oPropertyBO.buyorrent); cmd.Parameters.AddWithValue("@size", oPropertyBO.size); cmd.Parameters.AddWithValue("@rate", oPropertyBO.rate); cmd.Parameters.AddWithValue("@totalImages", oPropertyBO.totalImages); cmd.Parameters.AddWithValue("@parkings", oPropertyBO.parkings); cmd.Parameters.AddWithValue("@toilets", oPropertyBO.toilets); cmd.Parameters.AddWithValue("@kitchens", oPropertyBO.kitchens); cmd.Parameters.AddWithValue("@hasReception", oPropertyBO.hasReception); cmd.Parameters.AddWithValue("@isFurnished", oPropertyBO.isFurnished); cmd.Parameters.AddWithValue("@image", oPropertyImageBO.image); cmd.Parameters.AddWithValue("@name", oAgentBO.name); cmd.Parameters.AddWithValue("@business", oAgentBO.business); cmd.Parameters.AddWithValue("@email", oAgentBO.email); cmd.Parameters.AddWithValue("@phone", oAgentBO.phone); cmd.Parameters.AddWithValue("@status", oAgentBO.status); dad = new SqlDataAdapter(cmd); dt = new DataTable(); dad.Fill(dt); return dt; } catch { throw; } finally { con.Close(); } }
public DataTable FindSimilarPropertyByAddress(PropertyBO oPropertyBO) { try { query = @"SELECT TOP 2 [Property].propertyID, SUBSTRING ([Property].description, 0 , 100) + '..' AS description, [Property].address, [Property].size, [Property].rate, RTRIM(LTRIM([PropertyImage].image)) AS image FROM [dbo].[Property] LEFT JOIN [dbo].[PropertyImage] ON [Property].propertyID = [PropertyImage].propertyID AND [PropertyImage].ID IN (SELECT MIN(ID) FROM [PropertyImage] GROUP BY [PropertyImage].propertyID) WHERE [Property].address LIKE @address AND [Property].type = (SELECT type FROM property WHERE propertyID = @propertyID) AND [Property].buyorrent = (SELECT buyorrent FROM property WHERE propertyID = @propertyID) AND [Property].propertyID != @propertyID ORDER BY RAND()"; cmd = new SqlCommand(query, con); if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Parameters.AddWithValue("@propertyID", oPropertyBO.propertyID); cmd.Parameters.AddWithValue("@address", "%" + oPropertyBO.address + "%"); SqlParameter message = cmd.Parameters.Add("@message", SqlDbType.VarChar, 500); message.Direction = ParameterDirection.Output; dad = new SqlDataAdapter(cmd); dt = new DataTable(); dad.Fill(dt); return dt; } catch { throw; } finally { con.Close(); } }
public DataTable FindPropertyByID(PropertyBO oPropertyBO) { try { query = @"SELECT *, y.name AS agentName FROM Property x INNER JOIN Agent y ON x.agentID = y.agentID WHERE x.propertyID = @propertyID"; cmd = new SqlCommand(query, con); if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Parameters.AddWithValue("@propertyID", oPropertyBO.propertyID); SqlParameter message = cmd.Parameters.Add("@message", SqlDbType.VarChar, 500); message.Direction = ParameterDirection.Output; dad = new SqlDataAdapter(cmd); dt = new DataTable(); dad.Fill(dt); return dt; } catch { throw; } finally { con.Close(); } }